About CCSI
Contact Us
News & Events
Partnerships
Products & Services
Site Map

Registered Users

Return to Registered Users Main Page

Utilities

Customer

Open order information in the customer credit record
cm/calcopnord reads Customer Credit records, zeroes out open order amount, calculates net open order amount from the order header record and updates the Customer Credit record.

Customer credit information at end of a calendar year
cm/calcredcur moves credit information from the current year to the previous year fields in the Customer Credit record if your fiscal year-end is the end of the calendar year.

Customer credit information at times other than the end of the calendar year
cm/calcredprev calculates and moves credit information from the current year to the previous year fields in the Customer Credit record if your fiscal year-end is some time other than the end of the calendar year.

Year-end customer credit information
cm/yearend moves credit information from the current year to the previous year fields in the Customer Credit record, zeroes out YTD information in current fields.

Change bill-to cross-reference
cstconvert converts the bill-to cross-reference on ship-to records.  The Customer Conversion Entry on the Customer Master Processing Menu (run path 1, 7) must be run first to produce the file necessary to do the conversion.

Salesrep substitution
cm/slsmsub replaces the salesrep number on all customer records. Prompts for existing division, salesrep# and new division, salesrep#.

cm/slsmzip replaces the salesrep number on all customers with the zip code entered.  Prompts for existing division,salesrep#,zip code and new division, salesrep#, zip code.

cm/slsmstate replaces the salesrep number on all customers in the state entered. Prompts for division, salesrep#, state.

cm/slsmbillto replaces the salesrep number on all ship-to's for the bill-to that was entered. Prompts for bill-to, division, old salesrep, new salesrep.

Salesrep and account manager
util/chgcmdinput imports salesrep changes and account manager initials from an input file and updates customer/division records and optionally open orders. Click here for details.

EDI

EDI cross-reference file
util/calledixf clears out the edixref file.  It should be run monthly.  See EDI Cross-reference Purgefor details.

EDI Inventory Inquiry/Advice
util/ecomavail prompts for entry of minimum quantity and next available date which allows for the physical inventory period (enter 9999 minimum quantity & date inventory completed), then allows entry again to enter actual minimum quantity and 0 date to revert 846 back.


Order Processing
All zeroes pick tickets (000000000)
unzeropl completes the process of picking orders that have a picklist number of all zeroes.

List order lines with pick ticket equal to all zeroes
util/zeropllst lists order lines with the pick ticket number equal to all zeroes.

Update Customer Stock Cross-Reference from .csv file
util/opcrossref updates the Customer Stock Cross Reference File with trading partner SKUs using a csv file from an Excel spreadsheet and entering in the EDI Parent/Bill -to number.


Sales Analysis
Rebuild Sales Analysis Master
sajhirerol rebuilds the Sales Analysis Master File (data/samaster) from scratch.  This should be run if you've added a new division.


Style Master
Change style/color of UPCs
util/upccolor changes a UPC from an old style/color to a new style/color. 
The utility obsoletes smprepack records for the old style/color/sizes and adds smprepacks for the new style/color/sizes when the old and new style are the same.  If the style changes, it will have to be manually added to the smprepack file.  If you're just changing colors, the system will add the new smprepacks based upon the information on the smprepacks for the old colors.

Manually enter UPCs

sm/upcmanent allows manual entry of UPCs. 

Mass delete of style/prepacks and UPCs
util/smpdelmass allows deletion of smprepacks and UPC records if they have not been used anywhere.


Warehousing
Physical Inventory Check List
wh/whpichk prints the Warehouse Physical Spot Check List. It lists the warehouse location file (data/whloc).
                          
Home Contact Us Top of Page