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

Hi, Extremely stumped by this price list report. It will pull through most of my customers SALES_LEDGER.ANALYSIS_1 field (which is market type)....but not all of them. Cant see any filter/conditional formatting on that field, cant find any common denominator with all the customers that this field do...

Hi,

Sorry I'm so late replying I saw your replies late and then jumped back into it and managed to get my report working .

Many Thanks

Hi, Struggling (same report) trying to change a text field: 10,000 kg to a number field for a calc. To extract 10,000 as a number to do net/10,000kg to get me a per kg price. Keep getting error Input string was not in a correct format. I have used remove and length functions to remove "kg"...

Hi Bruce,

Thanks a lot for that really didn't even attempt the splits.... that's ace works a treat .

One of those things I suppose always returning a transaction pathway even if there isn't one and getting an error.

Thanks again

Saw yesterday as well that the splits messed it up, but didn't have a clue how to sort that!

Argh just 2 slashes 🤦‍♂️. Couldn't find it in any sage literature and the online chat couldn't help me told me ring report team. I did and lady who answered couldn't help she wasn't report trained, plus they always want to Bill you mad money for telling me a small expression which is about 5% of ove...

Hi Bruce, Only just read your reply (so haven't tested) but want to say straight away thanks for going the extra mile there. Yeah saw this morning that will always return a data path even if no attachment...so still get the error. So I'm right in thinking there's no flag/identifier/variable whatever...

Hi, Before I ask this specific question may be much easier way 😆. Have a summary Purch ledger report, I wish to export a link to the attachments folder: C:\ProgramData\Sage\Accounts\2021\Company.000\Transaction Attachments\Purchase Transaction 137809 So can quickly access the supporting pdfs we have...

Thanks Bruce, think just have to get the stock switched on....for other reasons as well down the line, re-order levels etc. When we start selling kits I think will be too hard to check the stock BOM sub component stock levels the way we do things now anyway. I know there would be a learning curve bo...

A little bit of knowledge (on my part) is a dangerous thing! :oops: Our MD doesn't want stock "switched on". So all our prods are set to Item Type: Non-Stock.....because of this Sage told me my profit reports would always have to be based on cost price in the stock record "Last Cost p...

Morning Bruce, Doing my usual starting about 5 things and never completely finishing them 🤣 Do you know of a solution to this as sage aren't very helpful and don't know whether to investigate 3rd party software for raising our PO's. We don't have our stock switched on so to speak (but prob will in t...

Hi Bruce, thanks for this I'll have a go this afternoon.

Thanks

Any help as always much appreciated

Hi Bruce, Just stumbled across this feature and think it will be really useful. May result in me abandoning the use of batch report to show info in slightly diff ways. I have a report Sales invoice summary....I want to click an invoice number (drill down target) on my report and for it to open my De...

Hi Bruce, Is there a report for this? Without listing all the PO's raised which include said product. I just need individual lines for each product stating from which supplier we last bought any other PO info qty and net doesnt really matter. Just need to see who we last bought from for each prod......