GP should update currency index for GL quick journals instead of leaving it at 0
Since at least GP 2015, GL quick journals currently does not set the currency index on transactions, only the currency ID. Instead of setting the value for currency index, it leaves it at 0 causing the value to be incorrect in the GL20000\ GL30000 tables. This can cause various issues with these...
Batch Edit shows incorrect GL Account
After adding the Distribution Reference to the Batch Edit report, when posting inter company transactions the GL account is incorrect as it tries to pull them from the originating company. Need ability to add the Distribution References to the Batch Edit List and also have the correct GL distr...
"Account is inactive" error in GL when posting from sub-module (PM/RM/SOP/POP) and account defaults in
When a GL account is defaulted on to a document in Payables, Receivables, SOP or POP, there is no validation. The batch will post fine in the sub-module, but will fall out to Batch recovery when you try to post in GL. The message on the GL edit list is "Account is inactive; please activate or ...
More MDA Reporting Functionality
MDA Smartlists need to include Originating Master Name and Originating Document Number and add the option to run on Posting Date in addition to the existing Transaction date. Also, the ability to include MDA groups and codes on batch edit lists, specifically in the Purchasing module, would be ...
When you use the Mass Modify Chart of Accounts it does not update MODIFDT column in GL00100
We use this column in a SmartList to show when an account changes so it would be nice if it updated all the time even when the Mass Modify is used When inactivating a range of accounts using the 'Mass Modify' feature in Dynamics GP, the Modified Date populates at 0/00/0000 on the SmartList aft...
Would like the General Ledger Mass Modify window to go through workflow when creating a new account
When creating new accounts using GL Account Mass Modify, the accounts come in with a Workflow Status of 0 (in the GL00100 table), which is not valid therefore allowing you to post against the account before being approved. No warning message is provided. When you manually create the item under...
Ability to copy an account
The ability to copy an account from an existing one, then change a segment or two, would be very helpful.
Ability to Reconcile to GL that will span multiple months when you run Multicurrency Revaluation
Currently, if Multicurrency Revaluation transactions span multiple months, the following error will occur when attempting to run the Reconcile to GL tool: Violation of PRIMARY KEY constraint ‘PK##XXXXX.’ Cannot insert duplicate key in object ‘dbo.##XXXXX’. The duplicate...
General Ledger with 4 letter segment will not display correctly in many windows
If you set up a General Ledger account with 4 letters in a segment such as JWEB or FORE when you pull them up in many windows including the General Ledger Account Maintenance, the entire segment will not display, it will look like JWEI and FORI as the last letter is always cut off, typically any ...
Ability to import Budgets with greater than 30,000 accounts
Would like the ability to import Budgets when I have more than 30,000 accounts, if we try this today, we get an error message “Unhandled Script Exception: Long integer out of range. Results Invalid." as the budget is too big to import.