29

In the case when the unit cost of the inventory has more than two decimal places, the system posts the COGs during sales, rounding the cost to two decimal places.


When posting the whipment that closes the given delivery, the system adds an entry: rounding, which is posted according to the following principle:


  • Document number = receipt document number,


  • Posting date = posting date of the receipt document, if the dates in the general ledger settings limit the posting dates, the entry will be posted on the first possible date,


  • Document posting = the system will enter:

a) the Inventory account according to the settings of the inventory posting group and the location to which the entry will apply

b) the bal. account to the Inventory account: the system checks which accounting groups Business and Product were selected on the receipt document and which Inventory Admj. Account is set in the General Posting Setup at the time of posting the sale;


This can often cause unwanted postings, because the appropriate Inventory Adjustment Account is not always set at the time the roundings are posted. Therefore, it seems like a good idea to handle this process, e.g. by:


  1. Add an option to the Inventory Setup to select a default General Business Posting Group for the ROUNDING entry type - which would be used when posting such roundings.
  2. The appropriate combinations of settings with the Inventory Adjustment Account will be created by users in General Posting Setup.
  3. Posting in the G/L would be done like this:
  • Inventory Account (according to the settings of the Inventory Posting Group) and location = no changes here)
  • bal. account: Inventory Adjustment Account from the General Posting Setup for the General Business Posting Group and Product Posting Group.


The document number and date do not seem to need to be changed, the posting date is monitored thanks to standard functions- restrictions in the general ledger setup or closed inventory periods.


STATUS DETAILS
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team

Comments

D

That would effectively solve many problems in my day-to-day tasks. Good idea.

Category: Financial Management

D

That would be a great solution that can avoid a lot of issues during daily work. Hope it will be implemented soon.

Category: Financial Management

D

Great Idea. I hope it will get on Microsoft roadmap. I bet it will be game changer for some clients.

Category: Financial Management