Project Quantity does not match Cost Budget tab

Created by Damien Zwillinger, Modified on Thu, 05 Oct 2023 at 05:50 PM by Gabriel Michaud

Applies to:

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


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)




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



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.



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 atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article