Cannot Receive Transfer Order Problem

wakaka

Dear Experts,

The Transfer Order is fully shipped but one of the item A can only be partially received.
When I post to receive the item, a warning message popped up :
“Lot No. is required for Item A.”

Thus, I open the Item Tracking Line window.
The NAV5.0 system do not allow me to type in Lot no. and Quantity(Base).

And I find the item A is in In-Tran.
How come the item cannot be recived?
What is wrong when I process the TO?
The problem often comes out.

What can I do to enable me to receive the TO??
Please kindly advice me.

MarkHamblin

I have seen this before (somewhat intermittently). There could be many causes - the reservation system (which deals with item tracking) can leave a bit of a mess in the reservation entry table.

To fix the issue, you'll have to manually edit the table, and it could get a bit tricky. First try filtering the reservation entry table on the source ID using the TO #, and filter the "Source Prod. Order Line" to the line number of the transfer order that is missing item tracking (yes, I said "Source Prod. Order Line").

If lines exist, you will probably just need to set the lot # field on the existing lines. If they don't exist, you'll have to create them. Main fields to set:

Item No., Location Code, Quantity (Base)=1, Res Status=Surplus, Source Type=5741, Source Subtype=1, Source ID=TO#, Source Prod. Order Line=TO line #, Source Ref No.=hidden TO line (see below), Lot No.

The "hidden TO line" refers to a transfer line that NAV creates for the receipt that is not visible in the form. To see it, open table 5741 and filter on the TO # and "Derived From Line No." (set to original line #).

- Mark

wakaka

Thank you for your reply.
After following your instruction, now I can see the lot no. in the Item Tracking window.

However, when I post to receive the item, a warning message popped up:
Base Qty. to Receive must be 0.

It is not possible to make it 0 as I need to receive the item.
Please advise.

MarkHamblin

Does the quantity to receive match the quantity to handle on the item tracking lines? If everything looks right and seems like it should post, there may be more problems than just missing item tracking lines.

wakaka

Yes, it does.
Therefore, I have no idea why the error message coming out.

wakaka

What should I look for to investigate the problem??

MarkHamblin

It's quite likely something more than just a messed up reservation entry occurred when posting the shipment.

You could try two things: check the qty per unit of measure and qty shipped (base) fields on the transfer lines and make sure they're correct. If they are, your only chance is to debug the error and trace it back to the bad data that's causing it. Hopefully it's nothing too serious.

- Mark

davmac1

To successfully edit the data, enter a transfer in a test company and ship it. Then compare the data in your reservation table to the data in your live table.
I have one customer who was getting intermittent problems like these, so I had to edit table 337 and occasionally the item ledger table (takes a developer license).
There are patches to prevent these types of problems in NAV 2009.

SCSImpl

I have spent a great deal of time troubleshooting the same problem for a client. You should do a search for that error message in CustomerSource or Partnersource. Depending on which version you are on, there are hot fixes available specifically published to address this problem.

MarkHamblin

SCSImpl wrote:

You should do a search for that error message in CustomerSource or Partnersource.

Good call - KB article 972607 is likely the fix. However, it is not a retroactive fix - for the current transfer order you will still have to manually fix the data. Based on the hotfix code, the bad data is likely in the reservation entry - check the Quantity (Base) field.

Dev

Check for remaining Qty in ILE in from of posted shipment document number and concerned item. if its 0 make it the right value and place a open true. I think it will works