We are preparing to send our fiscal year report on April 1st and have noticed discrepancies in some project calculations related to purchased vs. invoiced amounts. It appears that purchases and invoices are being combined incorrectly.
For example, project 99 reflects $23,000 in purchases, whereas the actual amount is approximately $1,266.42. This issue is occurring across multiple projects.
Additionally, the invoice hyperlink is not functioning as expected.
Please see the attached example for reference: Project Example
Please let us know about the purchase vs. invoiced cost.
Why is it including labor cost to the total purchased?
Since we only have a few days to submit our report.
For Project 99, where are you getting the expected cost from the invoices being $1,266.42? I don’t see this number anywhere, and even just adding a few of these costs up totals to around $15k based on the resale value of the invoice.
I’m just wondering where you are getting the expected number so I can see where you are seeing the discrepancy and we can compare to what it should be and find where it is going awry.
We only purchased a total of $1,266.42 items.
We didn’t purchase $23k of items on Project 99.
We did invoice some stuff.
I can send you a list of the POs
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.
The project rollups are going to distinguish external and internal invoices now, and we simplified some labeling to make it more clear. Currently its fixed in the old version, but we are getting a fix for the new version out shortly.
