• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

Add Ins Query of Open Checks

 1 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Beth
New Member Send Private Message
Posts: 3
New Member
9/21/2011 5:55 PM
This seems to me it would be a simple query, but I can't pull all of the info that I need.  I want a simple list of any open checks for a particular cash code, along with the vendor Name and address for mailing due diligence letters.  Does anyone have any suggestions?
Sam Simpson
Veteran Member Send Private Message
Posts: 239
Veteran Member
9/21/2011 7:14 PM
If you are using CBCHECK then the REC-STATUS is 2 and the REC-STATUS in CBTRANS = 1. Of course yoiu have to relate cbcheck with cbtrans using trans-ident and bank-inst-code.