Cancelling Internal reconciliation

[Former Member]

Hi Experts,

I am using 2007 B and I have an wrongly cancelled an invoice by creating an A/R credit memo against it.Now I need to open the credit memo and the invoice (unreconcile the two documents) so that the invoice can be reconciled against incoming payment.

How should I proceed ?

Thanks & Regards,

Asap Fan

[msundararaja_perumal]

Hi,

After booking the AR credit memo,the status of the AR invoice will be updated to 'Closed'.

Now by no other means you can change the status of the AR invoice to open,even you cancel the System reconciliation of the AR Invoice with the AR credit memo,the status of the AR invoice would be 'Closed'.

So either you have to book a new AR invoice. OR

Restore the old back up of the live database(Backup taken before booking the AR Credit memo for that AR invoice)

[Former Member]

Is there any possibility of just cancelling reconciliation status of invoice using sql so that the same invoice is avaiable again for reconciliation with an incoming payment.

[msundararaja_perumal]

Hi,

If you try to use update/insert statement directly via SQL,then i am afraid that you will be losing support from SAP.

Check this note:[631504|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E&note_numm=0000631504] on the same.

[jitin_chawla]

Hi,

It is not advisable to use update/insert anything in the database through SQL as it can cause further inconsistencies and you would lose the support for the customer.

The best suggestion reagrding the issue would be to create a Invoice by duplicating and doing the correct credit for the same.

No way it would be possible to have the status of the Invoice open to be available to be credited again.

Regards,

Jitin

SAP Business One Forum Team