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
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
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
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
security around bank to prevent duplicate checks
Right now you can prevent duplicate checks in AP but you can't prevent duplicate checks between AP and Misc checks. I would like to see no duplicate checks by bank account so it would include both Misc and AP checks.
Thank you for your feedback.
We released this feature as part of the functionality in Dynamics GP 2018 R2.
Sincerely,
Theresa Nistler,
Microsoft.
NACHA Data Security Requirements June 2020 Changes for GP?
There are some NACHA Security Requirements for June 2020 Effective Dates: Phase 1 – June 30, 2020 for Originators and Third-Parties with ACH volume greater than 6 million in 2019 Phase 2 – June 30, 2021 for Originators and Third-Parties with ACH volume greater than 2 million in 202...
Please review an ISV for this if you need it, such as David Musgrave - GP Power Tools!
GP Power Tools Portal | Winthrop Development Consultants Blog (wordpress.com)
Thanks
Terry Heley
Microsoft
Administrator
We have recently released the February hotfix for GP 2018 and GP 2016 and this includes the Making Tax Digital functionality.