Sales History Transaction Processing Loc/Item List Stuck
Release Date: 10/12/2020
Version: 7.5 & Up
Q - One of the reports I run from time to time is COP -> Processing -> Sales History Trx. Processing -> Report -> Loc/Item List. It used to work. Starting recently, for no apparent reason, it always gets hung up when we try to run it. We know there has been no software update recently, So why would this happen?
A - It might be related to NTFS security. To confirm, browse to your <ElliottRoot>\DATA (or whatever corresponding company DATA_99) folder. Look for CP3HS???.BTR where ??? may have a value of 001-999. See sample below:
If you have 999 of them, that means every file name from CP3HS001.BTR - CP3HS999.BTR exists, and you may experience this problem. The solution is to simply delete all the CP3HS???.BTR files from your corresponding data folder.
This is a side effect of implementing NTFS security. See the following KB article on how to secure your Elliott folders with NTFS:
If you went through the procedure in the above KB article, then your user has minimum rights to your DATA folder. The Sales History Loc/Item List program will ask the PSQL engine to create a CP3HS???.BTR file as a work file starting with ???=001. It will not override the existing CP3HS???.BTR file. After the report is done, it will attempt to delete the corresponding CP3HS???.BTR file. What happens is the CP3HS???.BTR file is created by the PSQL engine which is running under admin rights. The deletion of the CP3HS???.BTR file is from the user's OS security which has minimum rights and thus is not able to make the deletion.
As a result, you started to have CP3HS001.BTR, 002, 003...etc. files created each time your users run this report. When it reached 999, the system was not able to continue running this report. The solution is to simply delete these files from the Admin user. Please be careful not to delete other files yourself in the DATA folder for you may lose data.
Another similar example is COP -> Processing -> Sales History Trx. Processing -> Report -> Cust/Invoice-List. The corresponding work files the system creates are CP2HS???.BTR files.
EMK
Related Articles
CP0501 Customer Order Processing Sales History Trx Processing
Sales History Trx Processing Application Overview The Sales History Trx Processing is a standard transaction entry module allowing add, change and delete/inquire functions, as well as an edit list print‑out to verify that the transactions entered are ...CP0503 Customer Order Processing Sales History Reports
Reports Sales History Reports Application Overview There are six Sales History Reports. They are the Sales Comparison by Customer; Sales Comparison by Customer and Product; Sales Comparison by Product and Customer; Sales Comparison by Product ...CP0502 Customer Order Processing Post/Purge Sales History Trx
Post/Purge Sales History Trx Application Overview By the end of the current accounting period, you can optionally transfer all the sales transactions from the Sales History Transaction file into the Sales History file. Sales History file is the basis ...BM1800 Bill of Material Production Transaction Processing
BM1800 Bill of Material Production Transaction Processing ← Bill of Material / Work Order Plus Production Transaction Processing Application Overview The Production Transaction Processing application allows for reporting progress made toward ...CP0500 Customer Order Processing Sales History Processing
Sales History Processing Application Overview Period End Procedure After you have finished posting the month's sales history data from the Sales History Transaction file into the Sales History file using Post/Purge Sales History Trx application and ...