transactions on voucher 2222 do not balance

Finance and Operations/AX User Forum
1

Hi All ,

AX 2012 R2 .

i have created the new vendor and post the purchase invoice with the TDS amount , now When i try to post the payment againt the vendor invoice system throws the following error like

The transactions on voucher 2222 do not balance as per . (accounting currency: $<some#> - reporting currency: $<same#>).

Payment journal had oneline only.

All configuration had been done properly .

Accounting Currency - INR

Reporting Currency - AUD.

All currency exchange rates had been defined for the particular transaction date and rounding options made 0.00

Could any one help me how to resolve the error .? Is there any hotfix available to resolve the problem.

2

There must be some rounding getting created in foreign currency. You need to setup up penny difference amount in GL parameter and also define Penny difference in reporting currency account in account for automatic posting setup under GL setup.

Pranav…

3

Thanks Pranav,

Even i have configured the above setups already as mentioned by you , still the error occurs .

When i enable the TDS setup , then only the error occurs , if TDS not enabled then system posts the transaction without errors.

Could you help me to resolve the error ? Any idea about that MS has released hotfix for this problem ?

Thanks in advance.

4

Hi Pranav,

The exact error is

The transactions on voucher 2222 does not balance as per 4/11/13 (accounting currency: 0.00 - reporting currency: $ 234567.89)

I am not understanding why the system is taking the accounting currency is taking Zero , even though i have configured all the setups properly.

What i have noticed is If the TDS is not enabled then system would not throw the above error and when it is enabled then only the error occurs.

In the below post ,

https://community.dynamics.com/ax/f/33/t/74163.aspx

Poster says that MS hotfix is available for this error .

Could i know how to get that hotfix , if you know please share the link to download the patch.

Thanks in advance.

5

Hi ,

The exact error is

The transactions on voucher 2222 does not balance as per 4/11/13 (accounting currency: 0.00 - reporting currency: $ 234567.89)

I am not understanding why the system is taking the accounting currency is taking Zero , even though i have configured all the setups properly.

What i have noticed is If the TDS is not enabled then system would not throw the above error and when it is enabled then only the error occurs.

Any one can help me ?

6

lally , check whether have u forgotten to give an rounding accounts for penny difference of accounting currency and reporting currency. in

general ledger>> setup>> posting>>automatic for automatic transactions

hope this will help you.

7

Hi Lally,

The accounting currency and reporting currency difference is really high, this can be potential bug. Not aware of any particular hotfix for this. I will suggest you to create a support ticket if this is urgent. Generally, hotfix information/bugs are not charged by Microsoft.

Pranav…

8

Thank you Mohan ,

I have configured everything as you said , even though the error occurs.

Thank you Pranav,

I also feel the same probably the above error can be bug . Let me know raise the ticket and will post the MS feed back .

Meanwhile if you come to know any solution or hot fix regarding the above error . Please post me.

9

Sure. But pls post the solution if you get it from MS.

Pranav…

10

This kind of error basically happens if you didn’t setup Vendor posting profile or if there’s economic imbalance in the GL parameters like penny differences, currency differences etc…

I would suggest you to go through following steps to resolve this error.

Go to Accounts Payable=> Setup=> Vendor posting profile

Create a record if one doesn’t exist and specify the accounts for specific or group of vendors.

Go to Accounts Payable=> Setup=> Accounts payable parameters

Click on the Ledger and sales tax hyperlink on the left pane

In the Posting section, set Posting profile to the one you created

Refer this link: http://community.dynamics.com/ax/f/33/t/91165.aspx for other causes of this voucher imbalance error.