You are wondering how to ensure a healthy Microsoft Dynamics 365 Business Central implementation? One of your best allies is the Financial Management module. Here are some verified tips for a successful go live.
Never select ‘Direct Posting’ for an account listed in a posting setup table.
The reason is simple: if a user posts a manual journal entry directly in the general ledger, that will create an unbalanced reconciliation between the ledger and sub-ledger figures. In order to prevent such incidents from occurring, it is recommended to have this setup turned off for specific accounts.
Therefore, for each transaction that is posted in the inventory accounts, there should be an associated entry in the inventory tables (e.g. item ledger entry table or value entry table). For example, posting a sales transaction will generate entries in the inventory tables as well as in the inventory accounts on the chart of accounts.
It is beneficial to always use a different account number for each transaction type: sales account vs sales discount account, local sales vs foreign sales account, COGS (Cost Of Goods Sold) in transit (shipped not invoiced) vs COGS (shipped and invoiced).
COGS and cOGS interim, sales and sales discount, etc.
Interim inventory accounts and inventory account.
The system uses the most restrictive ones.
The General Ledger Setup page is used to specify default settings for the general ledger and all finance related application areas, and controls certain behavior within the system. The General Ledger Setup page must be completed for each company.
Inventory periods are used to manage posting of inventory adjusting entries. Adjusting entries will post in the period of the original transaction unless inventory periods are closed on a monthly basis. Creating and closing inventory periods will prevent the inventory adjustments from posting in that period. If the posting date of the original transaction is in a closed inventory period, then the value of the adjustments is posted on the first day of the first open inventory period. This makes sure that the General Ledger value of inventory, expenses, and cost of goods sold do not change once the financial statements have been printed for a month.
Run the “Adjust cost batch” job via job spooler over night and every night even with automatic adjust cost and post cost to the General Ledger.
Yes, you can allow ‘Prevent negative inventory’ in the Inventory setup and Item card.
By default, Microsoft has restricted manufacturing consumption posting if the inventory reaches negative. We also understand that this restriction had been placed in order to avoid costing discrepancies (specially if items are on Average Cost) that may occur due to the system not being able to apply the relevant demands and supplies.
Supposing that you have good inventory accuracy, there should be no negative inventory at the end of any day. Negative inventory means your replenishment planning system is using invalid data—which yields incorrect reordering recommendations—and your costing system has no chance of reflecting accurate inventory and COGS values.
In Microsoft Dynamics 365 Business Central, we can also think of negative inventory as being negative in one location and positive in another location. For instance, in Location A, the system shows 1 on hand, but in location B, it shows -1 on hand. When we look at the total, the system shows 0 on hand, which is accurate when viewed globally. However, this is still not acceptable and needs to be addressed.
An easy way to prevent negative inventory would be to change the system to never allow negative inventory. This sounds good in theory, but I find that in some companies it would be a culture shock. You can imagine if, at the end of a month, quarter, or year, the boss asks why you didn’t make the shipment that would have made the company’s shipping goal, and you answer, “Because the system wouldn’t let me post negative inventory.”
It is best to identify the areas that are causing a negative inventory and then correct those issues.
Keep in mind, however, that inventory values should never reflect a negative value, so it is just as important to correct at the root what caused the negative inventory in the first place.
Stay up to date with vendor invoice vouchering:
On-hand inventory accuracy will generate confidence in the system for all users.
Key users should have basic accounting knowledge to understand and facilitate learning of a new ERP system. Typically, a key user should have a clear idea of financial terms like Chart of Accounts, Credit / Debit, Profit & Loss, Balance Sheet, Taxations, Basic Accounting (like Invoicing, Bank, FA, Cash Expenses) etc.
In the end, Finance is the most important module in any ERP system. All the modules are integrated with Finance. All the more reason to be very careful in configuring all its parameters in the system.