Skip to main content

We a getting several zero quantity records in Inventory Value per period where total inventory value is not zero.  I understand that the ROUNDDIFF transactions should balance these out at the end of the period but we are NOT getting ROUNDDIFF transactions.  We use the Inventory value per period screen as an audit record for inventory in stock.  Auditors do not like when zero * zero equals a dollar amount that is not zero at the end of the period.  SO I have a few questions:

  1. What are others doing for audit records of inventory values?
  2. If it is the inventory value per period screen, how are you explaining the total inventory value amounts when all quantities are zero
  3. What do you do when no ROUNDDIFF records are created?

Hi @MaurineS ,

  1. As far as I know, inventory values are tracked in this Inventory Value per Period and comparing also with Inventory Accounts
  2. Inventory Value per Period is an aggregation of inventory values available in Inventory Transactions. If costs have changed between incoming transactions (direction +) and outgoing transactions (direction -), or revaluation events have been triggered, then final balance can have a value different than 0, when quantity=0 and the number of inactive days is acceptable. The total value then shows in each period the variance of inventory value, not really the Total Value. That could be the reason why you are having remaining values with quantity=0.
  3. Then, system generates ROUNDDIFF transactions when a new period is generated in Inventory Value per Period, to clear the remaining values. 

If you are sure that you don’t have stock and values shown in Inventory Value per Period are correct for quantities = 0 then these ROUNDDIFF transactions should be generated when Aggregation is executed for the next period. Also, the related Accounting Period should be an Open period. Otherwise, again the remaining inventory value will be carried to the next period without creating the ROUNDIFF transaction

 

If they are not generated, then please create a Support case, so it can be reviewed in your environment.

You can also refer to these other Community posts, that can help you:

Regards,

Pilar

Thanks Pilar.  Where do I check the number of inactive days value?

Hi @MaurineS ,

This is configured at site level:

Regards,

Pilar

Thanks Pilar.  I’ll check that setting and see if we get any ROUNDDIFF transactions at the end of this week.  If not, I’ll log another IFS case.

Reply


Terms & ConditionsCookie settings