Error - The shipment lines have been deleted.

Apricot

Hi All

I Get this Error "The shipment lines have been deleted." when posting shipment lines from Warehouse,
IN CU80
RemQtyToBeInvoiced = -1 and SalesLine."Qty. to Ship" = 0 hence it satisfies the condition
IF ABS(RemQtyToBeInvoiced) > ABS(SalesLine."Qty. to Ship") and Throws the error. Any idea what could be the possible reasons.

The version is 3.70, SQL DB

Thanks

Apricot

David_Cox

Has the Order already been part shipped then changed?

Has a line been added to or deleted from the Sales order after a Shipment has been Shipped, or has the Code been changed to codeunit 80 to supress empty lines.

This error happens when you have a Shipment with less or more lines than a Sales Order, and the code is looking for a line with the same line number or the same number of rows.

Say 12 lines on the Order and 11 on a Shipment would cause this error.

You can have more lines on a shipment if the shipment has been reversed but these are marked as correction lines.

I remember this error in older versions where customers did not want all the lines with 0 quantities, and the developers changed the posting codeunit, and you sometimes got the error in standard, but I thought it was corrected?

Apricot

Hi, Thanks for the info,
It is a partial shipment, In Table 111, there is no entry with one of the shipped items and the current order no. There is one number missing in sequence of Item Shipment entry No. firld in the table, so I guess the line has been deleted, not sure how, its a customized DB so the error might have been bypassed or something when deleting not invoiced but shipped lines.
Now the question is how to correct it, I was thinking of adding a fictitious line with same item no. and the missing Item shipment entry no., not the best way( to touch the table) but can't think of anything else. also don't know what cost to add in this line.

Thanks

David_Cox

Apricot wrote:

Hi, Thanks for the info,
It is a partial shipment, In Table 111, there is no entry with one of the shipped items and the current order no. There is one number missing in sequence of Item Shipment entry No. firld in the table, so I guess the line has been deleted, not sure how, its a customized DB so the error might have been bypassed or something when deleting not invoiced but shipped lines.
Now the question is how to correct it, I was thinking of adding a fictitious line with same item no. and the missing Item shipment entry no., not the best way( to touch the table) but can't think of anything else. also don't know what cost to add in this line.

Thanks

I was talking more in Shipment Lines vs Order Lines, are there the same number of lines on both tables?

Check the Sales Lines "Line No." and Shipment Lines "Line No." and the number of lines are they the same on both tables, it is looking for a line "Line No." that no longer exists on the Sales Order, or you have added lines to the order since the shipment.

It may be that after part shipping, the user deleted a line, that had not been shipped, just re-enter the line on the order in the same position with the same detail "No." and "Line No." from the shipment detail, set the quantity to zero, then you should be able to complete the process.

I think that the Item Shipment Entry number is not the problem here, but the line numbers!

Anonymous

That looks suspiciously like a message I recieved when there was something wrong with the tracking lines. Is the Qty to invoice correct on the tracking lines? The error message may be a little random.

David_Singleton

Apricot wrote:

Hi All

I Get this Error "The shipment lines have been deleted." when posting shipment lines from Warehouse,
IN CU80
RemQtyToBeInvoiced = -1 and SalesLine."Qty. to Ship" = 0 hence it satisfies the condition
IF ABS(RemQtyToBeInvoiced) > ABS(SalesLine."Qty. to Ship") and Throws the error. Any idea what could be the possible reasons.

The version is 3.70, SQL DB

Thanks

Apricot

Check if there are two sequential lines on the sales order with the same item number. I have seen a case of a slight bug in 3.70 where if you have two virtually identical lines on an order, and the second one was shipped before the first one, then you can get this error.

Apricot

The records in the sales shipment line, table 111 were not same as the records in the original order, some lines were deleted, it's customization which is causing a few lines to delete, entering those lines manually in
table 111 worked, now I'm investigating the code, how it got deleted in the first place.
Yeah, I guess the differences in quantities in tracking lines or tables 336, 337 can also cause this error to pop up.

Thanks

David_Cox

Apricot wrote:

The records in the sales shipment line, table 111 were not same as the records in the original order, some lines were deleted, it's customization which is causing a few lines to delete, entering those lines manually in
table 111 worked, now I'm investigating the code, how it got deleted in the first place.
Yeah, I guess the differences in quantities in tracking lines or tables 336, 337 can also cause this error to pop up.

Thanks

So the Error The shipment lines have been deleted." was exactly the problem!

Apricot

Exactly, for a change , the error was precisely what message said, but thanks anyways guys.

A.