Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Canadien suppliers in US suppliers Cheque Edit list (and vice-versa)

(0) ShareShare
ReportReport
Posted on by

Hi,

I would like to know why we find CAD supplier in our US supplier Cheque edit list (and vice-versa).

This problem happened only if we have a credit note apply on a invoice.

What could be the problem?

Thanks

Richard Malouin, CPA, CGA

*This post is locked for comments

  • Suggested answer
    Josh P Profile Picture
    Josh P 2,895 on at
    RE: Canadien suppliers in US suppliers Cheque Edit list (and vice-versa)

    Hi All,

    So, you can send a check that is in USD if the vendor is CAD and you also have CAD vouchers to be paid by allowing GP to handle the conversions. GP will convert the USD to CAD using the rate in your system. This happens when the currency being converted is your functional currency. The same would be true no matter if your functional currency is USD or CAD. The edit list may only be showing you functional amounts too. I do not remember off the top of my head if the standard edit list is by default only showing functional, not originating.

    Either way, I'd suggest adding a currency column in your edit check batch window to make sure you are selecting invoices that are all of the same currency if you do not want the conversion function to automatically happen. You can right click on the headers for the selection lists, and add the currency column there.

  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: Canadien suppliers in US suppliers Cheque Edit list (and vice-versa)

    hi Richard

    The behavior that you describe, I believe, is how GP is supposed to work.  If you enter invoices in different currencies against the same vendor then when you print cheques for that vendor you will get two different cheques giving you the opportunity to change the cheque stock and print on the appropriate currencies cheque.

    I think Joshua and I must be misunderstanding your question / concern.

  • rmalouin Profile Picture
    rmalouin on at
    RE: Canadien suppliers in US suppliers Cheque Edit list (and vice-versa)

    Hi Ian,

    Or vendor is identify properly in GP. The problem is depending which currency we print first (USD or CAD). On the "edit cheque list", the CAD vendor it converted in US$, but the cheque will be print in CAD$ (and vice-versa).

    Richard

  • rmalouin Profile Picture
    rmalouin on at
    RE: Canadien suppliers in US suppliers Cheque Edit list (and vice-versa)

    Hi Joshua,

    The credit is poste via a batch, and the batch have the proper checkbook ID. On the "edit cheque list", the CAD vendor it converted in US$, but the cheque will be print in CAD$.

  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: Canadien suppliers in US suppliers Cheque Edit list (and vice-versa)

    hi Richard

    We use the vendor class to identify CAD and USD vendors.  We then select cheques based on the vendor class.

    Where the a/p clerks have mistakenly entered a CAD currency transaction against a USD class vendor GP we end up with a CAD transaction on the USD cheque run.

    GP of course being multicurrency has no issues with this at all and believes the clerks in their data entry.

    The only issue is then we have the wrong cheque stock in the printer based on our data entry and set up.

    Have you possibly entered the wrong currency at data entry as my clerks sometimes do?

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Canadien suppliers in US suppliers Cheque Edit list (and vice-versa)

    Hi Richard,

    Do you have the box checked that will Include previously applied documents on the check stub?

    Kind regards,

    Leslie

  • Josh P Profile Picture
    Josh P 2,895 on at
    RE: Canadien suppliers in US suppliers Cheque Edit list (and vice-versa)

    When the credit is posted to the supplier, is this through a batch? Does the batch contain the proper checkbook id on it? The credit memo does not have any implications on cash if there is no direct cash transactions being entered in the transaction window, but the credit memo will show up on a report for the wrong checkbook if the wrong checkbook was selected when the credit memo posted in the system.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans