Version 12 and the Cloud introduced a few changes to the North American Reports. The changes are listed in the table below
New Core Report |
Existing Core Report |
Report Name |
Deprecated |
NA Report Name |
CSHREQ |
Cash requirements |
NA-CSHREQ |
Cash requirements |
|
CUSSTA |
Customer statement |
NA-CUSSTA |
Customer statement |
|
SPAYHIS |
Supplier invoice payment |
NA-SPAYHIS |
Supplier payment history |
|
BPCINV2 |
Customer BP invoice |
NA-CINVAR |
Customer invoice |
|
BALAGEGRP and BALAGEGRPDEV |
Aged balance and Aged balance/currency |
NA-BPATB |
Aged trial balance |
|
BALGRP and BALGRPDEV |
General balance and General balance/currency |
NA-TRLBAL |
Trial balance |
|
GLGRP and GLGRPDEV GLANA1 and GLANA2 Note: no changes were added to the core reports |
· GL journal account details and General ledger/currency · Ana. GL/account and Ana. GL/dimension |
NA-GLBAL |
GL Detail account balance |
The report parameters listed below are the minimum entries to obtain the same output from the BALAGEGRP and BALAGEGRPDEV reports as the NA-BPATB:
- Company
- Pivot date
- Age invoices by (Age by invoice date)
- Detail by open item (Yes)
- Keep the remaining report parameters with their default values
See the attached file TransitionToBALAGEGRPFromNA-BPATB.pptx (contained in Transition.zip) for comparison and parameter descriptions
The report parameters listed in the table below are the minimum entries to obtain the same output from the BALGRP and BALGRPDEV without dimensions
- Company
- Date Range
- Keep the remaining report parameters with the default values
To include dimensions, use the 3 new report parameters.
- Display all dimensions
- Analytical dimension type
- Dimension
- Keep the remaining report parameters with the default values
- See attachment TransitionToBALGRPFromNA-TRLBAL.pptx (contained in Transition.zip) for explanation of the parameters