Can anyone tell me starting with the CustTable, what fields and Tables do I join in order to get the Country Code (ie USD, CAN etc)
Steve
*This post is locked for comments
Hi Steve,
These are basically the linkages described in the post that I added previously.
You will probably not need the last two/three ones.
n:1 > Customer
n:1 > Global address book
1:n > Party location relationship
1:n > Locations
1:n > Communication details
1:n > Contact information and role relationship
n:1 > Roles
Best regards,
Ludwig
CustTabe has a relation named "BirthCounty" with LogisticsAddressCounty. LogisticsAddressCounty has a relation "Country" with LogisticsAddressCountryRegion, who has a field "CountryRegionId".
Hi Ludwig
I checked the link you sent me above but I don't see any article dealing with my problem.
Can you point me in the right direction?
Hello SteveWhyte,
Here is a blog post that shows you an example how the customer table can be linked with others to go down to the party location and related tables, such as location, communication details, etc. , which hopefully helps getting your linkage established.
https://dyntips.com/2016/08/30/e-mail-invoices-with-a-smarter-dynamic-print-management-setup/
In addition to this information, you can also take a look at the customer base data report that is available in the AR module. Maybe this report already includes all the information you are looking for?!
Hi Dinkar
Can you recheck this as there is no method called countryRegionId()
Hi,
Check custtable method countryRegionId()
custtable = CustTable::Find('ABC');
info(strfmt("%1",custtable.countryRegionID()));
It return customer primary address Country Region ID
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 4
Guy Terry 2 Moderator
Nayyar Siddiqi 2
