ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Problem Transfering Inventory
http://www.istechforum.com/YaBB.pl?num=1301323837

Message started by gtladmin on 03/28/11 at 07:50:36

Title: Problem Transfering Inventory
Post by gtladmin on 03/28/11 at 07:50:36

Shipping is attempting to transfer a part (IN-L-J) from "default" inventory to a recently created location and they are receiving an error message. Two other parts have been successfully transferred to the new inventory location. I asked and the parts that transferred successfully were not part of any open/closed sales order

The following warning message appears when selecting the "Lot Number" when doing the part transfer:
"Item ILT-2x2-W65 has Open Sales Order (54758) with Lot information allocated for this location. Please unrelease this order and Try again."

The sales order the error is referring to has already been closed and invoiced--I checked the system and the SO was closed and invoiced on 3/21, but the new inventory location was created after that, probably on 3/24 or 3/25. I'm saying it's because the inventory has already been sold/released shipped/gone out that this isn't working, but Sales and Shipping and Finance disagree. Ok, so I'm asking the experts--why isn't this working?

And if they need to get some sort of a part transaction to this new location after the fact, is there a way for them to do this?

Title: Re: Problem Transfering Inventory
Post by Lynn_Pantic on 03/28/11 at 08:10:59

The message you are getting is because there is data for that part/lot in BKARTXN wjhich is the temporary file that assigns lot numbers to sales orders during the invoicing process. The file should have cleared when the invoice posted. You can clear it using Maintain Database.

Title: Re: Problem Transfering Inventory
Post by gtladmin on 03/28/11 at 12:20:39

That worked, thank you! Accounting said they didn't notice an issue when they did the invoice but well, there you go.