web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Payable Cheque - Zero ...
Microsoft Dynamics GP (Archived)

Payable Cheque - Zero dollar Remittance

(0) ShareShare
ReportReport
Posted on by Bill Campbell 12

Zero_5F00_Remit.GIF

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

I have the same question (0)
  • Justin Thorp Profile Picture
    Justin Thorp 2,265 on at
    RE: Payable Cheque - Zero dollar Remittance

    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

  • Suggested answer
    Andrew Hall Profile Picture
    Andrew Hall 190 on at
    RE: Payable Cheque - Zero dollar Remittance

    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

  • Suggested answer
    Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: Payable Cheque - Zero dollar Remittance

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans