-
Dynamics GP: The 'Customer Combiner' tool not compatible with the RM Recalc scripts for 'average days to pay'
If you use the RM Recalc scripts for 'average days to pay', data exists for both customers in the ta780000 table, and so when you use the Customer combiner tool, it sees this as a duplicate record and you get this error: Violation of PRIMARY KEY constraint 'PKta78000'. Cannot insert duplicate key in object 'dbo.tx78000'. The duplicate key value is (XXXXX). Please make the customer combiner tool compatible with the 'average days to pay' RM scripts and not error on the ta78000 table. (CR #87802 - rejected) -
DYNAMICS GP: Need a unique 'file creation number' that increments for each Safepay file generated
Please add the functionality to have a "File creation number" or "unique file identifier" number that can be included on the header line in a SafePay file in Dynamics GP. It should increment over time. 1,2,3, etc. (This would mirror the same functionality that EFT has, (In EFT file format, map to DATA FIELD, table: Checkbook electronic funds transfer master, field: 'EFT Next file number'.) Safepay needs the same functionality to have a unique file identifier, as it is required by many banks. -
Dynamics GP: Life Insurance premiums only to allow 3 decimals (instead of 'All' benefits/deductions)
Over the years, it has been a popular product suggestion request to have Life Insurance to allow 3 decimals, as premiums often go out to 3 decimal places, and the SQL Table does allow up to 5 decimals. You can change the decimals under Tools | setup | Payroll | Payroll | Options for benefits/deductions to go to 3 decimals, however this changes ALL benefits and deductions in HR and Payroll, and users want it for Life insurance codes only. (Note: Older product suggestion databases would have more votes on this, as it has been a popular request over the years. This post below was logged, but I think it was worded incorrectly as the ability to go to 5 decimals is already there and users want it for LIFE INSURANCE ONLY and not 'all' ben/ded codes: ) https://experience.dynamics.com/ideas/idea/?ideaid=55806895-a627-e811-bbd4-0003ff68bdb9 -
Dynamics GP: 'Edit 1099 Transaction Information' window to include column for CHECK/PAID DATE to user knows what 1099 year any changes will affect
The "Edit 1099 Transaction Information' window (Transactions | Purchasing | Edit 1099 Transaction Information) is a fairly new window which allows you to change the 1099 tax type, 1099 box number or amount of the invoice that is 1099able. All invoices are listed and the DOC DATE for the invoice is listed, however the 1099's go by the PAID DATE or CHECK DATE, not the invoice date so it makes it difficult for the user to know what 1099 year any changes are going to affect, especially if an invoice is dated in December, you don't know if it was paid in the same year or the next year. It would be very helpful to add the PAID DATE or CHECK DATE into the window as well. (The invoice in the PM30200 tables had a 'DINVPDOF' column for 'date invoice paid off' that could simply be pulled on to the window along with the rest of the invoice information, so the column is already there on the invoice record.) -
Dynamics GP: make revenue and expense deferrals (RED) compatible with AA
Make deferral allocations compatible with AA. The work-around is to stop the batch in GL and add the AA codes to the GL batch in work before posting, or use the AA Edit Analysis window to edit/add the AA dimensions/codes to the Journal entry after it is posted.
-
Dynamics GP: make revenue and expense deferrals (RED) compatible with Intercompany
Dynamics GP: make revenue and expense deferrals (RED) compatible with Intercompany transaction processing. The Deferral allocations are booked in the originating company, but do not flow through to the destination company. Only the due to/due from accounts are used in the destination company.
-
Dynamics GP: Ability to sort EFT check remittances by name
For an EFT batch, the 'sort checks by' field is locked down in the Print Payments window in Payables. It defaults to payment number, regardless of what the 'sort checks by' default is set to in Payables Setup. It would be nice to open up this field and allow EFT check remittances to be sorted by vendor name instead of payment number.
-
Not require users to be out of ALL companies when reversing a GL historical year in one company
When you go to MDGP | Tools | Routines | Financial | Year-End Closing, click on the 'REVERSE HISTORICAL YEAR' button and click PROCESS, you get the error message: "You cannot reverse the historical year because other users are logged in to the system". It stops you from reopening the year, even if the users are in a different Company, so that doesn't make any sense. It makes sense to have all users out of the company you are reopening the GL year for, but it is not efficient to make users get out of all the other companies (in the Dynamics database) as well.
Can this feature be enhanced, so it only requires all users to be out of the company you are reopening the GL year for?
-
Dynamics GP: Have the DINVPDOF (date invoice paid off) column populate for all applied documents in Receivables
The DINVPDOF (date invoice paid off) column does not populate for all applied documents in the RM20101/RM30101 tables. The method you use to apply will drive if this column is populated or not and it should be populate for all 'apply' scenarios. For payables, it is populated for all 'apply' scenarios on both the invoices and payments, but for Receivables it is not updated for all apply' scenarios (where CURTRXAM = 0.00) .
There doesn't appear to be any impact to aged trial balance reports in Receivables, but it would be a nice enhancement to have to satisfy Auditors that are inquiring on documents and reviewing the data n the RM20101/RM30101 SQL tables.
-
Dynamics GP: Unable to process Lockbox in Web client (all configurator files change path)
When you attempt to process Lockbox transactions in Web client, the user browses to the import file on a mapped drive and the file location is changed to C:\GPHTMLTMPE\1 and will not process. In fact, all configurator type files (Lockbox, Safepay, EFT, Payroll DD, Electronic reconcile) have an issue in Web client with the path. Please fix. The work-around is to use the Fat client.
Link to safepay product suggestion:
https://experience.dynamics.com/ideas/idea/?ideaid=289bdfa9-3fb9-e911-b083-0003ff68bc25
You’re offline. This is a read only version of the page.
