new version 9.0 · daily sales, to report current value of inventory as of the selected date. note:...

25
Page | 1 New Version 9.0.0 Contents General Updates ......................................................................................................................................................................3 Payroll ..................................................................................................................................................................................3 Affordable Care Act .........................................................................................................................................................3 New Receivings Process* ....................................................................................................................................................3 Open Invoice View ...............................................................................................................................................................4 Sales Tickets.........................................................................................................................................................................5 Sales Volume View ..........................................................................................................................................................5 Emailing Statements ........................................................................................................................................................5 Sales Category Totals View ..................................................................................................................................................5 C-store .....................................................................................................................................................................................6 Inventory .............................................................................................................................................................................6 Sales & Purchases at Cost View* .....................................................................................................................................6 Roll Forward/Backward Audit View*...............................................................................................................................6 Vendor Receiving Conversion Factor View..........................................................................................................................7 Management Tools..............................................................................................................................................................7 C-store Secondary Sales View..........................................................................................................................................7 Inventory Management View ..........................................................................................................................................8 Projected Sales Report* ..................................................................................................................................................9 Weekly Margin View*......................................................................................................................................................9 Audit View Report* ...................................................................................................................................................... 10 Cash Long/Short View*................................................................................................................................................. 12 Deli Profit & Waste View* ............................................................................................................................................ 12 Management Comparison View* ................................................................................................................................. 13 Projected Sales Budget* ............................................................................................................................................... 13 MSO Report View* ........................................................................................................................................................... 14 Passport ............................................................................................................................................................................ 17 Archiving Mix and Match* ............................................................................................................................................ 17 Promotions View .............................................................................................................................................................. 18 New Gross Margin View for C-stores* ............................................................................................................................. 18

Upload: others

Post on 18-Jul-2020

0 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 1

New Version 9.0.0 Contents General Updates ......................................................................................................................................................................3

Payroll ..................................................................................................................................................................................3

Affordable Care Act .........................................................................................................................................................3

New Receivings Process* ....................................................................................................................................................3

Open Invoice View ...............................................................................................................................................................4

Sales Tickets .........................................................................................................................................................................5

Sales Volume View ..........................................................................................................................................................5

Emailing Statements ........................................................................................................................................................5

Sales Category Totals View ..................................................................................................................................................5

C-store .....................................................................................................................................................................................6

Inventory .............................................................................................................................................................................6

Sales & Purchases at Cost View* .....................................................................................................................................6

Roll Forward/Backward Audit View* ...............................................................................................................................6

Vendor Receiving Conversion Factor View ..........................................................................................................................7

Management Tools ..............................................................................................................................................................7

C-store Secondary Sales View..........................................................................................................................................7

Inventory Management View ..........................................................................................................................................8

Projected Sales Report* ..................................................................................................................................................9

Weekly Margin View* ......................................................................................................................................................9

Audit View Report* ...................................................................................................................................................... 10

Cash Long/Short View*................................................................................................................................................. 12

Deli Profit & Waste View* ............................................................................................................................................ 12

Management Comparison View* ................................................................................................................................. 13

Projected Sales Budget* ............................................................................................................................................... 13

MSO Report View* ........................................................................................................................................................... 14

Passport ............................................................................................................................................................................ 17

Archiving Mix and Match* ............................................................................................................................................ 17

Promotions View .............................................................................................................................................................. 18

New Gross Margin View for C-stores* ............................................................................................................................. 18

Page 2: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 2

Fuel Marketers...................................................................................................................................................................... 19

Bill of Lading Overview ..................................................................................................................................................... 19

Coop Ledger Comparison View* ...................................................................................................................................... 19

Daily Sales Report ............................................................................................................................................................. 20

Tank Tracking .................................................................................................................................................................... 20

Tank Tracking Calculation ............................................................................................................................................. 20

Tank Rental Agreement ................................................................................................................................................ 20

Fill Type View ................................................................................................................................................................ 22

Tank Tracking Maintenance View*................................................................................................................................... 22

Available for Purchase .......................................................................................................................................................... 23

Advanced Rebates* .......................................................................................................................................................... 23

Vendor Rebate Calculation* ......................................................................................................................................... 23

Lottery .............................................................................................................................................................................. 25

Vendor Contracts .............................................................................................................................................................. 25

*indicates programs that are only effected if running on SQL server

These program enhancements throughout the document are available if the specified program has been purchased

Page 3: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 3

General Updates Payroll Update of 1099 and W-2’s forms for 2015 filing

Affordable Care Act A new Additional Medicare Tax went into effect starting in 2013. The 9% Additional Medicare Tax applies to an individual’s wages, Railroad Retirement Tax Act compensation, and self-employment income that exceeds a threshold amount based on the individual’s filing status. The threshold amounts are $250,000 for married taxpayers who file jointly, $125,000 for married taxpayers who file separately, and $200,000 for all other taxpayers. An employer is responsible for withholding the Additional Medicare Tax from wages or compensation it pays to an employee in excess of $200,000 in a calendar year. The IRS and the Department of the Treasury have issued proposed regulations on the Additional Medicare Tax. Comments may be submitted electronically, by mail or hand delivered to the IRS.

