ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon Hardware and Software Requirements for Installing SQL Server
DrillDown Icon List of Modules Converted to MANEX Client Server
DrillDown Icon Installing SQL Server
DrillDown Icon System Administrator
DrillDown Icon Security System
DrillDown Icon Accounting Setup
DrillDown Icon System Setup
DrillDown Icon Operations Manuals
DrillDown Icon Sales
DrillDown Icon Sales Management
DrillDown Icon RMA Management
DrillDown Icon Sales Price List Information
DrillDown Icon Prerequisites
DrillDown Icon Introduction
DrillDown Icon Fields & Definitions
DrillDown Icon How To .....
DrillDown Icon Find a Sales Price List
DrillDown Icon Edit/Add Sales Price List Information
DrillDown Icon Customer Information (CI)
DrillDown Icon Sales Representitive Information (SR)
DrillDown Icon Inventory Management
DrillDown Icon Material Planning
DrillDown Icon Production
DrillDown Icon Quality/Engineering
DrillDown Icon Administration
DrillDown Icon Accounting
DrillDown Icon System Utilities
DrillDown Icon SQL Server Memory Settings and Performance
DrillDown Icon Definitions
DrillDown Icon How to schedule and automate backups of SQL Server databases in SQL Server Express
DrillDown Icon SQL_FAQ's
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Edit/Add Sales Price List Information

Enter the SQLMANEX.EXE (within the ManEx root directory)
This action will then prompt the user for a password

The following screen will be displayed, enter Sales/Sales Price List Information

 

The following screen will be displayed:

Depress the Find Action button to find a Product. See Article #1652 for further information on how to find a record.

After a Product has been found or entered, it may be edited by selecting the Edit Action button. Once the password is entered, the "Add", "Delete". and "Reorder" buttons are activated.

Selecting the button brings up a screen listing all the Active Customers from which to select from.  Select a customer for which the pricing is to be applied.  There may be different pricing for each customer.

Double Click on a customer will add that customer to the product pricing information
Note:  Only the customers listed in the Customer List will be available for this Product within the Sales Order module. 



Selecting the   reveals buttons by each customer and the order may be changed by dragging the buttons to the desired order. When sorting is completed, select the Done button completes the action

Selecting the  allows the removal of a customer from the product information.



Add Sales Type

By selecting a part number, you can then assign a Sales Type. Selecting a Sales Type will automatically enter the type when the part is added to a sales order. Otherwise, the user will have to select the Sales Type before saving a Sales Order.

Depressing the down arrow next to the field will display a list of sales types:

Select the desired Sales Type.
 
Assigned Sales Rep and Select Commission
 
If applicable, assign a Sales Rep and Commission.

Add Price Markup Percentage

If applicable, enter the markup percentage in the box.

Add Warranty Information

If applicable, enter the number of days for the warranty.

The completed Part Number Information tab will look like this:

Depress the Save Action button to save changes or the Abandon changes Action button to abandon changes.

ADD PRICING

After completing the PART NUMBER INFORMATION tab, the user may (click on) to the PRICES BREAKS tab.

In this screen, the user may elect to add additional customer pricing for a product by using the Edit function.  
 

Then the Price Break screen for a specific customer is presented to the user, based on the customer selected in the first screen:

And the Add Action button becomes active. If the user is creating the first pricing screen, then the Edit Action button is not yet available.

The user may create up to seven different pricing levels for each customer. To add the first pricing screen, the Add Action button must be pressed and the password entered.

The “Price 1” screen is activated, allowing the user to enter pricing for the customer shown.


 

This screen has two main sections: the pricing at quantity levels; and the ability to amortize the expense of any object such as tooling over a fixed number of deliveries.

In the Amortization Charge section, the user can enter an amount to be amortized, and the number of units shipped over which the amortization is to be applied. As product is shipped, the Shipped Qty will be updated, and when the entire quantity is shipped, the additional amortization cost will be dropped from the invoice.

The first prompt is for the beginning number of items to be priced, defaulting to one (1). The next field is for the upper number to be included in the price structure, e.g., 100 (pricing is for 1 to 100 items).You can input pricing up to 999,999, but you are limited to seven price breaks.
 
In the Amortization Charge section, the user can enter an amount to be amortized, and the number of units shipped over which the amortization is to be applied. As product is shipped, the Shipped Qty will be updated, and when the entire quantity is shipped, the additional amortization cost will be dropped from the invoice.

The cursor then moves to the first Sales Price Breakdown section where the user may define the pricing used for individual units. The definition of the pricing is established in the System Setup, and may be selected with the “pulldown arrow” and clicking on a definition, or typing the definition.  After selecting a definition, the pricing associated with the definition is entered. (e.g., the definition might be “Total Material Cost” and $350 per unit. Or, perhaps a definition simply called “Standard Price” is used.)

On the next line, another pricing definition may be included, e.g. “Priority Charge”, with an additional charge of $50 per unit.

Manex will continue to total up the unit pricing and show it on the screen.

The completed screen looks like this:

When the user has completed the information for the 1st price break, the screen is either saved or canceled.  The following message will appear asking if the user wants to add another record.

If there is another price category to be added, depress the Yes button.

The user may then add an additional price break, which will default to a beginning quantity equal to the top of the first price break quantity plus one. The fields used in the first price break will be carried over to the second price. Changing the definition in any price break screen changes all the others for that product.

Pricing for a different customer for the SAME product may be established by selecting the customer in the first screen, then adding a new price break for that customer.

After completing this PRICING customer information screen, the user may tab (clicks on) to the Part Information Note screen.

The Part Information screen for the product is presented to the user, and may be edited. Information placed in this screen is common to all customers, (it is based on information about the product), and the Tab Label turns RED.

Press the Save Action button Save new or edited data.

Press the Abandon changes Action button to Cancel any new or edited information without saving the information in the database.

Press the Edit Action button to exit the current screen and returns the user to the previous screen.

Article ID: 4535