What does the InvntSttus field in the Sales Order Rows table mean?

[Former Member]

Hello,

I have a Sales Order with 8 lines in it. I was trying to bring the last line up in the Pick and Pack Manager to create a Pick List for it so we could ship it. For some reason though, it didn't show up (even though it is open in the SO and my criteria in the Pick and Pack Manager is set to show everything). I checked around and about the only thing I could find that was weird about it (this was done by comparing the line that wouldn't show up with one that had shipped from the same Sales Order) was that the line that wouldn't show up has a "C" in the Warehouse Status (InvntSttus) field. I noticed that all of the lines on that Sales Order that had already shipped had a "C" in this field as well.

We have since fixed the problem by deleting that row and creating a new one that looks exactly like it. I still want to try and figure out what happened here so that we can avoid it in the future. I guess what I'm asking is if anyone knows what this field does and how it is governed, and also why this may have happened to this row.

Thanks in advance to whoever can shed some light on this,

Brent McDonell

[Former Member · Accepted solution]

Is it the only Sales Order with the problem or any others have the problems too? If only for this one, it will be very hard to find the reason. You may need to play with test environment to see if you can reproduce the problem.

[Former Member · Accepted solution]

Hi Gordon,

This is the only one I know about as of right now. We ended up fixing it back when this happened by deleting that row and re-creating it. If you don't know what it is that is causing this that's fine. I'm kind of thinking this was just a fluke of some sort. Anyways, thank you for your help.

Brent

[Former Member]

Unfortunately, there is not possible by any transactions to change 'C' to 'O'. Once closed, it is not reversible anymore.

As for the reason how that 'C' assigned in the first place, only you may find it out.

Thanks,

Gordon

[Former Member]

Hi Gordon,

I'm sorry it took me so long to respond to your post. Anyways, I just really want to know why that row has an inventory status of closed (InvntSttus='c') when the whole row is still open (lineStatus='o') . What could possibly cause the Inventory Status of the item on that line to get set to closed? I don't know of anything specifically that we would be doing that would set that to closed with the whole line still open (mainly because I don't even know what this field is for).

Please let me know if you have any more light to shed on this. It just perplexes me.

Thanks again for any info you can give me,

Brent

[Former Member]

But is there a reason that this field could contain a "C" and the regular status (LineStatus) be "O"? This is what happened. Do you know what kind of transaction would result in the line itself being open but the Warehouse Status being closed?

This just doesn't make a whole lot of sense to me.

Thanks for your help,

Brent

[Former Member]

InvntSttus field (Whse Status) accept two values: 'O' for Open and 'C' for Close. I don't think system would automatically close that line. It must be closed associated with some other transactions or manually.

Thanks,

Gordon