Project Quantity does not match Cost Budget tab

Created by Damien Zwillinger, Modified on Tue, 16 Jul at 9:34 AM by Gabriel Michaud

Applies to:

  • Velixo NX
  • Velixo Classic
  • Acumatica, MYOB Acumatica, Cegid XRP Flex


Overview

Under certain circumstances, Acumatica's Cost Budget tab may display different values than what is returned by the Velixo Project Quantity functions (PROJECTBEGINNINGQUANTITY, PROJECTENDINGQUANTITY, PROJECTTURNOVERQUANTITY)

 

proj_qty_mismatch.png


Cause

The Velixo Project Quantity functions retrieve totals from Acumatica's PMHistory table.

 

When entering project transactions in Acumatica, if an InventoryID is not provided, Acumatica (by design) does not add the transaction quantity to the aggregated quantity data in that table. As a result, the Velixo functions do not include such data in the results.

 

Acumatica's Cost Budget tab aggregates all the quantities individually (instead of using the total in the PMHistory table).

 

Resolution

Use an inventory ID in all your transactions. This will ensure that Acumatica includes the transaction quantity values in the totals stored in the PMHistory table.

 

Workaround

If data without an InventoryID is already present in Acumatica, an alternative for reporting this data would be to build an Acumatica Generic Inquiry to get the data from the PMBudget table and then bringing those results into Excel using Velixo's GI() function.

 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article