When you adjust the inventory level on a Part that is NOT accruing costs, no GL entries should be made. In some historic cases (in Control 4.3), these entries were made. This query identifies those entries. Once reviewed, they may be deleted or zero'd if desired.

High. Data is modified in this query. Do not run this except under the direction of a Cyrious Technical Support staff member. Doing otherwise may result in lost or contaminated data. All data modifications done through direct SQL are permanent and non-reversable.

SELECT ID,
       GroupID,
       Description,
       (SELECT ItemName FROM Part WHERE ID = PartID) AS PartName,       
       (SELECT AccountName FROM GLAccount WHERE ID = GLAccountID) AS AccountName,       
       Amount,
       *
FROM GL
WHERE PartID IS NOT NULL
AND PartID IN (SELECT ID FROM Part WHERE AccrueCosts = 0)
AND AccountID IS NULL 
AND Description IS NOT NULL
-- and EntryDateTime >= '1/1/2009'

• Entered : 12/2009
• Version : Control 4.3