Mapping of Chart of Accounts

[Ikrama]

Dear Fellow Experts,

I hope you all are doing great.

I am currently facing an issue with auto-mapping the Chart of Accounts for various item types in ERPNext. I have different types of items such as consumables, raw materials, services, semi-finished goods, and finished goods. For each specific item type, I need the relevant transactions to automatically hit the appropriate GL account upon Goods Receipt Note (GRN) or delivery.

I have referred to the ERPNext documentation, which suggested two options for mapping accounts:

1. Item-wise Accounting Setup
2. Item Group-wise Accounting Setup

The documentation advised me to enter accounts in the Accounting tab of each item under Deferred Expense or Deferred Revenue for both mentioned setups. However, when I enable the Deferred Revenue and Deferred Expense checkboxes, the system does not display the relevant accounting fields to map the appropriate accounts.

I have attached a screenshot for reference. Could you please guide me on how to resolve this issue and ensure that the correct GL accounts are automatically mapped to each item type during GRN, Delivery, Stock Adjustment, Inventory Transfer, Income/Revenue account, Expense account, Warehouse accounts etc.

Note: If I mised to mentioned any important relevant account kindly do provide guidance on that too

I look forward to your guidance.

Best regards,
Ikrama

[Maveez]

Account Mapping for items in ERP can only be done on sales, not on purchase. However you can create warehouses and see warehouse wise stock balance in chart of account/Balance sheet

And item wise stock balance can be viewed in Stock Balance report.
Deferred Revenue and expenses are booked against prepaid services.

[Ikrama]

Thank you for the response, Maveez. However, I have a scenario where I’ve created a purchase order containing raw materials and consumable items, both tagged with their respective item groups. Now, when I receive goods from the supplier, I want the inventory of raw materials to increase, and the raw materials account to be debited by a specific amount. On the other hand, for consumable items, the inventory shouldn’t increase, but the consumables account should still be debited by the corresponding value.

[Maveez]

for Consumables you can set the default expense account in item group defaults table.
and dont enable maintain stock in item master.

Here whatever item you purchased will be treated as an expense and hit that ledger accordingly.

[Ikrama]

Thanks @Maveez for helping out. Let me configure and execute the process.