Sage 100

Sage 100 ERP 2013 Advanced PU 4 - Trying to use VI to bring in inventory transfers for lot/serial items. If I have four of the same item (Ex - ABCD) and different lots --- (Ex -- lot1, lot2, lot3, lot4) The VI seems to bring in lot1, lot2 then tells me for lot3 and lot4 that we don't have enough quantity to distribute. Can manually create the transfer no problem. There are quantities on hand (we can see them) for each lot. We run the IM_ClearCommitDataEntry utility and IM_CommitCheckClear_utl on the off chance that is part of the cause but nothing. Has anyone run into this or have any experience here? The issue seems to be with VI jobs to IM Transaction Entry where you are transferring lot/serial type items from one warehouse to another.

Answer: Surprisingly the portal has no info on this but the legacy knowledge base had a hint that led me to the answer. I found that we had to total the items that had lots and use the total in the line and then distribute the lots individually on the LL type line. Just to clarify with an example: Item # ABCD has 3 lots that I'm importing ABCD - Lot 1 --- 10 items ABCD - Lot 2 --- 23 items ABCD - Lot 3 --- 30 items You total up the items for ABCD and get 66. That goes to the first L quantity Then you pass each individual lot qty to the LL quantity lines This is one of those VI jobs where the error messages are of little use. We tried this on: Inventory Transaction : Adjustment Transfers Had to treat it the same way on both

How did you setup the spreadsheet or CSV file for the import? I'm attaching the Excel file, the VI Job printout and the job log. I'm stumped and your solution is the closest I found.

It's been a while but I think we totalled up the transactions for all lots of same item and imported that total to the first transaction quantity at the L field then we pulled in the details (lot by lot) to the transaction qty at the LL field. Both fields named TransactionQty. I know once we did that it worked like a charm -- so it does work just don't remember the exact file layout we used. I believe we had to feed a total for all lots of same item# to that first L field.