Microsoft Dynamics AX (Archived)

Vendor Group for a give Vendor Transaction in VendTrans record in AX 2012

(0) Share

Report

Posted on by Muneeb

895

Hi,

I am using AX 2012 R2 CU7.

I have few Vendor Transactions, and if I browse VendTrans table I could see few records of Type - Vendor and few records of type - Payment.

Now for Type - Vendor, the corresponding records exists in VendInvoiceJour and from this VendInvoiceJour I could find the corresponding Vendor Group attached.

Likewise, I am trying to find the Vendor Group attached to the records of Type - Payment in VendTrans, but I am unable to find.

Can someone help me out if we can find out the Vendor Groups attached for these records?

Would appreciate for some help.

Sincerely,

Muneeb

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor Group for a give Vendor Transaction in VendTrans record in AX 2012

Hi Muneeb,

You can establish this relationship through the VendTrans-VendTable-VendGroup tables.

Best regards,

Ludwig

Was this reply helpful? Yes No
Muneeb 895 on at

Like (0)

Report

RE: Vendor Group for a give Vendor Transaction in VendTrans record in AX 2012

Hi Ludwig,

Thank you so much for your quick response.

I am getting the details but that gives me the Vendor Group attached to Vendor.

Let me explain the scenario in detail,

1. The vendor is attached Vendor Group - 10. The transactions is done.

2. Now the Vendor Group of the same vendor is changed to - 20. The transaction is done.

3. Furthermore, the Vendor Group of the same vendor is changed to - 30. The Transaction is done.

Now the transaction against the vendor was done for 3 Vendor Groups as stated above. But the current Vendor Group attached is 30.

Query is, I want to fetch the Vendor Groups of all the above 3 transactions against which the transaction was done for the specific Vendor.

Sincerely,

Muneeb

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor Group for a give Vendor Transaction in VendTrans record in AX 2012

Hi Muneeb,

I just tested this using the invoice journal inquiry form in AP.

I believe this form will give you the information you search for.

Here an example where I changed the vendor group from 20 to 30 and where I can identify the vendor group valid at the time of posting.

Best regards,

Ludwig

Was this reply helpful? Yes No
Muneeb 895 on at

Like (0)

Report

RE: Vendor Group for a give Vendor Transaction in VendTrans record in AX 2012

Hi Ludwig,

Thank you for your quick response.

Kindly find the below snapshot with further details.

Sincerely,

Muneeb

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor Group for a give Vendor Transaction in VendTrans record in AX 2012

Hi Mohammad Muneeb Ghazi,

Unfortunately, this information is not tracked in the vendor transaction and settlement tables. Unless you either activated the database log that tracks changes of the vendor group or unless you use the vendor group as financial dimension - that is updated once you change the group association - you cannot get this information out of AX.

Best regards,

Ludwig

Was this reply helpful? Yes No
Muneeb 895 on at

Like (0)

Report

RE: Vendor Group for a give Vendor Transaction in VendTrans record in AX 2012

Hi Ludwig,

Thanks a lot for your help.

Sincerely,

Muneeb

Was this reply helpful? Yes No