Still Open A/R Invoice Status after Reconciled.

[Former Member]

Hi,

Id like to ask what other reasons why the A/R invoice still Open after it has been reconciled. I click on applied transaction on AR invoice, here's the result.

Origin     Amount          Applied Amount    

IN           3,876.00          3,876.00

CN          (3,876.01)          (3,876.01)

JE           0.01                0.01

Does it affect in terms of item? it was invoiced using item#01 and it was CM using item#2?

Your idea is a big help.

Thank you.

Ryan Villarosa

[jitin_chawla · Accepted solution]

Hi,

It is better to check the balance due LC fields in the Journal Entry of the affected transaction to see whether it has some balance due for the BP Code involved in the AR Invoice.

Check, if value, then reconciliation has some issue.

More information is required to further check what exactly is the issue.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

Hi Jitin,

As I've checked on BP Account Balance, the A/R invoice is no longer on the list as collectibles. So this means that, that Invoice has been reconciled. Just wondering why does that A/R Invoice still "OPEN" in status,

Is there any area that I need to check?

Thanks.

Ryan Villarosa

[jitin_chawla · Accepted solution]

Hi,

It could be a possibility that the balance due is not properly updated on the journal entry of the document. Even though the document is not displayed in the account balance of the BP.

Check by running the following query "

select transid, Line_ID, balduedeb, balduecred, * from JDT1 where transid in ("Enter the transid of the transactions in the reconciliation here")  and check if the columns balduedeb and balduecred are displaying any balance or not.

Then only further check can be done.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

Hi Jitin,

The columns balduedeb and balduecred are not balance. Please see the result of the query.

transID    Line_ID    balduedeb        balduecre

185319     0             0.000000          0.000000

185319     1             0.000000          0.010000

Your comment please.

Thank you.

Ryan Villarosa

[jitin_chawla · Accepted solution]

Hi,

If your reconciliation is a Manual then, you can try by cancelling the reconciliation and re-doing it.

Also, there is a checkbox available on the internal reconciliation button named 'Display LC only'.

Check if it available and checking that box displays the JE of invoice without any balance.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

Hi Jitin,

Alright. I will try to cancel the reconciliation and reconcile it again.

Keep posted once done whatever the results. Thank you.

Ryan Villarosa

[kothandaraman_nagarajan · Accepted solution]

Hi,

You may check with SAP note 1776123

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Thank you very much. This is very helpful. Now this issue is now solved.

[former_member662620]

Hi,

I think someting is wrong during internal reconciliation . Please cancel your previous reconcilation and reconcile them again

[Former Member]

Hello,

Are there any freight / packing charges or any other misc charges in the Inv. ?

Thanks,

Priya

[KennedyT21]

Hi Ryan Villarosa

If there is only the invoice in 'applied transaction' window, it means then invoice is not reconciled with any transaction.

Please make sure that you have done the internal reconciliation via

Business Partner -> Internal Reconciliation -> Reconciliation , which is for internal reconciliation.

Hope Helpful

Regards

Kennedy

[Former Member]

Hi Kennedy,

Actually, there are 3 transactions in "Applied Transactions", IN (A/R Invoice), CM and JE. and thus, it has reconciliation happened since that A/R invoice is no longer listed on BP Account Balance.

What other area that I need to check?

Thanks for the help.

Ryan Villarosa

[KennedyT21]

Have you checked does the issue solved or not if not pls ask your questions

if solved pls close the thread with correct or helpful answers

Regards

Kennedy