Hello Community,
I am a beginner user facing the following problem. I pulled GL Entry table records to have all lines for a given Sales account. Then pulled Customer Ledger Entry table records with NF function and a filter on "Document No" to link GL Entry table with Customer Ledger Entry table (to add additional info as customer number and invoiced item). Say that, per a given invoice there are 3 records in the GL Entry table, and 9 lines in the Customer Ledger Entry table, the result I get is of 27 rows, with a duplication of lines of 3x. Can anyone please advise how to solve this problem? What I'd like to get, is just the 9 lines from Customer Ledger Entry Table with the related GL account they got posted to.
thanks in advance for your help!
