handle with return debit note

[Former Member]

Hi all,

is there a process for handle with return debi notes?

A AR invoice for an customer is payed made by direct debit (Lastschrift)

for any reason the direct debit comes some days later back on the bank account

but now the AR invoice ist marked as Payed (with the direct debit with the payment wizard)

and the Bookings of the bank account are

debit and credit on different days.

ist there a way to handle this process to get the old invoice open?

Kind regards

Gerhard Bienen

[Former Member]

Hi Gerhard,

Bring up the Incoming Payment, right-click and select 'Cancel'. If it lets you cancel the I/P, this will reverse the I/P and the AR Invoice will be changed to 'Open'.

If a deposit was done, you will not be able to cancel the I/P (you can try but it will give you an error message). You will need to post a J/E to reverse/CR the returned amount from your bank account and offset is post/DR the customer account.

Heather

[Former Member]

hi gerahard,

if u want to change the status of AR invoice from closed to open u can do it with the help of the query is this what u wanted to know

samle query to change the status of the ar invoice when banking module kas been met and i revesed teh payment thus openinging the banking module option

SELECT oinv.docnum, oinv.docstatus

FROM OINV INNER JOIN

INV1 ON OINV.DocEntry = INV1.DocEntry

where oinv.docnum='29'LECT oinv.docnum, oinv.docstatus

regards,

Manish

[zal_parchem2]

Manish - how does this change the status of an AR Invoice? Is that the full SQL you placed there? I might be wrong with my previous statements, but it would be great if you could explain how this changes the status of an AR Invoice.

Thanks and Regards - Zal

[Former Member]

Hi Gerhard Bienen,

What is your B1 version and PL?

Thanks,

Gordon

[Former Member]

Hi Gordon,

the B1 Version is 2007 A SP 01 PL 09

Kind regards

Gerhard

[Former Member]

Hi Gordon,

the follow up issue is, if i book the return from bank to the BP it create an JE, but this JE is not available in the dunning wizard.

(If i book an manuell JE it is available in the dunning wizard.)

any ideas to handle this issue ?

Thanks

Gerhard

[Former Member]

Please explain what you mean for book the return from bank to the BP.

[Former Member]

the first step is the debit note to the bank, the bank book the money transfer to the account. later the customer calll back the debit note (its possible for 6 Weeks in Germany) . so the bank book the money back to the customer (it is also possible if the acount from the customer is empty)

So the bank book on the credit side the money back.

Gerhard