Item is not on inventory...item IS on inventory!!

Marco_Ferrari · 2006-09-13

Hi all, I have a very strange problem in transfer orders version 3.7 (SQL)updated with all SP.
I have a transfer order, I post the ship, then I post the Receipt and I get the error "The Item xxx is not on inventory". If I post another time, I get the same error, but for another Item in another line!!

With some others Trenasfer Orders, I ship, when I post the receipt I get the error for an item but the second time I post the receipt all goes well!!

Note that the DB on which I try to do that is a test DB with no users connected to it. The customer don't use reservations, warehouse, bins, lot numbers or serial numbers, so is a very very easy and normal situation!!

Can someone help me?

Thanks
Marco

philippegirod · 2006-09-13

Ciao Marco,

Are you "the" Marco from JET ?

We had the same kind of problem in a SQL Navision database, but in production orders. The only way found to resolve is to reserve the items on the line.
For instance, when you see the message, go on Function (Funzioni), Reserve (Impegno) from the line of Item not in inventory. Click on Outboud, the click on Functions, Auto-reserve.

In our database it work very well.

Salutti,

Marco_Ferrari · 2006-09-13

Hi, no i'm not the "Jet" Marco sorry, I don't know what you mean...

In any case, the problem is random: when I receive the error, if I delete the Quantity to Receive on the item immediately before the item that causes the problem, the system post it correctly!! So I think is a technical problem, due probably in an error in refreshing some variables in tables or in codeunit.... ](*,)

Miklos_Hollender · 2006-09-13

Make a backup-restore to a local database and try it there. If the problem can't be reproduced, then it is an SQL issue.

Marco_Ferrari · 2006-09-13

Sometimes, when you ship the item, the transfer posting generates two entries and not only one; one of my case is:

Shipping 13 PCS: two entries (8+5). Don't ask me why the program split the shipping!!

In this case when you post the receipt, the program find only the first entry (8 PCS) and so it tells the the item is not on inventory. The problem is in the function ApplyItemLedgEntry of Codeunit 22 more or less when it search for the shipping entry:

[...]
ItemLedgEntry2.SETRANGE("Item No.",ItemLedgEntry."Item No.");
ItemLedgEntry2.SETRANGE("Variant Code",ItemLedgEntry."Variant Code");
ItemLedgEntry2.SETRANGE(Open,TRUE);
[...]

I don't know now hoe to fix the problem, but I try!

Marco

kine · 2006-09-15

Sometimes Navision "do not see" some records. Solution for that is to use this SQL command to set one property on the database for Navision:

UPDATE [$ndo$dbproperty] SET diagnostics = 131072

You can search this forum for more about that...

Luc_VanDyck · 2006-09-15

Indeed. You can apply this fix, or use the 3.70B executables. It was fixed in this version.

Item is not on inventory...item IS on inventory!!

Comments

Categories