Customization DS1516- Print MC Misc Checks

Customization DS1516

Print MC Misc Checks

Problem Definition:

ACME has its functional currency setup as CAD for their GP Company.  They have a Checkbook setup with USD as the Currency assigned.

They want to be able to use the “Miscellaneous Check” feature in the Financial Series to enter and print a physical USD check so they don’t have to create the Vendor in GP.

If you attempt to select the Checkbook in GP for a Non-Functional Currency Checkbook you get the below message and can’t use the Checkbook.

A screenshot of a computer

Description automatically generated

Solution Overview:

This solution will modify the behavior of the Miscellaneous Check window to allow for creating checks in any currency.

Design Features:

Miscellaneous Check

Navigation: Financial >> Transactions >> Miscellaneous Check

The Miscellaneous Check window will be modified to enable Checkbook IDs that use non-functional currency IDs to be used. When one of these Checkbooks is selected, the window will behave as follows:

  1. The title bar will display the Currency ID being used on this check.
  2. ALL currencies displayed on the window will be in the Checkbook currency. In the example below, the $25 displayed and printed on the check, as well as the Credit/Debit in the scrolling window are ALL in USD (Checkbook Currency ID).

A screenshot of a computer

Description automatically generated

Viewing Functional Amounts

Navigation: Miscellaneous Check >> Additional >> Functional Amounts

A screenshot of a computer

Description automatically generated

(Sample screenshot from elsewhere in GP)

Field Function
Originating Displays the check amount
Functional Displays the amount in the company’s Functional Currency

Print Check and Post

When the Print Check and Post button, or Post button is clicked, the enhancement will first ensure there is a valid exchange rate for the Currency ID and Date. If one cannot be found, a warning will appear and the user cannot continue.

The printing of the check will not change. Since the amount entered is in the Checkbook Currency, it will be printed as displayed.

The posting of the check to the financial module will result in a recalculation of the functional amount based on the originating amount of the check and the assigned exchange rate for that date. The multicurrency information will be included in the document posting.

Assumptions/Requirements:

  1. The functionality described above will not work with eConnect, any software that uses eConnect, or any software that directly writes to, updates, or deletes from SQL tables.
  2. The functionality described above is intended for the GP Desktop client.
  3. National Accounts functionality is NOT used.
  4. Advanced Distribution functionality is NOT used.
  5. Unless otherwise noted in this document, reporting is not included in this estimate.
  6. Unless otherwise noted in this document, Word Template functionality is not addressed.
  7. Unless otherwise noted in this document, the enhancement will not integrate with 3rd party products. Some examples of 3rd party products would be:
  • An ISV plug-in product including WilloWare products
  • A dexterity customization designed by another developer
  • Dynamics GP Modules including, but not limited to:
  • Project Accounting
  • MDA
  • Analytical Accounting
  • Copy functionality found in SOP, POP and Inventory
  • Field Service
  • Extended Pricing
  • Manufacturing

For information on this design, or any other WilloWare customization or product, please contact us:

www.willoware.com/contact-me/