Saturday, March 5, 2016

Do you see the error while creating AR transactions "System cannot determine geographical information for this location and cannot derive a tax jurisdiction"??

You might want to check if the geography and tax validations are enabled for that country for which you are seeing this error....

If they are enabled then you might have not run the 'Geography name referencing program' for this country...

To implement the solution, execute the following steps:

  1. First check if there is a value for profile option HZ :Generate Party Number, if no, set it to 'yes'. Post that follow the below steps.
  2. For the ship-to/bill-to which is failing navigate to the customer form and look up the particular ship-to/bill-to record. Please make note of the site number 
  3. Run the following queries to determine the location_id which is failing

    select party_site_id, party_id, location_id
    from hz_party_sites
    where party_site_number = '&site_number';


    select location_id, country, address1, address2, address3, city, postal_code, state, county
    from hz_locations
    where location_id = &location_id; 
  4.  once you have the valid location id, then run this query
    select map_status, location_id
    from hz_geo_name_reference_log
    where location_id = &location_id;

    Map_status S means that the location_id is successfully created.
    Map_status E means that the location_id has not been successfully created.

  5. Navigate to Trading Community Manager -> Administration -> Geography Hierarchy

    Click on Manage Validations, and find the geography mapping and validations.

    For eg:
    State, County, City, Postal Code

    Verify if tax validation and geography validation is enabled for each of the segments

  6. In the customer form, query the customer in question and review the ship-to, bill-to addresses

    The format you selected under the geography hierarchy must match what you have entered under each bill-to, ship-to

    for example if you are missing the county and you have selected to have this segment validated under the geography hiearchy, you must have this field entered for the ship-to, bill-to under the customer.