Tag Archives: Payables Management

Cashbook Bank Management – Value Exists In The PM_Key_MSTR Table

A client had an odd error with the Cashbook Bank Management module the other day when trying to enter a deposit; the following was printed on the exception report when trying to post the transaction:

Value exists in the PM_Key_MSTR table

I did some digging around and found that the Next Voucher Number field in Payables Management Setup – Options (Microsoft Dynamics GP menu >> Tools >> Setup >> Purchasing >> Payables Setup) was blank.

I set a new value in the Next Voucher Number field and the deposit could be posted without problem.

Posted in Cashbook Bank Management, Dynamics, GP, Microsoft | Tagged , , , , , , , , , | Leave a comment

Adding the Vendor’s Address To The Check Remittance

In Microsoft Dynamics GP 2010, Microsoft changed the underlying tables used by the Check Remittance; I believe this was for purposes of efficiency. However, the downside is that the table, pmRemittanceTemp, used to replace PM_Payment_WORK did not contain the vendor’s address or a link to a table which did.

In the past I have tended to use VBA to add the vendor’s address to the Check Remittance because it was quick and easy to do and I didn’t revisit this approach until Microsoft Dynamics GP 2013 was released. And the reason I revisited, was because of the new Web Client which does not support VBA customisations.

As always, I figured I might as well do a blog post about this and had it scheduled in to write when Richard Wheeler asked the question on the Community Forum. So, here is the step-by-step guide to adding the vendor address back onto the Check Remittance modified report.

Continue reading

Posted in Dynamics, GP, Microsoft, Report Writer | Tagged , , , , , , , , , , , | Leave a comment

EFT File Format Import/Export Error

I’ve recently been creating an HSBC Standard 18 BACs file format for a client in Microsoft Dynamics GP 2010 R2.

Unfortunately, once I released it to their system, they reported an error with the import where the Creditor’s Cheque Name wasn’t being output on the resulting file.

I did some testing and it turns out to be a bug in the export function of the EFT File Format (Cards >> Financial >> EFT File Format) window in Microsoft Dynamics GP 2010 R2; I have subsequently tested on GP 2010 SP3 and GP 2013 and the import/export works fine. I realised something odd was going on when I looked at the template in the EFT File Format window (Cards >> Financial >> EFT File Format) and saw that while the Series was defined as Purchasing in the header, the scrolling window for the Data Field only had Receivables Management tables and fields available to it and not the Payables Management tables and fields I would expect;

EFT File Format

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , | 2 Comments

MDGP 2013 Feature of the Day: Manual Prepayments

Microsoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The eighty seventh feature they’ve announced is Manual Prepayments.

This feature allows the management of the prepayment amount from Purchase Order creation through the creditor invoice by using the Manual Payment process in Payables Management while allowing the purchaser to control the prepayment amount.

The user has the ability to pay the prepayment at the time of creating the Purchase Order by using a check or credit card. GP tracks prepayment amounts separately from the vendors account balance which means creditor aging is not affected by prepayment transactions;

Purchasing Prepayment Entry

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , | 1 Comment

MDGP 2013 Feature of the Day: Computer Prepayments

Microsoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The eighty sixth feature they’ve announced is Computer Prepayments.

This feature allows a user or multiple users to process a Purchase Order Prepayment using a computer check or EFT (Electronic Funds Transfer). The process is managed from the creation of the purchase order with the prepayment through the consumption of the prepayment when the vendor invoice is posted.

When raising a purchase order, there is now a field for entering the Prepayment amount (which can be printed on the PO);

Purchase Order Entry

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , | 1 Comment

MDGP 2013 Feature of the Day: Document Attach

Microsoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The sixty eighth feature they’ve announced is Document Attach.

You can now easily and efficiently attach documents to a Purchasing or Sales transaction or Purchasing, Sales or Inventory master records. This feature creates the foundation for Document Attachment and the necessary additions to address Document Attachment for the Procure to Pay & Quote to Cash process and Inventory card.

The feature supports the scan process “Scan to be attached later”. “Scan to be attached later” – Is the process when documents are scanned using either a desktop or bulk multi-functional scanner to a storage location. At a later time the image is attached to a transaction or record in the ERP system.

Document attachment will store the initial scans in a file location and then upon attaching to the Microsoft Dynamics GP 2103 record, the image will store the attachment in a new SQL table specific to Document Attach. Attachments are stored by company.

Easy access is achieved from the transaction or record.

The default location for the documents to be attached can be specified in a new Document Attachment Setup window;

Document Attachment Setup

When entering a Purchase Order, for example, a new button is available in the scrolling window;

Purchase Order Entry

Which opens the Document Attachment Management window where the user can specify the files to be attached;

Document Attachment Management

This new feature is targeted at the following roles:

  • Warehouse Manager
  • Accounting Manager
  • Purchasing Agent
  • Shipping and Receiving
  • Accounts Payable Coordinator
  • IT Manager
Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , , , , | 3 Comments

MDGP 2013 Feature of the Day: Payroll Integration To Payables

Microsoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The sixty third feature they’ve announced is Payroll Integration To Payables.

With Microsoft Dynamics GP 2013 Payroll Integration to Payables we have added multiple enhancements to the integration.

You can have custom voucher descriptions, include or exclude leading zeros from the voucher number or consolidate vouchers for federal tax.

Control how the payroll information is posted to Payables Management by modifying your settings to meet your business needs;

HRP Suite Options

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , | 1 Comment

MDGP 2013 Feature of the Day: Reprint Payables Management Remittance

Microsoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The fifty eighth feature they’ve announced is Reprint Payables Management Remittance.

Now, in Microsoft Dynamics GP 2013, you can reprint the vendor check stub or remittance form after you’ve processed the payment. You can see invoices that were paid, credits that were applied and other information that displays on the check stub or remittance.

Re-create Check Stub is available on the Payables Payments Zoom window;

Payables Payments Zoom

Check Remittance

This new feature is targeted at the following roles:

  • Accounts Payable
  • Bookkeeper
  • Certified Accountant
  • Accounting Manager
Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , | 1 Comment

MDGP 2013 Feature of the Day: Printing 1096 Forms

Microsoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The forty eighth feature they’ve announced is Printing 1096 Forms.

In Microsoft Dynamics GP2013, you can print the 1096 summary form in addition to printing the 1099 forms.

The 1096 information can be printed on a pre-printed form for the 1099 Miscellaneous, 1099 Dividend and 1099 Interest tax types.

There is also a 1096 SQL Reporting Services Report that is similar to the IRS report layout that you can use for informational purposes only.

In Print 1099, mark to print the 1096 after you’ve printed your 1099’s for the tax type. Microsoft Dynamics GP will print on the preprinted form and mark the correct box for each tax type;

1096

This new feature is targeted at the following roles:

    • Accounts Payable
    • Accountant
    • Bookkeeper
Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , | Leave a comment

MDGP 2013 Feature of the Day: Default View Stores Sort Order

Microsoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The forty seventh feature they’ve announced is Default View Stores Sort Order.

Customers have the ability to choose additional sorts or custom sorts within lookups and can choose Set as Default View. Once this has been chosen as the default, the next time the user enters the lookup the list will populate based off the sort they Set as Default View.

This gives the customer the flexibility to set the lookups based off how they need to see the data and can save them valuable time in the application. The Set as Default option is available within the Customer and Prospects, Vendors, Items, Salespeople and Employees lookups;

Customers and Prospects Lookup

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , , , , , , | Leave a comment