Computerized Daily Book Version 7.3.7 Released
SSCS is pleased to announce V7.3.7 of the Computerized Daily Book (CDB) program.
This program is filled with many new features that were requested in our 2004 User Conference, as
well as requested by other current customers.
The update includes features for Home Office, general features for CDB, Auto Repair
package and pollers. Central Price Book and hand held applications will be updated later.
To request your copy of this program, click here and
complete this web form, or visit our Product Version page for a list
of other options for making your request. The order will be filled in the order it was received. It will only
be shipped to customers who have a current support agreement.
CDB Version 7.3.7 Features
New Features for CDB and Home Office:
Work Force Management
This feature permits user to build a work schedule for up to four weeks by shift, by day and by employee.
The system automatically copies one week forward when the user begins editing the next week. The manager
edits the hours worked if different than scheduled. A convenient report that compares hours scheduled and
hours worked is available. An export file can be generated to be imported to other payroll systems such
as the BusinessWorks Gold time card program or Paychex. Overtime rules can be set to meet most state or
federal rules. Hours can be rounded to different fractions of an hour.
Budgets and Projections
The operator can create a budget for Income, Cost of Goods Sold, and Expense accounts in the CDB. There are
three different methods to produce a budget. (1) The amount can be entered as an Annual amount and be spread
equally over the twelve month period. (2) The operator can spread the annual amount across twelve monthly
periods as desired. (3) The user can import the previous years Income and Expense Statement values from the CDB
and apply an "uplift" as a percentage. The system permits the operator to view or print monthly, budget variance
reports. When used with the Sales, COGS and Expense projection programs in the CDB, creating a budget and
tracking results will be easy and productive.
Reset the Beginning of the Month
The new version of CDB will permit a user that forgot to run End of Month Process in the correct shift a chance
to apply the End of Month Process to a shift within the current month in order to age A/R and to have the current
MTD date range begin on the shift it was supposed to start.
Open Tag Report
This report has been enhanced to show the customers and employee names rather than just the Customer ID and
Employee ID. This will help the user identify the work order and identify the employee who generated the
tag much more easily.
Message Center (Notes)
The Daily Work menu of the CDB now has a place for the user to send messages to and from the Home Office.
This will be a great way for the Central Price Book Manager to remind site managers of an up-coming promotion
or way for the site manager to notify the Home Office of a vendor who is attempting to leave a new item in the
store. This feature currently works with the Local Corporate or Sunray/ASP configurations.
Check Register and Voucher
V7.3.7 will not only provide a new option to print a check register immediately after printing the checks but
will also offer a check voucher that can be used in Accounts Payable. A new running balance format is available for
Check Register from Reports > Daily Book > Current Assets > Check Register.
Category Manager
A new user restriction tab has been established in the CDB to manage a single or multiple categories
(departments) across the enterprise. The Category Manager feature allows the operator to set up restrictions
for users. Users are restricted to particular categories (departments) for particular sites. Normally, without the
Category Manager restriction setup, any user can select any department while working in any site when performing
inventory maintenance, purchase order line item selection, etc. A user that is limited by the Category Manager
restriction setup is then not allowed to access categories (departments) in sites for which they have not explicitly
been granted access. In addition, the CDB offers many item level reports for a site or selected sites to track
overstock, dead stock, and movement of inventory. If a PO is generated at the Home Office, it will appear in the
respective CDB site when operating with the Local Corporate or Sunray configuration.
EDI Enhancements
- Added a Receive and Convert button to the EDI Conversion window.
- Added support for the 2005 Sunrise and GTIN projects to use EAN (GTIN-13) and ITF (GTIN-14) bar codes.
- A new check box has been added to apply combo items as shipper items. Converting as combos will not track purchase of
"child" items. Converting as shippers will track purchase of "child" items.
Transfer Inventory Between Sites
A new feature (controlled by access level such as Category Manager) will allow local corporate and Sunray/ASP users
to identify item level inventory across the enterprise and transfer it from one site to another automatically.
Reorder Reports Now Support Multiple Site Operators
This option permits the operator to generate a Reorder report by site, by zone, or globally using the min/max
values set in Inventory Maintenance, sales history from a date range, or manually creating a reorder by selecting
a range of departments. When used for multiple sites, all the items for each site will be listed and totaled by
department.
General Ledger Bridge Support
We now offer G/L Bridge files for: MIP Fund Accounting, Great Plains, MYOB Plus, MAS 90, RealWorld, ACCPAC, a report,
DacEasy Accounting, AES/2000/GL, QuickBooks, Peachtree, BusinessWorks, S*T*A*R*S, Creative Solutions Accounting, and
Micro Business Applications (MBA) accounting systems.
Accounts Receivable and Accounts Payable Bridge
This option requires the A/P Export and A/R Export modules. In V7.3.7, you can also send collections and payments from
the CDB to QuickBooks, MAS 90, or BusinessWorks Gold. An A/P Bridge for MIP Fund Accounting software is also now available.
QuickBooks G/L Batch Support
The G/L Bridge Options now allows QuickBooks G/L output files generated by the program to contain an arbitrary number
of journal entries before the final post variance line.
Purchase Order Exception Report
This report compares the delivery (which may have come from EDI, HHT, etc.) to the open order (CAO) transaction.
It will produce reports that identify new items, price increases and price decreases between the order and delivery.
In addition, the operator can select a report that lists quantity ordered versus quantity received with any exceptions
and price quoted versus price billed.
Alerts
This is the first of many scheduled reports for tracking the activity at the POS. The site manager will use a predefined
set of criteria limited by the POS and build a profile for the CDB shift to send an alert message when the criteria
matches or exceeds the profile. When the End of Shift Process option is selected, the CDB generates a report that
shows all the critical parameters established by the user have been reached on the shift. Alerts can be sent to the
manager via e-mail, PDA or pager.
Alert criteria include: Cash Balance Over/Short, Maximum Sales Variance (between POS data and CDB), Fuel
Inventory Allowable Variances by Product, Voids, No Sales, Minimum Customer Count, Minimum Average Customer Sale,
and Discounts. A user has the option of halting the End of Shift Process until the alerts are cleared.
User Must Type Invoice Numbers on Paidouts
A new check box option will force the user to enter an invoice number on a paidout transaction when this box is selected.
This will help accounting determine if the invoice was paid and if it was authorized. This check box will be selected
and not alterable when the A/P Export is set up.
WAM Updated After Every Fuel Invoice
Now the Fuel Manager will recalculate the WAM when the Post Inventory check box is selected and when the payment is
closed for each fuel invoice. This will give you a very up-to-date WAM--even when you leave the invoices open for a
period of time and then close them all on one shift. This process will use the delivery date and go back to the drop
date and recalculate the WAM when you pay for the fuel.
Fuel Inventory by Site Across the Enterprise
A date range selected report that will list the tank inventory by product by site across the enterprise is now available.
Fuel Price by Site Across the Enterprise
A date range selected report that will list the price for each product by site across the enterprise is now available.
Unverify Deposits and Payments in Current Assets
Deposits and Payments can now be unverified.
Trend Reports
Management will have the opportunity to generate a trend analysis. The analysis will be available in both text and
graph format for any date range.
Note: You must have a POS device that captures this type of data and it must be downloaded and posted
from the poller interface to the CDB or you will not be able to use this feature. Poller interfaces that support this
feature currently are G-PollWin, N-PollWin, P-Poll, R-Poll, and V-PollWin.
Below are trend features currently supported by POS and CDB:
G-SITE:
NRGT
NetNRGT
NetSalesValue
DiscountsCount
DiscountsValue
TaxesCollected
TaxableSales
VoidsValue
NoSalesCount
Nucleus::
CustomerCount
RefundsValue
RefundsCount
VoidsValue
VoidsCount
DiscountsCount
DiscountsValue
TaxableSales
TaxExemptSalesValue
Passport::
SafeDropValue
RefundsValue
RefundsCount
PayoutsValue
PayinsValue
NRGT
NetCarWashSales
DiscountsValue
DiscountsCount
NoSalesCount
VoidsValue
VoidsCount
RefundsValue
RefundsCount
FuelDiscountsValue
FuelDiscountsCount
TaxableSales
TaxesCollected
MOPSalesValue
MOPSalesCount
REGAL Touch::
PayinsValue
PayoutsValue
SafeDropValue
SuspendCount
SuspendValue
MoneyOrderCount
MoneyOrderValue
MoneyOrderFeesValue
NoSalesCount
RefundsCount
RefundsValue
CorrectionsCount
CorrectionsValue
OutsideFuelSalesValue
Ruby::
ItemCount
CorrectionsCount
CorrectionsValue
VoidsCount
VoidsValue
SuspendCount
SuspendValue
SuspendVoidCount
SuspendVoidValue
ReserveStopCount
ReserveStopValue
ReserveStopApproveCount
ReserveStopApproveValue
InsideFuelSalesValue
RefrigeratedDiscountsValue
MerchandiseSalesValue
OutsideFuelSalesValue
IncludedTaxesValue
TaxesCollected
InsideNRGT
InsideNetNRGT
OutsideNRGT
NegativeTaxValue
NegativeDiscountsValue
FuelSalesValue
RefundsCount
RefundsValue
PromotionsCount
PromotionsValue
TaxExemptSalesValue
PayinsValue
PayoutsValue
SafeDropValue
BottleReturnValue
BottleReturnsWithoutSalesCount
BottleReturnsWithoutSalesValue
MoneyOrderCount
MoneyOrderValue
MoneyOrderFeesValue
CustomerCount
RefrigeratorDiscountsValue
MOPSalesCount
MOPSalesValue
CashSalesCount
CashSalesValue
CreditSalesCount
CreditSalesValue
DebitSalesCount
DebitSalesValue
User Setup
User Names are now sorted in alphabetical order rather than in the order they were initially typed.
Restrictions
Now many menu options can be restricted by the Setup Security operator, including many of the report options.
Note: User Restriction setup has moved from CDBWin Settings.
Competitive Fuel Price Survey
This feature allows you to set up competitive price profiles in your marketing area. It will compare your
prices to any or all of the competitors presenting price differences over time. The data can be presented
as text or graphically displayed. Over the same time period the graphical report presents volume sales so
you can see how the price difference between any or all of your competitors affects volume of fuel sold.
When used with the Volume Profit Projection program, you can quickly and easily determine where you want
your fuel prices to be. This file can also be exported in ASCII and other report formats to third party
tools.
A/P Distribution Report
This report will be available by account and by Vendor. It displays Account, Vendor ID, Invoice #, Invoice
Amount, Amount Paid, etc. Run this report from the Home Office if you have the Home Office package.
New General Features:
Lottery
The CDB will now permit easy tracking of lottery activity regardless of how the sale was made. The CDB will
provide reports to track state lottery sales and commissions as well as instant lottery and machine sales.
The CDB generates a comparison of the lottery sales downloaded from the POS and compares it to the sales that
would be generated based on what is gone and displays the quantity and dollar amount on the screen for easy
reconciliation.
Item Adjustment Feature Changes
A user can not select items in Item Adjustment unless they are in the "Apply Mode".
Minimum Reorder Quantity is now labeled Min. Purchase Qty on the Item Adjustment window.
Applying Discounts
The operator can apply a discount to all selected line items with one command or identify selected items to
which to have the discount applied. Parts or services or both can be filtered when applying discounts.
New Vendor ID Sort Option in Purchases/Payables
We have added the ability to sort by Vendor ID in Purchases/Payables Invoice Open and Reversal Open windows.
Fuel Delivery Total Cost by Gross or Net
Fuel Delivery Total Cost can be based on gross or net gallons. The program will remember the method you selected
when you choose the 'Pay On' selection.
UST Reports
The operator can select a summary total for any number of days. For example, in New York a ten-day summary is
required; in other states a seven-day summary is required. Now the operator can set any number of days for the
summary report.
Fuel and Water readings for Manifolded Tanks
We have added Fuel Depth 2 and Water Depth 2 to Shift and MTD Fuel Inventory reports. A second tank chart may
be set up.
Customer Discounts
CDB now permits user to setup a percentage discount and apply it to the statement when printing for individual
customers. Discounts are setup from Customer Maintenance and typing a discount in the Discount box for that customer.
Sales to this customer (tagged and shift ended) are then discounted when doing A/R Register/Statements when the user
types apply in the dialog box to apply finance changes and discounts. This creates a negative sale for the amount of
the total discount for that customer. This discount is then applied and appears on the next statement after end of shift.
Additional Vendor Terms
New Vendor Terms have been added including: Day of Month {day1} {day2}, End of Month, and End of Next Month. This only
affects the Due Date for A/P Invoices. If Day of Month is selected, invoices dated before {day1} will be due on {day1},
and invoices dated after {day1} will be due on {day2}. For example, if {day1} is set to 15 and {day2} is set to 28,
and the invoice is dated the 19th, the invoice due date will be set to the 28th.
Reprint of A/R Statements
Whenever A/R Statements are printed, the current date and time is recorded. The exact same A/R Statements can then be
reprinted by selecting the original print date and time in the new Reprint Date field.
Taxable Sale Report
There is a new report for any date range that will list only taxable sales, what the tax would be if calculated against
those sales, and the actual tax amount collected.
Purchase Order (PO) Required option ddded to Paidouts
A new PO box has been added to Paidout transactions accessed via the Daily Work menu, Purchases/Payables.
The PO number appears in the Purchase Exceptions window.
Mandatory Vendor ID and Invoice Number Setup on Paidouts
Added to CDBWin Settings are two new check boxes. One is Require vendor on paidouts and the other is Require invoice
# on paidouts. If G/L A/P Export is enabled, the Require invoice # on paidouts check box is automatically selected and
cannot be cleared.
Alphanumeric Postal Codes now supported
Added for addresses outside the U.S.
Number of Rollover Digits for Fuel Sales Money/Volume
In the Fuel Level/Grade Setup window (Setup, Fuel, Level/Grade) there is a new box to support number of rollover digits for
totalizers. Use this box when the totalizer entered is a sum of multiple dispensers, otherwise leave it blank. The value to
use is the number of digits on each dispenser before rollover.
Report Changes/Additions
- The Fuel Sales report now shows open meter total from starting date for totalizers.
- Sales (Closed) shift report now shows method of payment totals.
- Deactivated items are omitted from the Inventory: Reorder report.
- A new Inventory: Turns report has been added.
Sunrise 2005 Project
CDBWin is 2005 Sunrise compatible. Existing U.P.C. bar codes will continue to work after January 1, 2005. Contact
your vendor to confirm the vendor can send EAN bar codes to CDBWin 7.3.7's new EDI specification which supports EAN
bar codes for 2005 Sunrise compatibility.
New Auto Repair Features:
NAPA On-Line
If you buy parts from NAPA parts house you can now go on line to check availability and cost of items needed to complete
the estimate. If you local store does not have the part, you can look into his distribution center to see if they have the
part which you can request on your order. The program includes a vehicle category by year make and model and all
aftermarket parts required to complete a job. This feature requires the NAPA PartsPRO Catalog interface module. You will
need to make arrangements with your local NAPA stores to use this option.
Estimates and Final Work Orders
Now the operator can select different number of copies for estimates and work orders. To set this up, open the Setup
menu, and click CDBWin Settings, the Work Orders tab. The date and time the estimate or work order was printed now
appears on the work order or estimate.
Follow Up Notices
Now the operator can select follow up notices based on number of miles driven versus months between services.
The number of miles driven will be calculated by the CDB Customer Follow-up and Vehicle History modules. The Months box
is still valid and if the number of months entered elapses before the number of miles entered is driven, the follow-up
will still be generated. This feature requires that you type the odometer reading on at least two work orders before it
will be useable as this allows the program to calculate the average number of miles driven in a month. Follow-up notices can
now be sent using e-mail with proper setup. This requires the customer have an e-mail address entered in Customer
Maintenance. There is also a check box on in Customer Maintenance to send follow-ups via regular mail only (even though
the customer may have an e-mail address). The E-mail customers which have e-mail address and print others check box on
the Follow-ups/Labels/Specials form must also be checked to send the follow-ups through e-mail.
Vehicle and Employee ID in Canned Sales
If entered, the vehicle and employee information is now part of this time saving feature.
Department Vehicle Totals and Averages Report
A new report has been provided to present average money per transaction over a date range by department separating
vehicle sales from non-vehicle sales. The report also contains sale totals and average money per vehicle totals.
Work Order Revisions
A new revisions form has been added which allows the user to track work order revisions and new authorized work order
amounts as well as comments.
New Appointment Date/Time Box Added to Sales
An Appointment Date/Time box has been added to Sales. The appointment will appear in the Open window at a time
you determine prior to the appointment. If the current time is within the display appointment window for each open
invoice, those invoices appear in the Sales Open box, otherwise they do not appear. A toggle to display all invoices
regardless of appointment time is also available on the Sales Open box.
Odometer Out Box Added to Sales
An Odometer Out box has been added to Sales.
CDBWin Department for Parts and Labor When Using ALLDATA Interface
This feature allows the user to map the ALLDATA estimate items for parts and labor to the appropriate CDBWin department
when creating sales from estimates in the ALLDATA system.
Custom Properties for Vehicles
Custom properties (called codes) can now be added to vehicles. For example, vehicle codes might be 4x4, Auto, Manual,
or whatever the user wants. A Setup Codes button has been added to Vehicle Maintenance to add your own codes.
Production Date for Vehicles
Added to the Vehicle Maintenance (Setup, Vehicle) is a production date box. This is helpful in ordering correct parts
for a vehicle with more than one production date within a year.
Service's Subdepartment and Default Follow-up Form
A Service/Labor ID can now be assigned to a subdepartment. A default Form Letter ID can now be set for each service
so when the service is selected, the appropriate follow-up is added to the sale automatically.
New Work Order Settings
The CDBWin Settings Work Order tab (Setup, CDBWin Settings) now has a variety of additional settings including:
- when printing an estimate the system will warn the user if the Odometer In box was not completed
- when printing a final work order the system will check first if payment is required in order to print
- when printing a final work order the system may require Odometer In/Out boxes to be completed before it will print
- when printing a final work order the system may be configured to set the Date Out to the current date
- when printing a final work order the system may be configured to require Employee ID on line items
- may set up default nonstock parts department and default labor department
- may allow subdepartments for nonstock items
- may be configured to associate Customer ID, Employee ID, and Vehicle ID with Canned ID when saving canned sales
New Pollers/Features:
- E-Poll for Sam4s ER-650
- V-PollWin for VeriFone Ruby, Ruby-Sapphire, Topaz-Sapphire systems
- W-PollWin for Wayne Plus
- CFN-Poll (fuel money/volume, commercial card data) for CFN POS
- P-Poll for Gilbarco Passport, includes support for NACS XML v3.2, fuel price and department maintenance editor,
and viewer features
- R-Poll for AutoGas REGAL Touch, includes support for A60 Commercial Card
- T-Poll for Comdata Trendar, includes support for posting sales, inventory import, updating items from BOS PC
- N-PollWin for Wayne Nucleus, includes support for new fuel inventory record, EAN bar codes
 | 
