Solved

Customer Offset Issue

T
Rank
Userlevel 5
Badge +8

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

icon

Best answer by Adam Bereda 6 July 2021, 21:50

View original
This topic has been closed for comments

12 replies

Shehan Almeida
Rank
Userlevel 7
Badge +15

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.

R
Rank
Userlevel 6
Badge +8

Hi @Thakshila ,

 

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

 

Best Regards,

Ruwanjala

T
Rank
Userlevel 5
Badge +8

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.

Shehan Almeida
Rank
Userlevel 7
Badge +15

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. :relaxed:

T
Rank
Userlevel 5
Badge +8

Hi @Thakshila ,

 

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

 

Best Regards,

Ruwanjala

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.

T
Rank
Userlevel 5
Badge +8

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. :relaxed:

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

Shehan Almeida
Rank
Userlevel 7
Badge +15

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. :relaxed:

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

Please try ‘Customer Payment’

 

 

T
Rank
Userlevel 5
Badge +8

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. :relaxed:

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 

Shehan Almeida
Rank
Userlevel 7
Badge +15

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

A
Rank
Userlevel 5
Badge +10

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

T
Rank
Userlevel 5
Badge +8

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.

A
Rank
Userlevel 7
Badge +16

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;

 

Regards, Adam
Terms & ConditionsCookie settings