Hi Thakshila,

Have you searched by the preliminary payment ID in below windows.

Manus Customer Payment.

Customer Offset.

Netting.

This invoice must be used in any of the windows above.

Please check and let me know.

Shehan Almeida.

Hi @Thakshila ,

Also, could you go to the Customer Payment Analysis window and check whether the FM invoice is included? 

Best Regards,

Ruwanjala

Hi Shehan,

Though  I’ve tried with netting and customer offset windows, no luck there. I couldn’t find Menus Customer payment one.

Thank you.

So sorry... it was typo. It should be ‘Manual Customer Payment’ window. 

Hi @Ruwanjala Jayawardena

Hi have check there and only I could find that CUPOA payment only. But when I query into Customer Analysis window I can find that FM invoice.

Thank you.

I couldn’t find ‘Manual Customer payment’ window in the navigator. Any idea?

Please try ‘Customer Payment’

Hi Thakshila,

 

Have you searched by the preliminary payment ID in below windows.

 

Manus Customer Payment.

Customer Offset.

Netting.

 

This invoice must be used in any of the windows above.

 

Please check and let me know.

 

Shehan Almeida.

Hi Shehan,

Though  I’ve tried with netting and customer offset windows, no luck there. I couldn’t find Menus Customer payment one.

 

Thank you.

So sorry... it was typo. It should be ‘Manual Customer Payment’ window. 

I couldn’t find ‘Manual Customer payment’ window in the navigator. Any idea?

Please try ‘Customer Payment’

 

 

It was the first window I tried when I got this error. But unfortunately this Preliminary payment ID is not there. As per user’s comments when he try to offset these invoices suddenly IFS got stuck. Again he tried with another one and this error popups then.

Thanks 

Perhaps you can check the prel.payment ID in other companies as well. However, I am not 100% sure, whether this error is given for invoice is used in different companies. You can try. 

If does not help. You might have to raise a support ticket, as this might need detailed investigations

Hi,
probably there is inconsistency in data, I mean invoice is included in offset transactions, but offset header does not exists.
This could happen because IFS go stuck when user tried to register offset first time.
You can check this using SQL queries:

select * from prel_payment_trans_tab t
where company = 'VISA'
and prel_payment_id = 62540

select * from prel_payment_tab t
where company = 'VISA'
and prel_payment_id = 62540

First query shows invoices included in offset transactions.
Second query checks if offset header exists.
If first query returns any rows and second query returns no rows, it means that there is inconsistency in data.
In this case data in prel_payment_trans_tab should be corrected using SQL script.
Best regards,
Adam

Hi Adam,

Thank you so much for your input. I will check this and let you know the results.

Yes, sometimes we have problem with “orphan” preliminary payment items.

They can be found using query:

select * from ifsapp.prel_payment_trans t
where not exists (select '1' from ifsapp.prel_payment p where p.company = t.company and p.prel_payment_id=t.prel_payment_id)

If such issue exists, simple procedure can be executed to clean them:

-- delete by method of IFS Applications
declare
  info_ varchar2(2000);
  attr_ varchar2(2000);
  objid_ varchar2(2000);
  vers_ varchar2(2000);
begin
  for rec_ in (
select * from ifsapp.prel_payment_trans t
where not exists (select '1' from ifsapp.prel_payment p where p.company = t.company and p.prel_payment_id=t.prel_payment_id)
   )
  loop

    ifsapp.prel_payment_trans_API.Remove__(info_, rec_.objid, rec_.objversion, 'DO');  
 
  END LOOP;
  COMMIT;
end;