Sage 100

Has anyone created a VI import (4.3 or 4.4) to import SO Invoices with Lots. These would be 1-step invoices with no Sales orders to worry about.

No I haven't

This ALMOST seems to be a no brainer, but then I remember who wrote the source code. About the only challenge (there I go again) is dealing with the lots, whether or not you have enough on hand in MAS. More difficult to visualize is how you handle multiple lots for the line item. Would this have to be a separate import? How else would MAS handle it?

Not that hard. Give me a second to find the notes from Scott Brady

How to import Lot/Serial Items into Sales Order Invoice Data Entry on version 4.10 and higher To import and distribute a Lot/Serial item, the source file must contain a distribution record. The format of the Distribution Record must begin with D, followed by the quantity, then followed by either the Lot number or the Serial number. For Serialized Items with a quantity greater than 1, the distribution record must include all serial numbers on the same distribution line separated by comma. Also, the distribution record on the Records tab must be defined where Field 1, Start 1, Length 1 = D Example: To import 3 serialized WIDGETS with serial numbers 1006,1007,1008, use the following format: 01,ABF,WIDGETS,3 D,3,1006,1007,1008 Note: The first record containing the Customer Number can be in any order, but the second, distribution, record must be in the specified format.

Nice. Very much appreciated @LouisAraiza The lot part is the part I was concerned about and this solves it. I'll let you know if I have any questions and will zip/store it here on the board. #VI