Skip to content


Dynamically add a distribution to a document

Paul asked 7 years ago
Is it possible to programmatically or otherwise dynamically add a distribution to a document within SmartConnect? For example, suppose the data set is a list of distributions and we want to automatically create the offset distribution before submitting the whole thing as a journal entry.
Patrick Roth Staff answered 7 years ago
You could yes.
You’d be able to do something like I did in this blog article:
keep track of the debit/credit amount.
then in a new “create OFFSET” node that you would add you would group your lines to be 1 line (since we only need 1 record inserted).  Then supply the debit & credit amounts.
pretty much the same concept that the blog article is doing with RM distributions.
Paul replied 7 years ago

Awesome. That worked. Thanks.

If you would like to submit an answer or comment, please sign in to the eOne portal.