Updating generic general ledger tables
Accounting prudence requires that all financial transactions should be reviewed by someone other than the person creating the transaction.Approval ensures validity and correctness of the transaction.You might need to make some adjustments to the journals coming from other sources if you want to change the accounts or amounts that are coming from the sub-systems.Review functionality gives the capability to query the journals based on different parameters and also make edits if required.ERPs come with a large number of seeded reports as well as with tools to define user specified reports. Some systems may have slight variations to the above process, but the underlying concepts remain more or less same!I would like to start by saying that I do not normally advocate updating Dynamics GP data directly in SQL Server.A busier company may post daily, while other companies may post weekly or monthly.
This decreases the possibility of errors and fraud.
In that case you need to follow the accounting principles and the steps explained in accounting process.
At this stage the journals are entered in the system and available for further processing, but they have not impacted the general ledger account balances yet.
Once the Journal is available in the General Ledger System you can query the journals that have been created.
While reviewing the journal, you can make edits/corrections if required.