Production Order Layout

[shikin]

Hi all.

I am using SAP B1 version 10 where i have a configurator for BOM and also Sales configurator. Meaning that by default it will follow BOM configurator and at the same time sales PIC also can configure when the time they want to create Sales Order. Here is the example:

Currently my production order layout, for sub component it takes data from BOM configurator which is wrong cause sales PIC already configure inside sales configurator here. How can i amend my production order layout where if no changes in SO configurator then it will show data by default based on BOM configurator but if they using sales configurator to configure it, it will show based on sales configurator data.

current sub report query in my layout is this:

SELECT 
distinct
'1st Row' as 'type',
t1.docentry,
t0.ComponentCode,
t0.bomCode as 'bomCode',
t0.Quantity *t1.PlannedQty as 'Quantity'
FROM FT_BOM_SUBCOM_ROW1 t0
left join owor t1 on t1.ItemCode=t0.BomCode

union all
SELECT 
distinct
'2nd Row' as 'type',
t1.docentry,
t0.ComponentCode,
t0.bomCode as 'bomCode',
t0.Quantity *t1.PlannedQty as 'Quantity'
FROM FT_BOM_SUBCOM_ROW2 t0
left join owor t1 on t1.ItemCode=t0.BomCode

union all
SELECT 
distinct
'3rd Row' as 'type',
t1.docentry,
t0.ComponentCode,
t0.bomCode as 'bomCode',
t0.Quantity *t1.PlannedQty as 'Quantity'
FROM FT_BOM_SUBCOM_ROW3 t0
left join owor t1 on t1.ItemCode=t0.BomCode

the table for sales configurator for this sub row is FT_CONFIG_SUBCOM_ROW1,FT_CONFIG_SUBCOM_ROW2 and FT_CONFIG_SUBCOM_ROW3

[DellSC]

I added the SAP Business One tag to your question to help get you a better answer.

-Dell