The total purchased is wrong.
I exported closed and open POs for Project 78 and I am getting $40,000 more and I’m not sure where that is coming from.
Same issue with Project 99 and a few other projects.
We urgently need this fix for our fiscal year report.
We have responded here to the original thread about this issue: Project purchased vs Invoiced calculation bug - #4 by rcheremeh
"You are correct - the Project is using the internal POs associated to your build to stock orders (remember the internal PO is the function to create the finished good inventory, and you really shouldn’t ever need to think about or touch these) in addition to the true supplier Purchase Orders. The Project functionality was originally designed with external customers in mind, while JST is using it for internal customers. This is tripping up some of the logic there. However, it shouldn’t be a problem, the Purchased section should only be looking at POs for external vendors - we will get a fix in place for this.
I will keep you updated on this resolution. For the short term, I would not rely on the project rollups and instead use the invoice/PO tabs to calculate costs."
Thanks,
Cetec ERP Support Team
We are still having the same current issue. On Project 78, it reads the total purchased at ~$316,000, but when we export the PO’s and total them, it only totals to ~$276,000. After looking further, I think I may have discovered the issue, it seems whenever there is a negative value for a PO, it is instead adding a positive value. For example, when I add abs() to the excel formula, it than shows me the value cetec is showing. This is wrong, can this be fixed?
We don’t support negative values at receipt.. you’ll notice the receipt value for those non inv parts in positive.
In Cetec the vendor discount is applied on the voucher.
Thanks!
CetecERP Support
@cetecerp2
So than what do I need to change to get the Total Purchased value to be correct? (Correctly add a negative value)
@edixon you could have a PO line but simply not receive it. The ledger impact will come from the discount on the voucher against the received inventory that the discount is for but the unreceived poline will still show in the project as a line item.