Why Applies-to Entry NOT Exist if already Shipped?

selece28

Hi Nav Masters,
I just want to ask something.
Is is a bug, or is there any explanation for this?

Let say, i have a Positive adjmt on ItemA, Qty 100 with Lot No. XXX
Then i do a SO and post Ship,
Then we realize that out item is incorrect, i want to fix the Lot No. from XXX to ZZZ
so i do a Undo Shipment, Delete the Item Tracking Lines.

Then i go to Item Journal and do a Negative Adjmt.
Then when i want to insert the "Applies-to Entry" i cannot find the ILE.
I know its because in ILE i already have 3 lines,
1 Entry Type = Positive Adjmt
2 Entry Type = Sale

The one with Open = TRUE and Remaining Qty > 0 is the Sale.

So how to do a negative adjmt on this,
All i want to do is negative the line with Lot No. XXX,
then positive another one with Lot No. ZZZ
Currently i change manually from the ILE table,
I make both Entry Type "Sale" field Open = FALSE, Remaining Qty = 0
And move the Remaining Qty to the one with Entry Type = Positive Adjmt, and make Open = TRUE so i can do "Applies-to Entry" from my Item Journal.

Is it ok to do so?
Is there any better suggestions?

Thanks in advance

kriki

Shipping something, means the remaining quantity of the positive entry is diminished.
If you you then undo the shipping, a NEW positive entry is created for that amount.
So to remove the quantity, you need to make 2 lines. 1 with the quantity of the shipping, connected to the UNDO-entry. And another with the remaining quantity of the original entry, connected to that original entry.
After that, you can create your new entry.

selece28

Hi kriki,
What do you mean by make 2 lines?
If i do Negative adjmt without Apply, can i do it?
Whats the effects? let say i know the unit cost and insert manually to the Item Journal.

Please advice,
Thanks

kriki

Example:
-when you buy 100 items, they are posted with 1 ILE-record as +100 (a)
-When you ship 10 items, they are posted with 1 ILE-record as -10 (b), connected to (a).
-When you UNDO the shipment, it is posted as 1 ILE-record as +10 (c)

So now you have 2 ILE-records with a positive quantity (a) with remaining quantity 90 (=a-b) AND (c) with remaining quantity = 10.

If you are sure there are NO other positive quantity-ILE-records, you can just post a negative entry with quantity=100.

Otherwise you have to create 2 item journal lines (one with quantity=90 and one with quantity=10 which you respectively apply to (a) and (c).


PS before doing it in a production-DB, why don't you first try it out in a test-DB?

ayhan06

as far as i remember, aaply-to entry field filters Item ledger entries only whose "corecction" field is not TRUE.

when you undo shipping, postive sales entry is signed as correction. so that s why you can't see taht record when you lookup apply to entry field on ıtem journal..
but it doesnt matter. when you look up apply to entry field, press Ctrl + F7, and delete "Correction" filter,then select entry you want. i think that it won't lead to any problem and it will work as you want.

selece28 wrote:

Hi Nav Masters,
I just want to ask something.
Is is a bug, or is there any explanation for this?

Let say, i have a Positive adjmt on ItemA, Qty 100 with Lot No. XXX
Then i do a SO and post Ship,
Then we realize that out item is incorrect, i want to fix the Lot No. from XXX to ZZZ
so i do a Undo Shipment, Delete the Item Tracking Lines.

Then i go to Item Journal and do a Negative Adjmt.
Then when i want to insert the "Applies-to Entry" i cannot find the ILE.
I know its because in ILE i already have 3 lines,
1 Entry Type = Positive Adjmt
2 Entry Type = Sale

The one with Open = TRUE and Remaining Qty > 0 is the Sale.

So how to do a negative adjmt on this,
All i want to do is negative the line with Lot No. XXX,
then positive another one with Lot No. ZZZ
Currently i change manually from the ILE table,
I make both Entry Type "Sale" field Open = FALSE, Remaining Qty = 0
And move the Remaining Qty to the one with Entry Type = Positive Adjmt, and make Open = TRUE so i can do "Applies-to Entry" from my Item Journal.

Is it ok to do so?
Is there any better suggestions?

Thanks in advance

selece28

Hi Kriki,
I already do some testing.

IF we do SALE for all of the ILE (100 in your example).
THEN i do SALE 100, Post Ship and Undo Ship 100.
The 1st ILE (Positive) Open = False.
The 2nd ILE (SALE) Open = False.
The 3rd ILE (SALE) Open = True, but Correction = True (like ayhan06 said)

I also compare if i do it with Apply and without Apply.
I see not so different in the result. (but i dont know after many process and Adjust Cost)
I just want to know, what is the purpose Nav do Apply?
Is is like what i think it is? Just to make sure the cost is the same? or is there anything else.
Because, i will enter the unit cost manually from Item Journal and insert the Item Tracking.

Is ayhan06's way deleting the Correction Filter Legal?
Or is it better not to Apply?

Please Advise, i'm confuse.
Thanks in advance

kriki

The apply serves when you want to take quantity from a certain entry for some reason.
If you have tracking/reservation, you might try to use that to apply the quantities.