Hi Again Everyone!
With the release of Microsoft Dynamics GP 2016 R2, users can now specify a Vendor Address and a Distribution Account in the Payroll Vendor Setup window!! This feature will come in handy when a Vendor has multiple addresses and multiple distributions accounts that are used on a regular basis!
In prior versions of Microsoft Dynamics GP, the Address Id on the PM voucher is pulled from the Primary Address Id field in the Vendor Maintenance window. Additionally, the PAY account associated with the invoice created is normally pulled from the Vendor Account Maintenance window, or the Posting Account Setup window (when no accounts are assigned in the Vendor Account Maintenance window).
In Microsoft Dynamics GP 2016, if you assign a Vendor Address in the Payroll Vendor Setup window (Microsoft Dynamics GP >> Tools >> Setup >> Payroll >> Payables Integration >> Vendor), it will default as the Address Id on the corresponding PM voucher created via the PIP process. Additionally, the Account assigned in the Payroll Vendor Setup window will default as the PAY account on the corresponding PM voucher created via the PIP process:
You can view/verify the Address Id associated a voucher prior to posting in the Payables Transaction Entry window (Transactions >> Purchasing >> Transaction Entry):
You can view/verify the voucher PAY account prior to posting in the Payables Transaction Entry Distribution window (Transactions >> Purchasing >> Transaction Entry >> Distribution button):
Two columns were added to the APR_PIP40100 table (APR Payroll Vendors) to accommodate this new feature:
ADRSCODE = Address Code
ACTINDX = Account Index
Click HERE for more detailed documentation on this feature and for all other Dynamics GP 2016 R2 features.
For the Dynamics GP 2016 R2 feature VIDEO click HERE!
Be sure to check back to the Microsoft Dynamics GP 2016 R2 Feature Blog Series Schedule page to review posted blog articles and upcoming blog posts to help you gear up for What's New in Microsoft Dynamics GP 2016 R2 with great content, documentation, and videos.
Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP
Hi I know I am about a year late but I am kind of perplexed that this changes the PAY line? Wouldn't it be more useful for it to change the PURCH line?
What am I missing?
I have a client that the address is not working. They have a specific address setup in PIP, but when it comes to GP, the address is using the default address for the primary and remit to address. This is causing alot of issues with one vendor because there are three different remit to addresses.