Configuring for Sage 500

From DataSelf Knowledge Base
Revision as of 23:25, 28 November 2014 by Lwright (talk | contribs)
Jump to navigation Jump to search

Reporting Packages

SA Sales

SA Sales reporting imports the Warehouse and the line-level ShipToAddrKey from tsoSOLineDist.WhseKey. SO if sales reporting by warehouse or line-level ShipTo address is desired, tsoSOLineDist table will need to be included in the ETL refresh batch process. The tarInvoice.ShipToAddrKey could be substituted into the _B_SA_SalesHeader then into the _B_SA_Sales views, if all invoices ship to the same address.