How to get rid of an EMPTY value GRN?

**michellepace** · 10-Feb-20, 10:15 AM

Eurika!!! Thanks Kevin

Click image for larger version.

Name: Delete - successful.png
Views: 159
Size: 25.5 KB
ID: 7774

**Neville Bailey** · 10-Feb-20, 10:17 AM

Excellent news.

Thanks, Kevin, for the input!

**michellepace** · 03-Mar-20, 05:38 PM

The safest way to do it:
1. Make a backup of the company via the front end
2. Run a select statement (with the delete line commented out)
3. If the right thing was selected, comment out the select statement and un-comment the delete line in it's place.

Code:

select * from "HistoryHeader"
//Delete from "HistoryHeader"
where documenttype = 7
And Documentnumber in (' GN11563')

Thread: How to get rid of an EMPTY value GRN?

Thread Tools

Display

Similar Threads

Pastel Partner 12 Company data EMPTY.

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions