Difference between revisions of "Configuring for Sage 500"

From DataSelf Knowledge Base
Jump to navigation Jump to search
Line 6: Line 6:
  
 
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.  
 
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 in, if all invoices ship to the same address.
+
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.

Revision as of 23:25, 28 November 2014

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.