undo shipment leaves open item ledger entries

hawkeye

Hi All

My customer has a problem, which I have reproduced in a standard clean CRONUS 2009 R2 classic client.

1. Take an Item with no Item ledger entries, and make a sales line on an order with that Item.

2. Ship NOT POST the line.

3. Go to the posted shipment and make an Undo Shipment.

4. Delete the sales order.

This creates to Item ledger entries - one with a positive quantity and one with a negative quantity. The problem is that they are not applied to each other, they are left open.

Yes they could apply them manually, but that is not a question for my customer. I believe I have to do some modifications in the "Undo Shipment" - functionality or make a batch that can apply all relevant entries.

Does anyone have some experience with this problem or some advice before I start making something - I have searched Partner Source, but did not have any luck.

BR Hawkeye


edit:

in my researh I have found that if I set the Correction-boolean in the Item Journal line to false instead of True in CU 5815. Everything is graet. But I´m not sure what the consequence of that is - any comments?

Alex_Chow

You should probably report this to Microsoft.

Reinhard

I am a little confused by something in your description.
When you click on Undo Shipment, there is no Item Journal visible to the user. So how could they apply it manually?
Also you tried changing the Correction boolean. Again I'm not sure how you would actually see the journal lines; unless you "intercepted" them as a developer.

The sales shipment is a negative item ledger. It should automatically apply against an existing positive inventory. It should reduce the Remaining Quantity on an existing inventory.
When you do the undo, it creates a new positive entry. I don't think it would undo the application of the shipment against your previous inventory... right?

Basically you say:

one with a positive quantity and one with a negative quantity

but really it's more the other way around, one negative and then one positive...


Not saying your issue isn't valid just trying to understand why it may be happening.

- Reinhard

DonDyck

I have seen this before going back to when the undo shipment functionality was first introduced. It usually happens when you ship into negative inventory. Scenario:

1. Ship a quantity of an item with no on-hand quantity. This results in an item ledger entry that is open/unapplied with a remaining quantity since there is no inventory to apply it to.
2. Undo the shipment (before any quantity has been received). This results in an item ledger entry that is open/unapplied with a remaining quantity.

You end up with a negative and positive quantity that do not get applied to each other (even though logically you might think they should as the undo is usually to correct an erroneous shipment). Eventually these entries will be applied to other transactions but not to each other - If I remember right, I think in older versions (4.0) this wasn't always the case.

If the scenario is different and you have a positive quantity first it looks like this:
1. Receive a quantity of an item.
2. Ship the same quantity of that item. This results in an application such that the purchase receipt and sales shipment are fully applied against each other.
3. Undo shipment done in 2. This results in a positive quantity on hand with a remaining quantity - the original purchase and shipment remain applied to each other.

Bottom line is that NAV does not apply the negative/positive entries that result from the shipment/undo shipment of the same line against each other - even though you could argue that it should.

hawkeye

@DonDyck - Thats is excactly my problem.

My solution was to build a check in the "undo Shipment" - functionality to avoid it to be run if the Item has an open, negative sales Item Ledger entry.

For the ledgers with this issue, I have told the customer to do a positive adjustment followed by a negative adjustment in the Item Journal. This will close/Apply the entries.

BR

Hawkeye

hawkeye

Reinhard wrote:

I am a little confused by something in your description.
When you click on Undo Shipment, there is no Item Journal visible to the user. So how could they apply it manually?
Also you tried changing the Correction boolean. Again I'm not sure how you would actually see the journal lines; unless you "intercepted" them as a developer.d

No there is no Item Journal visible for the user. But it is visible for CU 5815 :-) And yes I made a correction to the code in CU 5815 to set the correction flag to false - just to see the influence.

Reinhard wrote:

The sales shipment is a negative item ledger. It should automatically apply against an existing positive inventory. It should reduce the Remaining Quantity on an existing inventory.
When you do the undo, it creates a new positive entry. I don't think it would undo the application of the shipment against your previous inventory... right?

Yes you are right - that was my problem.

Reinhard wrote:

Basically you say:

one with a positive quantity and one with a negative quantity

but really it's more the other way around, one negative and then one positive...

Yes I mixed it up - you are right

BR

HAwkeye