Physical inventory by item group

(0) Share

Report

Posted on by Mirza Mujib Ur Rahm...

1,443

Hi all,

One of the items in "physical inventory by item group" report shows huge value in negative for both financial and inventory value.

I asked the user to make inventory recalculation again but still it shows the same value.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (30)

Answers (4)

Guy Terry 28,924 Moderator on at

Like (0)

Report

On the Inventory model group for the Item, what is the Inventory model? And is 'Include physical value' ticked?

Was this reply helpful? Yes No
Mirza Mujib Ur Rahm... 1,443 on at

Like (0)

Report

Hi Terry,

Its inventory model group is "Weighted Average by date" and yeah it is ticked for "Include physical value".

Thanks Terry

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (1)

Report

Go to Inventory management -> Inquiries -> Transactions -> Transactions to open the Inventory transactions inquiry. Press Ctrl + F3 to open the Advanced Filter. Set your filter like this:

AX will show any transactions for your item that are 'Registered'. Registered is a status that means the items are in stock, but do not have a value. It is possible to sell these items. When this happens, the value of the items will be negative. Is this what has happened in your scenario?

Was this reply helpful? Yes No
Mirza Mujib Ur Rahm... 1,443 on at

Like (0)

Report

Hi Terry,

I made the above filter and found nothing in my transaction inquiry grid.

Yeah we've huge negative value for both Inventory & Financial value for an item.

Thanks Terry,

Anymore suggestions and help would be really helpful.

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

It means that your 'Issues' (e.g. Sales) have been made at a higher cost than the total of all your costed Receipts (e.g. Purchase orders).

Since you have 'Include physical value' ticked, the only way to create an uncosted receipt is to use the Registered status. But you don't have any of those.

Can you look at the inventory transactions for the item? I can't really say exactly what you're looking for, other than what I describe above.

Oh, you don't run negative inventory, do you?

Was this reply helpful? Yes No
Mirza Mujib Ur Rahm... 1,443 on at

Like (0)

Report

Hi Terry,

Thanks again for your kind help.

Yeah we do run negative inventory for financial.

Now can u please guide me how can I reduce this item financial & inventory value from huge negative value to 120 .

Thanks,

Was this reply helpful? Yes No
5400 7,162 on at

Like (1)

Report

X++ finance is double entry system. if you want to reduce value, same value will go to another GL account.

You can go to profit and loss journal and adjust the value and quantity. Make sure you have select required GL account for offset and invent item group setup.

Thanks

Bhaskar

Was this reply helpful? Yes No
Weaveriski 23,618 Moderator on at

Like (0)

Report

The costing updates (inventory recalculation) will never run whilst you have negative stock. Therefore to correct you need to not be in this position by dimension. So make sure you do not have physical negative inventory, then run the inventory recalculation, then review.

"Physically" you cannot have negative stock, so you should be able to correct it, but until then the figures will remain.

Was this reply helpful? Yes No
Mirza Mujib Ur Rahm... 1,443 on at

Like (0)

Report

Hi Roy,

But this value refers to our last year inventory which we've already closed it.

How do we adjust the last year values from this year through Profit/loss journal.

Thanks Roy,

Was this reply helpful? Yes No
Mirza Mujib Ur Rahm... 1,443 on at

Like (0)

Report

Hi Steven,

Can u please tell me what u mean by "So make sure you do not have physical negative inventory".

Thanks,

Was this reply helpful? Yes No