Percentage Pricing

An item can be classified as Percentage Pricing within the inventory module of EBMS when the pricing is calculated by a percentage of pervious lines within a proposal or sales order. A Percentage Pricing item is useful in the following situations:

  1. Calculating a tax based on a percentage of the previous lines. This option should not be used for general sales tax calculation.  

  2. Calculating a surcharge or any other item based on a percentage of a previous item(s) rather than a fixed price.

  3. The percentage Price can be restricted to be entered into a sales invoice for a user defined number of times. For example a customer may be limited to allow a specific percenter price item to be entered 1 time.

The calculation can be based on the previous line of the document, all the previous lines, or the previous lines located between the inserted item and a previous item classified as Percentage Pricing.   

Creating the Inventory Item

Complete the following steps to create a percentage pricing item:

  1. Launch the new inventory item wizard as shown below: Review the Product Catalog > Entering New Products section for more details on the inventory item wizard.

  2. Select an appropriate folder and click Next.

  3. Enter a Description of the discount or percentage adjustment.

  4. The Default Selling Unit and Manufacturer settings can be ignored. Click Next to continue.

  5. Set the Classification setting to Percentage Price.

  6. Select the proper Tax Group and click Next. Review the Sales > Sales Tax section of the sales documentation for more details on the Tax Group setting.  

  7. Set the Percentage Pricing value. For example enter 1.00 to set the pricing at 1% of the line above the tax line.

  8. Select one of the Calculate From options:

    1. The Above Line - This is the most common option used for taxes and other fees that are displayed following specific items on a sales invoice.  Add the Percentage Price item as an accessory if this item should always follow the parent item.  Review the Components and Accessories > Components and Accessories Overview section for more details on adding items as accessories.

    2. Above Lines - This option will total all previous lines until it locates another item classified as percentage pricing.

    3. All Above Lines - This calculate is derived from all the invoice or proposal lines listed above the percentage pricing item.

  9. Percentage pricing item must be placed after any items that are used to calculate the percentage pricing price. Click Next to continue.

  10. Change the percentage pricing dialog below to list the new fee:

  11. Enter the Item Code for the inventory item. Review [Main] Features > Creating IDs for more details on creating ID codes or automating this step.

  12. Set the Limit Use to __ Per Bill To Customer setting to restrict the number of times the customer can have this code applied to their account. The settings can be used:

    1. Keep the value blank or zero to remove any restrictions.

    2. Enter a positive number to restrict the code's usage within a specific customer's account to the number of times stated.

    3. Enter a negative value to require a manager to override the restriction.

Using the Percentage Code in a Sales Order

The Percentage Price amount within a sales invoice is calculated from the total of detail lines selected by the Calculate From setting of the item. The percentage price is calculated from the Ordered or Shipped quantity (whichever is greatest) multiplied by the unit price of each previous item(s) line and then multiplied by the percentage entered within the Percentage Price item. (Unit price of Percentage Price item = (Ordered or Shipped, whichever is greatest * Price) + Repeat for each line indicated from Calculate From setting)

  

The Ordered and Shipped quantities will normally equal when a percentage pricing item is used within an invoice but greater quantities can be utilized. Percentage pricing items should not be used within back orders under normal circumstances since back orders could create duplicate discounts. Review the Sales > Invoices > Processing a Sales Invoice section from the sales documentation for more details on back orders.