V1 DBForm sniplets
In DBForms try where possible to use -E for Trusted Connections rather than hard coded usernames and passwords. Use dbsvpdf.exe to output V1 outputs to PDF For multi page, multi document outputs use a variable to control the end of page such as END_OF_DOC using a field you know will appear on the last page…
The Journal Listing Report on General Ledger produces lots of blank pages
Sage Line 500 V7.1 had an option added to not include blank lines between journals which lead to hundreds of pages of blank pages being printed. If not in your version ask your reseller referencing 58022 to obtain the latest binary version and system key file introducing this. NLJLISTBK1 = NO NLJLISTBK2 = NO Assembly…
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…
DBAuthorise View offscreen or offmonitor
With multiple screen setups (Laptop where a docking station has a different screen size to the laptop), the version of DBAuthorise client we have used sometimes displayed the window off the screen. If you can’t get the screen on your display (Shift right click the program in the task bar and click Move, or Restore…
Use TSQL to extract V1 DBArchive Blobs
Using TSQL it is very easy to automate extraction from Version One’s DBArchive product with its dbremoteblob program (It does require a username and password to access DBArchive and the program comes with DBArchive). With a 4 core CPU I extracted 72000 documents a day, a limitation found was the programs used did not return…
Check scheme.plitempm for any orphaned entries
Check scheme.plitempm for any orphaned entries against plpy tables, found to be caused by third party app not Sage Line 500.
Batch file set year into the future
Simple batch to set a variable 2 years into the future, works out Year, plus 2 and then adds to the date Credits: SS64 set /a YEARVAR=%DATE:~+8,2% set /a YEARVAR=%YEARVAR%+2 set YEARVAR=%YEARVAR% set DATEVAR=%DATE:~0,8% set “EXP_DATE=%DATEVAR%%YEARVAR%”
Restart Windows Server Task Scheduler
Requires PSExec to use the interactive account psexec -i -s cmd sc stop schedule sc start schedule Credits: StackOverflow