Report budget balances do not match the ERP Budgets screen

Overview

When using the Velixo balance functions (i.e., ACCOUNTBEGINNINGBALANCE, ACCOUNTTURNOVER, ACCOUNTENDINGBALANCE), the values that appear in the report do not match the values seen on the ERP Budgets screen.

Example

Velixo report:

Velixo Excel report showing budget balance values for several GL accounts that differ from the ERP

ERP Budgets screen:

Acumatica Budgets screen showing budget amounts with the Released column containing blank values indicating unreleased budgets

Cause

Assuming that a Refresh of the report does not successfully bring in the expected information, the most common cause of this is when the values being displayed on the ERP's Budgets screen have not yet been released:

Acumatica Budgets screen with the Released column showing empty cells, highlighting that the budget has not yet been released


When used with Budget ledgers, the Velixo balance functions return only RELEASED data.

Resolution

Once the budget values have been released from the ERP's Release Budgets screen...

Acumatica Release Budgets screen with budget records selected and the Release action button highlighted


... those values will show on the Budgets screen as having been released:

Acumatica Budgets screen with the Released column now showing released status for the budget records


and the Velixo balance functions will display the released data:

Velixo Excel report now showing budget balance values matching the released amounts in the ERP Budgets screen