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

It is a memory error, using the 64bit version of 30.1 would, I expect resolve it.

I find export to excel to be very handy with small amounts of data, but with large amounts it is very very slow.

You might find it easier/faster to save one of the printable reports as csv/xls and open that.

If you want to keep things as they are then do nothing.

I thought you wanted to change it.

Is this in Price Lists?

If so, you can import them.

If you need to do a lot of changes, then using something like ImportPlus you can import the pricelists.

There are a number of price lists tools other than vanilla imports, e.g. a tool that creates price lists when discounts are given to give the ...

The date on the purchase order is an 2 places.

There is one on the order and then multiple ones for each item.

Which you use depends on when the goods will be delivered. The whole order or in parts.

Note there are DUE_DATE and an DELIVERY_DATE which are easy to confuse.

You could work out the lead times by looking for GI transactions in Stock_Tran and comparing the date they were received to the date they were ordered on the PO.

Not sure what you would then do with that.

If you are building a model of stock requirements then, that is very dependant on the ...

You can't convert reports, they refer to different variables in different tables.

You can use templates to apply a look and feel to all reports.

Please attach the SageDB dsn

Put a page break after on the invoice footer section.

You need to add a section for the invoice number so it can split, see this.

There are a number of things that can cause this.

Do some file maintenance. A reindex and compress and see if that helps.

The stock transfer is set up using a BOM

Create your sample product code, go to the BOM tab and enter the recipe to make it, add the source product and in the Qty enter 0.1 if you get 10 samples or 0.833 if you get 12.

Once setup, you can do a stock transfer enter the product you want to make and ...

So just select grey and the job is done.

No

You can use all the attributes exposed eg suppress print.

Background colour is one of the options, not sure what your issue is?

I thought you were wanting a border setting.

ive guessed the synatx to add the border colour condition:

The way to do that is to draw a box around the item set ...

The border is not an option.

The available options are shown in the wizard.
However, you could add a text box around the subject and then suppress printing with a conditional format to get the result you are looking for.

I don't use the SDK it is expensive, I use a 3rd party tool to write my integrations for others.

The ODBC drivers are slow, they use a comma as a separator or something like that, which makes some SQL ambiguous.

It is what the report designer uses and is functional for many if not most purposes ...