Question

Creation of new quick report IFS Apps 8

  • 3 December 2021
  • 1 reply
  • 62 views

Userlevel 4
Badge +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 comments

1 reply

Userlevel 5
Badge +7

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