Search Site     
HOME >> TIP OF THE MONTH     
Back Office
Home Office
Central Price Book
POS Interfaces
Hand-held Scanning
EDI Conversion
Fuel Distribution
Work Orders/ALLDATA
Work Orders/Mitchell 1
Sunray - ASP
Digital Dispatch
Training
Support
System Administration
POS Conversion
General Information
Employment
Sales
Support
Tip of the Month
Press Releases
Product Versions
Trade Shows
Tip of the Month
Purchase Exceptions

Purchase Exceptions

Tip: Use CDBWin to spot discrepancies between orders and deliveries

One of the realities of the c-store business is that the vendor invoice sometimes does not match up.in terms of item cost and/or quantity ordered.to the submitted order. Locating and reconciling discrepancies on large orders with many items is time consuming, tedious and leads to user error, but CDBWin's Purchase Exception feature automates the process so ordering discrepancies can be identified quickly and with precision.

Orders may be generated by manually selecting items on a transaction or by using the Inventory: Reorder report, which allows you to base reorder quantities on your actual sales history. Order transactions may be printed or may be sent electronically to the vendor (if supported by CDB and vendor). Line item purchases may be recorded four ways.by manually keying them, through the EDI Conversion feature, through the Recurring Paidouts feature, and using Hand-Held Data Processing's (HDP) DSD feature.

While the Purchase Exception feature works with every kind of order and recorded purchase handled by CDBWin, it can be especially helpful when you want to compare your Computer Assisted Order (CAO) against a paidout created by CDBWin's EDI Conversion showing what you received from the vendor.

To compare your order transaction to your invoice transaction:

  1. from the Daily Work menu, click Purchases/Payables. With the Purchases window open, on the File menu, click Purchase Exceptions. A window like the following appears:




  2. The top part of the window displays a list of ordered invoices, with the bottom displaying the delivery invoices in the same sort sequence.
  3. To determine the specific differences between an order transaction and an invoice transaction, select the records in question by clicking on each of them and then click Compare. An Exception Report displays:




  4. Here you can view a specific comparison of what was requested and what was received, including Quantity Received vs. Quantity Ordered, and Price Requested vs. Price Paid. Quantity Variance is automatically recorded along with the Total Variance (Quantity Variance multiplied by Price Requested). With this document you can then contact your vendor and get the differences straightened out.

Past Tips of the Month...

March 2009: Maximizing Efficiency with Hand-Held Data Processing

February 2009: Battery Care and Maintenance

January 2009: Using Online Documentation

December 2008: Identifying Fast and Slow Movers

November 2008: Identifying Inventory Changes

October 2008: Identifying Over Stock

September 2008: Identifying Dead Stock

August 2008: No Sales Tracking

July 2008: Refunds Tracking

June 2008: Discounts Tracking

May 2008: Void Tracking

April 2008: Workforce Management

March 2008: Department Projections

February 2008: Resolving HHT Communication Issues

January 2008: Preparing an Annual Budget

December 2007: Speeding Up Direct Store Deliveries

November 2007: Calculating an Accurate Cost of Goods Sold (COGS) for Lottery Sales

October 2007: Processing Lottery Paidouts

September 2007: Marking Items (in CDBWin) Not to Be Sent to the POS

August 2007: Using Expense Items and Using the Department/Expense Report in CDBWin 7.4

July 2007: Configuring an Alert for Cash Balance

June 2007: Adjusting Inventory with the Hand-Held on a Daily or Weekly Basis

May 2007: Scanning Direct Store Delivery Invoices Without Affecting Retail Prices in CDBWin

April 2007: Restricting Duplicate Invoice Numbers

March 2007: Profit & Loss

February 2007: Fuel Manager Reports

January 2007: How to Buy Coffee Supplies and Expense Them

December 2006: How to Get a PLU Report without Bar Coded Items

November 2006: How to Create a Reorder Using the Hand-Held Terminal (HHT)

October 2006: Reorder Items in Selected Department Range

September 2006: Reorder Quantities Based on Minimum Purchase Quantity

August 2006: Reorder Quantities Based on Sales History

July 2006: How to Reconcile Inventory

June 2006: How to Reconcile Inventory After a Promotion...

May 2006: Reordering the Correct Number of Items

Home  |  About Us  |  Products  |  Services  |  What's New?  |  Contact Us