In this day and age where the economy seems to be at the center piece of all business decisions, not even Dynamics GP has escaped the turmoil. Customers are demanding more efficient use of all business resources and paper is certainly one of those elements that lend themselves for true money saving. Frank's customer had wondered if all posting reports could automatically be directed to screen without manually having to go into each series posting option to change the output. In addition, he requested the system not ask for the destination of the report each time it was going to be printed.
The Posting Setup window (Microsoft Dynamics GP | Tools | Setup | Posting | Posting) displays all posting reports based on the series and transaction origin.
|Posting Setup window|
These settings are then stored in the Posting Journal Destinations table (SY02200) under the company database. In order to understand how data is stored in the SY02200 table, run the following query against your company database:
In turn, the query will return the following result set:
The Table Columns
PRNTJRNL: It's a flag that will determine whether a posting journal will be printed at all. 0 - Don't Print, 1 - Print.
ASECTMNT: Ask Each Time - will force Dynamics GP to bring up the Report Destination window.
PRTOPRNT: Print to Printer - 0 - Don't Print, 1 - Print
PRTOSCNT: Print to Screen - 0 - Don't Print, 1 - Print
PRTOFLNT: Print to File - 0 - Don't Print, 1 - Print
To force all posting reports to screen, we can then run a query that will change the status of the PRTOSCNT column to 1 - Print, while changing the status of all the other output destination flag columns to 0, as follows:
Remember: You can always filter this UPDATE statement by product series in order to control the posting journals output more granularly.
Until next post!
Mariano Gomez, MVP