You’re offline. This is a read only version of the page.
Announcements
Hello - I am new to AX and am working with an existing AP Vendor Master File that contains many duplicates to accommodate multiple addresses within a single supplier. In my experience with other major ERP software, there is often a Master Buyer Vendor file that relates (one-to-many) to the AP Vendor Master file to accommodate for this and avoid duplicate AP Vendor records. Does this exist in AX and if so, can you please identify the table name and relationships, or where this data is available in user guides? I am aware of the Commodity Code aspect of the AP Vendor file but am hoping there may be yet another alternative option. Thank you!
*This post is locked for comments
Only one remit to address is held by Ax. However, its possible to have multiple bank accounts per vendor, which can be selected in invoice registers and invoice journals.
In the payment journal select from the bank accounts of the vendor. To select the bank account manually look on the 'Invoice' tab of your AP journal lines.
Thank you magic1949, I think this is what I was looking for!
Can you please verify if one vendor is allowed to have multiple remittance addresses?
Hi Josh,
Glad to hear that. If you don't mind please mark as verified so it's helpfull for others as well. Thank you
If all payments are made to the same vendor account then you only need one vendor with multiple addresses
Assign a different purpose to each address https://technet.microsoft.com/en-us/library/gg731964.aspx
Thank you Andre!
Vendor Merge is a great suggestion. It will help once we identify which accounts we want to inactivate/consolidate into one.
My question is more in the structural setup of the vendor data. Procurement/Supply Chain often uses the same vendor across different divisions and locations. Sometimes this means a different order location at the supplier (same parent and tax entity) with different remittance addresses. Another example is when Procurement uses differing purchasing systems for a given supplier and sets up a new AP Vendor record to capture as an identifier as to which AP system to pass the invoice to downstream. In each instance, AP is forced to set up a new vendor with the same Tax ID to capture these differences. This is not considered a best practice. Is there a preferred method to structure this information so that it is fully normalized for AP in that there is only one AP Vendor Master record for a given Tax ID? Perhaps the Group field is a key part of the answer here?
My hope is that there is a table that relates to the AP Vendor Master file that can capture this level of detail (e.g. AP Vendor #12345/Address A, AP Vendor #12345/Address B, AP Vendor #12345/Address C etc.).
Thank you!
Thank you David, this is very helpful!
HI Josh,
If addition: If you are looking for ways to prevent duplicates, you can use the Global address book for this. There are some features for a duplicate check. The DUNS number is one of the options to prevent duplicates.
If you say you have multiple duplicate vendors; are these in the same legal entity or different legal entities? I do think to understand it is in the same LE.
In some scenarios it is possible to merge vendor records. I had written a book on 'Merging global address book' in the past. This has some neat tips to prevent duplicates, merge records and also it contains the script to be able to merge records. The book can be found on CreateSpace and Amazon.
Hi Josh,
You can delete the vendor in AX. However, you only can delete the vendor that doesn't have any transaction yet.
So there will be some of steps and scenarios here:
1. Import/Consolidate the vendor address
- If you use AX 2012 R2 CU7 onwards, you can use DMF to import the vendor's address. Please refers to the links below.
http://shafeaa.blogspot.sg/2015/07/import-vendors-using-data-import.html
- If you use R2 CU6 and below, you can import the address by the job/script. Please, look the link below for the sample of code.
msdax.wordpress.com/.../job-to-import-vendorcustomer-postal-address-in-dynamics-ax2012
2. Clean up the duplicate Vendor accounts.
- You can delete one of the vendor account if the vendor doesn't have any transaction yet.
- If the vendor already has transaction, you can't delete it. So, instead of deleting you can rename the vendor account to indicate the vendor is not used anymore. Open the All vendor form (AP>Common>Vendors>All Vendor) then right click on the vendor account > Record info > Rename.
After renaming, you need to put the vendor on-hold so the vendor can't be used to enter any transaction in future.
Hi David - thank you for your quick reply.
We are using AX 2012. The AP master exists, I am working to try and clean it up. Much of the cleanup is needed because the same vendor was set up multiple times to accommodate different vendor addresses. I've usually seen this level of detail stored in other ERP's using a Buyer Vendor Vendor file that is related to the AP Vendor Master. I am looking to determine if AX has a similar structure.
Thanks much!
Hi Josh,
What is the objective that you want to achieve? Do you want to import AP Vendor Master File to AX? What AX version that you use?
Please elaborate more.
Best regards
#1
André Arnaud de Cal...
294,125
Super User 2025 Season 1
#2
Martin Dráb
232,871
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
