SageForum for UK versions of Sage 50- Help and support.

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...

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...

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

Hi,

Thats great Bruce thanks, I'll revisit this today.

Never thought of putting the Column O reference into Sage.

Thanks

Sort of process demo of what doing now.

Wish to replace this with Power Query and Pivot from there.

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...

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...

Thats great thanks for this Bruce

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...

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 ...

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...

Yeah thats right mate. Send it to excel so easier to manipulate and compare.

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...

Hi mate,

Its kept: C:\ProgramData\Sage\Accounts\2021\Company.000\REPORTS\Products\My Products Reports

Thanks