Table of Contents
Find the Ledger
The product ledger can be found in two ways.
- Via the three dots in the overview
Go to Items → Products/Bills of Materials. In the overview, hover over the three dots on the right-hand side and click Ledger:
- Via Actions when the item is opened
Open the item, click Actions in the upper right corner, and then Ledger:
Overview
Types of transactions on the ledger:
-
Order: The transaction number series. If transactions have been registered retroactively or in the future, you can follow the sequence here.
-
Date: The date the transaction affects the inventory (Ledger date).
-
Transaction: The type of transaction (Quantity adjustment, Value adjustment, Shipment, Receipt, Production Order, or Movement).
-
Location: The name of the location the transaction affects.
-
Quantity: The number of units involved in the transaction.
-
Value per unit: The booked value per unit.
-
Value: The total value of the transaction.
-
Total quantity: The total quantity in stock at the time of the transaction.
-
Total value: The total stock value of the item at the time of the transaction.
Corrections
Note! Corrections are only eligible for agreements using the Average cost principle.
When a transaction is adjusted, it is marked as “Corrected.”
Click the label to view an explanation, which typically refers to the triggering transaction (e.g., a backdated receipt or cost price adjustment).
A correction occurs when the cost price of an item is changed retroactively.
This happens, for example, if a receipt or shipment is registered with an earlier date.
The system will then adjust the original transaction to ensure that the inventory value and cost price remain accurate.
Accessing the transaction from the Ledger
All transactions on the product card are clickable (blue text). When you click, you’ll be taken to the corresponding entry in the system:
-
Shipment, Receipt, and Production Order → opens the specific entry
-
Adjustment and Movement → takes you to the general overview of the function (not the individual adjustment/transfer). From here, the transaction can be found by filtering on archived.
Export of the Ledger
It is possible to export product cards in Rackbeat through the Product Card report.
Go to:
Reporting → Ledger.
Apply the relevant filters and click Download sheet in the top right corner to export.
See also the guide for the report here:
Reporting: Ledger