The Inventory Bot monitors transactions in Financial Books and automatically tracks inventory items in a separate Inventory Book. Key features include:
To configure the Bkper Inventory Bot, ensure the following setup:
inventory_book
property to true
.The Inventory Bot interacts with various properties to manage and synchronize data effectively. Ensure these properties are correctly set in your books for optimal performance.
Book Properties:
exc_code
: Required - The exchange code representing the book currency.inventory_book
: Required set to true
- Identifies the Inventory book of the collection.Group Properties:
exc_code
: Required - Defines the exchange rate code that represents the currency in which the good is accounted for. Each good account to be tracked by the Inventory Bot must reside into a group with this property defined.Transaction Properties:
quantity
: Required - The quantity of the inventory item in the transaction.purchase_invoice
: Required - Reference to the purchase invoice number.purchase_code
: Required - The code that identifies the transaction. Also required (and must have the same value) in the additional cost and credit note transactions to reference those transactions for the good purchase transaction. Its value must be equal to the purchase_invoice
property value in good purchase transactions.order
: Optional - The order of the operation if multiple operations happened on the same day.good
: Required - The account name of the inventory item.quantity
: Required - The quantity of the inventory item in the transaction.sale_invoice
: Optional - Reference to the sale invoice number.order
: Optional - The order of the operation if multiple operations happened on the same day.purchase_code
: Required - Since it adds costs to a specific good purchase transaction, it must have the same value as in the good purchase transaction to reference it.purchase_invoice
: Required - Reference to the additional cost invoice number.order
: Optional - The order of the operation if multiple operations happened on the same day.purchase_code
: Required - Since it deducts costs from a specific good purchase transaction, it must have the same value as in the good purchase transaction to reference it.credit_note
: Required - Indicates this transaction is a credit note and references to its invoice number.quantity
: Optional - The quantity of the inventory item returned in the transaction.order
: Optional - The order of the operation if multiple operations happened on the same day.IMPORTANT: Always remember to check the transaction after recording it (by clicking on the ✓ icon) for the bot to perform its actions.
The Inventory Bot uses the FIFO (First-In, First-Out) method to calculate Cost of Goods Sold, ensuring accurate tracking of inventory costs.
Automatic COGS Calculation: When a sale transaction is detected, the bot automatically determines the cost of the goods sold based on the oldest purchases still in inventory.
Purchase and Liquidation Logs: The bot maintains detailed logs of all purchase and sale transactions, providing an audit trail of inventory movements.
Additional Costs Support: The system can account for additional costs associated with inventory items, ensuring accurate cost calculations.
Credit Notes Handling: Support for credit notes allows for proper adjustment of inventory when goods are returned.
Important: The Inventory Bot automatically adds properties to transactions in the Inventory Book when calculating cost of sales. These properties are used for state and log control. It also manages transaction states by checking/unchecking transactions (see Transaction States). These properties and states must not be manually altered.
To use the Inventory Bot:
Set up your books: Ensure your Financial Books and Inventory Book are properly configured with the required properties.
Record transactions: When recording purchase and sale transactions in your Financial Books, include the required properties (good
, quantity
, etc.).
Calculate COGS: Use the bot's interface (in the More menu) to calculate Cost of Goods Sold for inventory accounts. This can be done for:
Review results: The bot provides detailed results of its calculations, showing the cost of goods sold for each account.
Reset if needed: If you need to recalculate COGS for any reason, you can use the reset function to clear previous calculations and start fresh.