Includes database changes you need to log all terminals out during upgrade

This version fixes/ finalizes F2 lookup changes made a couple of weeks ago. Current version of F2 is now very quick when looking at all parts, but when you look at stocked items only it is slow, significantly slower than prior versions of c9.  This version fixes this.

One of the new things F2 changes try to do is treat old superceded parts as though they are the real parts. So you can optionally easily find things by old numbers or new numbers, or barcodes or custom numbers. When you look at a old part you should also show actual price and qty on hand for the part it eventually supercedes to.

Consider part, 502 08 410 000. 5 other parts supercede to it. In F2 screen  we want to show all these but also show the qty and price on final part at end of the supercession chain so you can quickly eyeball your effective inventory without having to pick the part going to next screen. The results also need to be sorted in part number order, without regard for what part number is for eventual part it supers to.

Part	Description	SuperS	Price	QoH
491 08 410 000	% FRONT FENDER '87	502 08 410 000	48.9	N/C
500 08 010 000	00 FRONT FENDER	502 08 410 000	48.9	N/C
502 08 010 000	% FRONT FENDER '87	502 08 410 000	48.9	N/C
502 08 410 000	*FRONT FENDER WHITE '93		48.9	N/C
546 08 010 000	% FRONT FENDER 250 '90	502 08 410 000	48.9	N/C
565 08 010 000	% FRONT FENDER '86 BAJA	502 08 410 000	48.9	N/C

Now when in view stock only view ,the F2 screen still needs to look at supers parts but only those parts that eventually land on a stocked item. So as soon a terminal adds part 502 08 410 000 into stock not only this part but the 5+ parts that superceed to it also need to be visible in F2 screen when f2 screen is in stock only mode, interleaved with every other stocked item which also has supers pointing to it.

Part	Description	SuperS	Price	QoH
491 08 410 000	% FRONT FENDER '87	502 08 410 000	48.9	1
500 08 010 000	00 FRONT FENDER	502 08 410 000	48.9	1
502 08 010 000	% FRONT FENDER '87	502 08 410 000	48.9	1
502 08 410 000	*FRONT FENDER WHITE '93		48.9	1
546 08 010 000	% FRONT FENDER 250 '90	502 08 410 000	48.9	1
565 08 010 000	% FRONT FENDER '86 BAJA	502 08 410 000	48.9	1

 

Further when filtering results such on description if the filter matches an item which has alot of parts that super to it, then those old/customer/barcoded part numbers should be displayed too.

Advanced database indexing involved here needs to also cope with multiple terminals simultaneously doing things like add parts into stock and added new supercessions/installing price files etc. The end result needs to be consistent irrespective of the sub millisecond timing involved in what various terminals are doing.

All this should now be fixed in this version of c9.  With instantaneous scrolling and part number searching in F2 screen. Database queries generally should be around under 20 milliseconds or faster to refresh if c9's server is running on a decent computer.

Other changes

• Further f2 optimisations. Query hints optimisation  that was supposedto be in version 4.832 didn't actually make it into c9. This will improve performance further in some areas. For example if you key in '123' in F2 it is generally fast, but typing in 'XYZ' can be slow due to poor query planner optimisation in postgres.
• Part group filtering has been removed. This part of ongoing effort to deprecate grouping since it has been replaced with variations for web based part grouping. For dealers that relied on part grouping for additional filtering and have ignored warnings in c9 about this feature is about to disappear, contact barney directly : grouping data can be bulk merged into part attributes if needed to restore this facility.