How to import Alias Item Numbers in Sales Order Invoice Data Entry for Sage 100
Desription
How to import Alias Item Numbers in Sales Order Invoice Data Entry in Sage 100 ERP
Disclaimer
Sage Customer Support does not provide assistance for issues related to third party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions.
Resolution
Create an import into the table SO_InvoiceHeader.
- Insert the required fields for invoices, for example:
- H.InvoiceNo
- H.ARDivisionNo
- H.CustomerNo
- L.ItemCode
- L.QuantityOrdered
- L.QuantityShipped
- To import the Alias Item Number, set the L.ItemCode operation to Replace and point to the Alias Item Number column in the source file.