Tuesday, June 25, 2019

How To Know Visitors Location Using IP Address

To identify visitors location details like country, state, city, zipcode, latitude and longitude etc...
Use below webrequest

http://api.ipinfodb.com/v3/ip-city/?key=&ip=103.238.107.173&format=json

The API returns Geographic location details in JSON format as shown below.
{
      "statusCode" : "OK",
      "statusMessage" : "",
      "ipAddress" : "103.238.107.173",
      "countryCode" : "IN",
      "countryName" : "India",
      "regionName" : "Gujarat",
      "cityName" : "Ahmedabad",
      "zipCode" : "380028",
      "latitude" : "23.0333",
      "longitude" : "72.6167",
      "timeZone" : "+05:30"
}

Here to get Api-Key, we have to register and get api-key

Thursday, June 13, 2019

How Factor is calculated in SAP B1?


Factor in Purchase A/P -> Landed Cost - > Costs Tab

Below is formula to calculate Factor in Costs Tab

Factor = (Amount / Total FOB) * 100

So for example, In Costs tab

Landed Costs Amount = $500

Total FOB = Total - Total Freight = $1500 - $500 = $1000

Factor = ($500 / $1000) * 100 = 50 %