3523393 - Inventory Account linked to Non-Inventory Transactions

Symptom

A database can be a candidate for an Inventory Valuation Check-up service when there is a difference between the overall inventory value in the Inventory Audit Report (IAR) and the inventory account balances in the General Ledger.

One of possible reasons can be the usage of an Inventory Account in the following types of Non-Inventory transactions:

Non-Inventory items or Resource items used in marketing documents
Resource components used in Receipt from Production / Issue to Production documents
Service Type marketing documents
Incoming and Outgoing Payments

In cases where it is required to investigate these differences and find out details, you can use the attached detection script to identify affected documents, item codes, resource items / components and linked journal entries.

These scenarios can lead to differences between stock value (IAR balances) and G/L inventory account balances.

Environment

SAP Business One

Product

SAP Business One all versions ; SAP Business One, version for SAP HANA all versions

Keywords

Stock, Inventory, Account, Non-inventory, Non inventory, Service Type, Resource, Payment, IVC, Journal Entry, IAR

, KBA , stock , accounting , SBO-MM-IVC , Inventory Valuation Check-up , SBO-REP-MM , Inventory Reports , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.