| Code Block |
|---|
--CHECK THESE ADDITIONAL LINES. NOT SURE IF THEY ARE CORRECT, AS CQuential WAS MAKING THEM! AND NOT SAGE!
WHEN PST.Id NOT IN ('OInv', 'Crn','JCS','JCM','OGrv','JCI','MFMF','MFDR') THEN ROUND(PST.Debit,2)-ROUND(PST.Credit,2)
WHEN PST.Id IN ('MFDR') AND PST.Quantity = 0 THEN 0 --doing the draw actions onto WIP
WHEN PST.Id IN ('MFDR') AND PST.Quantity <> 0 THEN ROUND(PST.Debit,2)-ROUND(PST.Credit,2)
WHEN PST.Id IN ('MFMF') THEN ROUND(PST.Debit,2)-ROUND(PST.Credit,2) |
Finding differences - GL vs PostST - by transaction
...