Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Search found 2 matches

by FDW
17 Jun 2012, 13:48
Forum: Sage 50 Report Designer
Topic: Building Chart of Accounts report
Replies: 3
Views: 5346

Re: Building Chart of Accounts report

Wanting to build a P/L trend (12 month view) which adds the Parent levels (e.g. Sales and Product Sales) - I can write the SQL needed and wasn't sure if you could use raw SQL to make joins in Sage 50 Report Designer.
by FDW
15 Jun 2012, 06:04
Forum: Sage 50 Report Designer
Topic: Building Chart of Accounts report
Replies: 3
Views: 5346

Building Chart of Accounts report

I am trying to build a simple report that shows the Chart of Accounts grouped by: Level 1: CAT_TITLE.TITLE (e.g. Sales) Level 2: CATEGORY.NAME (e.g. Product Sales) Detail: NOMINAL_LEDGER.ACCOUNT_REF (e.g. 4000) + NOMINAL_LEDGER.NAME How do I link the NOMINAL_LEDGER.ACCOUNT_REF field to the LOW and H...