Thursday, September 29, 2016

Dynamics GP - Posting Setup Tables - How to change the File Export Destination Name on the fly

How to get posting reports to print to a file including the audit trail code in the file name

select * from sy02200 - Posting Destination file name
select * from sy01000 - Next Audit Trail Code

Change the Filexpnm field just before printing using vbscript and a sql update query on the print button

No comments:

Post a Comment