MDGP October 2019 Release Feature of the Day: Long Description available for Payables Transactions

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP “October 2019” Release on which I am following and adding commentary. The index for this series of posts is here.

The eighth Feature of the Day is Long Description available for Payables Transactions. You can now enter a long description field for Payables Transactions once the option in Payables Setup, Enable Long Description in Payables Transaction Entry, has been enabled:

Payables Management Setup

Continue reading “MDGP October 2019 Release Feature of the Day: Long Description available for Payables Transactions”

Run Application Error Generating Remittances

Microsoft Dynamics GPI was onsite with a client a while ago helping them create new Citrix XenApp Gold Build Servers. When users were testing, they encountered the following error when generating remittances:

Run application error message

RUN APPLICATION ERROR

"C:UsersTEMP~1.FLAppDataLocalTempCheck Remittance~2.docx" '
returned 5

Continue reading “Run Application Error Generating Remittances”

Feature Explained: Invoice Receipt Date

Microsoft Dynamics GPBack in 2017, regulations in the UK changed so that business of a certain minimum size, had to start recording the date an invoice was received. To support this new regulation, Microsoft introduced a new Invoice Receipt Date field to a number of windows in the Purchasing series. This new field was introduced in the July 2017 hotfix.

The presence of this field does not seem especially well-known, so I figured I do a quick post covering where it is and how it would be used.

The Invoice Receipt Date has been added to the Date Entry windows for the three types of transaction:

  • Payables Transaction Entry (Purchasing area page » Transactions » Transaction Entry)
  • Receivings Transaction Entry (Purchasing area page » Transactions » Receivings Transaction Entry)
  • Purchasing Invoice Entry (Purchasing area page » Transactions » Enter/Match Invoice)

Taking Payables Transaction Entry as an example, to access the Payables Date Entry field, click the expansion arrow next to the Doc. Date field:

Payables Transaction Entry

Continue reading “Feature Explained: Invoice Receipt Date”

Payables Management Batch Posting Date Disabled When Workflow Active

Microsoft Dynamics GPA client recently logged an issue whereby the Posting Date on the Payables Batch Entry window (Purchasing area page » Transactions » Batches) in some companies:

Payables Batch Entry with Posting Date disabled

When we investigated the issue, it turned out that the field was disabled in those companies which had a Payables Transaction Approval workflow active; I did additional testing and the Payables Batch Approval workflow does not have the same effect.

Continue reading “Payables Management Batch Posting Date Disabled When Workflow Active”

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Mass Update Master Records from Navigation List

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The nineteeth new feature is Mass Update Master Records from Navigation List. This feature today is the ability to mass update a group of master records from the Navigation Lists; you can now inactivate and reactive multiple records at the same time for the following master record types:

  • Accounts
  • Checkbooks
  • Customers
  • Vendors
  • Items
  • Employees
  • In addition, the vendor navigation list allows you to mass update the temporary status; a visual indicator quickly lets you know the status of these records:

    Vendors navigation list

    With one caveat I like this new feature. Since they were introduced in Microsoft Dynamics GP 10, clients have been making more and more use of navigation lists; more interactivity can only be a good thing and the indicators make it easy to see the status of creditors.

    My caveat, is the presence of the option to toggle Temporary status. This is used by almost no clients and is very risky as temporary creditors can be deleted, regardless of history.

    Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

    Hands On With Microsoft Dynamics GP 2018 R2 New Features: Checkbook ID Defaults on Check Batch

    Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

    The fifteenth new feature is Checkbook ID Defaults on Check Batch. This feature means that when you create a new EFT payment batch in Payables Management, the Checkbook ID field will be automatically populated from Payables Management Setup:

    Payables Batch Entry

    Again, this is a small feature, but will save users time selecting the chequebook when creating a payment batch. It never really made sense that the chequebook would default in on a cheque batch, but not on an EFT one. This has now been remedied so both types of payment batch work the same way.

    Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

    Hands On With Microsoft Dynamics GP 2018 R2 New Features: Vendor Document Number Added to Purchasing All-in-One View

    Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

    The eighth new feature is Vendor Document Number added to Purchasing All-in-One View. This feature adds the Document Number to the Payments and Credits column of the Purchasing All-in-One View (Purchasing area page » Enquiry/Inquiry » Purchasing All-in-One View):

    Purchasing All-in-One View

    This feature is a good feature which will provide additional information to users that they have found the correct information.

    Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

    Hands On With Microsoft Dynamics GP 2018 R2 New Features: Transaction Level Post Through General Ledger

    Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

    The seventh new feature is .When transaction posting is enabled, this feature allows users to perform posting through the General Ledger at a transaction level. The following is a list of supported transactions for this feature:

    • Invoice Entry
    • Receivables Apply Doc.
    • Receivables Cash Receipts
    • Receivables Sales Entry
    • Sales Deposits
    • Sales Trx Entry
    • Voided Trx Maintenance (Sales)
    • Payables Trx Entry
    • Payment Entry
    • Purchasing Invoice Entry
    • Purchasing Prepayments
    • Receivings Trx Entry
    • Returns Trx Entry
    • Assembly Entry
    • Transaction Entry (Inventory)
    • Transfer Entry
    • Manual Checks (Payroll)
    • Project Accounting Transaction windows except Project Closing

    To enable post through for transactions, open the Posting Setup window (Administration area page » Setup » Posting » Posting), and mark the Post Through General Ledger checkbox below the Allow Transaction Posting one:

    Posting Setup

    In theory this is a great addition to Dynamics GP, as many clients want to do transaction level posting, although more these days are wanting to use workflow for approvals which still requires batches.

    However, in my testing so far, all Sales transactions which I post using post through work fine, but nothing on Payables posts through at transaction level regardless of the settings.

    I need to do additional testing, but so far this feature isn’t looking good.

    Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

    Hands On With Microsoft Dynamics GP 2018 R2 New Features: Display Vendor Hold Status

    Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

    The third new feature is Display Vendor Hold Status. This makes the vendor hold status more visible to users both by displaying an icon, but also by confirming with the user that the want to proceed with entering a transaction.

    The red hold icon will display next to the Vendor ID field in the following windows:

    • Vendor Inquiry
    • Transactions by Vendor
    • Purchasing All-in-One View
    • Payables Transaction Entry Zoom
    • Purchase Order Entry
    • Receivings Transaction Entry
    • Enter/Match Invoice

    When the user enters a transaction and the creditor is on hold, they will be prompted as to whether they want to proceed:

    Vendor XXXX is currently on hold. Do you want to continue?

    Continue reading “Hands On With Microsoft Dynamics GP 2018 R2 New Features: Display Vendor Hold Status”

    Hands On With Microsoft Dynamics GP 2018 R2 New Features: Monthly Recurring Batches

    Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

    The first new feature is Monthly Recurring Batches. This feature allows a recurring batch to be created in Payables Management, Receivables Management and Inventory Control.

    When creating the batch, after selecting a Frequency of Monthly, mark the new Use last day of the month; this will change the Posting Date to the last day of the month:

    Payables Batch Entry

    Continue reading “Hands On With Microsoft Dynamics GP 2018 R2 New Features: Monthly Recurring Batches”