Show a batch quantity double in credit memo

[former_member336402]

Hi All

One of our client side , a problem occur which is,it show batch quantity double in a/r credit memo.

Client side a scenario is > First it generate stock using goods receipt .Each item in good receipt are managed by batch. So no of unique batches generated with different quantity. This item was sale using A/R invoice.

Now one of item a/r invoice was punched with wrong information. So this a/r invoice was cancelled by user. Again it generate same invoice with same batch from previous cancel document. Again there was a problem in invoice . so he want to cancel invoice. But they want to return quantity using A/R credit memo.

But when he generate a/r credit memo ,batch shows double quantity for particular item.

we check all transaction, also we check at database in table OBTN, OITL, ITL1 , OBTQ. all table show correct quantity but in credit memo it show double.

ex : Itemname : 300/96 black managed by batch

production :quantity in batch: 1616010115 + 28.13
a/r invoice : 1616010115 - 28.13

cancel invoice : 1616010115 + 28.13

a/r invoice : 1616010115 - 28.13

now generate credit memo show double : 1616010115 + 56.26