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

Any idea how to delete GRN records?

Following receipt of items on a POP they have been 'booked in' using the GRN function. This has obviuosly created a GRN record somewhere on the system. The problem has occured after I have removed a large number of discontinued products that are no longer needed.

The error checker is now reporting that there are thousands of errors indicating that 'GRN number xxx is either invalid or corrupt'.

Is there a way of removing these old GRN records to clear these reported errors?

I'm using V10.02.0023

Out of interest I uploaded a backup into V12 (don't like the interface on V12 as I prefer the V8 appearance) and there were no errors reported just loads of warnings that products (part codes were identified) on a GRN were not there.

it is a VERY crude solution, but you can just delete the files containg the grns in the accdata folder.

Good morning,
I want to delete extremely old GRN records as I am getting the following warnings on Sage:

Goods Received Note Number ... product .... is missing

The product code is missing as they have been deleted due to no longer being required again and in the future.
The problem I am having is that these GRN numbers go right back to No. 1 and these can't even be viewed in the reports. The oldest GRN record I can view is No. 10146.

I am unsure where in the ACCDATA file are the old GRN records?

I am using Sage 50 Accounts Professional 2014.

Many thanks

I would backup, check data. reindex, compress and check data again first.

Deleting the GRN files will delete ALL GRN's

do you use the GRN's?