|
|
 |
|
UniItemInquiry (Plus/DOS) 6.5 speed issuesIn order to find items which are on sales order in ACCPAC Order Entry, it is necessary to ready the entire order line file to search for outstanding sales orders for the selected item. Logic prescribes that outstanding orders would be concentrated in the newest records on the system. In other words, the older an order, the less likely that it would contain outstanding item orders. To speed up the process of finding outstanding item orders in a large database, UniItemInquiry will first read the item master record (which contains the quantity on sales order) and then reverse reads the order file from the back (the newest/latest orders are read first). When the quantity on sales order exactly matches the quantity found in the order lines, the routine stops and displays the relevant item information. If the quantity on sales order per the order lines at any time exceeds the quantity per the item record, the routine stops and reports an integrity error. An error will also be reported if the system has read all lines and did not find the required quantity. Therefore, if there is an integrity problem between IC and OE, the inquiry function will read more data than normally required. This will slow down the inquiry significantly. If Order Entry does not use auto numbering for orders processed, and the document numbers are not assigned sequentially, the inquiry can no longer effectively use the above logic and the inquiry may be slower, depending on the time taken by the system to find all outstanding lines for an item. If the user selects to include standing and/or future orders, the inquiry function can no longer terminate the search when quantity on sales order has been found and the system will then read all open order lines. This will slow the inquiry down and should be avoided where possible. |
|
|
