Greetings of the day!
We have recently implemented ERPNext for one of our clients, and during their usage—particularly while working with reports—they are facing a few functional queries. We request your guidance and support in addressing the same. The details of the queries are outlined below for your kind review.
1) Trial Balance Report
Currently, the Trial Balance report is displaying balances in a hierarchical manner, i.e., Head-wise (Assets → Current Assets → Bank Account). However, the client requires the Trial Balance to display only the individual Chart of Accounts (for example, Bank Account) along with their respective Debit or Credit balances, without the parent group-level aggregation.
We attempted to configure this from our end but were unable to achieve the required output. Kindly guide us on the steps or settings required to generate the Trial Balance in the desired format.
2) Accounts Payable Ageing Summary – Credit Period Calculation
While generating the Accounts Payable Ageing Summary, the client requires the credit period to be calculated from the Inward Date (i.e., the date of receipt of goods) rather than from the Purchase Invoice posting date.
To explain with an example:
-
Purchase Order Date: 15.12.2025
-
Goods Receipt (Inward Date): 20.12.2025
-
Purchase Invoice Entry Date: 10.01.2026
Due to issues such as rate negotiation, the Purchase Invoice could not be entered immediately. Meanwhile, the goods were approved by the quality team and consumed in production. Since the client had already frozen their December accounts for TDS and GST filings, backdated posting of the Purchase Invoice is not feasible.
If the supplier’s credit period is 30 days, ERPNext currently calculates it from the Bill posting date (10.01.2026) instead of the actual receipt date (20.12.2025). The client wants the credit period to be calculated from the Inward Date.
Kindly advise on how this requirement can be handled in ERPNext, either through configuration, customization, or a recommended workaround.
3) GST Implications in Purchase Invoice (Item-wise GST Rates)
While entering Purchase Invoices for Services, the client wants to apply different GST percentages (for example, 5% and 18%) at an item level within a single Purchase Invoice.
Currently, ERPNext allows only a single GST tax structure per Purchase Invoice, and the selected GST percentage (either 5% or 18%) is applied to the entire bill amount, rather than calculating GST individually at the item level.
Additionally, the client maintains separate ledger accounts for each GST rate (such as Input CGST 5%, Input CGST 18%, etc.) for both Input and Output taxes. They want the system to post GST amounts to the respective GST percentage accounts instead of common GST ledgers (Input CGST, Input SGST, Input IGST, Output CGST, Output SGST, Output IGST), to enable accurate tracking and reporting.
Kindly guide us on how this requirement can be configured or addressed in ERPNext.