Microsoft Dynamics GP (Archived)

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

(0) Share

Report

Posted on by rmalouin

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

I have the same question (0)

All responses (7)

Answers (0)

Josh P 2,895 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ian Richardson 4,150 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
rmalouin on at

Like (0)

Report

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$.

Was this reply helpful? Yes No
rmalouin on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ian Richardson 4,150 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Josh P 2,895 on at

Like (0)

Report

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.

Was this reply helpful? Yes No