13. Utilities

Sales Utilities section.

13.1.  Customer Information Export

The Customer Information Export utility enables you to selectively identify Customer information, which you may then export into a plain-text, TAB-delimited file. The exporting of selected information is handled using the "Export Contents" option in the screen's right-click menu. To specify the Customer information you want to tag for export, select the "Customer Information Export" option. The following screen will appear:

Customer Information Export

When specifying Customer information you want to tag for export, you are presented with the following options:

All Customer Types

Select to tag all Customer Types for export.

Selected

Specify Customer Type you want to tag for export.

Pattern

Enter a Customer Type pattern to select a range of Customer Types. Refine your search using Regular Expressions.

Show Inactive

Select to include inactive Customers in the list of Customers tagged for export.

General

Select from the following general information categories:

Number

Select to tag the Customer Number for export.

Name

Select to tag the Customer name for export.

Billing Address

Select from the following billing address categories:

Address 1

Select to tag the first address line for export.

Address 2

Select to tag the second address line for export.

Address 3

Select to tag the third address line for export.

City

Select to tag the city for export.

State

Select to tag the state for export.

Zip Code

Select to tag the zip code for export.

Country

Select to tag the country for export.

Contact

Select to tag the contact name for export.

Phone

Select to tag the contact's phone number for export.

FAX

Select to tag the contact's fax number for export.

Email

Select to tag the contact's email address for export.

Correspondence Address

Select from the following correspondence address categories:

Address 1

Select to tag the first address line for export.

Address 2

Select to tag the second address line for export.

Address 3

Select to tag the third address line for export.

City

Select to tag the city for export.

State

Select to tag the state for export.

Zip Code

Select to tag the zip code for export.

Country

Select to tag the country for export.

Contact

Select to tag the contact name for export.

Phone

Select to tag the contact's phone number for export.

FAX

Select to tag the contact's fax number for export.

Email

Select to tag the contact's email address for export.

Information

Display lists Customer information tagged for export.

To the far right of the screen, the following buttons are available:

CLOSE

Closes the screen, returning you to the application desktop.

QUERY

Select to generate the display, using the specified parameters.

13.2. Reassign Customer Types by Customer Type

To reassign Customer Types by Customer Type, select the "Reassign Customer Types by Customer Type" option. The following screen will appear:

Reassign Customer Types by Customer Type

When reassigning Customer Types by Customer Type, you are presented with the following options:

Selected Customer Type

Specify the Customer Type you want to reassign.

Pattern

Enter a Customer Type pattern to select a range of Customer Types. Refine your search using Regular Expressions.

New Customer Type

Specify the new Customer Type you want to reassign the Customers to.

To the far right of the screen, the following buttons are available:

CANCEL

Closes the screen without reassigning Customer Type(s), returning you to the application desktop.

REASSIGN

Reassigns Customer Type(s), using the specified parameters.

13.3.  Update Credit Status by Customer

The credit status of a Customer has a direct bearing on whether Sales Orders can be created for that Customer. For example, Customers whose credit status is either "On Credit Warning" or "On Credit Hold" may not have Sales Orders entered for them. To update a Customer's credit status, select the "Update Credit Status by Customer" option. The following screen will appear:

Update Credit Status by Customer

Note

The credit status for a Customer may also be updated using the Customer master. Any updates made using this utility will be reflected in the Customer master.

When updating the credit status for a Customer, you are presented with the following options:

Customer #

Enter the Customer Number of the Customer whose credit status you want to update. The browse button located to the right of the field leads to a searchable Customers list. You may also access this list using the keyboard shortcut "CTRL + L". Once a Customer Number is entered, the Customer name and billing address will display.

Current Credit Status

Displays the specified Customer's current credit status. Current credit status is drawn from the Customer master.

In Good Standing

Select to make the Customer's credit status "In Good Standing." Customers with credit "In Good Standing" may have Sales Orders issued for them. A black-colored typeface will be associated with their account.

On Credit Warning

