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

" I think you want one just line per order."

Waiting for them to clarify, but per what theyve sent Ive read it as single line per order is fine...only if none haz.

If haz require indiv haz lines with repetition of order number only.

Thanks

What is the Web Category Header all about?

I'm useless adding sections (need to revisit the help literature) think the sage material isnt great so just sort of fudge it to get as close to the transport template as I could!

Hi, Thanks for the Implicit bit works a treat now for highlighted selection...just couldnt work it out from my inv report! Not all fields present? Correct I'm not too sure if Sage can pull through some of the fields think might be too complicated to do. Green fields I think I can return. 6. Hazardou...

Hi, Well I'm not sure if Ive misread there template and example Ive attached. But how Ive read it if the order contains haz items than these need to be below the first line (1st line containing core info to that order address details etc) So I think this is now correct Clarkes now.report other than ...

Good morning Bruce, Double apology! 1. For not making time getting back to you last week (was off yesterday), been a bit made with price increases lately. 2. The report you sent me was very close I just think I maybe saved it down and ran the wrong report or with incorrect sample data. Heres the req...

Hi, no as is on my report please exactly (as that mirrors there template they've asked for) the only diff being the first haz item line is on line 1 of that sales order so there's no gaps (orange highlighted) Remove gap.JPG Once that gap is removed some how it mirrors there template exactly. So when...

Sorry forgot to add the file
Many Thanks

Hi, Thanks for the quick response Bruce :D . Had a "misunderstanding" with transport company yesterday. I just semi mapped the csv file manually and sent it them expecting upload in their portal within 15mins per there promise. But then was told an hour later of a "misunderstanding&qu...

Hi Bruce, hope your well. It's taking us too long to key transport jobs on our transport portal plus its just a boring repetition keying sales order details again! Been given the transport import csv template and attempted to make a sage sales order report to mirror (by adjusting current report) but...

Hi Bruce, Have a few things to get back to you with...doing myself no favs starting something new. On a Sales Invoice report I want to return roofing trim sales by quanty per inv. I think the best way to do this is by Category but Im struggling to get it to work. Product category.JPG I can only get ...

Hi Bruce,

Yeah stumbled across this might be why then. So if ive got "Materials" in Details its trying to make this a number.

Ok might get rid of that kg price end field.

Thanks

Thanks Bruce... Ive tried to add on the data joiner The project reference fields & cost code field to the below report. So when I import the below fields I can run this report & see all the fields. Really struggling with the join tried a few variations but think the sage help material is cr*...

Hi Bruce,

Works great thanks. Can I encompass variations of Kg, kg, KG etc within replace?

Thanks

Cheers Bruce will have a look tomorrow.

Hi, Audit split.Details Occasionally this field will have tonnage figures in e.g. 22,000Kg Is it possible to treat this as a number. Wish to form an expression: Auditsplit.Net/Auditsplit.Details I dont know if can do this with text fields and also with the added complication of the"Kg" at ...