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.

  1. Insert the required fields for invoices, for example:
    • H.InvoiceNo
    • H.ARDivisionNo
    • H.CustomerNo
    • L.ItemCode
    • L.QuantityOrdered
    • L.QuantityShipped
  2. 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.