Hello,
Can you explain your situation a little bit more detailed?
I understood you issued an advance invoice to your customer and received payment. This should create usual negative CUPIA. 

Then you have “refunded it” meaning you have paid the money back to customer - you should close negative CUPIA doing it. 

What is your issue then? 

Hi ​@Adam Bereda 

Thank you for your reply.

The issue is, I have a positive CUPIA, and each time I attempt to offset it against a credit invoice, another positive CUPIA is getting generated. 

Hello,
If your credit invoice is marked as advance invoice, it will generate CUPIA each time it is paid. 
Positive CUPIA itself is a result of payment of advance credit note. Why did you create initial credit advance invoice? 

 

Hi,

We need to remove the CUPIA from customer analysis screen of IFS, as it is showing as open amount, which was the reason we created credit note, so that we can offset the amount.

OK, but your credit note cannot have “advance invoice” flag set. 

I do not understand still how did you get into this situation (what sequence of actions you made). Starting from original customer advance (“There was an advance invoice done by customer and we already refunded the same”). Especially, how did you perform refund. 
I can see two possible correct scenarios:

A)

1. You have issued Customer AD (positive advance invoice)
2. Customer sent payment, AD invoice closed, negative CUPIA created
3. Money send back to customer closing negative CUPIA

In this scenario there is no need to create credit note, as customer account is closed. 

B) 

1. You have issued Customer AD (positive advance invoice)
2. Customer sent payment, AD invoice closed, negative CUPIA created
3. You have issued AD credit note
4. Money send back to customer closing AD credit note, positive CUPIA created
5. Customer offset closing CUPIA + and -

Hi, 

I’ve followed the second scenario, because of which still one positive CUPIA is showing over customer account/analysis screen. 

I doubt, because in such a case you would have TWO CUPIAs: positive (created in step 4) and negative (created in step 2), and you would be able to do offset to close them both (step 5).