News

Rounding on Orders

The purchasing system works in two ways when rounding the quantity to reorder to match minimum order quantities:

  • The purchasing system round quantities to order up to minimum reorder quantity if the quantity required is less than the minimum reorder quantity. So if you need 6 and the minimum reorder quantity is 10 the system will buy 10.
  • If you need more than the minimum reorder quantity the system rounds down after the first multiple of the minimum order unit. So if you need 56 and the minimum reorder unit is 10 the system will order 50.

The system can’t tell if a quantity to reorder comes from back orders or min/max. It always uses the same rounding rules.

The above behaviour was built into Readysell quite a long time ago, in response to requests from customers to keep stock holdings down.

I suggest an option for you to make the quantity to reorder always round up to the next largest minimum order quantity might suit your requirements. The system would order more stock but would tend to always have enough for all back orders.

Minimum Order Quantity Quantity  Calculated Quantity Required Rounded Qty Ordered Comment
BEFORE
10 1 10 Round up the first multiple of the minimum order quantity
10 11 10 Round down if quantity ordered is larger than one minimum order quantity
10 22 20 Round down if quantity ordered is larger than one minimum order quantity
NOW
10 1 10 Always round up the to the next multiple of the minimum order quantity
10 11 15 Always round up the to the next multiple of the minimum order quantity
10 22 25 Always round up the to the next multiple of the minimum order quantity

Normally automated purchasing rounds the quantity purchased up to the minimum order quantity if the quantity orders is less than the minimum. If the quantity ordered is more than the minimum order quantity the system rounds the quantity down to the nearest multiple of the minimum order quantity.

A new system reference allows the system to always round up to the next largest multiple of the minimum order quantity. To enable this feature set system reference:

  1. Type ‘PURCHASE’
  2. Code ‘ROUND-UP-REORDER-QTY’
  3. Value 1 to turn on this feature.

More details can be found in the document “Rounding On Purchase Orders”, available in the Downloads section of our web site.

System References for Overriding Contract Pricing

If you have a customer with a contract price and you want that contract price to be the price they get provided the parameters of the contract (i.e. valid dates) are met regardless of whether the contract price is higher or lower than the current sell price.

NOTE: You DO NOT need to disable best of pricing system reference in order to run the system references below.

System Reference 1

  1. Type ‘SELL-PRICES’
  2. Code ‘NO-PROMOTION-FOR-PRICE-CODES’
  3. Description [all price codes to override promotions] (in this case ‘CS|PCS’ for contract price specific)

System Reference 2

  1. Type ‘SELL-PRICES’
  2. Code ‘ALLOW-SELL-PRICES-TO-INCREASE’
  3. Description and value set to 1

System Reference Type

System Reference Code

Value and Description

Comment

SELL-PRICES NO-PROMOTION-FOR-PRICE-CODES

CS/PCS = ON
Blank = OFF

Stops any promotions/flyers from overriding your contract price regardless of whether the promotion/flyer price is higher or lower.
SELL-PRICES ALLOW-SELL-PRICES-TO-INCREASE

1 = ON
0 = Off

Allows sell prices to increase if the contract price is higher than any of the pricing in your system.

Please read the above, decide on whether or not you wish to run with these system references. If you would like to activate any of these, please change the value and description of the system references as necessary.

More details can be found in the document “Contract Pricing Override”, available in the Downloads section of our web site.

Quick Tip: Modifying Barcode Scanning Behaviour

Just a reminder, there are settings you can use for skipping lines for scanning and entering products into a sales screen.

There are several settings in the system that relate to skipping lines:

Type “REGISTER”, code “SKIP-LINE-FOR-BAR-CODES”

When the value of this system reference is 1 the POS (point of sale) will skip to a new line when you scan a bar code. Bar code being defined as a bar code that is different to the product code.

Type “REGISTER”, code “SKIP-LINE-FOR-ALL”

When the value of this system reference is 1 the POS (point of sale) will skip to a new line when you enter any product. So if you scan in a bar code that is the same as the product code, a bar code from the product supplier or manually enter a product code the POS will skip to a new line.

Type “REGISTER-[register number]”, code “COMPRESS-BAR-CODE-SCANS”

When the value of this system reference is 1 the POS (point of sale) will add the lines together producing a total quantity supplied on the one line for the same product. I.e. scan product A 3 times, it produces 1 line of sale but quantity will read as 3.

Once you change any of the settings above, you will need to get each point of sale to close out of Sales and then go back to pick up the system reference changes.

For more information, please see the document “How To Skip Lines – compress lines for barcodes.doc” in the Downloads section of our web site.

Customer Rep Run Sales Management Report

A new report has been added to the Management Reports list – the “Customer Rep Run Sales Report”

This report has a number of prompts and reports comparing the average dollar value sales for the last 12 months, last month and variance of last month to the last year. Also reports on GP% for the last 12 months, the last month and the variance between the last month to the last year.

You can find all the details, including how to run this new report in the Management Reports document found at the Downloads area of our web site under Readysell Version 7 > Reporting.

Update: Readysell 7 Management Reports

Readysell Report Wizard

Based on some recent feedback we sent out a list of management reports that we had formulated some time ago. Since we have sent these out, we have received more feedback about enhancements to be made to these reports. We have various changes to help improve the usefulness of these reports and these changes have now been deployed out to all of our customers.

