Page History

...

The following will guide you on how to create Inventory Receipt for foreign customer.  This  

Example 1: This example will show you when functional currency rate is higher than foreign currency rate.

1. Say this is your foreign Vendor. In this example, Currency field is setup as INR (Indian Rupee). You can open Vendor screen from Purchasing (Accounts Payable) > Vendors.
   
2. Create Inventory Receipt. 
   1. Inventory > Inventory Receipts > click New
   2. Details tab
      1. In the Order Type field select Direct.
      2. In the Vendor field select the Vendor with foreign currency setup. 
         1. 
         2. Notice that Currency field will automatically show the Currency set for the selected Vendor.
      3. In the Items grid area,
         1. Select Item from Item No. field.
         2. Enter Qty to Receive and UOM.
            1. Image Modified
            2. Notice the Currency Unit will also show as INR. This field will default to the Currency assigned in the Inventory Receipt > Currency field.
         3. In the Cost field enter the Cost of the item. 
         4. The Forex Rate Type and Forex Rate fields are defaulted based on your Multi-Currency setup. That is why it is recommended that you have your multi-currency setup prior to doing foreign transactions. This will make the transaction entry easier than having to select Foreign Rate Type in every transaction.
            1. Image Modified
               1. The Foreign Rate Type is showing Spot since default setup for Inventory > Rate Type is Spot.
                  1. Image Modified
               2. The Forex Rate is showing the forex rate that matches the Forex Rate Type selected and the Date of the transaction. 
                  1. 
                  2. Also, the number of decimals to show in the Forex Rate field follows that of the Company Configuration > System Manager tab > Details tab > Default Values section > Currency Decimals field setup.
         5. The following fields are shown in foreign currency value.
            1. Image Modified
               1. Cost
               2. Line Total
               3. Sub Total
               4. Total
         6. Click on Post Preview tab. 
            1. Image Modified
               
               1. Foreign Debit and Foreign Credit will show the foreign value of the transaction. In this example, this is the INR value.
               2. Debit and Credit will show the value of the transaction in functional currency. In this example, this is the USD value. This is what get's posted to the General Ledger when the transaction is Posted.
         7. Click Post to post the transaction.
         8. Once transaction is posted, it will then be recorded in the GL Account Detail. 
            1. 
               1. GL Account Detail can be opened from General Leger > GL Account Detail > select to open any of the accounts used in Inventory Receipt transaction, in this example it is 16000-0001-001 or 21000-0001-000.
               2. To check the complete set of entries for the selected transaction, select for the transaction created (use the Record No. to look for the transaction) by checking the checkbox before the Date and click Transaction Detail.

Example 2: This example will show you when functional currency rate is lower than foreign currency rate.

1. Say this is your foreign Vendor. In this example, Currency field is setup as INR (Indian Rupee). You can open Vendor screen from Purchasing (Accounts Payable) > Vendors.
   Image Added
2. Create Inventory Receipt. 
   1. Inventory > Inventory Receipts > click New
   2. Details tab
      1. In the Order Type field select Direct.
      2. In the Vendor field select the Vendor with foreign currency setup. 
         1. Image Added
         2. Notice that Currency field will automatically show the Currency set for the selected Vendor.
      3. In the Items grid area,
         1. Select Item from Item No. field.
         2. Enter Qty to Receive and UOM.
            1. Image Added
            2. Notice the Currency Unit will also show as INR. This field will default to the Currency assigned in the Inventory Receipt > Currency field.
         3. In the Cost field enter the Cost of the item. 
         4. The Forex Rate Type and Forex Rate fields are defaulted based on your Multi-Currency setup. That is why it is recommended that you have your multi-currency setup prior to doing foreign transactions. This will make the transaction entry easier than having to select Foreign Rate Type in every transaction.
            1. Image Added
               
               1. The Foreign Rate Type is showing Spot since default setup for Inventory > Rate Type is Spot.
                  1. Image Added
               2. The Forex Rate is showing the forex rate that matches the Forex Rate Type selected and the Date of the transaction. 
                  1. Image Added
                  2. Also, the number of decimals to show in the Forex Rate field follows that of the Company Configuration > System Manager tab > Details tab > Default Values section > Currency Decimals field setup.
         5. The following fields are shown in foreign currency value.
            1. Image Added
               
               1. Cost
               2. Line Total
               3. Sub Total
               4. Total
         6. Click on Post Preview tab. 
            1. Image Added
               
               1. Foreign Debit and Foreign Credit will show the foreign value of the transaction. In this example, this is the INR value.
               2. Debit and Credit will show the value of the transaction in functional currency. In this example, this is the USD value. This is what get's posted to the General Ledger when the transaction is Posted.
         7. Click Post to post the transaction.
         8. Once transaction is posted, it will then be recorded in the GL Account Detail. 
            1. Image Added
               
               1. GL Account Detail can be opened from General Leger > GL Account Detail > select to open any of the accounts used in Inventory Receipt transaction, in this example it is 16000-0001-001 or 21000-0001-000.
               2. To check the complete set of entries for the selected transaction, select for the transaction created (use the Record No. to look for the transaction) by checking the checkbox before the Date and click Transaction Detail.