Multi-Company Customer & Vendor Payments in Microsoft Dynamics AX: Part I
Many of our clients have multiple companies which buy from the same vendors and/or sell to the same customers. If this describes your company and you want to a) streamline your cash receipts and disbursements processing and b) optimize cash management by consolidating bank accounts, you can utilize Microsoft Dynamics AX to pay vendors or receive cash from customers in multiple legal entities/companies in one step and using a single bank account. Dynamics AX gives you two tools to do this – Intercompany Accounting and Centralized Payments.
In this post, we will look briefly at the two methods and talk about the pros and cons of both. We will look primarily at multi-company vendor payments, but the same principles and setup apply to multi-company customer cash receipts. In upcoming blogs titled Multi-Company Customer and Vendor Payments - Part 2 Intercompany Accounting and Part 3 Centralized Payments, we will go through the setup and processing for both methods.
Intercompany accounting has broad application across Dynamics AX and can be used in all financial journals (i.e. General Journal, AP Invoice Journal, AP or AR Payment Journal).
Basically, Intercompany Accounting allows you to have a multi-company journal, a journal with lines for multiple legal entities. When the multi-company journal is posted, Dynamics AX generates and posts multiple journal entries (one for each legal entity included in the journal) and automatically creates the Due To/From entries to balance the journal entry within each legal entity.
Example 1: You have three different legal entities (USMF, DEMF, and USRT) but pay all vendors from one bank account (in USMF). (All the screen shots are from the New Microsoft Dynamics AX, but the functionality is the same in AX2012.)
Open vendor invoices:
The AP Payment Journal would look like this. (NOTE: You may need to personalize the Journal Voucher window to add Account Type and Legal Entity, called Company Accounts).
The resulting journal entries would be:
In Company = USMF
In Company = DEMF
To Company = USRT
Notice that in this example the vendor Property Management is set up separately for each legal entity and the vendor accounts are NOT linked in the Global Access Book. To utilize this method of AP payments across multiple companies, you will need to (a) separately select each vendor (in each company) and settle their open invoices separately or (b) Create Payment Proposal for each legal entity.
Example 2: Same scenario, same facts. In this scenario, however, Centralized Payments has been set up, AND the Property Management vendor account in all the legal entities have been linked in the Global Address Book. The vendor account numbers do not need to be the same, but they must be linked. (We will cover this in upcoming blog titled Multi-Company Customer and Vendor Payments – Part 3 Centralized Payments.)
The AP Payment Journal would be:
The net effect is the same, but using Centralized Payment you (a) select the vendor once and (b) can view and settle all the open invoices for this vendor across all your companies.
In summary, the net accounting effect from both methods is the same:
- One Payment Journal to pay vendors across multiple legal entities
- Subledger transactions (i.e. General Ledger, AP, Cash and Bank Management) generated in all legal entities with Due To/From transactions automatically created
- Utilize one bank account for multiple legal entities, simplifying cash management
The first method, Intercompany Accounting, is easier to set up but requires more manual effort for each Payment Journal as each vendor and the vendor’s invoices to be settled must be selected individually by company within a Payment Journal. Also, this method would generate three checks (in the above example) to the vendor.
The second method, Centralized Payments, requires more one-time setup (see upcoming post Multi-Company Customer and Vendor Payments – Part 3 Centralized Payments) but each Payment Journal is easier to prepare as a vendor is selected once and invoices across multiple legal entities can be settled at the same time. Also, this method will result in one check being generated. Stay turn for part II in the series, coming later this month.
Contact us if you have questions regarding multi-company customer and vendor payments.
About the Author
Diann Spencer, Dynamics AX Finance Consultant
Diann Spencer, Western Computer’s Dynamics AX Finance Consultant, has been involved in many successful implementations of Dynamics AX in small, midmarket, and large companies across a variety of industries. Diann has over a decade of financial experience and she is a Certified Public Accountant.
Based on this article, you may be interested in:
It’s not uncommon to see businesses using a variety of disparate specialty systems and elaborate spreadsheets, particularly in industries like manufacturing, distribution and internet retail. There is a lot of valuable information being…Read More
There is something fascinating about seeing machines do the work traditionally done by humans. This past fall at Summit (NAVUG and AXUG), our team setup a robot to demonstrate a pick and stage inventory scenario inside the Western…Read More
Multi-Company Customer & Vendor Payments in Microsoft Dynamics AX: Part 3 Using Centralized Payments
In this blog, we will go over the setup for the second method – Centralized Payments. Although these blogs primarily discuss multi-company vendor payments, the same functionality and setup apply for configuring multi-company customer…Read More
E-commerce is clearly an essential element to a successful retail business. The marketplace is fast-paced, customer demands are changing and e-commerce is evolving as well.Read More