Select to make the Customer's credit status "On Credit Warning." Customers with credit "On Credit Warning" may not have Sales Orders issued for them. An orange-colored typeface will be associated with their account.

On Credit Hold

Select to make the Customer's credit status "On Credit Hold." Customers with credit "On Credit Hold" may not have Sales Orders issued for them. A red-colored typeface will be associated with their account.

To the far right of the screen, the following buttons are available:

CANCEL

Closes the screen without updating the Customer's credit status, returning you to the application desktop.

UPDATE

Updates the Customer's credit status, using the specified parameters.

13.4. Purge Invoices

Purging Invoice records is one method for freeing up disk storage space—without losing important sales history. Running this utility will also purge the whole chain of documents associated with an Invoice. The chain of documents which will be purged when this utility is run include the following: Invoices (invchead, invcitem); Return Authorization (rahead, raitem, rahist); Lot/Serial Registrations (lsreg); Sales Orders (cohead, coitem, payco, backup_payco); Shipments (shiphead, shipitem, pack); and Billing (cobmisc, cobill). Again, running this utility will not purge sales history. That information is retained for historical sales analysis purposes.

To purge Invoices and their associated documents, select the "Purge Invoices" option. The following screen will appear:

Purge Invoice Records

Note

The consequence of purging Invoice records is that any purged Invoice records can no longer be re-printed.

When purging Invoices and their associated documents, you are presented with the following options:

Cut Off Date

Invoice records created before and including this date will be purged.

To the far right of the screen, the following buttons are available:

CANCEL

Closes the screen without purging any Invoice records, returning you to the application desktop.

PURGE

Purges the Invoice records.

13.5. Purge Credit Memos

Purging Credit Memo records is one method for freeing up disk storage space—without losing important sales history. To purge Credit Memo records, select the "Credit Memo Records" option. The following screen will appear:

Purge Credit Memo Records

Note

The consequence of purging Credit Memo records is that any purged Credit Memo records can no longer be re-printed.

When purging Credit Memo records, you are presented with the following options:

Cut Off Date

Credit Memo records created before and including this date will be purged.

To the far right of the screen, the following buttons are available:

CANCEL

Closes the screen without purging any Credit Memo records, returning you to the application desktop.

PURGE

Purges the Credit Memo records.

13.6. Allocate Reservations

The Allocate Reservations utility enables you to allocate Inventory to batches of open Sales Orders. This can be a more efficient method for quickly making hard Inventory allocations, as compared to allocating Inventory one-at-a-time at the individual Sales Order Line Item level. You can allocate Inventory to batches of Sales Orders using the following screen:

Allocate Sales Order Reservations

Note

Only Sales Order Line Items that can be completely reserved using actual Quantity on Hand will be affected when this utility is run. If a Line Item cannot be completely reserved, it will be skipped.

When allocating Inventory to batches of open Sales Orders, you are presented with the following options:

Selected Customer

Select to allocate Inventory to an individual Customer's open Sales Orders.

Customer #

Specify the Customer Number of the Customer whose open Sales Orders you want to allocate Inventory to. The browse button located to the right of the field leads to a searchable Customers list. You may also access this list using the keyboard shortcut "CTRL + L". Once a Customer Number is entered, the Customer name and billing address will display. Select the "?" or "$" symbol next to the browse button to view Customer information for the specified Customer. If a Customer's credit is "In Good Standing," the button will feature a black question mark ("?") icon. If the icon turns to an orange dollar sign ("$"), the Customer's credit Status is "On Credit Warning." A red dollar sign ("$") indicates the Customer's credit Status is "On Credit Hold."

Selected Customer Ship-To

Specify the Customer Ship-To Address whose open Sales Orders you want to allocate Inventory to. This is an optional setting which may be used in conjunction with the "Selected Customer" setting. The Ship-To option gives you the added flexibility of being able to assign multiple Pricing Schedules to a single Customer based on separate Ship-To Addresses.

Selected Cust. Ship-To Pattern

Enter a Ship-To Address pattern to select a range of Ship-To Addresses for the selected Customer.

Selected Customer Type

