Question

Open CUPIA and customer offset

  • 4 April 2024
  • 3 replies
  • 46 views
C
Rank
Userlevel 2
Badge +6

Hi

I have a client who just went to IFS 10.  They have an customer order that was created in IFS 9.  There was an advance invoice created and one advance payment made to the order.  The final advance payment was posted, they did not clear the CUPIA at that time and it did not apply to the transaction.  Instead they just posted the cash side of the entry using the Deferral cash account and that removed the balance in the GL.  This left the CUPIA still open. 

They are now in IFS  10 and are trying to close the CUPIA.  

They have done a rollback that parked the payment.  They tried to do a customer offset and received the following error. 

The CUPIA is still open and now the final invoice has an open balance of the 7,155.

They have gone back into IFS 9 and did the same steps that were done in IFS 10 and they were able to create the offset. 

Any thoughts or suggestions on what can be done?

 

3 replies

Ieva Rituma
Rank
Userlevel 6
Badge +16

Try fixing this through a mixed payment instead of a customer offset.

If I understand you correctly, you should add two lines - one positive and another negative so there is no cash impact, but match each with the remaining items. Match one of the items to the parked payment, and the other side to either the advance item or a manual payment - depending on which is the right transaction in your scenario. Did the manual cash transaction get reversed? If yes, then it should be the advance invoice; if not - then it should be the manual cash transaction (with the opposite sign of the original manually posted payment). 

IRituma
C
Rank
Userlevel 2
Badge +6

HI Ieva

 

It still has the error.

 

 

Ieva Rituma
Rank
Userlevel 6
Badge +16

Thanks for getting back with this. Is the CUPIA 201 still showing up as an open item? Based on the message alone, it isn’t. 

Without seeing the full picture it sounds like the solution would be to do the mixed payment with 2 transactions: one clearing the customer invoice (CD 67788) and the other side of the transaction being a manual posting reversing the previously created manual posting. 

IRituma

Reply


Terms & ConditionsCookie settings