How to deduct return goods amount directly in invoice

[Former Member]

Dear Experts,

Customer return the goods now, after six months he will raise an sales order.

Now client requirement is the return goods amount deduct from this this invoice.

they want to show in billing,total amount and deducted amount with reason.

Regards,

Amar Reddy

[Former Member]

hi

Customer return the goods now, after six months he will raise an sales order

I am sorry but this requirment dosen't make any sence.

If customer is returning goods now, then there must be some document (sales order or invoice for these goods)

But if invoice is cleared i.e. posted to accounting then you can not do anything.

Now coming to your scenario.

Customer returns goods QTY = 100

and after 6 months placing order for= 200

You can add 2 line items with 100 and 200 qty for same material and one of material can have '-' pricing condition type

in V/06 make the positive/negative as blank for this condition type

And to deduct amount you can give negative value

But again how you will handle stock??

so best way is to go for Credit / debit memo and keep system sync

[jpfriends079]

See, here you have to educate your client use of credit memo & debit memo.

If invoice is already have accounting doc then altering the invoice is not possible. in that case directly create a credit memo reference to the invoice for the differential amount. This will reduces Amounts Receivable from a customer.

OR

If invoice is not released to accounts an there is no accounting doc then cancel the invoice and re-generate the invoice the desired value and quantity.

Thanks & Regards

JP