MS SQL KBA for Evolution

Our Logo

Switch off negative inventory quantities in Pastel Evolution

When you want to deselect the "Allow Negative Inventory Quantities" on Inventory Defaults and the following standard message appears "Some inventory items currently have negative quantity. Please ensure that there are no items in negative in the master file and all warehouses before disallowing negative quantities."

It should then be obvious to check all the items' Quantities on Hand to ensure there are no negative stock quantities. However, the following scenario could make it a bit complex to detect where the source of the problem is:

A warehouse item A has -10 (negative) units in Warehouse XXX and 20 units in Warehouse YYY. It's net result would then be 10 (positive) units when viewing the Item Grid under the Quantity on Hand column and if you have hundreds of items and are not specifically sure which items might have negative stock quantities in any warehouse, the Item Grid Quantity On Hand column values will not help at all.

This will result that unselecting the "Allow Negative Inventory Quantities" will not be possible.

To correct this, do the following:
1. Open SQLEditor or SQL Server Management Studio, then type and run "select * from whsestk"
2. Sort the table according to the WHQtyOnHand field to see any negative quantities in any warehouses
3. Find the correlating WHStockLink values for those negative quantity records.
4. Do a query on the STKITEM table ("select * from stkitem")
5. Sort the table according to StockLink field
6. Identify the relevant StockLink values (the same as the WHStockLink values) and find the correlating field values on the Code and Description columns
7. Within Evolution it would now be easy to identify the relevant Items which have neg. warehouse quantities within Inventory Enquiries to determine the exact warehouses involved, and then process the required stock adjustment transactions for those items per relevant warehouses.
8. After all required processing is done and no negative quantities exist, the "Allow Negative Inventory Quantities" option could be successfully deselected.

If you are still not sure how to do this, do not hesitate to call us for Pastel Evolution Support

No Obligation Chat!

"Software4Business customised our Sage Evolution system, giving us full ERP functionality and complete control of every aspect" - NA Glass Pty Ltd.

We Are Here To Help


We know that you do not always have time to do your own work as well as Sage Evolution configuration, training and troubleshooting. Evolution might be user-friendly but being an administrator takes a bit more than what meets the eye. We know, and we dedicated thousands of hours learning the ins-and-outs. We know the front-end, back-end, programming code and triggers inside out. We can help you, that is what we are here for.

Strategic Reporting

We know you want to see income statements, balance sheets, make sure the TB balance and keep an eye on those ageings totals, but what if you need something more. Something like KPIs for your warehouse staff, or a monthly sales report that gives you budgets per customer and GL account. What if you want to segment your reps and products. How do you do that? We use our "secret" weapons combined with Excel-based reporting. Impossible becomes strategic.

Years Of Experience


With over 40+ years combined IT experience and 30 years with Sage, you can be sure to get the right solution, with the right answers and years of "know-how". Our experience shows in the lists of prestigious customers we have helped over the years. We can also help you. Martin Luther King, Jr. said that knowledge gives man power; We are adding this "without experience you have little control"

Ready When You Are


We would love to meet you and see how our solutions can help you "take back control". A meeting, demonstration or support with any of our highly skilled Sage Evolution consultants can be arranged.

 

 

Click here when you are ready!