Skip to main content
Solved

Non-supplier Payment payment method LOV

  • February 19, 2021
  • 4 replies
  • 215 views

Carlo Palma
Sidekick (Partner)
Forum|alt.badge.img+9

Hi all,

 

I’m trying to create a non-supplier payment but I’m having problem on LOV (nothing came out) though when you zoom in there are values.

 

 

zoom has values: 

 

 

 

Best answer by Mohamed Infaz

Hi Carlo,

You might have to enable or tick the format id which is relevant to your company.

 

Let me know how it goes.

This topic has been closed for replies.

4 replies

Mohamed Infaz
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • 158 replies
  • February 19, 2021

Hi Carlo,

 

Lov query as follows,

 

-- Context: dlgDynamicLov

select WAY_ID,DESCRIPTION,FORMAT_ID,FORMAT_DESCRIPTION,REFERENCE from IFSAPP.PAYMENT_WAY_LOV_SUPP_CURR where ( COMPANY = 'TE' ) and FORMAT_ID NOT IN ('BOE','CHECK','EMPTY');

 

it checks for format id, not in BOE, CHECK & Empty your payment methods format id needs to be other than these three.


Carlo Palma
Sidekick (Partner)
Forum|alt.badge.img+9
  • Author
  • Sidekick (Partner)
  • 90 replies
  • February 19, 2021

That’s also an issue, when I try to add new payment methods, the Format ID only displays 3 options.

 

 


Mohamed Infaz
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • 158 replies
  • Answer
  • February 19, 2021

Hi Carlo,

You might have to enable or tick the format id which is relevant to your company.

 

Let me know how it goes.


Carlo Palma
Sidekick (Partner)
Forum|alt.badge.img+9
  • Author
  • Sidekick (Partner)
  • 90 replies
  • February 19, 2021

Hi @infaz got it! Thanks!