Creating Document Distributions
I am using the new SmartConnect 2014 functionality to be able to sum a field to create the summary part of the GL Distribution. My problem is that my input file has multiple lines for each invoice, so the Debit side must be summed on the 1st Distribution node, as well as grouped. So when I try to sum the 2nd Distribution node to create the Credit side of the Distribution, it will not save the grouping on that node. Is there another way to accomplish this? Thanks
Laurie, No, using the method as described in the blog is the only way to do it – other than creating a new distribution in your source data. When we talked about this the other day, I believe we found that you were using 18.104.22.168 which does have a bug that if you don’t have a field that is the ‘group on’ field mapped to data then it won’t save. This has been corrected in SC 22.214.171.124 recently released. To solve this on your version, we used Node Maintenance to add a User Defined Field 1 to the map and mapped our group by column to that unused field which resolved our issue and allowed the map to run correctly. Patrick eone
If you would like to submit an answer or comment, please sign in to the eOne portal.