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 galetaacc
14 Jun 2019, 13:07
Forum: Sage 50 Report Designer
Topic: Aged debtors to excel via Microsoft Query
Replies: 3
Views: 6621

Re: Aged debtors to excel via Microsoft Query

I see. Thank you. 1. When you say two queries, do I need to run them separately on different tabs or under one? 2. It is easy to bring up the sales ledger info because all I need is ACCOUNT_REF and NAME. In order to link it with audit header, I believe I have to create the connection. Do I have to l...
by galetaacc
14 Jun 2019, 11:38
Forum: Sage 50 Report Designer
Topic: Aged debtors to excel via Microsoft Query
Replies: 3
Views: 6621

Aged debtors to excel via Microsoft Query

Good afternoon, Could please anyone help me run aged debtors report from Sage to Excel using Microsoft Query? I linked my Sage (version 25.1) with excel. I struggle when linking the Sales ledger with Audit Header. I choose Acc.reference and Acc name from Sales ledger and then trying to get the aged ...