SmartConnect Calculated Additional Column
I need some coding help
I have found an AP integration MAP and edited it accordingly
now I’m stuck a little bit below is the preview of the MAP
as you can see the MAP generated Purchase Amount, Tax Amount and Creditors Amount but when I upload it the whole of column F8 for Purchase Amount gets uploaded which isn’t right and same for Tax amount
I’m thinking to over come this is to create 2 calculated additional columns but I’m not great at coding
Those two columns to say “Sum F10 where Linetype column = 3-tax” this way it will only sum the Tax
Second column to say “Sum F8 where Linetype column = 1-exp”
Q: For 6200 (F3) & 117-01 (F4): Is your purchase amounts pulling in with a total of 123.51 and tax as 24.69?
If yes: You need to group your records in the create payables transaction node. Grouping by F3 and F4 should return 41.17 (purchases) and 8.23 (tax).
If you would like to submit an answer or comment, please sign in to the eOne portal.