This feature is requires Velixo Reports version 6 or higher
Acumatica allows a transaction from a specific date to be posted to a different financial period.
When calculating account balances using dates instead of financial periods, Velixo does NOT include those transactions which are within the date range but have been posted to a different period.
Let's assume the following three transactions have been posted to account 11000:
|May 5, 2021||100.00||04-2021|
|May 6, 2021||100.00||05-2021|
|May 7, 2021||100.00||06-2021|
If we were to use the ACCOUNTTURNOVER function to report the account turnover for May 5, 2021 through May 7, 2021...
The results would be $100.00 (the amount of the transaction from May 6, which was posted to period 05-2021).
The transactions from May 5 and May 7 affect ONLY the balances in the financial periods to which they were posted (04-2021 and 06-2021, respectively).