Bin Transfer Fails with eConnect Error 5047 "Lot Number Is Not Available"

Bin Transfer Fails with eConnect Error 5047 "Lot Number Is Not Available"

Bin Transfer Fails with eConnect Error 5047 "Lot Number Is Not Available"

Symptom

Submitting a bin transfer transaction can fail with eConnect error 5047 from the taIVMultibinBinToBinTransfer stored procedure: "Lot number is not available."

Cause

eConnect only checks whether the item/bin combination has a Lot Number Sold (LTNUMSLD) value in the IV00300 table. Even if enough quantity exists in the bin, eConnect doesn't check for more than one instance of the item before generating this error.

How to Fix

This is a workaround performed directly in SQL Server Management Studio (SSMS) against the GP company database:

1. Update the LTNUMSLD column on the affected item/bin row in IV00300 to 0.
2. Resubmit the failed transaction in the PanatrackerGP portal.
3. Update the LTNUMSLD column back to 1.

Questions? Contact Panatrack Support.

Related articles