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

Hi bruce,

Typo by me was wondering why you kept mentioning border.
No it was background colour, dont know the syntax to specify in conditional formatting so was guessingt how to apply grey fill.

Hi Bruce,

Thanks for the quick reply much appreciated 👍

So its literally only options below the expanded "Text Style" menu only?


if COMPONENT.STOCK_CAT = 60 OR COMPONENT.STOCK_CAT = 30 then
begin
TextStyle->Italic := True;
TextStyle->FontName := "Sitka Text";
TextStyle->Color := NamedColor ...

Hi,

Can you conditional format on anything?

Im trying to format colour background.

if COMPONENT.STOCK_CAT = 60 OR COMPONENT.STOCK_CAT = 30
then
begin
TextStyle->Italic := True;
TextStyle->FontName := "Sitka Text";
Background := Solid
Colour("Transparent");;
TextStyle->Size := 9;TextStyle ...

Hi Bruce,

Is a report via ODBC into excel always going to be slower than directly output from Sage natively? (as in just normal report output within sage itself)

Is this because:

Program/system wise its got to wait for the odbc driver/dsn pull from the data tables into power query then run ...

Thanks Bruce. So is the bank feed on merchant account a standard sage bank feed feature?

Can you email me details/prices for the the tool for sending emails please:


Thanks

Hi, thanks Bruce.

Yeah thought this was maybe beyond me I didnt know if was possible to make a dyamic external link, I'm guessing thats what the web developer is...there hosting the invs?

Whats the security issue?... the fact anyone can access the invoice if they have the link "www.hostwebsiteurl ...

Hi, thanks for this Bruce.

No I havent really noticed the payment tab on invoices 🤦‍♂️ but we dont use it and I dont think we will.

So I think it will be the SI header per your recommendation.

Sort of linked to this, we have never setup bank feeds. Can see how this is huge time saver for ...

I was very close ...getting alright at variables, functions and the expression syntax in between (IF statements etc) but i still hate/dont get sections and their interdependence

Hi,

Im new to drill downs but recently managed to parse the Delivery Postcode and a delivery tracking number (we insert into sage analysis 2 every day) to create a live tracking link. I've included these links to a dropshipping customer, we send him a daily statement with these links (alonside ...

Hi Bruce,

I was wondering if this is possible...or if there is a default invoice layout for this?

User case:

We post the daily sales invoices and then email them all at the end of play (4.15pm) each day.

We semi often get a customer reply upon reciept of their daily email that this has already ...

Hi,

Yeah, due to complexity Bruce was able to do it for me as a custom report. Maybe worthwhile contacting him directly.

Take care.

Everything is working how I require but i just can't sum these weights.

When item contains a "KIT" I wish it to sum the indivi componemts of the kit rather than pull through that Kits SKU weight.

The yellow highlighted are none kits just SKU's which contain a BOM and their showing indiv weight ...

"You need to filter out the unwanted weights, one way would be to create a "Weight" Expression in the footer of the stock item, then add up the Weight expression to get your total."

Is this section the "footer of the stock item"?
Thanks

Hi,

Thanks for this Bruce. Sorry didnt have time to get back to you yesterday....I jumped straight to trying to get it to work...unsuuccessfully prob done it wrong per what youve advised.
I'll screen grab later at work what Ive done.

Thanks

Hi Bruce,

This is a picking note template Ive started (well you helped me with section 5. ages ago) & I wish to sum the total weight at the bottom so we can quickly input onto our transport portal (currently manually calc weight from all the indiv item lines).

This overall layout is prob only 30 ...