Dynamics GP General Ledger SQL Code
- All GL Transactions Includes posted, unposted and historical GL transactions.
- All Posted GL Transactions Includes posted and historical GL transactions only (nothing unposted).
- Budget Refreshable Excel report for monthly GL budget in Dynamics GP.
- Fixed Allocation Accounts The distribution accounts and percentages for all active fixed allocation accounts.
- Historical GL Trial Balance Refreshable Excel report for Dynamics GP General Ledger trial balance showing the monthly net changes for the specified year.
- Open Year GL Trial Balance – Net Changes General Ledger trial balance showing the monthly net changes for the first open year in your Dynamics GP.
- Open Year GL Trial Balance – Month End Balances General Ledger trial balance showing the month end balances for the first open year in your Dynamics GP.
- Search GL Transactions Easier Has an Amount column for searching and also adds the date and time stamps,
- Variable Allocation Accounts The distribution and breakdown accounts for all active variable allocation accounts.