Leading provider of Account Software
Questions? We got answers!
Support Center > Knowledge base> Article: Script to check the transaction which is posted to GL but does not appear in Bill Entries

Script to check the transaction which is posted to GL but does not appear in Bill Entries

Article ID: 52655 Email Print
Question
Script to check the transaction which is posted to GL but does not appear in Bill Entries

Answer

select *  from gltransaction
where journaltypecode = 'BILL' and documentno not in (select billcode from bill)


related articles

Article Details
Views: 666 Created on: Aug 07, 2014
Date updated: Aug 07, 2014
Posted in: Delphi

Poor Outstanding