FEATURES: Phantom BOMs for subproducts, hierarchical chart of accounts, financial periods report with updated monthly closing process, and more!
Feature 1: Phantom BOM
When it comes to nested products within a Production BOM, a separate nested Production Order is created for the nested product (e.g. Parent – Cake and Child – Frosting). However, in some cases, it will make more sense to produce the nested product in the same production process as the parent.
In this release, we have introduced a phantom BOM, representing a product that is physically built, but not stocked, before being used in the next step or level of manufacturing. This can be used to add earlier production steps (Frosting) quickly and easily into multiple parent BOMs, while still keeping the child as part of the same production process. Phantom BOMs function like an assembly BOM with auto-assembly/disassembly enabled.
Phantom BOMs can also be used to auto-disassemble a component (e.g. package of flour) into the required quantity for production during the production process.
Documentation will be included in the next release.
Feature 2: Hierarchical Chart of Accounts
Financial module, Settings
The Chart of accounts lists the accounts used by an organisation to define the entity’s finances and segregate expenditures, revenue, assets and liabilities. Multi-level accounting structures are used by merchants to track segments of companies, business units, or profit centers. This structure allows organisations to consolidate their transactions by levels for summary purposes. In this release, DEAR have added the option of selecting a hierarchical COA structure as well as the flat structure currently in use. Hierarchical COAs allow users to create subaccounts for an existing account.
- Accounts integrated with Xero/QBO only support a flat COA.
- Go to Settings → Financial Settings and change Chart of Account type to Hierarchical
- Go to Settings → Reference Books → Chart of Accounts
- Select +Account to add a new account. A new field has been added for Parent Account.
- Selecting NONE for Parent Account will create a new root account.
- Selecting a parent account will cause the new sub-account to inherit the properties of the parent account.
- Up to 10 levels of sub-accounts are allowed.
Transactions can only be posted to the bottom-most level of sub-accounts. Accounts with transactions can not be deleted. Adding a sub-account to an account with transactions will trigger a confirmation message, confirming that all transactions will be moved to the sub-account.
Feature 3: Monthly closing and financial periods report
Financial module, Reports module
With this release, we have introduced a report displaying Financial Periods for all of our users. This report was previously available to our customers in China but has now been expanded worldwide. This allows the user to open or close periods from the report, and view from the report if there are any reasons the period cannot be closed (e.g. draft manual journals).
- User permission Financial Reports must be enabled.
- Go to Reports → Financial → Financial Periods Report.
- The user can now open and close periods from this report. Before a period can be closed, the period must:
- have no DRAFT manual journals
- run depreciation
- run unrealised exchange adjustment process (if setting is enabled)
- run carry forward P&L process (if setting is enabled).
- Statuses of all these requirements are displayed in the report.
- Open the Period Details page by clicking a period. There are two additional tabs,which will run automatically when the user accesses them.
- Unrealized exchange adjustment calculation
- Carry forward calculation
- When a user closes the selected period, DEAR creates special journals for unrealised exchange adjustment and carry forward based on the calculations that took place on the Period Details tab.
Unrealised exchange adjustment and carry forward processes for monthly closing can be turned on or off by going to Settings → Financial Settings. If these processes are turned off, the user can close a financial period via the report without running these processes.
Feature 4: Xero consolidation improvements
Xero integration, Sales channels
Currently, DEAR accounts integrated with Xero support consolidating transactions by available eCommerce sales channels instead of processing each invoice/credit note individually.
All invoices/credit notes with the same date, currency, tax inclusive/exclusive indicator, shop name and sales channel will be consolidated into a single daily invoice/credit note to Xero. The period for consolidation is always one day. This function can be problematic for DEAR merchants who has 1000 of transactions from different sales channels on a daily basis.
With this release, new settings have been added to Xero to give the user more control over consolidation options. Sales can be consolidated daily or monthly, while payments, journals, and money tasks can be consolidated daily, monthly, or not at all.
- Integration with Xero
- Go to Integrations → Xero → [select store]. From here, scroll to Consolidate on Export.
- Enable Xero Summary Details to view and edit consolidation options.
Rolling out an Application Gateway service which will change the DEAR site IP address to 220.127.116.11