Solved

PPV Posting to Project

  • 20 December 2022
  • 7 replies
  • 196 views

Userlevel 5
Badge +3

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?

icon

Best answer by meganfriesen37 8 May 2023, 20:23

View original

7 replies

Userlevel 7
Badge +15

Hi @kristianharianja 

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:

 

Userlevel 5
Badge +3

@kandybeatty49 I didn't tick the accrue but I tested if the item is accrued and chose Standard Cost as the method of calculation but the amount difference is still not posted to Project.

Userlevel 2

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.

Userlevel 7
Badge +10

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

Userlevel 4
Badge

Has anyone gotten this to work as desired or confirmed that it is an official known issue?

Userlevel 7
Badge +10

I’ve submitted an idea for this: 

 

Userlevel 6
Badge +2

23R1 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.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved