hpCommerce Release
Notes
Build 563 à July 20, 2007
[+] New fields that
support the Remote POS (RPOS) and e-Commerce integration has
been added to the tables. These effect
large tables and could take some time to process the first time hpCommerce
starts.
[+] Setup.ADT now has a DBVersion field.
This field is automatically created by hpCommerce if it doesn’t
exist. This field stores the table
schema version. The version of the
current schema is 563. This is the
initial number that we will use but this number will not necessarily change
with the hpCommerce build number. hpCommerce will check this number to determine if it needs
to check the tables and update fields.
[+] A message will appear
when hpCommerce starts if database updates need to be processed. This message instructs the user to wait until
the complete message appears. Once
database updates are complete, a message appears to let the user know it is
okay for users to start hpCommerce on their workstations. This message will only appear if database
updates are needed because of a new build.
This is triggered by the DBVersion field in
the setup table.
[+] hpCommerce will now
stop and ask the user to setup a workstation if X-Charge is active in
hpCommerce but the X-Charge DLLs are not registered on the workstation. If the user agrees to setup X-Charge,
hpCommerce will look for SetupDLL.exe and execute it. It will wait for SetupDLL
to finish and then it will attempt to re-register the X-Charge DLL. If SetupDLL.exe is not found in the
hpCommerce program directory, an error message will be displayed and hpCommerce
will terminate. This prevents failed
X-Charge payments on new stations due to the X-Charge DLLs.
[+] A Dropship
Fee can now be defined in the UPS module (M-O-Z-D) that can be applied to a
sales order. It is also possible to
remove the dropship fee from an open order as
well. If the user chooses any type of “Dropship” in the reference field on the sales order header
(page 1), the system will prompt the user if they want to apply a dropship fee. It is
also possible to add and remove the dropship fee
using the F3 key on the sales order header.
[-] When a multi-package
shipment prints more than one label, a label was skipped and the second label
printed incorrectly. This was caused by
the new ReportBuilder 10.x upgrade. This has been duplicated and corrected.
[*] The HP import
routines have been enhanced to handle double quotes in part descriptions. The import routines would add an additional
double quote mark every time the data was imported before this enhancement. The routines were also tested with the single
quote mark which is sometimes used to represent feet.
[+] hpCommerce will
automatically add the new fields that are required for this build.
Build 562
[+] X-Charge credit card processing has been
enhanced to support a name on card, address on card, zip on card, and bank
phone number. Fields have been added to
the customer tables, SO table, and Invoice table to support these new
fields. This allows a credit card to get
the best rate even when the card information is not the same as the customer’s
billing information in HP Commerce.
[+] The new “Credit Hold”
report is now available (M-L-F4-PgDn-PgDn-F1).
This report shows all customer accounts that are currently on credit
hold.
[+] The Gross Sales by
PLC report (M-L-F1-PgDn-F3) has been optimized to generate over 10 times
faster.
[+] A new report that
allows all payment made using the pay type “Other” to
be reported. (M-L-F4-PgDn-PgDn-F2)
[-] When comparing
conversion sales vs. conversion usage, there was a discrepancy caused by an
incorrect SQL statement. This only
affected line type “X” and the fix is retroactive.
[+] It is now possible to
generate mailing labels by customer terms (M-I-C-T). This allows labels to be generated for any
specific terms code.
Build 561
[*] Tech: This was an internal build.
Build 560
à March 26, 2007
[-] Tech: Due to the upgrade from RB 9.03 to
RB10.05, the ppVariable to count kits on the sales
order and invoice reports was not firing properly. Specifying the variable type as integer
solved the problem as it was defaulting to string even thought the variable
result was not used.
Build 559
à March 25, 2007
[+] A new end-user report writer has been
installed. The new version is more
powerful and has a new interface.
[-] A bug in the display of costs in grids that
were over 1,000 caused them to display as 0.000. This was only a display problem and the
problem is retroactively corrected.
[-] A bug was found when deleting a sales order
that had a deposit on the order. The
deposit would be moved to unused credits (deposit on account) but the A/R
history didn’t get a void entry for the sales order. While this is not required for sales orders
without deposits, it is required by the running balance routines. When the customer balance was recalculated in
the future, this would cause the credit to corrupt the customer’s balance
information.
[+] A new report is available that will show the
receiving history of a purchase order when it has multiple receiving sessions
against it. This report (M-S-P-C) will
show the qty each time a part is received on a specific
[-] When in the PLC
maintenance module (L-B) the system default markups would reset the existing
markups on the PLC if the user pressed F2 to edit the PLC and used the enter
key or the tab key to move from the PLC name to the first markup field. This has been duplicated and corrected.
[+] The void report M-L-F4-PgDn-F6 has been
reworked and now shows the invoice number that was voided along with the
customer
[*] The CPU speed
mechanism has been changed to a normalized function that is aware of power
saving modes. This will prevent
inaccurate CPU speed readings on laptops. (cxCPU40)
[-*] When receiving inventory items using L-R, the
packing slip method was not recording the cost of the item in the receiving
history. This has been corrected. Further, the cost used for packing slips is
the true cost of the item. The last cost
field on the L-L screen is now maintained during packing slip receiving.
[-] On some preset kits, a small rounding error
could be introduced when the sales order was saved to the tables. This has been duplicated and corrected.
March 2,
2007 à Build 558
[-] The kit total line
was not displaying on sales orders and invoices when certain conditions were
met. This has been duplicated and
corrected. The option that allows kit
detail lines to be suppressed was also tested.
February 16, 2007 à Build
557
[*] Updated
toolkits and source code optimization.
[-] The UPS
dimensional weight calculator was using the wrong dimensional weight
factor. This has been corrected and
tested.
February 8, 2007 à Build
556
[+] New fast
optimized exe compressor. The new
compressor load faster and prevents the occasional problem where the splash
screen appears several minutes after the exe is “double-clicked.” The problem only appeared on certain systems
and was caused by the old exe compressor program.
[-] The full
text search was only considering the long description field. This has been corrected to consider both the
item description and the long description when performing a full text search.
February 2, 2007 à Build
555
[+] Source
code optimizations
January
26, 2007 à Build 554
[+] When adding lines to
an order in order entry, margin can be displayed with costs by using F8.
[+] It is now possible to
pick a customer for the “Ship To” address on the purchase order. When creating a new purchase order, the F1
key will display if you wish to pick a customer for the shipping address of the
entire po.
[+] When in the Inventory
Item Maintenance screen ( L – L ) it is now possible
to display a list of open purchase orders that have this item listed. It is also possible to display or print the
open purchase orders from the list. The
complete path is L-L-F9-F7.
[*] The Price Guide Pro
Import has been enhanced to allow base cost to be set to dealer cost, jobber,
or not changed at all.
[*] UPS
Letter shipments are now working properly.
January
12, 2007 à Build 552
[*] The password
requirement for setupxxx.exe has been removed.
This will allow hpCommerce users to update themselves easily when the
website download page is updated.
[*] The hpCommerce price
file import function has been changed so that when an existing item is found
and the “Force Price Calculation” is set to “Y”, the markups on the item will
now be used rather than the markups on the PLC.
[+] The warning message
the another copy of hpCommerce is running has been removed.
[+] The UPS freight
calculations now support the UPS 2007 changes including rates, zones, routing
codes, and accessorials. The new rules for large packages and ground
dimensional weight are fully supported.
The new rate updates are available via our website at http://www.hp-commerce.com/download/hpups.exe
Please note that after
installing the ups rate update you must choose M-O-Z-R in hpCommerce to read
the updated rate files.
[*] All UPS Rates, Zones,
and UPS utilities have been moved from the utility module (M-N) to the UPS
Manifest module (M-O-Z). The rate and
zone update programs are improved for ease of use.
[+] The advanced item
search (F2) now has a full text search option (F6) that allows users to perform
very fast searches of free format text data. Full text searches (also known as
content searches) use intuitive search conditions consisting of words and
phrases optionally combined with logical operators (AND, OR, NOT, NEAR) to
search the inventory item description and the long description
[+] In L-L, when a PLC is given, F2
respect the line code and only use the advanced search features within the
given line code. If the line code is not
given, the advanced search will search across all line codes.
[-]
The MotorState on-line stock check had a
typographical error in the dialog. The
word “interesting” was changed to “interested”.
[*]
Open orders (F3) in the order entry module now default to listing in
alphabetical order like they did in the past.
This listing can be changed to “SO Date” order via serial number for
manufacturing customers if they desire.
December 10th, 2006 à Build
547 – Release to Manufacturing (RTM)
[+]
The MotorState on-line stock check ability has been
enhanced to handle unexpected error messages from
[*]
When a plc or part number was not found when checking the
[+] The MotorState
on-line stock check ability has been added to “Stock Check” screens, the
Inventory listing (L-J), and during Order Entry.
[+]
The MotorState on-line stock check ability has been
added. It is now possible to call up a
part in inventory and check if MotorState has the
item in stock. The path is L-L-F3-F10.
[*]
When an RMA is created, the history will be displayed and allow you to choose
the item, qty, and price of the actual item.
The cursor will default to qty field.
Double click or Enter selects the item to return from history.
[+]
Price change history is tracked in a separate table when items are edited
storing the old and new prices and create a report by date range.
[+]
[+] Pueto Rico shipping through manifest
[*]
Prompt for CC when terms are prepaid on SO
[+]
In order entry, create a new F4 button that allows the user to pick an order
type without having to proceed to the order type field.
[+]
An RMA can be turned into a Credit Invoice
[+*]
New Packing Slip
[+]
The UPS calculator and the UPS Electronic Manifesting system now support
[+]
The UPS Zone import function has been enhanced to read more data from the ups
zone files. Users should reimport their zone table via M-N-4 to take advantage of
the new capability.
[*]
If integrated credit card processing is not being used by the customer, the
signature information is removed from the invoice. This applies to both US and Canadian
versions.
[+]
The disclaimer message at the bottom on the
[+]
It is now possible to import price updates from Rebuilder’s Data Service. If you are an RDS customer, they now support
hpCommerce as a possible file format. If
is found in M-N-R.
[+]
The ability to electronically check stock levels and cost for VSI Performance
Warehouse is complete. As long as the
customers dealer number is entered on a vendor called VSI, AND VSI has
authorized the customer to use this feature, it is possible to get an immediate
online status of any part that VSI supplies.
[+]
It is now possible to replace the Job # field on the printed invoice with the email
address on the customer master file.
This allows the address to print for shipping purposes. This is only available for the
[+]
An optimized memory manager has been added to the software to boost
performance.
[*]
When displaying sales history for a part during order entry, the history will
now be listed with the most recent sales at the top (first). This provides the most recent sale price at
the top of the list.
[*]
Default labor code modified from LAB to a custom value for Southern Racing
Supplies.
[*]
Default labor code modified from LAB to a custom value for Automotive
Specialists in NC
[*]
When a credit card number is entered or on-file for a customer, the number will
be stripped of any non-number digit before being given to X-Charge. This prevents invalid credit card messages
due to the punctuation that may be embedded in the card number by the user.
[+]
prompt for manager password when price changed during order entry.
Setup
Table:
Change
PromptMgrPriceChange to True
Make
sure use passwords is yes and a manager password is
defined in hpCommerce setup screen and you are set.
Only
changing the price for Kits, Conversions, Parts and Labor will trigger the
password logic since some line types require a price from the user.
The
admin password will also work in place of the manager password since admin has
all rights.
[*]
When passing the server connection type on the command line, the case no longer
matters. Before this build, passing the
connection type of remote, local, or AIS had to be uppercase. This has been changed for ease of use.
[*]
The Cash Receipts Journal Report will no longer display fully credit card
numbers.
[*]
When receiving inventory using L-R, the qty on order will no longer
decrease. This has been changed because
only the P.O. increases the qty on order and receiving the P.O. is the only
function that should decrease the qty on order.
[*]
The credit card expiration data has been removed from the deposit receipt and
regular payment receipt.
[*]
If a payment is made in A/R using X-Charge to process a credit card and the
payment is cancelled after processing but before applying the amount to open
invoice (‘C – Cancel this Payment Entry’), a message will display reminding the
user to void this payment in the x-charge software.
[*]
When processing an invoice for a PREPAID customer and payment cannot be given,
the message now reads: DO
NOT SHIP! Terms were PREPAID and no
payment was made. This invoice and any
packages have been voided and the sales order has been reopened.
[*]
When a credit card is added to a sales order, invoice, or any other printed
document, the card expiration date is no longer displayed. This is not retroactive but it was requested
by the credit card companies.
[+]
When entering an order, the reference information field in the order head will
now display a quick menu of common reference items. It is still possible to type any reference
information that the user desired but the quick menu offers some options for
typical orders. The options are Custom, Dropship, Promotional, Credit, and Custom Dropship.
[+]
Future Orders are now available. These
are a special type of order that is scheduled to happen in the Future. It can also be used for quoting a very likely
order. Future orders are a type of sales
order that does NOT commit inventory. It
also does not get added into sales statistics or any regular sales order
report. Future orders CAN be turned into
a sales order which will commit the inventory that the order contains. (M-G-C). It is possible to list all open future orders
during order entry (M-G-F or A-F8).
There is also a report to list all open future orders in the system. (M-L-F5-F9). Future
Orders can be continually edited or deleted and are used as a tool for
inventory requirements planning. The
Date of the F.O. is used to indicate when the F.O. was created and the Due Date
indicates when the inventory is needed for the order. Future orders are created by starting a
standard order via Order Entry and setting the order type to FUTURE ORDER (F5)
on the order header page.
[+]
A credit card can now be specified for a sales order at order entry. This card will automatically be used when the
sales order is invoiced so the shipping department need not re-enter the card
number or information. This works with
both manual and integrated credit card processing. Please note that if the customer has existing
credits, it is recommended that they be placed on the sales order as a deposit
on order so they will be used before the card is charged.
[+]
If a credit card is specified on the sales order in order entry and the
customer does not have a card on file, the user will be prompted if they want
to save the card to the customer master for future use. This allows the customer master to record
card numbers during the order process.
[*+] The invoicing processing (F2 in order entry)
has been streamlined so that any sales order that is defined as “PREPAID” will not generate a
final invoice without payment. If
payment cannot be given at the time of Invoice, the invoice will automatically
void, any packages on the invoice will void, and the original sales order will
reopen.
[*]
When duplicating parts in the inventory module, the new part would have the
date of 12/30/1899. This is a date value
of zero meaning no date. This has been
changed to set the date to “null” which will display as a blank date.
[*]
When ADDING a new customer you will now be prompted for the card #, expiration,
then the CVV instead of the old order of card #, CVV, then expiration.
[+]
Credit card returns using the integrated credit card processing option has been
tested and certified and is ready for use.
[+]
When applying payments in A/R, the automatic distribution of payments can be
turned off so that
payments are properly matched to open invoices.
This is helpful when customers pay for specific invoices with their
payment. This is controllable by serial
number.
[+]
Zip codes for the
[+]
UPS routing codes have been updated from 33.0A to 54.0A (2004 to 2006).
[*]
When changing terms on a sales order to “more restrictive”
terms, old terms such as “COD” rather than “C.O.D.” are recognized.
[*]
When adding or editing a customer in customer management, the field “Bill UPS”
now precedes the field requesting the customer’s UPS shipper number.
[+]
When performing an advanced search in customer management (G-F2-F8), it is now
possible to search by area code. The search will search phone1 and phone1 on
the customer account in case the main number is a toll-free number. This search will look at the number of digits
that the user provides so three digit searches are not necessarily required.
[+]
When performing an advanced search in customer management (G-F2-F9), it is now
possible to search by country.
[+]
When performing an advanced search in customer management (G-F2), the F10 key
will allow the list of customers to be sorted by current year-to-date sales or
alphabetically.
[+]
In Order Entry when a shipping address is specified, the system is designed to
ask the user if the new alternate address should be saved. This can now be turned off by serial
number. The flag is called PromptToSaveAlternateAddress.
[*]
When a statement for a customer that has no open invoices, the statement will
now print and show the activity in the period of the statement. The old procedure displayed a blank page
because the account didn’t have any open invoices.
[+]
The XCPurchase function of XCharge
is implemented and alpha tested throughout the system. This allows hpCommerce to process credit card
charges anywhere a credit card can be used.
[+]
The US and Canadian invoice footers have been modified for credit card
signature lines and a standard merchant agreement statement. The payment receipt has also been modified
with a signature line and standard agreement.
[*]
If the item has a max defined and the qty on hand is over the max level, it
will instruct them to pull from the overstock location, otherwise the normal
location is printed on the Pick sheet or SO.
If the overstock location is blank, it will now use the normal
location. This is more helpful to the
person pulling the parts.
[*]
Kits now default to “PRESET” rather than “CALCULATE” for the calculation method
for new kits. This can be controlled by
serial number and does NOT apply for Coast Fabrication and Ferrea
Racing.
[*]
The logon / Sign-on screen has been made brand-aware. It will now display hpCommerce titles.
[*]
When entering a credit card to an existing customer in the customer management
module, you will now be prompted for the card #, expiration, then the CVV
instead of the old order of card #, CVV, then expiration. (Thanks Kevin)
[*]
The XCharge fields are now being read from the
setup.adt table to determine if the system is to use integrated credit card
processing. These fields are only
available via the SQL console or Data Architect.
The
VSI Performance warehouse import is now available. (M-N-V). All logos for imports have been updated.
During
the HP and VSI import, any item that is skipped because EPS was set to NO will
now be documented in the log.
During
the HP and VSI import, any invalid price level values will be documented in the
log file. It will not prevent the good
values from being saved but it will log the anomaly
Multiple
choice kits are now supported. A new
line type allows these items to be added to kits to prompt the user which part
to use when the kit is placed on a sales order.
PRESET
(non-calculated) kits are now supported.
Kit
pricing can be changes during POS and it will be respected for non-calculated
kits.
Calculated
kits will automatically calculate in when the kit is saved in the kit
module. Customer specific pricing will
be used if it is better than the calculated kit price during POS.
When
posting additional deposits to an open sales order (or layaway) the subsequent
receipts will now be dated with the current date instead of the date of the
original sales order.
Comments
in kits will now post into the sales order when a kit is added to the order.