Sales Order Import with GL Distributions
Business integration specialist Janeece Moreland explains GL Distributions and how a developer can take data that has been provided on an Excel spreadsheet and create a map with SQL Select to group data appropriately on the detail map functions. The example shows how an Excel Spreadsheet containing items such as customer info, item descriptions and GL account numbers can be mapped to correct places within the general ledger so that invoices can be created. While the original map provides GL distributions lines, EFT imports, Post Import SQL tasks and Rolling columns, this article only addresses the distribution line functionality.
To read the full blog posted on The eOne Dymanics GP and CRM visit here.