Breadcrumbs

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:

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/7GnqkwNTUmZHAZDMewnOqUd66ZozqoFZ6Q.png


ERP Budgets screen:

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/iKFADYVIz5e8ilrnWx_nAnXcBDvs8MvKrw.png

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:

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/VmJxgFq5zhvwSamlqaWMvLAHyXOkB0kQsA.png


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...


https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/0C6RaN9ohOOC_a5JhN2b3X2dSoiyw_HehA.png


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

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/OWvoee_b8VQr4vjUf7LeSzga3RaaZAuTTg.png


and the Velixo balance functions will display the released data:

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/t2pLyBEMEOflRs8WIB9gZpbR6QupCZ78zw.png