Leading provider of Account Software
Questions? We got answers!
Support Center > Knowledge base> Article: How to Adjust if QTY in Batch Detail Report and Stock inquiry is not tally?

How to Adjust if QTY in Batch Detail Report and Stock inquiry is not tally?

Article ID: 52654 Email Print
Question
How to Adjust if QTY in Batch Detail Report and Stock inquiry is not tally? Example Problem happend like this: 1. batch item in OB with Batch 100 QTY 2. Stock Out in D/O 50 QTY 3. Stock IN in PINV 50 QTY 4. check Stock inquiry and Batch Detail report is not tally ! Check stock inquiry it show 100 QTY balance and check Batch Detail report it show 150 QTY as never deduct the D/O QTY

Answer

You have to adjust the stock inquiry QTY to 0 and the Batch Detail Report Balance QTY to be 0. So what you need to do is

1.1   Go to Stock Adjustment, select the batch item and issue OUT ALL the batches, so the Batch Detail Report Balance QTY is 0 now

1.2   However if you check Stock Inquiry, there is –ve QTY in the Balance (example -116), so you go to Delivery Order screen, select the item and set -116 in the QTY column (Original we issue 116 in D/o, this will deduct stock but now we set -116 and this will Stock IN)

1.3   So if you check stock inquiry now it will become 0

1.4   For these kind of D/O, write the descript for adjustment purpose and tick “Closed” Option

1.5   Go to perform actual stock take, then update the actual QTY and batch no. in system

1.6   Tick setting “Compulsory to select batch no.” so it could prevent the same problem happen in the future


related articles

Article Details
Views: 1163 Created on: Aug 07, 2014
Date updated: Aug 07, 2014
Posted in: Delphi

Poor Outstanding