Red River Software now shows the new boxes in the “Setup Payroll FICA Information” section.

New Receivings Process* • Recreated the receivings process for more functionality. • Give certain users specific accessibility to change and manipulate fields. • Allows the user to email manager of the receiving.

The software will send an email to someone when prices on the receiving are different than what is in the pricebook, or if it’s been modified.

Page 4: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 4

To assist you with the changes to the Receivings screen we have created a video.

To access this video go to the Red River Software website (www.RedRiverSoftware.com) – from the top menu bar, click MyRRS

It will then redirect you to a new webpage and ask for a Username and Password

Username: rrscust Password: video123

Once logged in, you will have access to the training videos.

Open Invoice View Displays an “at-a-glance” view of invoice that have not been posted.

Page 5: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 5

Sales Tickets Sales Volume View Now has the option to include history tickets by using a checkbox.

Emailing Statements Add multiple email addresses for Emailing Statements on the Customer Setup screen.

Sales Category Totals View While viewing the Sales Category Totals View there is now an option to select based on the Sales Period or selecting by a Date Range. By selecting Sales Period it allows you to select the Month and Year,** as shown in the image below.

**We don’t have period information for tickets prior to 2012, as we started collecting it in version 8.1.5.

When the Date Range Checkbox is selected there are options for Starting Date and Ending Date.

If both Sales Period and Date Range Checkboxes are selected then you have the ability to select data within both of those ranges.

Page 6: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 6

C-store Inventory Sales & Purchases at Cost View* Displays the purchase price of the inventoried product, the sales cost for the inventoried product, and more (as shown in screen shot below)

Roll Forward/Backward Audit View* • This view shows the inventory values for any given date in time based on the last physical inventory count. • Based on a category, and the date entered for the report, the view summarizes the posted receivings, and

daily sales, to report current value of inventory as of the selected date.

Note: If the individual items are changed manually, using different actual count dates, this could potentially make it difficult to get the correct beginning dollars and displaying the correct purchases/sales information.

From the screen below, select from Roll Forward or Roll Backward, then select whether the type of items should Show All, Show Only Negative Quantity on Hand, or Show Only Positive Quantity on Hand.

Page 7: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 7

Vendor Receiving Conversion Factor View Allows the client to receive the same product from different vendors that could have a different package quantity

Management Tools C-store Secondary Sales View

Page 8: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 8

Inventory Management View Displays total inventory cost and retail based on each sales category

Page 9: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 9

Projected Sales Report* This tool gives the user the ability to see projected sales for locations, by sales categories. Based on sales for the current number of days and averaging for the rest of the months.

Weekly Margin View*

Page 10: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 10

Audit View Report*

Summary – Overview of inventory cost by category

Page 11: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 11

Beginning Inventory Detail – Can click into a category and see the individual items that made up the beginning inventory valuation.

Inventory Purchases Detail – Displays what purchases that occurred to make up the ending inventory value.

Inventory Sales Detail - tab comes from roll forward or Roll back.

Page 12: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 12

Cash Long/Short View* Displays date specific, Cash Long and Short figures.

Deli Profit & Waste View* Displays a particular stores Deli Profit for a given time (specified by user) and the Deli’s waste

Page 13: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 13

Management Comparison View* Determine what store is bringing in the most profit and which store is lacking by comparing multiple aspects of

the storefront within the same time frame.

Some of the compared data includes (but not limited too): Sales, Sales Discounts and Promotions, Cost of Goods Sold, Shrink, Gross Profit, Margin, Labor, Overhead, Over/Short, Profit, etc.

Projected Sales Budget* Display projected sales for locations, by sales categories. Based on sales for the current number of days and

averages for the remainder of the year, by month.

Page 14: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 14

MSO Report View* Summary View – compiles all the other tabs into one condensed view.

Fuel Delivery

Page 15: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 15

Metered Sales

Actual Readings

Credit Card $ and other Cash Info

Page 16: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 16

Fuel Price Survey

Stores

Page 17: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 17

Passport • Red River Software now has the capability

to authorize Orpak’s Fleet Home Office using the Passport.

• Changes to accommodate V10 Passport Credit Card transactions.

• Updated the Loyalty Reward to allow the reward be displayed as a Payment.

Archiving Mix and Match* Mark Mix / Match records as archived or not archived by clicking on a checkbox, in the Archive Mix and Match.

Page 18: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 18

Promotions View Keep track of the current promotions at one glance.

Some of the items that are listed in this view are, but not limited to:

