Unbalanced Transaction in A/R Invoice

[Former Member]

Dear All,

We have been trying to add a A/R Invoice and it throws the following error named "Unbalanced transaction". Where could the error have occurred and what are the possible places that we can check these things.

Please guide me.

Thanks in advance.

- Rajesh

[former_member186095]

Hi,

The previous answer from Syn Qin is correct. So, you also see if block unbalanced FC journal entry is ticked or not in the document settings --> per document tab --> journal entry.

After that unticked the FC journal entry in the journal entry as suggested by Syn Qin.

This issue possibly caused by BP currency is FC meanwhile the G/L account code that created when invoice added is multicurrency

Try to check it

Rgds,

[Former Member]

Hi,

Normally this error will display when your Cr. side and Dr. side of the Jornal relavant to the document A/R Invoice is not tally. Check the Cr. side amounts total and Dr. side amount total of the document.

Normally In A/R Invoice

Dr. Cr.

Customer Account -- A --

Tax account if any -- B

Sales Account -- C

-

---

Total A B+C

-

---

Here A = B+C, If this is not happened then the error will display as you told.

Pl. check the relevant account amounts.

Hope this will help you

Regards,

Venkatesan G.

[wilma_wang]

Hello Rajesh C ,

Has the tax rate has been modified in regard to a certain tax code? If there is a difference rate for the same tax code between base document and its target, it will generate that error.

Here are relevant notes for your reference: 1066276,1063743,1102077,1112941

Also, you are always suggested to patch up with the latest PL it might fix the reported error.

Regards,

Wilma Wang

SAP Business One Forums Team

[Former Member]

Hi,

We can prepare A/R Invoice from Sales order --> Delivery --> A/R Invoice or Sales Order --> A/R Invoice or Directly A/R Invoice.

I don't know which method you follow to prepare A/R Invoice.

Notice carefully, when this error occurs, what i try to explain you is, We can prepare A/R Invoice from Delivery (ie., from delivery form using "Copy To" Button) we can prepare A/R Invoice. or From A/R Invoice form using "Copy From" button we can prepare A/R Invoice from Delivery or from Sales Order.

Notice whether you get error when copying document using "Copy From" or "Copy To" option. Identify the situation and if you get error when using "Copy To" option then do not prepare A/R Invoice from base Documents, just go to A/R Invoice form and copy the documents using "Copy From "option.

If you get error when using "Copy From" option, then just copy the documents from base document to Target document.

At the same time convey the error information to SAP so that they can solve the problem.

Raja.S

[Former Member]

Hi Rajesh

Unbalanced transactions could occur for more than one reason.

There are a few more notes on Unbalanced Transactions.

One of the most likely reason is the rounding issue.

Please refer to SAP Notes :869774.

Also,please try to uncheck the [Block unbalance FC journal entry] in

JE tab of document setting.

Regards,

Syn Qin

SAP Business One Forums Team