Finance | Project Operations, Human Resources, ...

Vendor balance in Accounting currency is incorrect after doing settlement ad revaluation.

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello adviser!

I am now facing with an issue (actually it comes form our customer) in Vendor balance:

Let's say: Accounting currency = DKK and Transaction currency = HRK; Outstanding amount = HRK 100 ~ DKK 98

I had 4 vouchers are pending as open transactions and they are: 01 invoice, 02 credid notes, 02 payment vouchers, both in HRK currency.

I created a GLJM voucher (for eg. voucher A) with 2 line for same vendor (B), used settlement function for line 1 and got the amount to debit (or credit) and then credited (or debited) the other line by same amount. The expectation of this action was getting the outstanding amount in voucher A with the balance in HRK (= 100) and DKK (=98) but it's not. The Vendor balance in HRK was correct but in DKK was incorrect (it sounds like be double).

I've investigated and found that the variance occurred automatically as adjustment amount for exchange rate (just in DKK) and booked to Vendor and Gain/Loss.

Is there anyone has experience on this issue? Please help me with it.

Thank you!

All responses (8)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor balance in Accounting currency is incorrect after doing settlement ad revaluation.

Hi Thi Thi,

The form that you shared is called "VendOpenBalanceCurrency" that makes use of the VendTrans and a temporary table called VendTransBalanceCurrency table.

You can have a look at those to find out what might be wrong.

Best regards,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: Vendor balance in Accounting currency is incorrect after doing settlement ad revaluation.

Hello Michal Krejza,

I am petty sure that the issue is not caused by customization coz we've tested on other Vendors and looked at the previous periods on this Vendor, the results were fine.

Do you have any suggestion that I can investigate by myself?

Thank you!
Suggested answer

Michal Krejza on at

Like (0)

Report

RE: Vendor balance in Accounting currency is incorrect after doing settlement ad revaluation.

Hello Thi Thi,

If you have consistent repro and you are sure the issue is not caused by customization, please open a service request to our Microsoft support and our team will investigate it for you.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor balance in Accounting currency is incorrect after doing settlement ad revaluation.

Good morning Thi Thi,

I had a look at LCS but did not find a specific hotfix for AX2012 that would address this issue.

I would thus recommend that you either get in contact with a developer who can debug the issue or - alternatively - open a support case with MS.

Best regards,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: Vendor balance in Accounting currency is incorrect after doing settlement ad revaluation.

Thanks Ludwig,

I have checked and It's not the linked to a customer. Is this the bug in the official bug list from Microsoft?

Do you have any idea to solve this by adjusting data?

Thank you!
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor balance in Accounting currency is incorrect after doing settlement ad revaluation.

Hi,

Is this vendor also a customer?

Can you check if the global address book party id of this vendor is linked to a customer?

If this is the case, check the customer balance.

If there is no linked customer account, get into contact with a developer to debug this issue.

Best regards,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: Vendor balance in Accounting currency is incorrect after doing settlement ad revaluation.

Hi Ludwig,

Yes, I understand that i should have some screens to show the issue but as i shared before, it's our customer's data (should keep it in confidential)

For Illustration and make the issue easier, I have Tested and have the result as the picture.

1. Show get the Vendor Balance

2. Vendor Balance result

3. Open Transactions

My question is:

1. What is the logical for Vendor balance form? why it showed difference amount for DKK currency in 01 platform?

2. After investigating, the adjustment amount is booked by DKK amount to Vendor and Exchange rate adjustment, how it comes?

Thank you!
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor balance in Accounting currency is incorrect after doing settlement ad revaluation.

Hello Thi Thi,

Is it possible that you share some illustrative screenprints that illustrate the issue?

Would be easier to understand and be a good reference.

Many thanks,

Ludwig