Back

Finance

Long Descriptions for Payables

[vc_row][vc_column][vc_column_text] What’s New in Dynamics GP 2019 Long description for payables transaction entries There are times where just a little more room in a description is needed. Until Dynamics GP 2019, one of the few options available was to add a note to the transaction. This is a great option when significant information is helpful to attach to a transaction. Many times, just a few more characters is all that is needed. There is a new option in Payables Setup for very long descriptions up to 200 characters.       The long description displays on the following pages: Transaction Entry Payables Transaction Entry Zoom PM Transaction...

Post Through General Ledger Files

Is there a way to post subsidiary ledger transactions direct to the GL? What’s New in Dynamics GP 2018 R2 Ever wonder why subsidiary ledger translation level posting do NOT post through to the GL? Users can now post through the general ledger at the transaction level in several windows. A new option has been added to Posting Setup to allow transactions to post through the general ledger if marked to post through. Posting Setup Before Dynamics GP 2018 R2 Posting Setup After Dynamics GP 2018 R2 Sometimes it’s the simple things that make a difference.  For many organizations this feature saves time and effort...

Project Cash Flow in Dynamics GP

How can I project cash requirements for the coming week in Dynamics GP?   Dynamics GP has a little-used feature, Cash Flow Calendar, that looks at all open AR and AP transactions and projects net cash flow based on the terms due date. When it comes to customers, they don’t always pay on time. The Cash Flow Calendar has an option to project cash receipts by the customers’ average days to pay. During times of tight cash flow, it becomes necessary to project cash flow requirements for the coming weeks. This starts with projecting customer and vendor invoice payments based on currently entered...

Dynamics Management Reporter Currency Translation Type

I posted this last year and felt it worth repeating! How Does Management Reporter know what rate to use when translating an Account from its functional currency to the Reporting Currency in Dynamics GP? They say a picture is worth a thousand words. Well, my white paper, Currency Translation in Dynamics GP and MR, has 3,147 words and this image sums it all up! I thought it may be helpful to lay out the logic and connections used by MR to correctly translate a functional to a reporting currency used in the sample Balance Sheet. Account is setup to Currency Translation...

Smartlist Builder to sort by Reporting Ledgers

As of the publication of our white paper, "Eliminations and Adjustments in Dynamics GP and Management Reporter", standard SmartLists for Account Transactions does not have a sort field for Reporting Ledgers. Here is what you need to create an Account Transaction SmartLists by Reporting Ledger. Basically, you have to rebuild the standard SmartLists, Financial>>Account Transactions, to bring in the field, Ledger_ID. GL40001 contains the needed descriptions for the Ledger_ID setup in GP. There are other options and it is hoped that Microsoft will add this field to the standard SmartLists soon, as well as in the Detail Inquiry window. Using separate Accounts dedicated...