Difference between revisions of "MAS 90 or 200"

From DataSelf Knowledge Base
Jump to navigation Jump to search
Line 19: Line 19:
 
May want to change QtySold and/or AmtCostofSales for Components to zero, and/or make a ComponentsQtySold measure.
 
May want to change QtySold and/or AmtCostofSales for Components to zero, and/or make a ComponentsQtySold measure.
  
'''Sales Order Lines''':<br />Import both ExplodedKitItem and SaleskitLineKey.
+
===== Sales Order Lines =====
 +
Import both ExplodedKitItem and SaleskitLineKey.
  
CASE WHEN ExplodedKitItem = ‘Y’ THEN ‘Kit’ WHEN SalesKitLineKey &gt; ‘000000’ THEN ‘Component’ ELSE ‘Regular Item’ END
+
<tt> CASE WHEN ExplodedKitItem = ‘Y’ THEN ‘Kit’ WHEN SalesKitLineKey &gt; ‘000000’ THEN ‘Component’ ELSE ‘Regular Item’ END </tt>
  
 
== ver 4.5 in SQL ==
 
== 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).
 
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).

Revision as of 16:45, 2 December 2013

AR Invoice History Header/Detail

Kit line items

Import fields 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).