1 / 12

DA1244 Retrospective AR & AP Statements

Understand and utilize Retrospective AR & AP Statements for audit comparisons. Learn how to print and analyze transactions as of specific dates. Explore retroactive statement functionalities.

botsford
Download Presentation

DA1244 Retrospective AR & AP Statements

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DA1244Retrospective AR & APStatements DA1244 Retrospective AR & AP Statements Last updated: March-2004

  2. Overview • Overview of Retrospective AR & AP Statements • With your system set up to use Retrospective AR & AP Statements, functionality is provided that is useful during an audit when comparisons are made between the system being audited and the customer’s or supplier's system: • Printed values on statements can be 'rolled back' to the Statement date, i.e. the value printed is the value as at the Statement date – transactions with a posted date later than the statement date are not printed • The Accounts Receivable and Accounts Payable Listings can print the status and value of each transaction on a particular date Note that only items within the transaction files can be reported on, i.e. the system keys xxBFORWARD must be set to NO and archiving must not have been carried out DA1244 Retrospective AR & AP Statements Last updated: March-2004

  3. RetrospectiveStatements DA1244 Retrospective AR & AP Statements Last updated: March-2004

  4. You can specify a retrospective date in this field You can age against the system date as well as the invoice and due dates Statements – Accounts Receivable This option has been modified to allow the statements to be printed as of a selected statement date With the system key SLRETSTAT set to YES, the statements can be printed retrospectively The transactions printed on the statement are those with a posted date not later than the entered Cutoff due date and the entered Statement date – transactions with a posted date later than the Statement date are not printed DA1244 Retrospective AR & AP Statements Last updated: March-2004

  5. Statements – Accounts Payable This option is NEW – as for Accounts Receivable Statements, it allows you to print the statements as of a selected statement date The functionality for producing supplier statements is identical to producing customer statements and as for Accounts Receivable Statements, with the system key PLRETSTAT set to YES the statements can be printed retrospectively (see slide 4) DA1244 Retrospective AR & AP Statements Last updated: March-2004

  6. RetrospectiveStatements – Example DA1244 Retrospective AR & AP Statements Last updated: March-2004

  7. Retrospective Accounts Receivable Statements A customer statement at the end of March 2003 shows: Date Invoice Amount Open 05/03/03 1234 117.50 117.50 10/03/03 3001 500.00 300.00 15/03/03 CS003 -200.00 0.00 Amount Due: 417.50 DA1244 Retrospective AR & AP Statements Last updated: March-2004

  8. Cash is received during April – the April 2003 statement shows: Date Invoice Amount Open 05/03/03 1234 117.50 0.00 10/03/03 3001 500.00 300.00 15/03/03 CS003 -200.00 0.00 02/04/03 CS102 -117.50 0.00 Amount Due: 300.00 DA1244 Retrospective AR & AP Statements Last updated: March-2004

  9. The statement is run retrospectively to the end of March – the March 2003 statement shows: • Date Invoice Amount Open • 05/03/03 1234 117.50 117.50 • 10/03/03 3001 500.00 300.00 • 15/03/03 CS003 -200.00 0.00 • Amount Due: 417.50 • The cash received during April has been ‘rolled back’ – it is not shown on the statement DA1244 Retrospective AR & AP Statements Last updated: March-2004

  10. Open Item Listings DA1244 Retrospective AR & AP Statements Last updated: March-2004

  11. To only print transactions up to a particular date you can type in the cutoff date required – the status and value of each transaction as at this date are printed however transactions with a posted date later than this date are not printed Accounts Receivable Listing This option has been modified to allow only open items and their status at a particular cut-off date to be printed DA1244 Retrospective AR & AP Statements Last updated: March-2004

  12. Accounts Payable Listing This option has also been modified to allow only open items and their status at a particular cut-off date to be printed The functionality is identical to the enhancements provided for the Accounts Receivable Listing (see slide 11) DA1244 Retrospective AR & AP Statements Last updated: March-2004

More Related