Management reports are available under the category “Management Reports” in the Readysell 7 Report Wizard.

The new/updated reports include:

  • All Finalised Sales Transactions Check To General Ledger
  • All Finalised Sales Transactions Check To GL
  • All Sales by Date By Product Detail
  • Bank Deposit Report
  • Catalogue to Product File Comparison Detailed
  • Customer Trial Balance
  • Last Product Sales By Customer
  • Customer Sales Detail Prompt For Min GP/Date
  • Customer Sales Summary By Rep By Period Grid
  • Department Sales By Period Summary
  • Customer Sales By Period Summary Grid
  • Sales Comparison Against Stock Receipts
  • Top Selling Products Summary For A Range Of Customers
  • Product List
  • Daily Report Sales By Day Summary
  • Sales By Period By Supplier Summary
  • Daily Sales By Date Detailed
  • Sales Gross Profit Review by Line
  • Sales Orders Outstanding
  • Stock On Hand Report

You can find all the details in the Downloads area of our web site under Readysell Version 7 > Reporting.

Readysell Feedback Portal

As we approach the final stages of development in Readysell 8, we would like to take this opportunity to gather feedback from our Readysell 7 users about features and enhancements they would like to see in the new version. Based on this feedback we will develop a roadmap for future enhancements to Readysell 8.

To do this we have setup a UserVoice feedback forum. This forum will allow you to submit new ideas, vote on other user’s ideas (to increase their priority) and will allow us to respond with our plans in regards to your suggestions.

To visit this forum, click here. You will need to register to submit new ideas (you can use an existing Facebook or Google account if you have one).

Important Products and Sales System References

There are some checks in the system to:

  • warn you if stock will go negative when you sell an item
  • warn you if the margin/GP is below a minimum percentage

It has come to our attention that many of our customers are not aware of these options, so we would like to send out this quick note in case you are interested in turning either/both of these on in your system.

System Reference Type

System Reference Code

Value and Description

Comment

REGISTER SALE-LINE-NEGATIVE-STOCK-WARNING

0 = Off
1 = On

Displays a warning if the stock on hand would go negative if you complete the sale.
REGISTER SALE-LINE-MINIMUM-GP-PERCENTAGE

0 = Off
[Any Other Number] = The percentage to be used

Displays a warning if the GP % on any lines is below this minimum percentage. Product maintenance displays the same warning message.
REGISTER SELL-BELOW-COST-WARNING

0 = Off
1 = On

Display a warning if you sell a product at less than cost price.

Please read the above, decide on whether or not you wish to run with these system references. If you would like to activate any of these, please change the value and description of the system references as necessary.

Razor Stationery Catalogue

Working in conjunction with Razor Stationery, Readysell has released Razor’s range of products in the form of a Readysell catalogue load. Should you be interested in loading this range of products into your system, this will automate the process and ensure compliance with the supplier’s data. The range of products has already been allocated with Ez-Codes and images will display alongside the products in your system.

If you are interested, you can load the data using the Readysell Price Change program in one easy to manage step.

  • DELI01 Razor OB700 Codes (1/06/2012 – 1/01/2013)
    • To be loaded as a Catalogue

For more information about loading catalogues into Readysell, please review the support material on our web site.

Release Notes for Recent Readysell 7 Upgrade

We have recently rolled through all of our Readysell Version 7 customers and upgraded all systems to our latest release.

Please be advised that the upgrade release notes are available for you to download at any time. These upgrade notes are kept up to date as often as possible and should you find any release that is after this date that you would like added to your system, please email support@readysell.com.au and advise of the date of the relevant the release note and we can update your system accordingly on an appropriate date for you.

For your reference, the upgrade your store received is for release notes up until 21st June 2012.

  1. Open up your web browser
  2. Navigate to www.readysell.com.au
  3. Click on Downloads
  4. Left click on Readysell Version 7
  5. Left click on Release Notes

Alternatively, you can use the following link: http://www.readysell.com.au/files/Readysell%20Version%207/Release%20Notes/

Reminder: Readysell 7 Management Reports

Readysell Report Wizard

Recently we have had some questions regarding management reporting. As such, we would like to re-release this post to remind our customers of the management reports already available in Readysell 7. Management reports are available under the category “Management Reports” in the Readysell 7 Report Wizard.

The list of reports that are being released includes:

  • All Sales by Date By Product Detail
  • All Sales Transactions Codes by Date Detail By TransCode
  • Bank Deposit Report
  • Customer Sales By Period Summary Grid
  • Customer Sales Summary by Rep by Period Grid
  • Customer Trial Balance
  • Daily Report 1 SalesByDaySummary
  • Daily Report 2 Sales Detailed By Day
  • Department Sales By Period Summary
  • Product List
  • Purchase Order Line Details By Transaction No Selection
  • Purchase Order Lines For One Transaction NO
  • Purchase Receipt Listing By Receipt No
  • Sale Outstanding in Details By Date Range
  • Sales By Period By Supplier Summary
  • Sales Comparison Against Stock Receipts
  • Sales Orders Outstanding
  • Stock On Hand Report
  • Top Selling Products Summary For A Range Of Customers

You can download a spreadsheet with a full list of available reports here.