Introduction

Intercompany Logistix comes with enhanced functionality in the physical inventory journal, for calculating current stock and reconciling againt the virtual operations company. This document describes this functionality.

Prerequisites

There are no prerequisites for this functionality.

Walk through

To generate a stock balance journal at the end of any month, follow the steps below:

1. Start by opening up the "Phys. Inventory Journal", by searching for it in the search pane.
2. Then calculate the item inventory by clicking "Calculate Inventory".
3. Make sure that the posting date is set to the end of the period to calculate. For example "2024-03-31".
4. Also check "Items not on inventory"-checkbox in order to include items with zero inventory.
5. Click "OK" to generate the worksheet.
6. When the journal is filled with items, click "Actions" => "Function" => "Calc. Phys. Inv. Qty. per Posting Date". This will re-calculate the "Qty. (Calculated)"-column with the quantity based on the posting date.
7. At last, when finished, click "Reconcile items From Logistics Company". This will fill out the "Qty. (Phys. Inventory)" with the value from the virtual operations company. 
8. Analyze the result, and decide if and to post or not.