Search Knowledge Base Articles

Consumable Mapping

Accounting & Bookkeeping BuildX



Used to map the value of consumable in the Fixed equipment module to the account.
Mapped value = Purchase cost * Quantity
All consumable states can be mapped.

Manual Mapping

 If the Consumable mapping setup is disabled, the value of the consumable is not automatically mapped. Manual mapping is required.

  • Step 1. Go to Consumables menu under the Fixed Equipment module -> create a consumable , enter the purchase cost, purchase date and quantity 1.png

  • Step 2. Go to Transactions menu under the Accounting module -> Fixed equipment -> Consumables-> click 2.png

3.png

  • Step 3. Select the account and click Save 4.png
    Result:

 5.png

Note: Prioritize data mapping by consumable purchase date. If the consumable does not have purchase date information, the data will be mapped to the account by the mapping date.

Automatic Mapping for Consumables 

  • Step 1. Go to Settings menu under the Accounting module in the left sidebar -> Select the Mapping setup menu -> Select the Fixed equipment tab  ->  Enable the consumable mapping setup and select the payment account and deposit to then click on the Save button
    6.png

  • Step 2. Go to Consumables menu under the Fixed Equipment module -> create a consumable , enter the purchase cost, purchase date, quantity

  • Step 3. Go to Transactions menu under the Accounting module -> Fixed equipment -> Consumables ,  value of this consumable is mapped automatically.
    7.png
    Note: Prioritize data mapping by consumable purchase date. If the consumable does not have purchase date information, the data will be mapped to the account by the mapping date.

Mass Mapping 

  • Step 1. Enable the consumable mapping setup and select the payment account and deposit to then click on the Save button.

  • Step 2. Go to Transactions menu under the Accounting module -> Fixed equipment -> Consumables-> Select the consumable which mapping status is Has not been mapped -> click on the Bulk actions -> select the Mass mapping -> click on the Confirm button
    8.png

  • Step 3. Confirm your selection in the following pop-up. The value of consumable will be mapped.
    9.png

Edit Mapping

  • Step1. Go to Transactions menu under the Accounting module -> Fixed equipment -> Consumables ->  Click on the Edit  
    10.png

  • 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 Transactions menu under the Accounting module -> Fixed equipment -> Consumables -> Click on the Delete
    11.png

  • Step 2. Confirm your selection in the following pop-up. The mapping of this consumable will be deleted.
    9.png

Mass Delete Mapping

Deleting the mapping will change the account's amount

  • Step 1.  Go to Transactions menu under the Accounting module -> Fixed equipment -> Consumables -> Select the consumable which mapping status is Has been mapped -> click on the Bulk actions -> select the Mass delete mapping -> click on the Confirm button
    12.png

  • Step 2. Confirm your selection in the following pop-up. The mapping of consumable will be deleted.
    9.png

 

Did you find this article useful?

Related Articles