Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Payable Check Printing
Microsoft Dynamics GP (Archived)

Payable Check Printing

(0) ShareShare
ReportReport
Posted on by Bill Campbell 22,647

Payable Cheque display - thought I understood it pretty well and I was pretty sure it was clear ( well as clear as it can be considering the way it is designed ) and I figured that since I had been at this for way too many years and never heard a complaint from a single vendor that all was right in the world of the Payable Cheque.

Not so . . . Today I got my first Vendor complaining 'I don't see where you paid this invoice.  The cheque remit shows the invoice but it says you paid zero to that invoice'

Wow . . . ok, is it me or is the format that hard to understand?

Maybe I am just soft in the head, and have convinced myself that the is good format and we should just tell all the vendors that this is how it is done.

Issue
I told the client 'oh, no you will not have any complaints and if you do I will go to Microsoft for you and see what we can do'   That was 2 months ago we set up the format and produced cheques, the client does not like them, but I was not about to 'recreate' the cheque format - heck we have been using it for years.

So, am I wrong?  Is there a better way?

*This post is locked for comments

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Payable Check Printing

    Thanks Leslie, I noticed that there is another post about the Check Remittance on the forum as well - similar comments about understanding the relationship between the Credit offered, how it is applied and then the way the Invoice shows as being PAID / or not.

    Thanks for your time on this matter.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Payable Check Printing

    I'll have to check this out. I'm sure you are correct, but maybe we can come up with something that will deliver the desired information.

    Kind regards,

    Leslie

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Payable Check Printing

    Hi,

    I sent you the cheque format as well as the remittance, the reprinted remittance has more information than the initial remittance. Which I have always found interesting.

    Hope it helps

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Payable Check Printing

    Posted a private Mail message.

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Payable Check Printing

    what's the email address

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Payable Check Printing

    Rosemary, can you export the Cheque Format that you are using.  Send to me via email.

    Thanks.

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Payable Check Printing

    Hi Bill,

    You are right there is no way to determine what happened there. Without disturbing the logic and design of GP we modified the cheque stub to include a description of the credit memo transaction and voucher number in order that both parties can follow the transaction.

    Don't work yourself up though, I needed to go check with our AP dept to remind me why that change was done.

    Ideally if a document type could print to show 'invoice' or 'credit memo' that would be more helpful.

    Regards

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Payable Check Printing

    No you are not - - here is a screen shot of the situation

    PayableCheckExplain.png

    Line 1: Invoice 1,455.90 there is a 2% discount offered - 27.73 shown ---- Net Amount Paid - ZERO

    Line 2: Invoice 2,139.90 there is a 2% discount offered - 40.76 shown ---- Net Amount Paid - 1,387.41

    Line 3: Invoice 1,078.05 there is a 2% discount offered - 20.53 shown ---- Net Amount Paid - 1,057.52

    Line 4 and 5 are the Credit notes that are applied AUTOMATICALLY by the system and so Line 1 gets the first 1,455.00 ( less 27.72 ) and line two get the remaining credit.

    Line 6 and 7 show Invoices with 2% discount, no Credit remaining to apply, and a completely understandable Net Amount Paid.

    -----------------------------------------

    So we all ask, whats the bid deal, this is how we have looked at the cheque ( check ) remittance for years and not until this one have a bothered to question the common sense of the document.  For 20 years I have simply agreed that when you apply the credit to the invoice it has to be shown somewhere and the remittance was the place.  But this client has made me challenge that thinking.  NO WHERE ON THIS DOCUMENT do I know  that this is what happened.

    The client took the time and effort to screen shoot the vendor detail and send it along so they would see better what happened.  That was still not enough.

    PayableCheckExplain.png

    The client did the math for the vendor as a way of explaining how the system works.

    -----------------------------------------

    Question:
    Am I nuts to work myself up over this?  Does anyone else struggle with the problem?

    If there is a better way to show the Payables Check without great amount of cost, please let me know as soon as possible.

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Payable Check Printing

    Am I missing something, if a credit memo is applied to an invoice of the same value, shouldn't it be zero for that document number?

  • Manikandan Profile Picture
    Manikandan 2,845 on at
    RE: Payable Check Printing

    Hi Bill,

    Is that payment batch different from functional currency? Is that Credit memo muliti-currency ? Is the invoice different than functional currency?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans