SBX - Search With Button

SBX - Forum Post Title

Adding GL Distribution to SOP Blank Invoice Form

Microsoft Dynamics GP Forum

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

Question Status

Unanswered

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
My Badges

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
My Badges

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
My Badges

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
My Badges

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

SBX - Two Col Forum

SBX - Migrated JS