Adding GL Distribution to SOP Blank Invoice Form

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi all,

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.

Thanks.

Regards,

Saras

*This post is locked for comments

All responses (4)

Answers (0)

Mohamed El-Tohamy 305 on at

Like (0)

Report

RE: Adding GL Distribution to SOP Blank Invoice Form

Hi Saras,

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.
Justin Thorp 2,265 on at

Like (0)

Report

RE: Adding GL Distribution to SOP Blank Invoice Form

Hi Saras,

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).

Thanks,

Justin
Community Member Microsoft Employee on at

Like (0)

Report

RE: Adding GL Distribution to SOP Blank Invoice Form

Hi Arun,

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.

Thanks.

Regards,

Saras
Community Member Microsoft Employee on at

Like (0)

Report

RE: Adding GL Distribution to SOP Blank Invoice Form

You can use Report Writer to modify this. Also, you may need to check the existing relationships in the reports.