I don't know about you, but I like to view all posting journals and edit lists on screen before deciding whether or not to print them. However, setting the default print destination for the 220 different journals is a real chore. If you have reasonable SQL skills and access to the SQL Server or know someone who does, here's a SQL script that will change all the posting journal settings in one fell swoop -
* click image to enlarge
This script sets the print destination for all posting journals in company 'TWO' to 'Screen'. 'TWO' is the company database. 'SY02200' is the Posting Journal Destination table. 'PRTOSCNT' = Print to Screen, 'PRTOPRNT' = Print to Printer, 'PRTOFLNT' = Print to File. A value of '1' = Print. A value of '0' = do not Print.
Because SY02200 is a Company database table, you'll want to run this script on each of your company databases. This is easily done by just changing the database ID in the 'USE' statement.
If there are journals you don't want to print at all, set the 'PRNTJRNL' field in SY02200 equal to '0'.
0 comments:
Post a Comment