cancel
Showing results for 
Search instead for 
Did you mean: 

incorrect and negative quantities after stock take

Former Member
0 Kudos

hi all

my client dd a stock take ad after the stock take the in whse quantities are incorrect and negative.

what the system does is it takes counted nd lesses the difference and gives a wrong and negative amount.

e.g. item glw4: he counted 4 in the warehoue and the difference was 16 and now theres -4 in the warehouse.

they are on 2007 PL47.

Please assist

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

What is your posting date? Is it current date or date in the past?

Thanks,

Gordon

Former Member
0 Kudos

Hi Gordon

thanks for your response.

The stocktake as done on the 4th May 2012. which was the current date

regards

travelyn

Former Member
0 Kudos

In the same date, is there any other stock change for the item? Run Inventory Audit Report to find out.

Former Member
0 Kudos

hi Gordon

i ran the inventory audit report and the in-warehouse stock is negative.

i even ran the posting list... and the in warehouse stock is negative

regards

travelyn

Former Member
0 Kudos

You have not answer my question: is there other inventory movement for this item in the same day? Better post your report here to see.

Former Member
0 Kudos

HI

You should tick 'Block Negative inventory by item setting or company setting'.

goto Administration->system initialisation_>Document settings.

Under general tab,you will find 'Block Negative inventory by item setting or company setting',you should tick this which wont allow negative stock.

I think,there was already negative stockt(-4) in that warehouse,when you do stock take for 10,

it will show only 6.

You need to adjust the inventory with correct value,by stock taking the correct figure.

Ex:If the correct inventory is stock is 10 and previously it was14,now you should add only -4 which equals it.

revert me for any clarification