Hello everyone, Looking at the transaction history, the following transaction is generated. We only did Receipt once on March 11th. What kind of transaction is this transaction that appeared on March 16th? Thank you in advance! [image]

OK, so this is very normal. You did the receipts when the standard cost was zero, so the entire PO price goes to variance (ADJ-CST). And this is all about system date, not “Date” - which is transaction date. Then (again, I mean in real-life time, not transaction date time) you did the std. cos…

That happens when cost on the receipt is changed and doesn’t match the PO.

Thank you for your reply. But, I checked the cost of the receipt and the PO, and they are the same. Did I misunderstand your answer? Could you Please explain a little more about the above reply?

@pilio.lee , with out clicking around your system, I’m not sure. Variances happen when something doesn’t match, so something somewhere doesn’t match.

Thanks for the reply. The strange thing about this case is that the Arrived Date and Receipt Date are different. Can this happen in this case? [image]

Yeah, you can enter the lines, and that generally is when the arrived date is set, and then when you set the line as received, it sets the received date. If you don’t do that on the same day, they can be different. Generally the arrived date wouldn’t be later than the receipt date, so it looks like …

Add the TranNum field to your grid and then sort descending. I bet you will find that the lowest transaction (first) from the screen shot above is your STK-MTL transaction which would have driven your on hand negative giving the variance. [image]

[image] Banderson: when cost on the receipt is changed Or if you are on std cost and the standard does not match the PO price. That’s not necessarily bad - it’s actually the point of std costing.

We use Std cost, but in this case, Std cost and PO Price are the same. Does this happen even if the cost is the same? In testing with other cases, this happens when the Arrived Date and Receipt Date are different. However, the problem is that the Arrived Date is set only on that day, not on the sp…

Hi Pilio, Is it possible that someone unchecked received on the receipt? This would back out the quantity and the cost. Here’s an example in our system ( we use std cost too) where user likely entered the receipt, wrong bin, unchecked received, fixed bin then re-received. Nancy [image]

We have the same issue occasionally with purchase order receipts and I have not been able to replicate the issue. I have tried deleting the Receipt Line, Unreceiving the PO Line, deleting the Receipt Head, Unreceiving the Receipt Head, changing the receipt and arrival dates. None of these transact…

Inventory Variance in Transaction History

Kinetic ERP

pilio.lee (pilio.lee) March 30, 2022, 11:48pm 15

This is the requested screenshot. Thanks for your continued support.

Topic		Replies	Views
Strange Mtl Unit Cost Calculation in Part Tran Hist Tracker Epicor ERP 9	20	5080	August 4, 2023
Receipt Entry Generates ADJ-CST Transaction Epicor ERP 10 e10	4	2407	August 19, 2020
Part numbers always going to variance Epicor ERP 10 e10	13	3269	July 1, 2019
ADJ-CST Variance per job - need explanation! Epicor ERP 10 e10	9	5003	May 31, 2019
Part Costs Received to Inventory Higher Than Job Costs To Date Epicor ERP 10 job-cost , cost , mfg-stk	7	1075	September 19, 2023

Inventory Variance in Transaction History

Related topics