Knowledge

Manual Mapping

NOTE: If the Inventory delivery voucher mapping is disabled, the inventory delivery voucher is not automatically mapped. Manual mapping is required.

Automatic mapping for inventory delivery voucher 

• Step 1. Go to Settings menu under the Accounting module in the left sidebar -> Select the Mapping setup menu -> Select the Inventory tab  ->  Enable the Inventory delivery voucher mapping setup  and select the payment account and deposit to -> Click on the Save button
  
  Profit = Selling price - Purchase price
• Step 2. Enable the Tax default -Sales mapping setup so that the total tax amount of the inventory delivery voucher will be mapped to this configuration. if this configuration is not enabled, the tax of the inventory delivery voucher is not mapped to any accounts.
  
  
• Step 3. Create the inventory delivery voucher and approve it. 
  
  Step 4. Go to the Transactions menu under the Accounting module -> Inventory -> Inventory delivery voucher, this inventory delivery voucher is mapped automatically.
  
  
  Click on the Edit to view mapping detail
  
  Value of inventory and profit  is mapped according to the Inventory delivery voucher mapping setup.
  Total tax amount mapped according to Tax default-Sales mapping setup.
  And this inventory delivery voucher is displayed in the report. 
  
  

Advanced Auto Mapping

This configuration allows you to map different Items to different Accounts, and different Tax Types to different Accounts. 

• Step 1. Enable the Inventory deliveryvoucher and select the Payment account and Deposit to for Inventory and Profit. At the same time, enable Tax (optional) if you need to map taxes for items in the inventory receiving voucher. The system will prioritize mapping based on the Tax Default configuration. 
  
  

• Step 2. Go to the General Tab, enable Tax Default, and select the Payment account and Deposit to for Sales. 
  
  

• Step 3. Create Item Mapping Setup for one or more required items and assign an Inventory asset account and Income account. Example: Green stripe with high grade black stone 
  Inventory Asset Account is used to map the inventory value (stock value upon receiving)
  Income Account is used to map the profit 
  
  

• Step 4. Create Tax Mapping Setup for one or more tax types, and select the Payment Account and Deposit To under Sales. Example: VAT 5% 
  
  

• Step 5. Create an Inventory Delivery Voucher with 2 items and corresponding taxes.
  
  
  ==> Result: System Auto Mapping
  1. Green stripe with high grade black stone: 
      - Inventory ($10.15): 
            + Payment account: Default from Inventory Delivery Voucher Default (Step 1) 
            + Deposit to:  From Inventory Asset Account (Step 3) 
   
     - Profit ($139.85): 
            + Payment account: From Income account (Step 3) 
            + Deposit to:  Default from Inventory Delivery Voucher Default (Step 1)  
  
      - VAT 5% ($0.5): Mapped based on the Sales Account Pair configured in Step 4
  
  2. Synology FS6400: 
  
  - Unit Price ($15,005,000): 
            + Payment account: Default from Inventory Delivery Voucher Default (Step 1)
            + Deposit to: Default from Inventory Delivery Voucher Default (Step 1)
  
  - Profit ($15,005,000): 
            + Payment account: Default from Inventory Delivery Voucher Default (Step 1) 
            + Deposit to:  From Income account (Step 3) 
   
   - VAT 8.75% ($11.9): Mapped based on the Tax Default configuration in Step 2
  
  
  
  
  
  

Mass mapping 

• Step 1. Enable the Inventory delivery voucher mapping setup  and select the payment account and deposit to -> Click on the Save button
• Step 2. Go to the Transactions menu -> Inventory -> Inventory delivery voucher -> Select the inventory delivery voucher which mapping status is Has not been mapped -> click on the Bulk actions -> select the Mass mapping -> click on the Confirm button.
  
  
• Step 3. Confirm your selection in the following pop-up. The inventory delivery voucher will be mapped.
  
  

Edit mapping

• Step1. Go to the Transactions menu -> Inventory -> Inventory delivery voucher -> Click on the Edit  
  
  
• Step 2. Change the account and click on the Save ==> the amount of the account will be changed. 

Delete mapping 

Deleting the mapping will change the account's amount

• Step1. Go to the Transactions menu -> Inventory -> Inventory delivery voucher -> Click on the Delete
  
  
• Step 2. Confirm your selection in the following pop-up. The mapping of inventory delivery voucher will be deleted.
  

Mass delete mapping

Deleting the mapping will change the account's amount

• Step 1. Go to the Transactions menu -> Inventory -> Inventory delivery voucher -> Select the inventory delivery voucher which mapping status is Has been mapped -> click on the Bulk actions -> select the Mass delete mapping -> click on the Confirm button
  
  
• Step 2. Confirm your selection in the following pop-up. The mapping of inventory delivery voucher will be deleted.