Aged Creditors Report

Question

Hi 
 Is there a way to run the aged creditors report (or aged debtors) for a specific nominal? 
 I am looking to identify the creditors at month end relating to stock (nominal 5010). i've tried but cannot seem to find a way to do this. if there is a report that would allow be to get this information without be having to review the nominal code each month and check for amounts sitting as a creditor. 
 Thanks

Andy Rickeard · Answer

Hi Anthea, I checked this with the Sage 200 Support team and they advised as below, unfortunately this isn't possible in Sage 200 because of the way the software works: 
 Sage 200 posts invoices as 1 transaction (no nominal code attached to this transaction) and then the relevant nominal transactions that make up the value of these invoices separately. 
 Due to this there is no unique link as a 1 to many relationship exists between the 2 data tables. 
 Example: 
 Sales Invoice = Net &pound;100 / Vat &pound;20 / Gross &pound;120 
 Nominal code 4000 = &pound;50 
 Nominal code 4001 = &pound;50 
 Vat Control 1100 = &pound;20 
 Debtors control = &pound;120 Regards, Andy Sage UKI

Sage 200 UKI

Aged Creditors Report

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING