3

In the 'Edit 1099 Transaction information' window (found under Transactions | Purchasing | Edit 1099 Transaction information), all the 1099 debit transactions (aka. 'invoices') are listed showing the 1099 tax type, box number and 1099 amount. However, since 1099's are reported by the PAID DATE, you cannot see the PAID DATE in this window, so it is really a guessing game for the user which invoices are included in the calendar year. (Was a 'December' invoice paid in December or January???.....) Showing only the Invoice doc date is really not helpful at all. To make this window much more efficient for the users, please consider:


  1. Adding the PAID DATE to this window. (The DINVPDOF 'date invoice paid off' field is already in the PM30200/PM20000 tables, so this field would just need to be dragged out to this window. simple!) Just having this would help SO MUCH!


2. And then add another date restriction to the top to be able to restrict the list for a specific calendar/tax year. Typically you only need to see the invoices for the given tax year, and not all their invoices back to the beginning of time. This would be a 'nice to have' feature. (However to do this, you may need to link to the PM30300 apply table, as some invoices may be partially applied to other documents, so you would need to consider all apply records. Note that the DINVPDOF field is only updated with the 'last' paid date for documents partially applied, and overwritten each time so one invoice from December could have been partially applied in Dec and paid off in Jan, so it would appear on both year's 1099's..)



STATUS DETAILS
Completed
Ideas Administrator

This is completed in the 18.7 release, year 2024.

Dynamics GP Resource Directory - Dynamics GP | Microsoft Learn

Thanks
Terry Heley
Microsoft