You’re offline. This is a read only version of the page.
22,647
We have a situation that I have not encountered in some time and I am not sure how to resolve.
When the client prints a Payables cheque the first 30 or more Invoices come up with the name, Voucher #, Date, Description and ZERO for the dollar amount.
However, one the face of the cheque the amount of 253,536.39 (correct value) is presented.
I seem to recall in the dark recess of my mind this in the past, but I don't recall the solution.
Thanks in advance.
*This post is locked for comments
Hi Bill!
We have KB article 855957 that goes over how to remove the Zero Dollar remittances which I am linking below.
855957 How to prevent zero dollar remittances from printing in Payables Management in Microsoft Dynamics GP
support.microsoft.com/.../en-US
There are a few other KB articles that might be of some help with the Zero dollar Remittances.
861276 How payments that have amounts of zero are treated in Payables Management in Microsoft Dynamics GP
support.microsoft.com/.../en-US
860395 Information about how manual payments, credit memos, and returns appear on the check stub and when they are removed from the PM20000 table and from the PM20100 table when you run the Select Checks process in Microsoft Dynamics GP
support.microsoft.com/.../en-US
Hope this information helps!
~Thomas Newcomb
------------------------------------------
Microsoft Dynamics GP Support
------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights
We used to have this problem all the time in the UK. In the end we put triggers on the PM20100 to remove the zero value entries , however if you do that you can't create a cheque batch through edit checks as that starts by building a zero value batch. the other option is to simply run a delete statement on the PM20100 and remove the zero value entries .
I have copied the triggers in below , how ever I would suggest converting them to a delete statement that you manually kick off that way you can still build cheque batches any way you like.
CREATE TRIGGER [DELETE ZERO REMITTANCE] ON [dbo].[PM20100]
FOR INSERT
AS
DELETE PM20100 WHERE KEYSOURC='REMITTANCE'
AND Apply_From_Document_Amou<>0
CREATE TRIGGER [DELETE ZERO AMT CHQS] ON [dbo].[PM10300]
FOR INSERT
AS
DELETE PM10300 WHERE APPLDAMT=0
AND CHEKTOTL=0
Hi Bill,
Can you tell me the exact name of the report you are using?
Can you also attach a screenshot of the layout of the report?
In the layout of the report if you open the field that is generating the Zero values...can you send a screenshot of that too?
Thank you,
Justin
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (