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”

    MDGP 2018 R2 Feature of the Day: Checkbook ID Defaults on Check Batch

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

    The eighteenth Feature of the Day is Checkbook ID defaults on check batch.

    This feature is an enhancement which defaults the Checkbook ID default from the Payables Management Setup window (Purchasing area page » Setup » Payables) into the Payables Batch Entry window (Purchasing area page » Transactions » Payables Batches) when creating a Computer Checks batch. The Checkbook ID will also default in the Select Payments and Edit Payment Batch window.

    Payables Batch Entry

    I welcome this feature as it will somewhat streamline the creation of payment runs. A lot of clients will only use one checkbook for making payments, so it has always seemed od that the chequebook couldn’t be defauted in.

    Click to show/hide the MDGP 2018 R2 Feature of the Day Series Index

    MDGP 2018 R2 Feature of the Day: Transaction Level Post Through General Ledger

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

    The seventh Feature of the Day is transaction level post through general ledger. This feature is a new posting option in the Posting Setup window (Administration area page » Setup » Posting » Posting); when Allow Transaction Posting is marked, a new checkbox for Post Through General Ledger Files is now available:

    Posting Setup

    Continue reading “MDGP 2018 R2 Feature of the Day: Transaction Level Post Through General Ledger”