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