Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Cashbook Bank Management

Posted on by 35

We have a GP client that is trying to enter bank transfers between two checkbooks that have different currencies, where neither of the currencies is the functional currency of the GP database. Therefore, GP does not allow this transaction.

Can someone please help me understand the role of CashBook Bank Management, and if this is an option for the client? It seems that the Cashbook Bank Management (CBM) module in GP may allow this type of transaction.The client does have 2 installs of GP - one is a US install and one is a UK localized install.

If we purchase this module, will the new reg keys work successfully in both the US install of GP and the UK install?

Thanks in advance for your help,

Eve

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Cashbook Bank Management

    Hi,

    It looks like Cashbook Bank Management would be a viable option for your client. More about that later.

    I'm certainly no expert in licensing, but I thought that you needed two licenses if you had two installations of GP. If your reg keys are different for each license, then the new reg keys will not work for both. If, however, you are using the same reg keys for both installations, the new keys will work for both.

    About Multicurrency and Cashbook Bank Management, here's the skinny:

    Cashbook Bank Management supports up to four different currencies within a

    single transaction. You can have a functional currency, two checkbook currencies

    (in the case of bank transfers), and a transaction currency. However, when you post

    transactions from Cashbook Bank Management, only two currencies update the

    General Ledger, Receivables Management or Payables Management modules.

    For example, if your functional currency is the Euro, but you also have transactions

    in the DEM and the BEF, you could have any of the following currency

    combinations while entering transactions in Electronic Bank Management:

    Refer to the following information to understand which two currencies will update

    Microsoft Dynamics GP for a transaction.

    • If all the currencies are the same as the functional currency, then General

    Ledger, Payables Management and Receivables Management are updated with

    the functional currency.

    • If the functional currency is the same as the checkbook currency, but the

    transaction currency is different, then General Ledger, Payables Management

    and Receivables Management are updated with the functional and transaction

    currencies.

    • If the checkbook and transaction currencies are the same, with a different

    functional currency, then General Ledger, Payables Management and

    Receivables Management are updated with the checkbook and functional

    currencies.

    • If the functional and transaction currencies are the same, with a different

    checkbook currency, General Ledger, Payables Management and Receivables

    Management are updated with functional currency only.

    If Bank Reconciliation is registered, you cannot process Payables Management

    transactions for this combination of currencies.

    • If the functional, checkbook , and the transaction currencies are different, then

    General Ledger, Payables Management and Receivables Management are

    updated with the checkbook and functional currencies. The transaction

    amount is converted to the checkbook amount using Cashbook Bank

    Management’s user-defined exchange rate. The converted checkbook amount

    is converted to the functional currency using the exchange rate set up in

    Microsoft Dynamics GP.

    The payment must be made in the functional or checkbook currency to apply it to an

    invoice.

    That's straight from the source (Microsoft).

    Kind regards,

    Leslie

    PS a cash receipt will automatically update the checkbook register balance without the need for deposit, if I'm remembering this correctly.

    LV

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