Logging of balance during price change

Log WIP balance during price change (purchased part)

This system setting checks and logs the balance of the parts that are WIP during price change. A check will also be made to see which manufacturing orders will be affected by the price change. This is made to prevent differences between the accounting and the WIP value when standard prices are changed for parts in ongoing manufacturing orders. There are four options available for the setting:

• None – No logging will take place.
• Started – Logging will take place when the orders are started.
• Started – Finished – Logging will take place when the orders are started and finished.
• Started – Finished – Post-calculated – Logging will take place when the orders are started, finished, as well as post-calculated.

Log WIP balance during price change (manufactured part)

This system setting checks and logs the balance of the parts that are WIP during price change. A check will also be made to see which manufacturing orders will be affected by the price change. This is made to prevent differences between the accounting and the WIP value when standard prices are changed for parts in ongoing manufacturing orders. There are four options available for the setting:

• None – No logging will take place.
• Started – Logging will take place when the orders are started.
• Started – Finished – Logging will take place when the orders are started and finished.
• Started – Finished – Post-calculated – Logging will take place when the orders are started, finished, as well as post-calculated.

Log delivered balance, not yet invoiced, during price change (purchased part)

This setting controls whether delivered but not yet invoiced balances, should be included in the price change log when the standard price is changed.

The function can be used to adapt price change logging and valuation according to the company’s accounting principles, depending on whether the value is considered finalized at the time of delivery or at the time of invoicing.

The setting can be changed when Standard price is used as valuation method. If FIFO FIFO is calculated via the old stock log records existing in the system. All records have a price which is saved during the arrival reporting. However, for a purchase order the price will be updated when the supplier invoice becomes linked to the arrival reported items. This means that the FIFO value can change even though no stock transaction has taken place after the most recent inventory value list was created. Stock count and direct stock reporting will have the standard price as value. Other transactions such as negative reporting of material via manufacturing order, gets the standard price and also affect the FIFO. When FIFO is to be calculated, the part's balance is first checked. Then the program will find as many (positive) transactions as needed to be able to valuate these parts. The most recent transactions will then be used first. Example: If you have a balance of 100 units and the most recent transactions are: first a purchase of 80 units for EUR 10 each and then a purchase of 20 units for EUR 20 each, then the FIFO will be: 80 × EUR 10 + 20 × EUR 20 = EUR 1200, that is EUR 12 per unit. is used as valuation method, this setting will be locked to Yes.

• No – The delivered balance, not yet invoiced, will not be included in the price change log. When price changes occur, only the following will be checked and logged:
  • Stock balance
  • Balance in work in progress (WIP), depending on the setting called Log WIP balance during price change (purchased part).

• Yes – The delivered balance, not yet invoiced, will be included in the price change log. When price changes occur, the log will also register:
  • Delivered balance which has not yet been invoiced
  • The value of this balance at the time of the price change.

Log delivered balance, not yet invoiced, during price change (manufactured part)

This setting controls whether delivered but not yet invoiced balances, should be included in the price change log when the standard price is changed.

The function can be used to adapt price change logging and valuation according to the company’s accounting principles, depending on whether the value is considered finalized at the time of delivery or at the time of invoicing.

The setting can be changed when Standard price is used as valuation method. If FIFO is used as valuation method, this setting will be locked to Yes.

• No – The delivered balance, not yet invoiced, will not be included in the price change log. When price changes occur, only the following will be checked and logged:
  • Stock balance
  • Balance in work in progress (WIP), depending on the setting called Log WIP balance during price change (purchased part).

• Yes – The delivered balance, not yet invoiced, will be included in the price change log. When price changes occur, the log will also register:
  • Delivered balance which has not yet been invoiced
  • The value of this balance at the time of the price change.

Log balance between warehouses

This setting is always activated and cannot be changed. The balance between warehouses is always logged during price change.

This setting is displayed to visualize which balances are included in the logging at price changes. The showing of this setting does not affect the function of the system or the logging behavior.