NIL Posted Nominal Accounts Enquiry

Question

Hi, 
 How do I get a list of Nominal Accounts which have never been posted to in Sage 200C?

Toby · Accepted Answer

din't think there is an easy way in sage but in sql this works 
 
 select * from NLNominalAccount where NLNominalAccountID not in (select NLNominalAccountID from NLPostedNominalTran)

Sage 200 UKI

NIL Posted Nominal Accounts Enquiry

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING