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

The issue is caused by you having opened the data set with 2 different version of Sage50.

This is not uncommon.

When you restore a backup that has been on a newer PC then it will expect you to upgrade to that same version, to do this, there is a watermark.xml file which advises Sage what version ...

Glad I could help.

Typically c:\programdata\sage\accounts\2012\company.001\Accdata

It may be present on the login screen when you select the company.

Here is the sage guide https://gb-kb.sage.com/portal/app/portl ... 7112349406

it is in the accdata folder it is a file called watermark.xml rename it to anything or delete it.

Hi Broken

1/ A clean reinstall to a non standard directory eg c:\sage is the best route for any old versions of sage.
https://www.makingithappen.co.uk/sage-50-guides/clean-reinstall.htm

2/ The message you are getting is because you have not installed the updates. Most updates are available here ...

this is the most simple method

StringToInteger(PURCHASE_ORDER.ANALYSIS_1)

Returns 0 if not a number else the number.

If the number is not 0 then you could convert the field to a number and see if it is greater than zero

The last transaction number will only be recorded when the report is run.

Instead of running the report, run a backup and you are in a better position as instead of knowing the last transaction number you have a backup of everything including the last transaction number.

HI Aurora

Knowing what the transaction number was yesterday, is not really going to help.

And this process is not going to help in the period after it was run.

You could use scheduled backup to put multiple backups in a dropbox/one drive.google drive (encryption recoverable) folder which would be ...

If you have separate lines, you have control over where the line breaks are, if you put all the fields into one string, you have no control.

This avoids blank lines and allows you to control where the line breaks happen.

You could concatenate a few strings on each line, but if the line is wider ...

Hi

The strategy you are using is the problem as you have no control over the line breaks.

The way I would do this is to have footer sections for each line and a conditional format that supresses the printing of the line if there is no value.

So if there are potentially 5 lines I woudl have 5 ...

Nut and bolts last forever. They go in stock nothng specail about the life of a product.

You could put them in theri own stock category so you can devalue them by 1/25 each year so in th elast year they are wrth nothing.

Then again if they are not being resold they have no resale value so should ...

The problem is the need for detailed analysis.

You can work around this as follows:-

Setup a sales nominal code eg 4299 DoNotUse
On each invoice use the globalisation option in the footer to set the nominal to 4299
Now each invoice will post one transaction to the 4299 account for each invoice.
In ...

You do a stock journal

https://www.makingithappen.co.uk/sage-5 ... asect2.htm

To calculate the available stock from the stock transactions.

On inwards transactions take the QTY_USED away from the QUANTITY that came in, this will tell you how much of that batch is left add them all up and you know how many you should have.

Imagine this scenario:-

We buy 100,000 of Product A ...