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 12 matches

by Onion RS
18 Mar 2024, 13:26
Forum: Sage 50 UK version General Help
Topic: Using ODBC sage 50 project activity report
Replies: 6
Views: 108

Re: Using ODBC sage 50 project activity report

Hi Bruce, That's really helpful. I'd clearly been looking at that in the development of my pivottable but had forgotten about the extra tables seen there. I put it down to advancing years. I must have twigged that a number of tables don't actually feature in the output of the PJACT.report and omitte...
by Onion RS
15 Mar 2024, 14:30
Forum: Sage 50 UK version General Help
Topic: Using ODBC sage 50 project activity report
Replies: 6
Views: 108

Re: Using ODBC sage 50 project activity report

Hi Bruce,

Eeek! By my count that report has 18 tables (although I'm not sure what to make of the top right table which doesn't appear to have any fields).

Do you mind me asking what report that screenshot is from?

Kind regards,

Ian
by Onion RS
14 Mar 2024, 22:11
Forum: Sage 50 UK version General Help
Topic: Using ODBC sage 50 project activity report
Replies: 6
Views: 108

Re: Using ODBC sage 50 project activity report

Hi, Having done this for a pivottable report recently, I think the columns you'll need are: PROJECT.CUSTOMER_REF, SALES_LEDGER.NAME, PROJECT.REFERENCE, PROJECT.NAME, PROJECT_TRAN.PROJECT_TRAN_ID, PROJECT_TRAN.AUDIT_TRAIL_ID, STOCK_TRAN.TYPE, PROJECT_ONLY_TRAN.TYPE, AUDIT_SPLIT.TYPE, PROJECT_TRAN.DAT...
by Onion RS
31 Jan 2023, 09:54
Forum: Sage 50 UK version General Help
Topic: Sage 50 Cloud Accounts downgrade
Replies: 8
Views: 21521

Re: Sage 50 Cloud Accounts downgrade

Hi Ian, I feel your pain. While you wait for a fix, maybe play around with the background image? If you remove it does the problem go away? It's likely that you wouldn't have paid much attention to the file size in 2016 if it just worked without issue back the. Maybe there would be a smaller file si...
by Onion RS
13 May 2022, 11:15
Forum: Sage 50 UK version General Help
Topic: Recreating Department P&L Report in Excel via ODBC
Replies: 9
Views: 7641

Re: Recreating Department P&L Report in Excel via ODBC

Hi Steve, Checked and I think this should work. Sheet1!$E:$E,"=40??" Regards, Ian PS Whilst this happens to work for your specific circumstance I'd be inclined to convert the code to a number, either in your query or in your worksheet, and then base the SUMIFS on the numeric version of the...
by Onion RS
13 May 2022, 10:53
Forum: Sage 50 UK version General Help
Topic: Recreating Department P&L Report in Excel via ODBC
Replies: 9
Views: 7641

Re: Recreating Department P&L Report in Excel via ODBC

Hi Steve,

Could it be a text v number thing? As I understand it the Sage nominal code field is of type VARCHAR.
by Onion RS
12 Feb 2021, 12:21
Forum: Sage 50 UK version General Help
Topic: read/write version of ODBC driver
Replies: 10
Views: 10696

Re: read/write version of ODBC driver

brucedenney wrote: 12 Feb 2021, 12:15 I think you use Excel and it is compatible.
Phew! Many thanks.
by Onion RS
12 Feb 2021, 12:05
Forum: Sage 50 UK version General Help
Topic: read/write version of ODBC driver
Replies: 10
Views: 10696

Re: read/write version of ODBC driver

Hi Bruce, It's just a little concerning when our product line relies on the reliable operation of the ODBC drivers! Maybe we are geniuses at SQL (without knowing it) or lucky that we haven't had any issues? I know it's a bit off topic (and a bit cheeky on my part - sorry) but I'm intrigued by what y...
by Onion RS
11 Feb 2021, 17:42
Forum: Sage 50 UK version General Help
Topic: read/write version of ODBC driver
Replies: 10
Views: 10696

Re: read/write version of ODBC driver

SomeGuy wrote: 11 Feb 2021, 07:43
I was reading a post on Sage's own support forum the other day where they were saying that they don't even support reading via the ODBC driver ...
Eeek!!
by Onion RS
28 Jan 2021, 11:05
Forum: Sage 50 UK version General Help
Topic: Inactive stock flag ODBC
Replies: 9
Views: 7685

Re: Inactive stock flag ODBC

Hi Someguy, Very interesting. I've played around a bit and it seems that the MS Query interface does indeed have a 255 field limit. However the ODBC driver does not. What I've done is use MS Query to set things up with a single field query like SELECT STOCK_CODE from STOCK and then edit the SQL in t...
by Onion RS
13 Feb 2020, 11:16
Forum: Sage 50 commercial postings (Adverts)
Topic: Onion - automated Sage accounts in Excel
Replies: 0
Views: 41242

Onion - automated Sage accounts in Excel

Onion Reporting Software aims to provide simple to use, low cost, yet flexible, high added value reporting products to the small business community. With many years of experience of working with financial reporting software for large businesses, responding to users’ needs regarding robust visibility...