Difference between revisions of "MAS 90 or 200"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
=== Kit line items === | === Kit line items === | ||
| − | ===== Import fields ExplodedKitItem | + | ===== Import fields ExplodedKitItem (SQL Server?) ===== |
Add the following fields to <tt> _F_SalesLine </tt>: | Add the following fields to <tt> _F_SalesLine </tt>: | ||
Revision as of 16:48, 2 December 2013
AR Invoice History Header/Detail
Kit line items
Import fields ExplodedKitItem (SQL Server?)
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)
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).