Company name, Manager, Manager Name, Store, UPC Code, UPC Description, C-store Category, Unit Base Cost, Total Base Cost, Total Margin $$, and Margin %.

New Gross Margin View for C-stores* Based on the programs running on your system, the Gross Margin will display the total dollar amount or the total percentage for a specified location, or by a specific manager.

NOTE: in this image, the customer has the Shrinkage & Spoilage modules

Page 19: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 19

Fuel Marketers Bill of Lading Overview Gives an “At a Glace” view of the customer’s information.

Some of the columns not displayed are (but not limited too):

Cost/Gallon, Difference, Margin %, Sales Ticket #, AP Vendor Invoice Number, AP Paid Date, AP Paid Amount, Customer Name, Ship To Name, Estimated Cost, etc.

Coop Ledger Comparison View* This view is based on the Operations by Commodity report in Coop Ledger. This view compares multiple periods

as well as multiple years.

The information that displays will be the account, department, location, description, and year, followed by columns for Sales, Cost of Sales, etc.

Page 20: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 20

Daily Sales Report When running the Daily/Monthly Sales Report there is an option to select by “Sales Period Month/Year.” This helps nail down the data by allowing you to select the “Month” and “Year” the data should come from.

Tank Tracking Tank Tracking Calculation

Modified the degree day history reset process so that the history is stored. This will give us the total degree days passsed, regardless of how many heating seasons we have been through.

Tank Rental Agreement Added Tank Rental Agreement on File to Tab 1 of Tank Information

Page 21: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 21

Included the Print Option for the Tank Location Report

Now displays the “Rental Agreememt on File” column header in the Fill Type View.

Page 22: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 22

Fill Type View Now includes the option to input the ‘Bill To’ information so that it displays on the screen.

Tank Tracking Maintenance View* Provides a report option that displays multiple sorts on the same data and submit the information that is being

requested by the auditors.

The data combines information from the maintenance tab (tab 4) and the hardware tab (tab 5). By combining these tab it displays how often gas leak checks are being done as well as displays the age of regulators.

This view could also provide the ability to run regulator manufacturing information in the event of a recall for faulty equipment. A General Manager can track how effective their drivers or maintenance personnel are at performing service tasks by verifying that the spot checks are being performed

Page 23: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 23

Available for Purchase Please contact your salesmen for more information on purchasing the following programs.

Advanced Rebates* Ability to handle odd rebates requests, such as; must have items in set number of stores, minimum number of UPC's, off the vendors cost that may not be cost that client pays, case rebate versus individual price can vary, and etc.

Vendor Rebate Calculation*

Created a column for Rebates that will hyperlink to the Rebate Id and show all UPC/locations setup on the rebate. The Hyperlink in the rebate amount will show a detail of how that rebate amount was calculated. On the item tab, the hyperlink on the UPC code will show the detail by date for that UPC/location.

Rebates setup screen

Rebate ID – insert a ID for the rebate

Rebate Description – create a description for the rebate

Vender Reference – select from drop down the vendor for the rebate

Vendor Name – based on Vendor Reference the Vendor Name will be populated

Percent or Dollar – select from drop down whether the rebate should be a percentage or a dollar amount

Sales or Purchases – select from drop down whether the rebate should be for sales or purchases

Quantity or Dollars – select from drop down whether the rebate should be for the quantity or a dollar amount

Minimum – enter an amount for a minimum amount

Cases or Units – select from drop down whether the rebate should be for the case or the individual unit

Start Date – enter the date that the rebate will start

End Date – enter the date that the rebate will conclude

Here are the different rebates that can be calculated…

1. 3% of purchases/sales 2. 3% of purchase/sales up to $500,000, 5% of purchases/sales $500,001 to $1,000,000 and 10% of purchase/sales

> $1,000,000

Page 24: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 24

3. $1.00 on each purchase/sale/Case 4. $1.00 on each purchase/sales/Case up to $500,000, $2.00 on each purchases/sales/Case $500,001 to

$1,000,000 and $3.00 on each of purchase/sales > $1,000,000 5. 2% of sales/purchases if the company makes at least $500,000 of annual purchases/sales, 3% of purchases/sales

if the company purchases/sells $500,001 to $1,000,000 and 10% of purchase/sales if the company purchases/sales > $1,000,000

6. Slotting $X per store

By clicking on the down arrow you can view the different types of rebates that have been entered into the system. By selecting specific rebates you can then view how the rebate faired.

From the Management View you can view the dollar amount the rebates generated for a specific item.

Page 25: New Version 9.0 · daily sales, to report current value of inventory as of the selected date. Note: If the individual items are changed manually, using different actual count dates,

P a g e | 25

Lottery Created a more stream lined process for receiving and counting Lottery tickets

Vendor Contracts Created a module to track contracted gallons from a vendor. Then thru BOL have gallons received effect gallons remaining on contract.