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

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!

I have the same question (0)

All responses (8)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Michal Krejza on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No