I have PO with a non-stock/expense item costs $850, linked to project. Process PO Receipt without changing unit cost, then create Bill at $1,000. The project however is only costed at $850 even though the Bill journal shows additional expense of $150 as a result of purchase price variance. The PPV allocation mode is Inventory Account. Is there anyway to post the additional expense to Project?
Solved
PPV Posting to Project
+3Best answer by meganfriesen37
I’ve submitted an idea for this:
+18Hi
On the Non-Stock Item, do you have the Accrue Cost box checked?
Here is info from the help with regards to that if you do:
+3
Kristian,
Did you find a resolution to this issue? We have the same issue with purchase price variances for projects and stock items. If the bill unit cost is different than the PO unit cost, neither subsystem is updating. The GL entries look to be correct, however.
+13It does appear the the PPV just goes to project X (non-project code) and that someone else had a related issue:
If your Non-Stock Items require receipt, it should create the PO Accrual automatically.
If you are using Standard cost, there are some unique things around Standard Costs and how the PPV allocates. For Items with Standard Costs, the system doesn’t look at the PPV variance allocation from the PO Preferences Screen (like it would for Average or FIFO), but rather at the settings from the Posting Class.
If your item has Standard Costing, when the invoice is received,
- Any differences between the standard cost and the unit cost on receipts multiplied by the quantity on the receipt are recorded to the standard cost variance account.
- For stock items with Standard assigned as the cost valuation method on the Stock Items form, any PPV amounts are allocated to the Purchase Price Variance account defined by the posting class of the item.
Thus, for items with Standard Costing assigned, it’s important that the standard cost on the item is updated regularly to keep in line with current costs/pricing, otherwise you could end up with large price discrepancies hitting the Standard Cost Variance accounts under project X.
Has anyone gotten this to work as desired or confirmed that it is an official known issue?
+13I’ve submitted an idea for this:
+223R1 Build 108 was released over the weekend. This is listed as a Fix under Project & Construction in the release notes: AC-276143: On the Journal Transactions (GL301000) form, if a purchase price variance appeared for a project related purchase order and its bill, the journal transaction line corresponding to the PPV amount had no project code, and the system did not create a project transaction.
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.