Same Product on multiple Invoice Lines (Sales & Purchasing), vs. Accounting document grouped in one line

Question

I am using the same Product on multiple lines on a Purchase Invoice in V11. 
 The Accounting Document groups this as one line (which is logical as the Products link to the same G/L Account). 
 Is there a setting (Parameters, Screen, Accounting interface, etc) that will allow the Accounting Document to show the same number of lines as the Purchase invoice? 
 A many-to-many relationship if you will, instead of a many-to-one. 
 Or is there more to this in terms of setup?

myliem · Answer

Yes, you can resolve this through defining grouping criteria in automatic journal. Try [F:PID]PIDLIN as your grouping criteria so that your accounting document always has the same number of lines as the invoice has.

Sage X3

Same Product on multiple Invoice Lines (Sales & Purchasing), vs. Accounting document grouped in one line

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING