Adding GL Distribution to SOP Blank Invoice Form

Question Status

Unanswered
SARAS asked a question on 2 Apr 2015 3:47 AM

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

Reply
Arunprasath responded on 2 Apr 2015 3:56 AM

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

Reply
SARAS responded on 2 Apr 2015 3:58 AM

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

Reply
Justin Thorp responded on 2 Apr 2015 4:47 AM

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

Reply
Mohammed Tohamy responded on 3 May 2015 7:46 AM

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.

Reply