Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Flagging an invoice in...

Flagging an invoice in GP10 as soon as it gets printed

(0) Share

Report

Posted on by Abdul Gafoor

My company is using GP10. We would like flag an invoice as soon as it get printed so that next time when we try to print the same invoice, 'DUPLICATE' word will appear in its header.

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: Flagging an invoice in GP10 as soon as it gets printed

Hi Abdul,

Whether an invoice is already printed or not is stored in database with the invoice. You can modified the Invoice to print the duplicate based on this information

1. In Sales Order Processing, you can use the TIMESPRT(Times Printed) from table SOP10100 (SOP_HDR_WORK)

2. In Receivables module, use DocPrinted bit to check whether invoice was printed or not from table RM10301 (RM_Sales_WORK)

3. In Invoicing Module, you can use TIMESPRT from IVC10100 (IVC_HDR_WORK)

For further details, you can refer to following post about Authenticate Reprinting of Sales Documents in Microsoft Dynamics GP.

dynamicsgphelp.com/.../authenticate-reprinting-of-sales-documents-in-microsoft-dynamics-gp

You will not need to write vba code, you can simply create a calculated field in Report writer to print DUPLICATE based on data stored

Rubal,

http://dynamicsgphelp.com/