Sales Order Processing - Pricing Table

 

Function

Use this task to define pricing tables which automatically calculate item pricing during order/invoice entry. The tables define price breaks on groups of items for groups of customers. The item groups are specified by Item Class (Inventory Maintenance). The customer groups are specified by Customer Price Code. A listing of all pricing tables and their descriptions is available.

 

=> To access this task...

Select Pricing Table from the Inquiry and Maintenance menu.

 

Pricing Table Maintenance

 

About the Fields

 

To enable edits to the form select  .

 

In the Item Class field...

  • Enter a valid numeric or alphabetic class code.

  • Click the record navigating buttons; to view the first record, to view the previous record, to view the next record and to view the last price table record.

  • Click Click to select from a list of item class codes.

  • Click Query button to select from a list of existing item class and pricing codes.

Item class codes are assigned in the Inventory Control module and identify a group of inventory items.

 

In the Customer Pricing Code field...

  • Enter a valid price code.

  • Click Click to select from a list of price codes.

  • Click Query button to select from a list of existing pricing codes from the selected item class.

In the Description field...

  • Enter up to 20 characters for a description of the pricing table.

From the Pricing Method dropdown...

Select one of the following from the drop down list:

  • Select Markup from Cost (C) to determine the item price by multiplying the item cost by the appropriate percentage in the pricing table, and adding this amount to the item cost. In formula form, this is: Item Price = Item Cost plus (Item Cost times Mark-up Percentage).

  • Select Markdown from List (L) to determine the item price by multiplying the list price by the appropriate percentage in the pricing table, and subtracting this amount from the list price. In formula form, this is: Item Price = Item List Price minus (Item List Price times Discount Percentage).

  • Select Margin over Cost (M) to determine the item price by dividing the item cost by the additive inverse of the percentage in the pricing table (i.e., 1 minus percentage). In formula form, this is: Item Price = Item Cost divided by (1 minus Margin Over Cost Percentage).

In the Quantity and Percentage fields...

  • Enter the quantity and price break percentage.

  • Enter up to 10 quantity price breaks for each Item Class.

When finished making entries to the fields...

  • Click Save button to save the record.

  • Click Clear Form button to begin a new line code record.

  • Click Delete record button to delete the record.

Closing an unsaved record will issue the prompt:

  • Select [Yes] to save the changes.

  • Select [No] to return to the Pricing Table form.



______________________________________________________________________________________

Copyright BASIS International Ltd. AddonSoftware® and Barista® Application Framework are registered trademarks.