Month: September 2023
Sage Line 500/1000 Period End Email Check
As part of Sage Line 500/1000 Period End we found it easier and more audit friendly to have an automated email fire via SQL. My colleague Jim wrote the below (Hey Bob!), I then changed it around to match the sections in which we ran period end. This made it easier to determine if period…
NL Batch processing states there is an error with a journal which does not show in list
In my experience this occurs on large Journals populated outside of Sage into Sage’s SQL database Record the errors or check the system.log file on the company for affected entries. Check if the entries actually exist with a TSQL statement select * from scheme.nljrnm(nolock) where journal_no IN (‘‘,’‘) order by journal_no,page_no Normally you will find…
Update Sage Line 500 Binaries
This should first be tested on a development system before being deployed to a live system. My steps may be incomplete, some binary upgrades will require new system keys or may require a utility to be run beforehand. Always test first! Ensure no-one is using the Binary being upgraded, it is recommended for all users…