Skip to main content

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

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