Further stock control problem in V9 when adding to orders

[CMB01]

We have found another issue with the way Actinic is handling stock control on orders, when they have a item added after they were originally raised.

If for example we manually raise an order for 10 of an item, where we have 10 in stock, the stock goes down to zero which is correct.

If we then go and add a new item to that same order after it has been raised, it re-allocates a further 10 of the original item, thus taking the stock level to -10.

This is creating us a lot of problems, as we then have to go in and add stock back to the items that are affected. It is also causing certain lines to go into suspend when we actually have free stock available.

[TraceyHand]

actually, I think this has been a problem in V8 also as I'm sure I recall it being mentioned before.
When doing an offline order, Actinic, while telling you how many are in stock, will still allow you to over-order.

[Mike Hughes]

I don't remember seeing this one before though. Malcolm seems to be saying that by changing the order qty actinic goes and subtracts the total qty again from stock rather just adjusting the stock for the difference.

I do all my stock adjusting externally in excel, but I do try and follow these threads for anything that might throw my numbers out.

Mike

[TraceyHand]

ok, you're right, Mike. I mis-read the post slightly in the middle.

I hadn't picked up on the fact that 'add a new item' had meant a completely different item.

However, I think this is perhaps something to do with the bug in the stock handling between the PSP pending and the Pending tab, perhaps?

Basically, it's all messed up!

I assume you're using 9.0.1, Malcolm and not the beta of 9.0.2 (which, assuming the stock control has been successfully fixed in it *could* give a different result?)

[CMB01]

Tracey,

Yes Mike is right, it is when we add an item to an existing order. i.e. a customer rings us up and asks to add an item to an existing order.

Anything on the original order will then have the stock adjusted down again.

We know about the PSP pending issue, we discovered that over the first weekend of using V9 where it threw our stock levels out on the website.

Fortunately we do run a second stock database independently of Actinic, which we cross reference, but Actinic is now showing a fair amount of items with incorrect stock levels.

It is now at 9.01 (we upgraded when 9.0 was just released) and ever since then we have regretted making the move from 8.52.

[TraceyHand]

It is now at 9.01 (we upgraded when 9.0 was just released) and ever since then we have regretted making the move from 8.52.

I can very well imagine!
I'll have a play with my 9.0.1 test site and see if I can get the same thing to happen.

The original order is an offline created one too, is that right?
Then an additional (different) item added again offline?
Does it do the same with online orders that subsequently have additional items added offline?

What payment method is being used for the orders? (just trying to guage if it's dropping into the PSP payment pending folder at any time) and is the payment method being changed at any point during the process (when you add the additional item, for example)

Do you have "Allocate stock for psp pending orders" (Settings > Business settings > Options) checked or unchecked?

[CMB01]

Tracey,

You are correct in that we raise an order offline, then at a later stage if we add another product, it will again deduct stock from the original item ordered.

From what I can see it seems to affect the orders we have raised offline manually as opposed to the ones which are downloaded. I have just modified an online order where the customer added some items and the stock level on the original item ordered has stayed the same.

The payment method we are using for offline orders is "credit card details sent separately". The online orders come through with "Secure Hosting (UPG)" as their payment method.

We have the "allocate stock for PSP Pending orders" checked, as it was causing chaos when we left it unchecked, after the upgrade from 8.52. Basically any PSP pending order we receive, we now mark it as deleted in order to keep the stock levels correct. We have also unchecked the auto delete PSP pending orders for the time being.

Malcolm

[TraceyHand]

Well, that was easily replicated!
I have the 'Allocate stock for PSP pending orders' UNchecked and it did exactly the same thing, reducing the original item a second time when additional items were added.

As an aside, I also must add that I initially (mistakenly) put through an offline order using Paypal as the method, it dropped into PSP pending without affecting the stock (as it should, as I have it set not to)
However, when I changed the payment method to 'Credit card details sent separately' thus moving it to the Pending tab, it DIDN'T deplete the stock as it should have.

Actinic...your V9 stock control is shot to pieces.

I might download the beta of 9.0.2 tomorrow (faster connection at the office) and see if that's any better.

[george]

We've had three instances of `wrong levels` lately that has puzzled me. Never really thought that it could be the software (8.5.2). I'll see if I can investigate if I have time what/when/why and report back if I find anything.

If its a fault this needs to be fixed asap as people need to trust the stock levels on their websites.

[TraceyHand]

We've had three instances of `wrong levels` lately that has puzzled me. Never really thought that it could be the software (8.5.2). I'll see if I can investigate if I have time what/when/why and report back if I find anything.

If its a fault this needs to be fixed asap as people need to trust the stock levels on their websites.

Are you using/monitoring the stock levels in the PSP pending tab, G?
Is your 'Allocate stock for PSP pending orders' box checked? (Settings > Business Settings > Options) and, if so, do the orders (if any) in this tab have any bearing on your stock mismatches?

Just a thought anyway

[george]

Aye. Yes. Dunno yet.

swtoc

[TraceyHand]

swtoc

you made that up!

come on..enlighten me!

[george]

Just discovered about six items that are sitting at a stock level of -1.

None of these items are sitting on a pending order, and we have nothing to suggest that we've `oversold` in the recent past.

A mystery of course, but we NEED to trust our stock levels.

[TraceyHand]

Just discovered about six items that are sitting at a stock level of -1.

None of these items are sitting on a pending order, and we have nothing to suggest that we've `oversold` in the recent past.

A mystery of course, but we NEED to trust our stock levels.

are they items you've ever (since last checking levels) created offline orders for, G?
I have huge problems with stock levels and offline orders, where it's decrementing items by 2 instead of 1...worryingly consistently.
could be a cause?

[george]

No, not connected to offline orders as far as I can see. Could well be that `double amounts` are being allocated though... somewhere along the line. You noticed that its 8.5.2 I'm using I hope.

Another reason why I'm losing interest in Actinic by the nanosecond.