Customer Statement modifications

(0) Share

Report

Posted on by Community Member

On our customer statements, GP uses description from AR invoices to populate the description for each line on the statement. I was wondering if there is a way to include location name and contract type along with the description?

It’s this report: RM Statement On Blank Paper

*This post is locked for comments

All responses (4)

Answers (0)

Suggested answer

David Musgrave MVP ... 14,042 Most Valuable Professional on at

Like (0)

Report

RE: Customer Statement modifications

Hi WennSoft

You can use VBA with ADO to access SQL or custom RW functions using Support Debugging Tool or GP Power Tools to return the additional data to the report as a calculated field.

Examples:

blogs.msdn.com/.../getting-data-from-isv-tables-onto-reports-without-needing-to-create-alternate-reports.aspx

blogs.msdn.com/.../how-to-add-item-category-long-descriptions-to-reports-using-the-support-debugging-tool.aspx

blogs.msdn.com/.../using-ado-with-vba-with-report-writer.aspx

David
Justin Thorp 2,265 on at

Like (0)

Report

RE: Customer Statement modifications

Hi WennSoft,

Can you send me some screenshots showing where you see "Location Name" and Contract Type"? Are these in the Project Accounting Module?

Thanks,

Justin
Community Member on at

Like (0)

Report

RE: Customer Statement modifications

you would have to go on Report writer and modify your report adding whatever fields you want :)
Community Member on at

Like (0)

Report

RE: Customer Statement modifications

anyone?