Sage 50 Accounts

Welcome to the Sage 50 Accounts UKI Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Add department to nominal ledger

Posted By AJ Watson over 1 year ago

Hi, I essentially I want to see my nominal ledger, split by department.

I'm building a report in Excel that uses the connection properties and command type of SQL to extract data from the SAGE databases, but I'm not seeing any links between departments and nominal ledger. Is there a middle table I can link trough?

0 Ken Starnes over 1 year ago

The Audit Journal file has department name and number in it but that's all I can help you with
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Darron Cockram over 1 year ago

Not 100% clear on what you are trying to show in the report but there are no links between a department and a nominal code. You could report on transactional information and group that by nominal code and department if that is what you mean?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 50 Accounts

Add department to nominal ledger

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING