Skip to main content
Solved

PPV Posting to Project

  • December 20, 2022
  • 7 replies
  • 309 views

kristianharianja
Semi-Pro I
Forum|alt.badge.img+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?

Best answer by meganfriesen37

I’ve submitted an idea for this: 

https://community.acumatica.com/ideas/ability-to-expense-ppv-to-projects-16219

 

View original
Did this topic help you find an answer to your question?

7 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2209 replies
  • December 20, 2022

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:

 


kristianharianja
Semi-Pro I
Forum|alt.badge.img+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.


Forum|alt.badge.img
  • Jr Varsity III
  • 13 replies
  • March 30, 2023

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.


meganfriesen37
Captain II
Forum|alt.badge.img+12

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.


jbuddecke71
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 30 replies
  • April 13, 2023

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


meganfriesen37
Captain II
Forum|alt.badge.img+12

DConcannon
Varsity II
Forum|alt.badge.img+2
  • Varsity II
  • 120 replies
  • August 14, 2023

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings