Negative PO update adds to cost layer

Has anyone else seen that a negative quantity line on a PO produces a positive quantity on a cost layer? I have a customer that created a PO. One of the items went in at the wrong cost and was received. They did a negative line for that item on the same PO with the same cost. At the receipt update, the LIFO/FIFO cost layer was doubled instead of depleted. I was going to take the "str(-p)" and make it "str(p)" in the call to ICC070 in POC230 so the quantity going into the routine would remain negative. If anyone has observed/fixed this issue?

Thanks

Paul

Infor's Vision for 2022 Q&A Document.pdf

Find more posts tagged with

Comments

skyler-williams

I'm about to look into an issue where customers return "core" items and the sales order shows a negative quantity. I recently converted them from v7.4 to v7.8.4 They use FIFO costing.
Without having investigated very thoroughly, it appears that thousands of cost layers for these items were created. These cost layers go back to 2005. They never get relieved. When ICC070 tries to pull a cost for this item in v7.8.4, it returns a cost from the oldest layer, dated back to 2005.
In the v7.4 system these items have no cost layers.

Cheng Ruan

Paul,

Are they using FIFO or LIFO? If FIFO, what you observed is normal. The initial receipt created a new layer "on top". The negative quantity line (aka sending back) "consumed" the oldest layer (FIFO), not the latest one put in error. Prior to 7.8, there was no notion of truly "fixing" a receipt. The positive quantity line will simply add another layer "on top" as the latest acquisition.

As for John's situation, negative quantities on sales orders are treated like credit memos with a return type. Product came in so it creates a layer. Since cores cannot be resold, those quantities must be moved to a different logical warehouse, adjusted out or instead, use a credit memo with an allowance type to handle the dollar aspect of the core return without creating a new layer.

[Updated on 6/16/2014 1:15 PM]

paul-antoniewicz

Ralph, In this case the initial positive created a layer and then the negative ADDED INTO that layer. So if the quantities were 4 and -4, where the layer should be zero, it is 8 on hand.

Cheng Ruan

I've never seen a negative quantity on a purchase order line create a new layer. It should have consumed quantities from either the earliest or latest layer(s). Negative purchase orders "commit" quantities just like a sales order since they are both eventually relieved.

Version? Mods?

Copyright © 2025 Infor. All rights reserved.