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 108 matches
- 23 Aug 2022, 08:49
- Forum: Sage 50 Report Designer
- Topic: Invocie summary report (Total qty via web cat 1)
- Replies: 4
- Views: 21613
Re: Invocie summary report (Total qty via web cat 1)
Hi Bruce, Apologies I'm so late getting back to you I did have a draft reply from the day after you responded but not had time revisit! Thanks to your help I got it working :D Your completely right about the cat no. rather than name....be handy if Sage had sub categs. I still really struggle with ho...
- 12 Aug 2022, 11:45
- Forum: Sage 50 Report Designer
- Topic: Invocie summary report (Total qty via web cat 1)
- Replies: 4
- Views: 21613
Invocie summary report (Total qty via web cat 1)
Hi Bruce, Ive managed to add a Weight of the entire invoice via IF. However, wish to break that weight down via webcateg1. So if web cat1 = UN 1866 then tell me the weight for those items only on said invoice. Ive tried combining if and sumif with no joy. So then tried to return the weight for UN 18...
- 14 Feb 2022, 09:45
- Forum: Sage 50 Report Designer
- Topic: ODBC
- Replies: 8
- Views: 25702
Re: ODBC
Power Query in General:
As my query stands now why do i only see a connection and not the actually query to double click & edit in power query....as Ive seen on youtube. Also is there a way to stop it duplicating lines for the same invoice?
Thanks
As my query stands now why do i only see a connection and not the actually query to double click & edit in power query....as Ive seen on youtube. Also is there a way to stop it duplicating lines for the same invoice?
Thanks
- 14 Feb 2022, 08:26
- Forum: Sage 50 Report Designer
- Topic: ODBC
- Replies: 8
- Views: 25702
Re: ODBC
Hi,
Thats great Bruce thanks, I'll revisit this today.
Never thought of putting the Column O reference into Sage.
Thanks
Thats great Bruce thanks, I'll revisit this today.
Never thought of putting the Column O reference into Sage.
Thanks
- 09 Feb 2022, 16:21
- Forum: Sage 50 Report Designer
- Topic: ODBC
- Replies: 8
- Views: 25702
Re: ODBC
Sort of process demo of what doing now.
Wish to replace this with Power Query and Pivot from there.
Wish to replace this with Power Query and Pivot from there.
- 09 Feb 2022, 15:15
- Forum: Sage 50 Report Designer
- Topic: ODBC
- Replies: 8
- Views: 25702
Re: ODBC
Hi, Appreciate your time there 👍....makes sense what you said & why crashing prob too big with unlinked tables and it auto querying. This is the Sage report I'm trying to replicate: Bruce eg.report Purpose of this report really is to keep track of individual invoice profit. Will eventually pivot...
- 09 Feb 2022, 11:22
- Forum: Sage 50 Report Designer
- Topic: ODBC
- Replies: 8
- Views: 25702
- 09 Feb 2022, 11:22
- Forum: Sage 50 Report Designer
- Topic: ODBC
- Replies: 8
- Views: 25702
ODBC
Hi Bruce, Following on from the last topic that you've helped me with....but its about ODBC in general. Looking at youtube vids now to learn query....but Microsoft query itself keeps hanging/not responding. If my data table joins are wrong would I just get a warning or return no data....or would thi...
- 09 Feb 2022, 11:07
- Forum: Sage 50 Report Designer
- Topic: BOM Summary Excel export
- Replies: 2
- Views: 20842
Re: BOM Summary Excel export
Thats great thanks for this Bruce
- 20 Jan 2022, 21:51
- Forum: Sage 50 Report Designer
- Topic: BOM Summary Excel export
- Replies: 2
- Views: 20842
BOM Summary Excel export
Hi Bruce, Been trying to do something for hours and hours!...should of just watched the footy! Current report works summarizing when makeup cost is not equal to the assembly sku's last cost price standard. However, I wish to add the sub components into my report (Col H:R). I can return the component...
- 17 Nov 2021, 16:24
- Forum: Sage 50 Report Designer
- Topic: Sales Ledger analysis 1
- Replies: 10
- Views: 26215
Re: Sales Ledger analysis 1
Do I need to put full Version ref or just 27? version.JPG Do I need to create new data source or just click the bottom option there: Machine Data Source/ SageLine50v27 System Data source.JPG Ive prob set it up a bit wrong as sometimes crashing or struggling to update regardless of what Machine Data ...
- 17 Nov 2021, 15:58
- Forum: Sage 50 Report Designer
- Topic: Sales Ledger analysis 1
- Replies: 10
- Views: 26215
Re: Sales Ledger analysis 1
Wow awesome mate 🤗🤩. So is this ODBC you've mentioned before? (read about it but was over my head)...so could connect live data to report anything within the data? If I made worksheet 1 "Sage Inv" as source data for pivot tables does that mean they would auto update all the pivot tables &a...
- 16 Nov 2021, 15:38
- Forum: Sage 50 Report Designer
- Topic: Sales Ledger analysis 1
- Replies: 10
- Views: 26215
Re: Sales Ledger analysis 1
Yeah thats right mate. Send it to excel so easier to manipulate and compare.
- 16 Nov 2021, 09:43
- Forum: Sage 50 Report Designer
- Topic: Sales Ledger analysis 1
- Replies: 10
- Views: 26215
Re: Sales Ledger analysis 1
Hi Bruce, Thanks for reply. Its a long time ago I made this report, I cant remember If I edited the joins ( maybe/prob I did hence why there 2 sales ledger joins if this is what your referring to). Its still guesswork for me the join editor (think sage literature is cr*p prob on purpose to encourage...
- 12 Nov 2021, 15:59
- Forum: Sage 50 Report Designer
- Topic: Sales Ledger analysis 1
- Replies: 10
- Views: 26215
Re: Sales Ledger analysis 1
Hi mate,
Its kept: C:\ProgramData\Sage\Accounts\2021\Company.000\REPORTS\Products\My Products Reports
Thanks
Its kept: C:\ProgramData\Sage\Accounts\2021\Company.000\REPORTS\Products\My Products Reports
Thanks