Accounting Dates from Acumatica

Accounting Dates from Acumatica

How Anterra Handles Accounting Dates

For virtually all information available in Anterra we store two dates, the transaction date and the accounting date.  The transaction date is usually when the transaction itself was entered into the accounting system, but is not necessarily when it becomes a matter of financial record.  There are numerous situations where a transaction is entered in the first few days of a month but should be considered as part of the prior accounting period.

Dates in Acumatica:

Generally, in Acumatica there are four dates associated with most transactions:
  1. Date of the document - Most of the time this is inside the Period, but there are times when it's not.  This is the date used for things like AR Invoices / AP Bills, and this is also the date used when it is between the start and end date of the period which allows Anterra to work on not just month-ends.
  2. Period of association - Unfortunately it is not possible in Acumatica to associate an actual accounting date, instead only a period can be associated.  If we only relied on the period, all transactions would be on the first of last day of the period, by using the Period and the Date we are able to provide the best experience.
  3. Creation date - This is the date we use for our transaction dates which allows us to understand when the record was originally created
  4. Update date - We use this date behind-the-scenes to validate that we have the latest information from Acumatica when we're running our automated validations

    • Related Articles

    • Acumatica To AnterraBI Synchronization Process and Timing

      Introduction This article provides an overview of how your data is synchronized from Acumatica to the Anterra Platform. Most data is delivered from the source ERP within minutes after changes are made. That information is transformed and loaded into ...

    • Acumatica Connected Application Authentication (SM303010)

      This process is often performed on your behalf by Anterra's staff during our initial implementation. Setup Acumatica Connected Application (SM303010) Login to your Acumatica instance as an administrator Go to the Connected Applications screen ...

    • Anterra's Acumatica Customization Project (AnterraBI)

      Latest Acumatica Customization Version: 2023.11.02 Downloading the latest version Choosing the right customization project for your Acumatica environment Depending on the structure of your cost codes there are unique versions of Anterra's ...

    • Acumatica AnterraBI Customization Project Features

      Installed Version The currently installed version of the AnterraBI customization project can be found by visiting the Customization Projects (SM204505) in Acumatica. The description has the version in it formatted as yyyy.MM.## which indicates the ...

    • Balances in Acumatica Not Matching Anterra

      There are situations where commitments, change orders, and unbilled amounts in Acumatica may be incorrect. Go to Screen ID PM504000 (Recalculate Project Balances), select the appropriate checkboxes, then choose Process All. Depending on the volume of ...