RxUniverse can allow a lab to provide sales discounts based on the volume of sales for a date range. The volume discount program allows lots of flexibility when deciding what the discount amount should be. Multiple discounts can be taken based on the type of sales if desired. The discount percentage can also be based on the $$$$ of the sales in the discount period. Before the volume discounts are applied to the accounts, the lab has the ability of reviewing the discounts and change them if desired.
The set an account up for volume discounts, the "Apply volume discounts" flag in the "General" tab must be checked.
Volume Discount table
The Volume discount table is accessed from the "Setup" menu. Volume discounts can be setup to apply to all volume discount accounts or can be set up for specific accounts. The volume discount table is a standard RxUniverse list / maintenance screen where you can add, modify or delete the various volume discount levels based on the users security clearance.
Note that Volume discount sales are based on the AR transaction types of "Order" and "Miscellaneous". The sales to include in the calculations is the amount associated with the item type, less the Net amount for the item type. If the item type discountable flag is set to "N", then the amount is not included in the calculations. Also, if there is an early payment discount for the item type, the amount will only be considered if the "Add invoice discount to month-end discount" flag in the "System Settings - AR tab" is checked.
The various fields are:
- Account - Enter a valid account number or leave blank for a global volume discount
- Sales Volume Based On - select one of the available options. the discount line purchase level will be based on this volume.
- All sales - will include all transactions item types
- Rx Sales - will include all AR transactions whose item type entry is "RX". (Rx Orders - lens and addon lines)
- Stock Lens Sales - will include all AR transactions whose item type entry is "Stock". (Stock order sales)
- Frame Sales - will include all AR transactions whose item type entry is "Frame" (Rx and Stock Orders - frame and frame part lines)
- Other Sales - will include all AR transactions whose item type entry is "Other". (Rx and Stock Orders - Misc lines)
- Purchase Level - this field will be the break point used when deciding if a discount entry is used. All sales up to and including this amount will use this discount line.
- Discount Percentage - this field contains the percentage amount to apply to the Discounted volume
- Discount Based On - select one of the available options. The discount percentage will be applied to this calculated volume.
- All sales - will include all transactions item types
- Rx Sales - will include all AR transactions whose item type entry is "RX". (Rx Orders - lens and addon lines)
- Stock Lens Sales - will include all AR transactions whose item type entry is "Stock". (Stock order sales)
- Frame Sales - will include all AR transactions whose item type entry is "Frame" (Rx and Stock Orders - frame and frame part lines)
- Other Sales - will include all AR transactions whose item type entry is "Other". (Rx and Stock Orders - Misc lines)
- Remarks - this field allows the entry of a descriptive text for this volume discount level
Volume discounts - How to run
Running volume discounts is done via the "A/R" menu. Select the "Volume Discount" menu and the Volume Discount screen will appear.
Press the "Create Volume Discounts" button to access the volume discount calculation screen. Enter the date range for the calculation and press "Continue". The program will select all A/R transactions within the desired dates and calculate the sales volumes for each account. The sales volumes will be compared to the Volume discount table records and the appropriate discount, if any, for each account will be calculated and displayed in a "Volume Discount" posting screen.
The calculated volume discounts for each account will be displayed in a grid. You can modify the discount amount that was calculated before posting the discount records to the A/R transaction database. Pressing the "Post" button will move the temporary volume discount transactions to the A/R transaction file and print a volume discount posting report. The posting report is also stored in the reports database under the name of "AR-VOL-yyyy/mm/dd", where the date is the posting date.