Export Processor Does Not Find Record Due to Space in Item Number
Release: 7/2/2021
Version: 7.5 & Up
Q - I attempted to run the Exporter on the Sales History TRX looking for sales equal to 9835-GS KIT. It pulled back 0 sales. See sample screen below:
Knowing this to be not valid, I then ran the Exporter looking for anything connected to GT 9835-GS. It pulled up 30 thousand records with the 9835-GS KIT. Thinking I possibly had an extra space, I copied the item number from the CSV for the 9835-GS KIT and inserted the copied text back into the Exporter to rerun and look for items that equaled 9835-GS KIT. The system again reported 0 sales.
Why is this occurring?
A - On the second parameter:
Cphsttrx.hist_trx_item_no EQ 9835-GS KIT
Please change it to:
Cphsttrx.hist_trx_item_no EQ “9835-GS KIT”
When the item number contains a space, the system interprets the above expression to mean EQ “9835-GS” or “KIT.” Add a quote around the item number with the space to resolve this issue.
Also, in the following KB article, we discuss what special characters to avoid with item numbers. Spaces are allowed but should be avoided whenever possible:
Related Articles
Feature - Support 12 Months History in Export Processor
Release Date - 7/13/17 Note: This feature is only available in version 8.2 and above. The Export Processer now supports the 12 Month History Summary file for the following tables and values: Customers: Total sales for the customer by period Total ...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 ...Feature - A/P Simple Trx Processing
Release Date - 2/4/16 This new functionality has been added with the intention of allowing customers to import CSV files that are provided by credit card companies. This new application will allow the users to import the transactions into a temporary ...Feature - Equal Sign Support in Export Processor
Release Date - 1/5/18 When exporting Elliott's alphanumeric fields to CSV through the Export Processor, the leading zeroes will be dropped when the file is opened with Excel. For example, when opening the CSV in Excel, item number 0100 is displayed ...Feature - Handle Sales History Trx Edit List by Location/Item When CP3HS999 is Reached
Release Date: 10/24/2022 Version: 8.5 & Up It has been reported that COP -> Processing -> Sales History Trx Processing -> Report -> Loc/Item List may lock up if work file CP3HS999.BTR is reached. See sample screen: In Elliott, we delete this work ...