V1 DBForm sniplets
In DBForms try where possible to use -E for Trusted Connections rather than hard coded usernames and passwords. Use dbsvpdf.exe […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
Restart Windows Server Task Scheduler
Requires PSExec to use the interactive account psexec -i -s cmd sc stop schedule sc start schedule Credits: StackOverflow