As experienced users may be aware, the as-of reporting functionality within SX.e software is a close but inexact process. What may work fine with daily reports may be insufficient for certain situations. This is especially the case during audits, when requests to provide a report ‘as of’ a particular date proves challenging.
For inventory values, the ICRTT Inventory Trial Balance was not designed to handle AP cost adjustments or manual balance overrides, and has a list of problems and issues reported which vary based on version. The ARRT Accounts Receivable Trial Balance has had issues with back posting of payments and cannot be relied upon to provide the same values as the report would have given if it was run on the selected as-of date. The APRT Accounts Payable Trial Balance has similar limitations if run in as-of mode. Also, if your system has any programs running to normalize costs across warehouse locations on a nightly basis, the as-of reporting will no longer work as designed.
There are also some reports such as the GLRBP, purchase orders received but not yet costed, that do not have an ‘as of’ functionality. Under duress of an audit deadline, with few alternatives, we get calls from customers asking us to reproduce these reports either in an ad hoc fashion or programmatically.
As an alternative to this, we have worked with many users who generate specific reports daily that they put in a central repository to allow easy access by authorized users. The concept is to make it as easy to access the saved copy as it would be to run a new as-of report. There are generally two main approaches to configuring this.
Check out the blog "As-of Reporting from SX.e" to learn more!!
For inventory values, the ICRTT Inventory Trial Balance was not designed to handle AP cost adjustments or manual balance overrides, and has a list of problems and issues reported which vary based on version. The ARRT Accounts Receivable Trial Balance has had issues with back posting of payments and cannot be relied upon to provide the same values as the report would have given if it was run on the selected as-of date. The APRT Accounts Payable Trial Balance has similar limitations if run in as-of mode. Also, if your system has any programs running to normalize costs across warehouse locations on a nightly basis, the as-of reporting will no longer work as designed.
There are also some reports such as the GLRBP, purchase orders received but not yet costed, that do not have an ‘as of’ functionality. Under duress of an audit deadline, with few alternatives, we get calls from customers asking us to reproduce these reports either in an ad hoc fashion or programmatically.
As an alternative to this, we have worked with many users who generate specific reports daily that they put in a central repository to allow easy access by authorized users. The concept is to make it as easy to access the saved copy as it would be to run a new as-of report. There are generally two main approaches to configuring this.
Check out the blog "As-of Reporting from SX.e" to learn more!!
Comments
Post a Comment