Hi Wayne,

If the figures in the 'Item Status' window are not correct, you can have them recalculated. To do this, go to the Technics module and run the 'Recalculate Item Status' Maintenance function.
If a figure is still incorrect after running this function, change to the Database Maintenance module and enter the Item Number in the Log Item Status Updates setting. Then run the 'Recalculate Item Status' Maintenance function again and open the "hansa.log" file (the server's "hansa.log" file in a multi-user system). Each transaction that affects the Item Status will be listed, which may help you find the cause of the error.

I suggest you to first test on "Test system" and not Live!

Regards
Dejan

Okay figured out what happen with that maintenance routine. The system is set to auto-deliver plain and service items. No delivery exists so that routine seems to have put every order in the system as Outstanding order as it removed the counts on Flip D for all items that are auto-delivered.

Now all 7000+ orders are saying they are outstanding.

Going over each one manually and marking them delivered.

Going to take a life time.

GOOD NEWS - "Recalculate Item Status" this worked.


Thanks!!!

Going back to Sales Orders->Maintenance-> Recalculate Sales Quantities.

It seems to ignore flags.

So, Auto-deliver Plain and Service Items is set to on but the utility will not find deliveries for them and resets fully invoiced Sales Orders to having Del and Del Ok cleared on Flip D of the SO. Which wa auto-delivered.

Also found the if Credit Invoice Updates Invoiced Quantity (AR -> Settings) the utility will still update the Invoiced Quantity on the Sales Order putting that order back into Outstanding Order state.


Should this be reported as a bug?

The issue I see here is that as this customer using a plain item on every order that maintenance routine simply has the effect for marking every order in the system as being Outstanding as each plain item is marked as a 0 for Del and a 0 for Del Ok Should it not pay attention to the auto deliver flag and make sure the SO is not touched in that area or at worse update the SO to have plain and service items show as del and del ok?

Hi Wayne, can you please try importing this db in a Mac OS client test environment and let us know if you have the same issues?

Regards,
Omar

So this was something that seems like it could be the issue. I need to understand how the system is calculating the "Order" count if I am to convince the client that those settings could be the issue. My concern is that the system shows


inventory 0; Order -1; P. Order 0; Shippable 1

When you click on Order you get a blank report.

How is this being calculate so that I can go into the system and do the manual calculation to demonstrate the to client issues as being seen.

Thanks in advance,

Wayne

Hi Wayne,

Can you please specify the system path to exactly where you unticked the setting?

There are a number of settings related to Returned goods

In Inventory Module >> Settings >> Returned Goods Settings
you have options to reduce
- Delivered Qty
- Ordered and Delivered Qty
and the option to allow returned goods not linked to orders


In Purchase Order settings there is also an option to not Allow Returned goods from Orders

We will better assist you with this info thanks!


Regards,
Omar

Hi Wayne, thanks for the information, we will look into the portal notifications.

- If over-delivery is ticked and you deliver more than you have in stock, the system logically does not know what the extra items are worth

- If the customer returns those items, then again the system has no idea of their worth

- However, the system should at least pay attention to items if they are not in negative stock.

This is why the maintenance routine worked when you un-ticked that setting.

I hope that this explanation of the system logic helps :)

We will do further investigation on possibly making enhancements to this in the future and will let you know of any improvements

Best,
Omar