I have an issue with customer offset window, when I try to offset some invoices against a payment I'm getting below error.
We didn't pay for these invoices and couldn't find this Preliminary Payment ID. Could you please help me on this?
Best Regards,
Thakshila
Best answer by Adam Bereda
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;
+18Hi 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
Also, could you go to the Customer Payment Analysis window and check whether the FM invoice is included?
Best Regards,
Ruwanjala
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.
+18Hi 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. 
Hi
Also, could you go to the Customer Payment Analysis window and check whether the FM invoice is included?
Best Regards,
Ruwanjala
Hi
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.
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?
+18Hi 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’
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
+18Perhaps 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,
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;
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
