GP needs VAT electronic filing to be compliant with Making Tax Digital initiative
The UK Governments Making Tax Digital initiative has started to be piloted and will be in affect within a year. More info on the initiative; https://www.gov.uk/government/publications/making-tax-digital/overview-of-making-tax-digital
Batch checkbook transactions
Every module in GP allows for the batching of transactions except for bank transactions. It would be very helpful, especially for companies that process hundreds if not thousands of batch transactions per month to be able to batch these transactions and print edit lists prior to posting these ...
Thank you for the suggestion, we will look into this in a future release.
Jodi Christiansen
PM, Microsoft
Group registration for VAT needed with making tax digital
With the February Hotfix we released VAT changes for making tax digital, electronic filing. There are some customers that may need Group registration for VAT. For Group VAT registration, separate legal entities are allowed to submit one consolidated return. As these are separate legal entitie...
This was added in teh 2021 mid year update
(+) Microsoft Dynamics GP 2021 Mid-Year Update Released! - Microsoft Dynamics GP Community
Terry Heley | Sr. Escalation Engineer | Microsoft Dynamics
701-492-6376 (o) | 701-412-5619 (m) | theley@microsoft.com
Edit List interruption causes batches to post
When a batch edit list is printed and interrupted, it can cause the batch to be put into batch recovery. When the batch is recovered, GP thinks that the batch was "posting" and finishes the posting process. This causes batches to post without workflow approval and can cause issues if the user h...
FIx Checkbook Register
The checkbook register runs very slowly after it was moved from a regular table in report writer to a temp table. The code to populate this temp table likely needs to be optimized because it takes up to 5 minutes just to run the report and I assume customers with higher volumes will take even lon...
Once you are on the latest code we honestly have had no users with problems unless they are a really big company with a lot of data
If you print from the inquiry window, choose the checkbook first and that will help with slowness, is this the step they are taking? I don’t think so based on initial suggestion.
This usually works much better for customers I have found and they are happy with it, just a little change of process.
With the work we did one is going through the report options window is using an old dexterity based report/coding
When we re-worked the other areas we converted all that to stored proc based so this could be part of the reason.
I would continue to advise the client to run it through the inquiry window if it works better for them.
Here is the history around it if you want to know:
If this is a larger company, depending on your records in your tables we may see this.
- If you print from the inquiry window, choose the checkbook first and that will help with slowness
When opening Checkbook Register Inquiry, before selecting a Checkbook ID, select to view Unreconciled transactions only. This will enable it to go quicker as it will eliminate parsing through the reconciled transactions in history. Optionally, you can also restrict it to a date range. Due to the volume of transactions in the history table, we don’t recommend viewing Reconciled transactions using this method
View Checkbook transactions in SmartList > Financial > Bank Transactions. This runs much faster than the Inquiry window.
Inactivate Checkbooks you are no longer using. Limit Checkbook ID Lookup to Active Checkbooks only.
Move reconciled transactions for the highlighted checkbooks to history. This will reduce open records by 28%.
Going forward, run Financial > Routines > Reconciled Transaction Maintenance on your active checkbooks on a regular (at least monthly) basis.
To give you a little history:
In GP 2016 we changed some items around Bank Rec and with those changes, we had some lingering report issues.
See blog on feature changes
https://community.dynamics.com/gp/b/dynamicsgp/archive/2016/11/11/microsoft-dynamics-gp-2016-r2-new-feature-blog-series-schedule
The last issue we fixed in GP 2018 R2, which i think you are on or later you indicated, when you try to print some of these reprint journals, you go into that options window
There is no option for checkbook so what you find in the dex.sql log if I say print this report for Audit trail code 'ABCDE'
It will loop through EVERY checkbook you have active and inactive, put them all in a temp table, then print that audit trail code, similar to what you stated.
For GP 2018 R2, we added "checkbook ID" options to several areas.
See this blog
https://community.dynamics.com/gp/b/dynamicsgp/archive/2018/10/26/microsoft-dynamics-gp-2018-r2-option-not-to-show-inactive-checkbooks-in-lookup-windows
We have done work on this already and most customers do not see it only a select few depending on the database size
Now if the issue is more going into the window and pulling up a document and they have upgraded from prior versions; I have found the following issue:
Query the CM20200 which will move to the CM30200
If not many in the CM30200, then we may need to do this.
Here is the blog on what we did and why we added it
https://community.dynamics.com/gp/b/dynamicsgp/archive/2016/12/22/microsoft-dynamics-gp-2016-r2-bank-reconciliation-reconciled-transaction-maintenance
If you are on the latest code, this window is working correctly and it will load blank with "no data" , we may just need to move some “stuff” to history.
If you have nothing in the CM30200 I would in a test company of the live, run the process and then see if you notice anything.
I have also had customers that do not mark off so then everything just sits in the CM20200 that too will cause this to be slow
Read Year field when defaulting First/Last Day dates in Fiscal Periods Setup window
When creating a new year in the Fiscal Periods Setup window, the system assumes the next year when defaulting the First Day/Last Day dates. If a client is adding history after going live, they may need to add historical years. Suggested update: read the year field to decide w...
Thank you for your suggestion. We will consider this functionality for a future release.
Best regards.
Increase the amount of Digits to Enter Exchange Rate in New Currencies
When creating a New currency, an attempt is made to create the exchange rate with the following amount: Bs. 103,225,562.85000000 in the Maintenance of multi-currency exchange rates screen, it only allows entering 7 digits in the integer part and 7 digits in the section for decimals. Problem: The...
Dynamics GP: HAve Safepay file pull name of employee used on the payroll check, not from employee master
In the past, there were complaints about the Safepay file pulling the vendor's name from the vendor maintenance card, and not the actual name used on the check. So in GP 2016 R2, we added a new feature to now store the check name in the Payables table (PM30200.VNDCHNM) and directed Safepay to pu...
(99+) Microsoft Dynamics GP October 2021 - Feature Blog Series Schedule! - Microsoft Dynamics GP Community
Add Date Range to Bank Trx History Report
Recognize quotes in bank file for comma delimited eReconcile download
When downloading a bank file that has a comma in a field and the entire field data enclosed in quotes, GP is ignoring the quotes and seeing the comma as a delimiter which throws off the entire file layout.
Thank you for the suggestion. We will consider this in a future release.
Jodi Christiansen
PM, Microsoft
Administrator
We have recently released the February hotfix for GP 2018 and GP 2016 and this includes the Making Tax Digital functionality.