Skip to main content
Solved

Non-supplier Payment payment method LOV

  • Feb 19, 2021 6:51 AM UTC
  • 4 replies
  • 269 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.

View original
This topic has been closed for replies.

4 replies

Mohamed Infaz
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • Feb 19, 2021 6:56 AM UTC

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)
  • Feb 19, 2021 7:05 AM UTC

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)
  • Answer
  • Feb 19, 2021 7:11 AM UTC

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)
  • Feb 19, 2021 7:19 AM UTC

Hi @infaz got it! Thanks!