Answer : You have to set Pricebook Categories first and map it to Chart of Accounts. To setup, please follow the steps as follow:


1.    To access this page, go to “CRM”, select “PRICEBOOKS”, select “PRICEBOOK CATEGORIES” and click on “VIEW LIST”.


 


2.    After you have clicked the button “VIEW LIST”. You will see this page. 

 


Description:


1

Click on “Add” button to add new category.

2

Click on “Edit” button to update data.

3

Click on “Delete” button to erase data. However, please note that data can only be erased if it is yet to be used. If used, if can’t be erased.

4

Here will show whether Pricebook category has been mapped to Accounting. If it is mapped, you can view the Chart of Account it is mapped to.

 

3.    To add new category, please click “ADD”.


EDIT PRICEBOOK CATEGORY:



Descriptions:


1

Please enter Pricebook Category name.

2

Please enter description if any.

3

In here, the system will list all the chart of accounts (Header and Detail) under Sales Revenue. 

If you choose Header account, each time you create a new product, it will automatically create a Chart of Account under the selected Chart of Account, and automap the product to that newly created Chart of Account. 

 

If you choose Detail account, each time you create a new product, it will automap the product to that Chart of Account. It will NOT create new Chart of Account.

4

In here, the system will list all the chart of accounts (Header and Detail) under Costs of Goods Sold / Overhead. 

 

If you choose Header account, each time you create a new product, it will automatically create a Chart of Account under the selected Chart of Account, and automap the product to that newly created Chart of Account. 

 

If you choose Detail account, each time you create a new product, it will automap the product to that Chart of Account. It will NOT create new Chart of Account.

5

In here, the system will list all the chart of accounts (Header and Detail) under Inventory. This is only applicable for products with inventory tracking. 

 

If you choose Header account, each time you create a new product, it will automatically create a Chart of Account under the selected Chart of Account, and automap the product to that newly created Chart of Account. 

 

If you choose Detail account, each time you create a new product, it will automap the product to that Chart of Account. It will NOT create new Chart of Account.

6

Tick in “Automap” existing pricebooks (this is only available during Edit), if you want to automap all the existing pricebooks that you have created before this mapping.

 

I want this to be fully automapped

  • However, you also have option to select “I want this to be fully automapped” if you have selected “Fully Automate” option in your Automated Accounting settings.
  • If you choose this, the system will automatically create a Header account under the selected account (Sales Revenue / COGS / Inventory), and the Account Type will automatically mapped to this newly created Header account.
  • The system will automatically create detail account when you create new pricebook with this category.

 

4.    After done please click the button “SAVE”.