General Ledger User-Defined Functions for Report Writer

 

We all know there is some really great things you can do with the Report Writer User-defined functions. Unfortunately they are not well documented.

What will follow is a series of posts where I will list all of the KB articles I could find include information about one of the RW functions in Report Writer.

The posts will be separated by module. First up, General Ledger.

Enjoy!

GENERAL LEDGER

1. How to use Report Writer in Microsoft Dynamics GP to add the purchase order number from the Payables Transaction Entry window to the Detailed Trial Balance report in the general ledger
   (863689 - modified: 2012-07-13)
   This article describes how to add the purchase order number from the Payables Transaction Entry window to the Detailed Trial Balance report in the general ledger in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains.
2. How to print a General Posting Edit List that includes distribution accounts for variable and fixed allocation accounts in Microsoft Dynamics GP
   (931452 - modified: 2007-08-21)
   Explains how to print the General Posting Edit List with distribution accounts for variable and fixed allocation accounts in Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0.

...

Payables Management User-Defined Functions for Report Writer

 

We all know there is some really great things you can do with the Report Writer User-defined functions. Unfortunately they are not well documented.

What will follow is a series of posts where I will list all of the KB articles I could find include information about one of the RW functions in Report Writer.

The posts will be separated by module. This post is dedicated to Payables Management.

Enjoy!

PAYABLES MANAGEMENT

1. How to use Report Writer to replace the Vendor Check Name field with the vendor note for a Payables Management check in Microsoft Dynamics GP
   (857745 - modified: 2012-07-13)
   Explains how to use Report Writer to replace the Vendor Check Name field with the vendor note in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains.
2. How to round a calculated field in Report Writer in Microsoft Dynamics GP
   (872275 - modified: 2012-08-27)
   Describes how to create a calculated field to round to the nearest two decimal places or the nearest whole dollar by using Report Writer in Microsoft Dynamics GP.
3. How to add buckets to the Payables Management "Aged Trial Balance" report for the summary print option in Report Writer in Microsoft Dynamics GP
   (948664 - modified: 2012-07-14)
   Describes how to add buckets to the Payables Management Aged Trial Balance report for the summary print option in Report Writer in Microsoft Dynamics GP.
4. How to modify the aged trial balance reports in Report Writer so that the printed reports show the number of days outstanding in Payables Management in Microsoft Dynamics GP 9.0 and in Microsoft Great Plains 8.0
   (910699 - modified: 2012-07-14)
   Describes how to add the total outstanding days to the Payables Management aged trial balance reports in Microsoft Dynamics GP and in Microsoft Great Plains. You need Report Writer to follow the steps. You may also need the system password.
5. How to add buckets to the Payables Management "Aged Trial Balance" report for the detail print option in Report Writer in Microsoft Dynamics GP
   (948599 - modified: 2012-07-14)
   Describes how to add buckets to the Payables Management Aged Trial Balance report for the detail print option in Report Writer in Microsoft Dynamics GP.
6. How to print the Check Date fields in the Canadian date format of MMDDYYYY in Payables Management reports in Microsoft Dynamics GP
   (970114 - modified: 2012-07-13)
   Describes how to print the Check Date fields in the Canadian date format of MMDDYYYY in Payables Management reports in Microsoft Dynamics GP
7. How to add the "Distribution Reference" field to the PM Transaction Posting Journal report in Microsoft Dynamics GP
   (865470 - modified: 2011-07-20)
   Describes how to add the "Distribution Reference" field to the PM Transaction Posting Journal report in Microsoft Dynamics GP.
8. How to suppress the "Address 1" field, the "Address 2" field and the "Address 3" field on any check in Payables Management in Microsoft Dynamics GP
   (874218 - modified: 2011-07-25)
   Describes how to suppress the "Address Line 3" field on any check in Payables Management in Microsoft Dynamics GP.
9. How to add a new bucket to the "Aged Trial Balance-Detail with Options" report in Payables Management in Microsoft Dynamics GP
   (864847 - modified: 2011-07-20)
   Describes how to add a new bucket to the "Aged Trial Balance-Detail with Options" report in Payables Management in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains.

Receivables Management User-Defined Functions for Report Writer

 

We all know there is some really great things you can do with the Report Writer User-defined functions. Unfortunately they are not well documented.

What will follow is a series of posts where I will list all of the KB articles I could find include information about one of the RW functions in Report Writer.

The posts will be separated by module. This post is dedicated to Receivables Management.

Enjoy!

RECEIVABLES MANAGEMENT

1. How to add the customer purchase order number to the Receivables Management Accounts Due Report in Microsoft Dynamics GP
   (856461 - modified: 2012-07-13)
   Describes how to add the customer purchase order number to the Receivables Management Accounts Due Report in Report Writer in Microsoft Dynamics GP and in Microsoft Business Solutions – Great Plains 8.0.
2. How to suppress the Address 2 field and the Address 3 field in a report in Receivables Management for Microsoft Dynamics GP
   (853430 - modified: 2011-07-11)
   Describes how to suppress empty address line fields so that the City, State, and Zip fields print under the last line of the address.
3. How to use Report Writer to print all seven aging periods on the RM Aged Trial Balance report in Microsoft Dynamics GP 9.0
   (933643 - modified: 2011-08-01)
   Describes how to print all seven aging periods on the RM Aged Trial Balance report in Microsoft Dynamics GP 9.0 and Microsoft Business Solutions - Great Plains 8.0.
