You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Acquisition Cost Adjustment - Calculation Logic/Formulae

edited Aug 8, 2022 2:32PM in Costing 4 comments

Summary:

Calculation Logic/Formulae

Content (required):

Hello,

Help with this query please.

Could you help me to know what is the formula to calculate the Unit Cost in the "Review Item Cost" screen when the source is Acquisition Cost Adjustment?


I have executed the below scenario :


The Cost Method is Perpetual average.

1. Created Purchase Order, Receipt A for QTY = 20, Price = 12; Amount= 240;


2. Created Purchase Order, Receipt B for QTY = 10; Price = 15; Amount = 150;


On "Review Item Cost"

 * Unit Cost is 13 because the formula is: ((20*12)+(10*15)) / (20+10)

 * And the Costed Value is 390 because the formula is: 13*30 (onhand)


3. Created SO Shipment1; QTY = 5


On "Review Item Cost"

 * The Unit Cost continues as 13

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!