Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
My customer would like to add the GL distribution to the SOP Blank Invoice Form. How can I do this? Do I have to create a relationship to the Account Master?
Any help would be greatly appreciated.
You can use Report Writer to modify this. Also, you may need to check the existing relationships in the reports.
Yes. I meant how do I add the distribution thru Report Writer. I have customized the report already but I am unable to see how the GL data can be added.
Unfortunately, this is quite difficult to do, due to the existing 1:M relationships already on the report, and therefore you can't just link the "Sales Distribution Work and History" table to the report.
If I were to attempt to get this information onto the invoice, I'd use VBA (to query the SOP10102 - Sales Distribution Work and History).
AS Justin replied it's little bit difficult to do by the report writer but if your ok by crystal report send me the layout and the explain the data you need to display and send to my email.