4. How to use the aging date to calculate the "Days Past Due" field on the RM Detail Historical Aged Trial Balance report in Microsoft Dynamics GP
   (856016 - modified: 2007-11-13)
   Describes how to use the aging date to calculate the "Days Past Due" field on the RM Detail Historical Aged Trial Balance report in Microsoft Dynamics GP.

SOP User-Defined Functions for Report Writer

 

We all know there is some really great things you can do with the Report Writer User-defined functions. Unfortunately they are not well documented.

What will follow is a series of posts where I will list all of the KB articles I could find include information about one of the RW functions in Report Writer.

The posts will be separated by module. This post is dedicated to Sales Order Processing.

Enjoy!

SALES ORDER PROCESSING

1. How to modify the SOP Blank Invoice Form to display the total amount of the invoice in words in Microsoft Dynamics GP and in Microsoft Great Plains
   (917473 - modified: 2012-07-14)
   Describes how to modify the SOP Blank Invoice Form in Microsoft Dynamics GP and in Microsoft Great Plains to display the total amount of the invoice in words.
2. How to change the date format on a Sales Order Processing report in Microsoft Dynamics GP
   (852554 - modified: 2012-06-27)
   Describes how to change the date Format on the Sales Order Processing reports in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains 8.0.
3. How to add the "Customer Item Number" field to a quote, order, or invoice form in Sales Order Processing in Microsoft Dynamics GP
   (918943 - modified: 2012-07-14)
   Describes steps that let you print both the "Inventory Item Number" field and the "Customer Item Number" field. You must have access to Report Writer, and you may need the system password to grant security.
4. How to print the difference between the list price and the unit price for items on Sales Order Processing order forms in Microsoft Dynamics GP
   (871675 - modified: 2012-07-14)
   Describes how to print the difference between the list price and the unit price for items on Sales Order Processing order forms in Microsoft Dynamics GP.
5. How to create a Line Number field for the lines items on the SOP Blank Quote Form, on the SOP Blank Order Form, on the SOP Blank Invoice Form, on the SOP Blank Return Form, and on the SOP Blank Back Order Form reports in Microsoft Dynamics GP
   (857285 - modified: 2012-07-13)
   Describes how to create a Line Number field for the lines items on various reports in Microsoft Dynamics GP.
6. How to add the customer e-mail address to the SOP Blank Order Form report or to the SOP Blank Invoice Form report in Microsoft Dynamics GP
   (874101 - modified: 2012-07-14)
   Describes how to add the customer e-mail address to the SOP Blank Order Form report or to the SOP Blank Invoice Form report in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains 8.0.
7. How to add Internet information for an item to the "SOP Blank Invoice" form in Microsoft Dynamics GP
   (924538 - modified: 2012-07-14)
   Describes how to use the Report Writer module to modify the SOP Blank Invoice Form.
8. How to use Report Writer to add the functional currency list price to the SOP Blank Invoice Form in Microsoft Dynamics GP
   (852962 - modified: 2012-06-27)
   Describes how to use the rw_ivGetFuncListPrice function script in Report Writer to add the list price of an item to the SOP Blank Invoice Form or other non-options forms in Sales Order Processing.

POP User-Defined Functions for Report Writer

 

We all know there is some really great things you can do with the Report Writer User-defined functions. Unfortunately they are not well documented.

What will follow is a series of posts where I will list all of the KB articles I could find include information about one of the RW functions in Report Writer.

The posts will be separated by module. This post is dedicated to Purchase Order Processing.

Enjoy!

PURCHASE ORDER PROCESSING

1. How to add the vendor ship-to address from the Purchasing Vendor Detail Entry window to the POP Purchase Order Blank Form in Microsoft Dynamics GP
   (927699 - modified: 2012-07-14)
   Describes how to use Report Writer to add the vendor ship-to address from the Purchasing Vendor Detail Entry window to the POP Purchase Order Blank Form in Microsoft Dynamics GP.
2. How to add the vendor e-mail address to POP Purchase Order Blank Form report in Microsoft Dynamics GP
   (874102 - modified: 2012-07-14)
   Describes how to add the vendor e-mail address to the POP Purchase Order Blank Form report in Microsoft Dynamics GP.
3. How to add purchase order notes to the POP Purchase Order Blank Form in Report Writer in Microsoft Dynamics GP
   (858264 - modified: 2012-07-13)
   Discusses how to use Report Writer to add purchase order notes to the POP Purchase Order Blank Form in Microsoft Dynamics GP.
4. How to add line item comments to graphical purchase order reports without creating additional white space in Microsoft Dynamics GP
   (906709 - modified: 2012-07-14)
   Describes how to add line item comments to graphical purchase order reports without creating additional white space in Microsoft Dynamics GP. You must have access to Report Writer, and you may require the system password to complete these steps.
5. How to modify the POP Purchase Order Blank Form report to print the "purchase order line item quantity ordered" note if you use Project Accounting in Microsoft Dynamics GP
   (944890 - modified: 2012-07-14)
   Describes how to modify the POP Purchase Order Blank Form report to print the "purchase order line item quantity ordered" note if you use Project Accounting in Microsoft Dynamics GP.
6. How to add the Purchases account or the Inventory account to the alternate "POP Purchase Order Blank Form" in Project Accounting In Microsoft Dynamics GP
   (918944 - modified: 2012-07-14)
   Describes how to add these accounts to the alternate POP Purchase Order Blank Form. By default, this report contains the Project Number and the Cost Category. You must be an administrator to complete these steps.