Difference between revisions of "MAS 90 or 200"

From DataSelf Knowledge Base
Jump to navigation Jump to search
(Import fields ExplodedKitItem (SQL Server?))
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
 
{{#breadcrumb:Tips for specific data sources}}
 
{{#breadcrumb:Tips for specific data sources}}
[[Category:MAS90]]    [[Category:MAS200]]
+
[[Category:MAS90]]    [[Category:MAS200]]  [[Category:MAS90/200]]
 
__NOTOC__
 
__NOTOC__
 
== AR Invoice History Header/Detail ==
 
== AR Invoice History Header/Detail ==
Line 6: Line 6:
 
=== Kit line items ===
 
=== Kit line items ===
  
===== Import fields ExplodedKitItem. =====
+
===== Import fields AR_InvoiceHistoryDetail.ExplodedKitItem =====
 
Add the following fields to <tt> _F_SalesLine </tt>:
 
Add the following fields to <tt> _F_SalesLine </tt>:
  

Latest revision as of 22:59, 28 May 2015

AR Invoice History Header/Detail

Kit line items

Import fields AR_InvoiceHistoryDetail.ExplodedKitItem

Add the following fields to _F_SalesLine :

CASE WHEN ExplodedKitItem = ‘Y’ THEN ‘Kit’ WHEN ExplodedKitItem = ‘C’ THEN ‘Component’ ELSE ‘Regular Item’ END AS KitLineType

And use these values to make a Kit Line Type dimension (probably with default for As Sold records)

KitItems.PNG

May want to change QtySold and/or AmtCostofSales for Components to zero, and/or make a ComponentsQtySold measure.

Sales Order Lines

Import both ExplodedKitItem and SaleskitLineKey.

CASE WHEN ExplodedKitItem = ‘Y’ THEN ‘Kit’ WHEN SalesKitLineKey > ‘000000’ THEN ‘Component’ ELSE ‘Regular Item’ END

ver 4.5 in SQL

SY0 table changes to a new location, and has all companies in one. So have to import once and make it static (or filter for each company).