Sage 100

Customer has one item that the SO Committed quantity on the Cost Detail is incorrect.
The COST DETAIL FILE is correct...but it is taking the SO Committed from this record.
Even after rebuilding sort files...it still keeps the 2 ordered.
When I look at the ORDERS tab is in blank... But if I hit the VIEW LOT/SERIAL...
I get this "orphan" order that is already in the history file.

What file do I need to look into?? I have looked everywhere


------------------------------
Lourdes Sobrino
LU² DSD Puerto Rico
Guaynabo Puerto Rico
787.485.9638
------------------------------

Look at IM_ItemCost.QuantityCommitted.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

The so committed is in zero in that file 

------------------------------
Lourdes Sobrino
LU² DSD Puerto Rico
Guaynabo Puerto Rico
787.485.9638
------------------------------

Original Message:
Sent: 08-22-2020 11:10
From: Doug Higgs
Subject: SO COMMITTED QTY INCORRECT

Look at IM_ItemCost.QuantityCommitted.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

Lourdes,  Have you reviewed the IM_TransactionTierDist table?  
Well, that is not the right table. :(

Look at the SO_SalesOrderTierDistribution table for the orphaned record, then Rebuild Sorts.

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772
------------------------------

Here are the queries I use when troubleshooting cost tier availability.  The first set looks at all unposted tiers, and the second set looks for orphaned data (where the transaction header is missing).  If you don't find blocking data with the first set of queries, rebuilding sort files within IM (saying Yes to the prompt) should recalculate tier Committed quantities.

 

select * from BM_ProductionTierDistribution;

select * from BM_DisassemblyTierDistribution;

select * from IM_TransactionTierDist;

select * from SO_InvoiceTierDistribution;

select * from SO_SalesOrderTierDistribution;

select * from PO_ReceiptTierDistribution;

select * from PO_ReturnTierDistribution;

 

 

select * from BM_ProductionTierDistribution where ProductionNo not in (select ProductionNo from BM_ProductionHeader);

select * from BM_DisassemblyTierDistribution where DisassemblyNo not in (select DisassemblyNo from BM_DisassemblyHeader);

select * from IM_TransactionTierDist where EntryNo not in (select EntryNo from IM_TransactionHeader);

select * from SO_InvoiceTierDistribution where InvoiceNo not in (select InvoiceNo from SO_InvoiceHeader);

select * from SO_SalesOrderTierDistribution where SalesOrderNo not in (select SalesOrderNo from SO_SalesOrderHeader);

select * from PO_ReceiptTierDistribution where ReceiptNo not in (select ReceiptNo from PO_ReceiptTierDistribution);

select * from PO_ReturnTierDistribution where ReturnNo not in (select ReturnNo from PO_ReturnHeader);

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Thanks Kevin....I will definitely safe this list of files...

------------------------------
Lourdes Sobrino
LU² DSD Puerto Rico
Guaynabo Puerto Rico
787.485.9638
------------------------------

Original Message:
Sent: 08-24-2020 12:39
From: Kevin Moyes
Subject: SO COMMITTED QTY INCORRECT

Here are the queries I use when troubleshooting cost tier availability.  The first set looks at all unposted tiers, and the second set looks for orphaned data (where the transaction header is missing).  If you don't find blocking data with the first set of queries, rebuilding sort files within IM (saying Yes to the prompt) should recalculate tier Committed quantities.

 

select * from BM_ProductionTierDistribution;

select * from BM_DisassemblyTierDistribution;

select * from IM_TransactionTierDist;

select * from SO_InvoiceTierDistribution;

select * from SO_SalesOrderTierDistribution;

select * from PO_ReceiptTierDistribution;

select * from PO_ReturnTierDistribution;

 

 

select * from BM_ProductionTierDistribution where ProductionNo not in (select ProductionNo from BM_ProductionHeader);

select * from BM_DisassemblyTierDistribution where DisassemblyNo not in (select DisassemblyNo from BM_DisassemblyHeader);

select * from IM_TransactionTierDist where EntryNo not in (select EntryNo from IM_TransactionHeader);

select * from SO_InvoiceTierDistribution where InvoiceNo not in (select InvoiceNo from SO_InvoiceHeader);

select * from SO_SalesOrderTierDistribution where SalesOrderNo not in (select SalesOrderNo from SO_SalesOrderHeader);

select * from PO_ReceiptTierDistribution where ReceiptNo not in (select ReceiptNo from PO_ReceiptTierDistribution);

select * from PO_ReturnTierDistribution where ReturnNo not in (select ReturnNo from PO_ReturnHeader);

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------