Skip to main content
Question

Creation of new quick report IFS Apps 8

  • December 3, 2021
  • 1 reply
  • 83 views

Forum|alt.badge.img+7

Hi Friends,

 

Please refer to the existing Customer payment analysis day wise report and create a new one with the below selection
please see attachment for reference 

Company
From Date
To Date
invoice date
Invoice due date
GM Territory with code
 

The above requirement i have received.

 

Here the question is where i can find GM Territory with code ?

Could anyone please help me on this.

 

Regards,

Nagarjuna

This topic has been closed for replies.

1 reply

Forum|alt.badge.img+7
  • Sidekick (Partner)
  • 14 replies
  • December 3, 2021

Hi,

The Country code is defined in 'Application Base Setup>System Setup>ISO code usage where we can find this column for - 'Country code', 'Description', 'Country Name' which are system defined.

The above info can be retrieved using the SQL expression : select * from iso_country_def 

 

Let me know in case of any further inputs required.

 

Regards,

Venkat