TCP Stock Add / Edit Screen Slow (DB51)

TCP Stock Add / Edit Screen Slow (DB51)


Performance issues in stock add/edit screens after TCP 2.09.7026 (DB51)


Issue:

When going into a stock screen such as a stocktake or delivery, the initial load of the screen takes longer than previously experienced on other versions.


Fix:

In the last version of TCP there has been a fix done to the option “Use product ‘To Date’ field” (found under Stock Add/Edit Screen). This is set to ‘False’ by default. It then forces a query to be calculated for sales data on the fly when the stock screen is loaded, even on small product systems (1000 products) there is a noticeable delay. Setting this option to ‘True’ means the system will take advantage of the option “To Date Field To Display” which can be customised to use various pre-set ranges specified on "Product to Date maintenance". This means you can change the default depending on how far you want the sales data to go back. The default is the "Last 4 Weeks".


*Please note if you don’t have product to date fields enabled, you will need to configure these, this is done through an applet generally under the menu heading Setup, the applet is called “Product to Date Maintenance”. You can enable all of these and we would recommend making the run frequency synchronise in accordance to how quickly you want to see an update on the field so you might want the last 7 days to run every 4 hours for example*





    • Related Articles

    • Stock Functions: Returns (How to Use)

      Introduction to Returns The Returns section of Total Control Premier allows you to record returns made to your suppliers. When a Return is Committed, the stock levels of the Products being returned decrease, according to the number of packs and/or ...

    • Stock Functionality

      Stock The stock level of a product is recorded and tracked in Total Control Premier over a stock period, through several key events. A stock period is a period of time used to track stock levels, starting with the Opening Stock level and finishing ...

    • Stock Transactions via GPOS

      Stock Transactions via GPOS Stock transactions such as; deliveries, orders, returns etc. Can be processed through the GPOS terminal. The requirements are GPOS 159 and later, so that site information can be sent to the tills. Inside Total Control ...

    • Importing a Stock Transaction with CSV (How to Use)

      How to go about importing a Stock transaction file into Total Control Premier When creating a .csv file you need to make sure you have formatted the Barcode column to make sure no blank spaces or character symbols. If you can format the cell to make ...

    • Stock Historical (How to Use)

      Introduction to Stock Historical The “stock historical” applet will allow the user to select a date and time and produce an on-screen report to show what the stock levels were at that time. The applet can be found under Analysis and select ‘Stock ...