Hello everyone,
a question for the group: like some others here, we are also obliged to value our inventories according to the lower of cost or market principle (Niederstwertprinzip).
Brief explanation: The lower of cost or market principle according to Section 253 of the German Commercial Code (HGB) is a principle of proper accounting (GoB) that requires caution in accounting. It states that assets must be valued at no more than their acquisition or production costs on the balance sheet date or, if lower, at their fair value (market/stock market price) in order to recognize losses in a timely manner.
We do here with an analysis from Excel, which is based on the inventory value simulation in IFS and some added values (last procurement, last sale, last consumption by shop order). This works, but is of course time-consuming and (because it is manual) prone to errors.
How do you solve this?