Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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

...