Post Bin Reconciliation

For an overview of Stock take procedures, refer to Bin Tracking Stock Take Procedures

For details on the fields, refer to Post Bin Reconciliation - Field List

Use this form to post inventory counts that you entered in the B/T Physical Inventory, bin Inventory Counts form.

When you post a Bin reconciliation, Bin Tracking will do the following:

1. Update I/C details

If the Bin Tracking Worksheet was generated by an I/C Inventory Worksheet, Post Reconciliation also updates the associated I/C Inventory worksheet with the sum of the items per bin.

If the Bin Tracking Worksheet was generated by the Generate Bin Worksheet process in Bin Tracking, Post Reconciliation creates an I/C Adjustment with either

The difference between the original quantity in the Bin Transfer Worksheet and the counted quantity or
The difference between the original quantity in I/C and the counted quantity

2. Create Bin Transfer Documents

If the I/C worksheet is updated successfully or the I/C Adjustment above are created successfully, Post Bin Reconciliation will create a Bin transfer document to increase/decrease the quantities per item per bin. The Bin Transfer documents will be marked Complete.

3. Delete the BT Inventory Worksheet .

Important!

When an I/C Adjustment is created on posting a Bin Tracking Worksheet , the description is set to "Created by B/T Stocktake". This is how Bin Tracking knows not to create another bin transfer for this I/C Adjustment. If the description is changed in any way, then BT will create another Bin Transfer for the I/C Adjustment.

The I/C Adjustment Description must not be changed.

Note:

Posting Bin Reconciliation only update quantities

I/C supports Serial and Lot tracking amendments via quantity only. So, for example if you have 6 of an item, all assigned to a single lot number, you cannot (via the stock take) amend the item to have 5 assigned to one lot, and one assigned to another lot. You can increase or decrease the quantity (and assigned lot), but not “change” the lot only. Accordingly, in the Bin Tracking stock take worksheet generated from I/C if you amend the item to have 5 to one lot, and 1 to another - this will be allowed in Bin Tracking but will give an error when posting through to the I/C Stock take.