This Help File Page was last Modified on 07/20/2020
Pricing Mark Up Groups
This Help File Page was last Modified on 07/20/2020
❑The Pricing Mark Up Groups Form is used to create any number of special purpose Mark Up/Mark Down Percentages, and assign each a Description and a system ID number.
•Once created, a Pricing Mark Up Group may be assigned to a Prospect on the Prospect Information Form, and/or to a Subscriber on the Accounting Information Section in the Edit Tab of the Subscriber Information Form.
2.If the Sale-Purchase Item's Retail Price value has been entered, then
3.As the Sale-Purchase Item is added to the Invoice or Proposal, the Amount (Price) to be charged for that Sale-Purchase Item will be calculated based on the Percentage Markup defined in that Pricing Mark Up Group, rather than using the default Sale-Purchase Item's Retail Price value.
a.Multiply the Sale-Purchase Item's Retail Price value by the assigned Pricing Markup Group's Percentage.
b.Adjust that result to the Retail Price (keeping in mind that a Minus Pricing Markup Group's Percentage value is subtracted from the Retail Price - see Important Note #1 below).
➢Important Note #1: The Pricing Markup Percentage may be a positive but will usually be a negative value.
i.When the assigned Percentage is a positive value, the calculated Price (Ext. Price) will be greater than the original Retail Price, thereby charging a "premium" for this item.
ii.When the assigned Percentage is a negative value, the calculated Price (Ext. Price) will be less than the original Retail Price, thereby offering a "discount" for this item.
iv.The Sale-Purchase Item Drop-Down Selection List will display both the default Retail Price and the price adjusted Ext.Price.
Sale-Purchase Items: Sale Item ID, Description, Retail Price, (wholesale) Price& the (circled) Ext. Price (which is the Pricing Mark Up Price)
➢Important Note #2: Regardless of whether or not the Subscriber or Prospect has been assigned to a Pricing Mark Up Group, if the selected Sale-Purchase Item's Retail Price value has not been entered, the Price on the Invoice will have to be entered manually for that Sale-Purchase Item.
➢Important Note #3: The Price on the Invoice - regardless of whether it is calculated based on a Pricing Markup Group's Percentage, or the original Retail Price, may still be modified by the User at the time of the entry.
❑Creating a Pricing Mark Up Group:
a)From the Backstage Menu System Select Maintenance and Choose General and Click the General Maintenance option which displays the Maintenance Menu or,
b)From the Quick Access Menu, Select Maintenance and Choose General Maintenance to display the Maintenance Menu.
•Once the Maintenance Menu is displayed, Select Receivables and Choose Pricing Mark Up Groups.
Pricing Mark Up Groups Form
✓This Mark Up Groups Form may be Re-sized by Dragging the Top and/or Bottom up or down, and/or the Right side in or out.
•Navigation Menu - The Navigation Menu is located at the top of the Pricing Mark Up Groups Form.
✓This Navigation Menu provides the normal Record Movement, plus Add, Delete, Cancel, Save, Refresh, and List options.
•Record Editing View - The details of the currently selected record are displayed below the Navigation Menu at the center (Main Body) of the Pricing Mark Up Groups Form.
Pricing Mark Up Groups Form - Record Editing View
✓Click the Add Icon to start a Pricing Mark Up Group entry in the Record Editing View.
▪ID - This record number will be assigned after the entry is initially saved.
▪Description - Enter a Description of this of the Pricing Mark Up Group.
oThe Description may up to 30 characters in length and include upper and/or lower case letters, numbers, spaces and normally used punctuation marks.
▪Percentage - Enter the Percentage of Mark Up/Mark Down as a positive or negative value.
oThe regular Retail Price entered for a Sale-Purchase Item will be increased or decreased (respectively) by the sum of that Percentage rate multiplied by the Retail Price, plus the original Retail Price, when creating an Invoice or a Proposal.
✓Click the Icon to record this Pricing Mark Up Group.
•Any number of additional Pricing Mark Up Groups may be created.
List Icon - The Navigation Menu also has a List option which provides a tabular view of these Pricing Mark Up Group records.
Pricing Mark Up Groups Form - List View
✓Click the List Icon to display the associated Grid Data.
✓The columns of Grid Data may be rearranged, filtered, sorted, and exported as a PDF file and/or an Excel formatted file.
✓Find - Enter text to search for a specific record, then Click the Find option.
✓Clear - To remove the text to search for entry, Click the Clear option
Navigation Menu shown with the List Options for Export & Print
✓Click the List Icon again to Close the List View and return to the Record Editing View.
❖See the Grids - Print Preview - Export Data chapter for complete information on using the List View, including its Export & Print options.
❑Using a Pricing Mark Up Group:
1.Define the desired Pricing Mark Up Groups to fit your Company's needs.
2.Enter a Retail Price (the "List Price" value) on the Sale-Purchase Items Form for each item to which a Mark Up Percentage calculation should be applied when the Amount (Price) for that item is inserted while creating an Invoice or a Proposal.
3.Be sure to also enter a Retail Price Amount on the Sale-Purchase Items Form because a Mark Up Percentage may not always be applied!
4.Inventory Items must also have both a Price (the actual cost or wholesale) value and a Retail Price value assigned
❖See the Inventory Valuation Methods chapter if using the Inventory Tracking System, and the Tracking Inventory Values chapter if also using the General Ledger System for more information about the Price, COGS Value and Inv. Value fields.
5.Any Sale-Purchase Item may also have a Price Override defined for any, or all predefined Pricing Mark Up Groups.
▪When a Price Override Percentage is defined for a Sale-Purchase Item, that Percentage will prevail in the Price calculation.