Specify the Customer Type you want to assign a Pricing Schedule to.

Customer Type Pattern

Enter a Customer Type pattern to select a range of Customer Types. Refine your search using Regular Expressions.

Start Date

Open Sales Orders having a due date on and after this date will have Inventory allocated to them. Start date and end date must be entered for calculation to proceed.

End Date

Open Sales Orders having a due date on and before this date will have Inventory allocated to them. Start date and end date must be entered for calculation to proceed.

Automatically Add to Packing List Batch

Select to automatically add affected Sales Orders to the Packing List Batch.

To the far right of the screen, the following buttons are available:

CANCEL

Closes the screen, returning you to the application desktop.

ALLOCATE

Select to run the batch allocation process, using the specified parameters.

SUBMIT

Select to submit requested action to the Batch Manager for processing.

13.7. Archive Sales History

If your system contains older Sales history information which you no longer need for Sales Analysis purposes, you may archive that history—effectively removing it from view. Any archived Sales history will not be shown in Sales Analysis reports. If you ever want to view archived Sales history again, you may restore it at any point. For more information, see Section 13.8, “Restore Sales History”.

To archive Sales history, select the "Archive Sales History" option. The following screen will appear:

Archive Sales History

Note

Archiving Sales history does not delete Sales history. Rather, the historical data is simply relocated to a storage archive on the database. You may restore Sales history from the archive at any time.

When archiving Sales history, you are presented with the following options:

All Customer Types

Select to archive Sales history for all Customer Types.

Selected

Specify Customer Type whose Sales history you want to archive.

Pattern

Enter a Customer Type pattern to select a range of Customer Types. Refine your search using Regular Expressions.

All Product Categories

Select to archive Sales history for all Product Categories.

Selected

Specify Product Category whose Sales history you want to archive.

Pattern

Enter a Product Category pattern to select a range of Product Categories. Refine your search using Regular Expressions.

Archive Freight, Sales Tax and Misc. Items

Select to archive all the sales information which is not directly related to the Item Sites for a Sales Order—that is, Freight charges, Tax, etc.

All Sites

Select to archive Sales history for all Sites.

Selected

Specify Site whose Sales history you want to archive.

Start Date

Sales history generated on or after this date will be archived.

End Date

Sales history by Shipping Zone by Item generated on or before this date will be archived.

To the far right of the screen, the following buttons are available:

CANCEL

Closes the screen without archiving Sales history, returning you to the application desktop.

SELECT

Archives Sales History using the specified parameters.

13.8. Restore Sales History

If you have Sales history stored in an archive on the database, you may restore that history at any point. Restoring Sales history makes it available again for Sales Analysis purposes. To restore Sales history that has been archived, select the "Archive Sales History" option. The following screen will appear:

Restore Sales History

Note

Archiving Sales history does not delete Sales history. Rather, the historical data is simply relocated to a storage archive on the database. You may restore Sales history from the archive at any time.

When restoring Sales history, you are presented with the following options:

All Customer Types

Select to restore Sales history for all Customer Types.

Selected

Specify Customer Type whose Sales history you want to restore.

Pattern

Enter a Customer Type pattern to select a range of Customer Types. Refine your search using Regular Expressions.

All Product Categories

Select to restore Sales history for all Product Categories.

Selected

Specify Product Category whose Sales history you want to restore.

Pattern

Enter a Product Category pattern to select a range of Product Categories. Refine your search using Regular Expressions.

Restore Freight, Sales Tax and Misc. Items

Select to restore all the sales information which is not directly related to the Item Sites for a Sales Order—that is, Freight charges, Tax, etc.

All Sites

Select to restore Sales history for all Sites.

Selected

Specify Site whose Sales history you want to restore.

Start Date

Sales history generated on or after this date will be restored.

End Date

Sales history by Shipping Zone by Item generated on or before this date will be restored.

To the far right of the screen, the following buttons are available:

CANCEL

Closes the screen without restoring Sales history, returning you to the application desktop.

SELECT

Restores Sales History using the specified parameters.