POS (Point Of Sale) Setup

Setup Steps

Organization – Address

One of the first steps in setting up CBOS to process point of sale transactions for a given organization is to add or update the Organization address information. 

Since POS Terminals may be located in different tax jurisdictions, a specific tax rate may need to be created for each respective location and associated to the POS Terminal in that jurisdiction. 

The State entered on the address field in the Organization Info tab must match the Region (from) value for every tax rate to be associated with a POS Terminal in that respective Organization. In this example, the Organization is assigned an address in the state of Virginia (VA).  

Menu Path: SYSTEM MENU: Organization (Maintain Organization) > Organization Info 

Tax Rates – Region From

The tax rates associated with POS Terminals are assigned to that terminal based upon the Organization State (Region) and the POS Terminal default Business Partner location. 

In this example, Tax Rates for the Organizations multiple POS Terminals are assigned to the Virginia (VA) from Region. (More tax rate setup information is covered later in this guide.) 

Menu Path: SYSTEM MENU: Tax Rates  

Organization – Point of Sale Configuration

One of the first steps in setting up CentralBOS to process point of sale transactions for a given organization is to add or update the POS Configuration information.

Menu Path: SYSTEM MENU: Organization (Maintain Organization) > POS Configuration

Select to add POS Configuration information. 

POS Configuration

Select More Options > Edit for a highlighted row for review & update

This window allows you to review and update detailed information related to the selected configuration.  

Key Fields:

Name

Description

Admin Roles

Set the Admin role(s) value of the organization. 

Enter semi-colon ";" separated Role Record IDs.

Once configured, only users having admin role access can delete POS tickets. 

If Discount Restricted is enabled (Y) just Admin Roles can perform discounts on SmartPOS. 

Default Business Partner

Set the business partner that will be selected by default in the POS terminal(s) within the organization.

Discount Charge

Select the charge code / account for the discounts applied.

Deposit Charge

Select the charge code / account in case of deposit bank transfer.

Charge Tips

Select the charge code / account for Charge Tips.

Currency

Set the default currency value.

Payment Term

Set the default payment term for POS orders.

Tax Rate For POS

Default tax rate for POS (not in use).

Partner Location

Default location for the selected default business partner.

Price List Version

Set the default price list version; Informational only.

Uses the customer price list if available and if not, uses the associated warehouse price list.

Will display message if no default pricing is found.

List Product Category

The field name actually refers to the product types. (A=Asset, R=Resource, I=Item, etc.)

If the product type is not referenced in this field, the User will encounter an error when attempting to add products of that product type to POS Tickets.

Warehouse

Default warehouse (not in use)

Check Open Orders Time

Delay time for open orders in milliseconds.

Check Orders Time

Delay time to check orders time.

Decimals

Set the decimal point.

Size Image

Set the default size of the image.

Locale

Set the default locale.

List Payment Term

Set the available payment term Record ID’s.

Printers by Group

Set the default printer group.

Printing from client

Check if printing from the client.

Discount Restricted

Check if discount needs to be restricted.

If enabled (Y) indicates that just admin roles can perform discounts on SmartPOS.

POS Tax

Check if POS tax needs to be enable (not in use).

Send Mandatory

Check if Send ticket needs to be mandatory.

Terminal Assigned to Logged in Warehouse only

If the flag is checked:

A User may only access POS Terminals if they have the same warehouse assigned to them as the one logged in from the main login. (Others will not display from the dropdown Terminal selection in the SmartPOS).

If left unchecked, default system behavior will occur, and all Terminals will appear from the dropdown regardless of the warehouse currently logged into. 

This flag must be selected in order to process "SmartPOS Sales Returns".  Otherwise the Terminal selection field will not display any values. 

Warehouse – is POS  

Specific warehouses must be point of sale enabled by selecting the Is POS checkbox. 

Menu Path: SEARCH MENU: Warehouse (Maintain Warehouse & Locators)

Select More Options > Edit for a highlighted row for review & update

Key Fields:

Name

Description

Is POS

Must be checked

Price List

Must select one of the Price list; used if POS customer does not have a price list assigned.

Price list version

Must select one of the Price list version.

Role

Need to select "Client Admin" or "Accounting Admin" or who ever has rights to perform accounting operation.

Document Type

Must be "AR Invoice (SmartPOS)".

Bank

POS Terminal setup is used for assigning the bank and bank account for payments associated with invoices generated from a specific POS Terminal.

Bank Account

POS Terminal setup is used for assigning the bank and bank account for payments associated with invoices generated from a specific POS Terminal.

Select the Locator tabbed window to set a location as the default for this warehouse. 

Menu Path: SEARCH MENU: Warehouse (Maintain Warehouse & Locators) > Locator

Key Fields:

Name

Description

Default

Must be checked

Active checkbox

Must be checked

Business Partner – Sales Rep   

Business Partners who are designated as sales reps may have a discount limit specified.  The discount limit will be enforced when processing POS transactions.

Menu Path: SYSTEM MENU: Business Partner (Maintain Business Partners) > Discount Limit tab

Key Fields:

Name

Description

Discount Limit %

Enter discount limit percentage if applicable.

Effective From

Discount will be applicable only for the defined date range.

Effective To

Discount will be applicable only for the defined date range.

Active

Discount functionality would be applicable only if its checked.

Even though all details specified the discount will not be available for the sales rep.

Users  

Users must link back to a Business Partner and have an email / password assigned.  They must also be assigned a role. 

Menu Path: SYSTEM MENU: Users (Maintain Users of the System) 

Key Fields:

Name

Description

Business Partner

Sales Rep association

Email Address

Sales Rep Login ID

Password

Sales Rep Login Passwords

Active Checkbox

Must be checked

Select the User Roles tab to assign a role to this user. 

Menu Path: SYSTEM MENU: Users (Maintain Users of the System) > User Roles tab

Name

Description

Role

Sales rep must have required role to perform accounting actions for POS.  Roles such as "Client Admin", "Accounting Admin".

Log in as a POS User

Select Org and Warehouse for POS transactions. The organization must be setup for POS transactions and the warehouse must be enabled for POS transactions.  The user must be a business partner, sales rep, and setup with an appropriate role.  Only POS Terminals associated with the log in Warehouse will be selectable for POS transactions.  The user must also be assigned to the POS Terminal to enter orders in there. 

Bank Accounts/Credit Cards

The bank account and credit card account are assigned to each respective POS Terminal that is setup. 

Menu Path: Financials > Financial Data > Bank Accounts/Credit Cards  

Bank Accounts/Credit Cards > Grid View

This tab defines a bank that is used by an organization or business partner. Each bank is given an identifying Name, Address, Routing No and Swift Code.  Bank and credit card information may be added and updated in this window.

Bank Accounts/Credit Cards > Edit

Field Definitions:

Name

Description

Organization

An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.

Name

The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.

Description

A description is limited to 255 characters.

Active

There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record.

Address

The Location / Address field defines the location of an entity.

Own Bank

The Own Bank field indicates if this bank is for this Organization as opposed to a Bank for a Business Partner.

Routing No

The Bank Routing Number (ABA Number) identifies a legal Bank. It is used in routing checks and electronic transactions.

Swift code

The Swift Code (Society of Worldwide Interbank Financial Telecommunications) or BIC (Bank Identifier Code) is an identifier of a Bank. The first 4 characters are the bank code, followed by the 2 character country code, the two character location code and optional 3 character branch code. For details see http://www.swift.com/biconline/index.cfm

Account Tab > Grid View 

The Account Tab is used to define one or more accounts for a Bank. Each account has a unique Account No and Currency. 

"POS Terminals" are assigned a bank account and specific cash account within that bank. 

Account Tab > Edit

Name

Description

Organization

An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.

Account ID

A search key allows you a fast method of finding a particular record.

If you leave the search key empty, the system automatically creates a numeric number.

Account Name

The name of an entity (record) is used as a default search option in addition to the search key. The name is up to 60 characters in length.

Bank

The Bank is a unique identifier of a Bank for this Organization or for a Business Partner with whom this Organization transacts.

Account No

The Account Number indicates the Number assigned to this bank account.

 

BBAN

The Basic (or Domestic) Bank Account Number is used in Bank transfers (see also IBAN). For details see ISO 13616 and http://www.ecbs.org/.

IBAN

If your bank provides an International Bank Account Number, enter it here.

The account number has the maximum length of 22 characters (without spaces). The IBAN is often printed with a space after 4 characters. Do not enter the spaces. 

Description

A description is limited to 255 characters.

Active

There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports. 

Default

The Default Checkbox indicates if this record will be used as a default value.

Currency

Indicates the Currency to be used when processing or reporting on this record.

Bank Account Type

The Bank Account Type field indicates the type of account (savings, checking, card, or cash) this account is defined as.

For POS use assign the type as "Cash".

Credit limit

The Credit Limit field indicates the credit limit for this account.

Payment Export Class

null

Current balance

The Current Balance field indicates the current balance in this account.

POS Terminal

The point of sale terminal will be used to record sales transactions.  The POS terminal is associated with an organization and warehouse. 

Menu Path: SEARCH MENU: POS Terminal (Maintain Your Point of Sale Terminal)

Key Fields:

Name

Description

Organization

Must be selected for which POS configuration done in above steps.

Active Checkbox

Must be checked

Bank Account

Bank account which is assigned to this POS Terminal; used for creating payments associated with invoices generated from sales at this terminal. 

Cash Account

Select "Cash" account as added in above steps ( all cash accounts will be displayed in the dropdown); used for creating payments associated with invoices generated from sales at this terminal.

Price List

Required field; Informational only

Warehouse

Select from dropdown for which POS configuration needs to be done.

Used for finding a price list when POS customer is not assigned a price list.

Use POS Location for Tax

If checked, the Default Business Partner location will be used to determine the "To" region (State) for Tax Rate assignment.

Default Business Partner

Used to find the "Ship To" location for tax rate assignment; the default business partner will have a location address the same as the POS Terminal; the tax rate will be determined by the POS terminal location.

Select the User tab to link the sales rep to the terminal  

Menu Path: SEARCH MENU: POS Terminal > User

Only these Users/Sales Reps will be able to access this POS terminal which has been defined here. Multiple Users/Sales Rep can be assigned for 1 terminal.

Key Fields:

Name

Description

User/Contact

Select the Sales Rep User to assign the terminal.

Active Checkbox

Must be checked

Products – POS Settings

The product POS Settings window allows the user to specify if discounts are allowed for a given product and if you "buy one you get one free".

Key Fields:

Name

Description

Discount Allowed

Discount field will get enabled at POS ticket for the product only if this checkbox is checked.

Buy One Get One Free

If this checkbox is checked then at POS ticket > user have to enter product qty in odd numbers only and price would be calculated for half of the qty.

Ex. Product price 10 and qty added 4: Actual total = 40

but as Buy 1 get 1 checkbox checked: Total = 20.

POS Tender Type

The POS tender type is referenced on POS transactions and may include cash, credit card, and checks. Tender types are defined at client level. Tender type can be specified in System Configurator window as below.

Tender types supported by POS may include "cash", "check", and "credit card".

Menu Path: SEARCH MENU: POS Tender Type

Key Fields:

Name

Description

Search Key

Cash, check, or credit card.

Name

Descriptive

Tender Type

Cash, check, or credit card.

Active

Must be selected to be used.

POS - Sales Tax 

The POS application can be setup to calculate sales taxes based upon the specific location of the POS terminal or the actual customers ship to location referenced on respective sales orders created at that terminal. This determination is based upon the "Use POS Location for Tax" setting in the POS Terminal window. 

POS Terminal Settings

If "Use POS Location for Tax" is checked, the system will use the location of the Default Business Partner, also assigned to the POS Terminal to determine the sales tax rate to use.  If not checked, it will use the customer assigned to the POS order to determine the sales tax rate to use. 

Each POS Terminal must have a Default Business Partner assigned to it. "Use POS Location for Tax" will be checked by default and it is a non-updateable field. 

Menu Path: SEARCH MENU: POS Terminal

Default Business Partner Setup

In order to implement this feature, default business partner (customer) records will need to be created with their location record having the physical address of the POS Terminal they will be assigned to.  In the example below, the customer location record will have the physical address of the Alexandria, VA POS Terminal it will be assigned to. 

Menu Path: Sales > Sales Data > Customers

Customer

Customer > Location

The tax will be calculated on the basis of location of Default Business Partner associated to respective POS Terminal.   

POS Tax Rates

Tax rates needs to be defined in Tax Rate window such that location specific tax will always have ‘Region From’ same as that of Organization's Region. ‘Region To’ value will be the state for which the POS Terminal tax needs to be calculated.

For example, The Tax "BLK VA" will have "Region From" value as "VA" (as the Organization region is VA) and "Region To" value as "VA" (since the POS Terminal is located in Virginia).  Make sure that the "Parent Tax" is empty for taxes. 

The tax will be calculated on the basis of the location of the Default Business Partner associated to respective POS Terminal. 

Menu Path: SEARCH MENU: Tax Rates

POS Tax Rates – for non-taxable items

You will need to create separate location specific taxes as explained above for Non-Taxable products with tax rate as 0. These tax rates will be assigned a Tax Category of "No Sales Tax", which can be assigned to non-taxable products. 

After doing the configuration explained above, taxes will be calculated as follows:

  • The tax will be calculated on the basis of:
    • Region From - The tax rates associated with POS Terminals are assigned to that terminal based upon the Organization Region (State)
    • Region To - The location of the Default Business Partner associated to a respective POS Terminal

Similarly, for the No Sales Tax products, the No Sales Tax defined for that particular location will be applied.

If the POS terminal does not have Default Business Partner defined then it will show an error message saying "Please configure Business Partner in POS Terminal window".

SmartPOS will give a "No Tax Found" error if:

  • The Tax Rate is not defined
  • The "Region From" location in Tax Rate window is not the same as Organization region
  • The "Zip From" in Zip tab of Tax Rate window is not the same as Organization zip code

The Tax Exempt checkbox on the SmartPOS window will exempt all taxes on the ticket.

The total applied tax on the products will be visible at the bottom right corner of SmartPOS window. Products specific tax rates will not be displayed.

Smart POS Document Type

The Smart POS document type is assigned to sales orders created through the Smart POS window.  The ‘Smart POS’ document type should be configured as follows.

Menu Path: SEARCH MENU: Document Type

Key Fields:

Name

Description

Name

Smart POS 

Sales Transaction

Selected (check marked)

Document Base Type 

Sales Order

SO Sub Type

Leave blank

Document Type for Invoice

AR Invoice (SmartPOS)

Document Type for Shipment

MM Shipment Indirect

Print Format

Custom SmartPOS Header (configurable)

POS Key Layout 

Not currently used in the system.

Menu Path: SEARCH MENU: POS Key Layout

POS Payment

Not currently used in the system.

Menu Path: SEARCH MENU: POS Payment

POS (point of sale) Transactions

Processing Steps

Smart POS

The Smart POS application can be used to enter and process customer sales and payment transactions. 

Menu Path: Sales > Transactions > Smart POS

This brings you to the "landing page", which allows you to select which Terminal to enter (if you have access to more than one), and to view any open tickets that remain within that Terminal. 

In order to work on open tickets, highlight the one you would like and click Select at the bottom of the page. This then takes you to the detail screen of that ticket. Here you can finish the ticket, add or delete items within the ticket, or delete the entire ticket.

From the "landing page" you can also click New in order to start a new ticket or just double click anywhere on the terminal and it will create new ticket. 

Fill in the Customer information (you can either type in the name of the customer or click the green circle to do a system search) and Sales Date (will default to today).

By default, the customer will be populated which is set as "Default Business Partner" in Organization > POS configuration window. 

Next, click into the Product field. Here you can either type in the name of the product, click on the green circle to do a system search, or use a scanner to scan the product into the field.

Once you have the product entered, select Enter on your keyboard to move the product into the detail line. If you are scanning the product will automatically move to the detail line as you scan.

To change Quantity, manually type in the number in the QTY column, highlight the product and click on the icon or continue to scan the same item to increase the QTY. 

If at any time, you wish to delete a line of product highlight the product line and click Delete Product.

Product default pricing is based upon:

  • The Customer assigned price list if available and assuming product is assigned to it
  • If no customer price list for product, then look for price list assigned to the Warehouse associated with the POS terminal
  • If product is not referenced on either price list, then a message will display that no default pricing is available

If at any time, you wish to delete the entire ticket, simply click Delete Ticket.  Delete capability is controlled with the Organization > POS Configuration admin setting covered previously. 

If you just want to go back and create new ticket without doing further action like payment then click on Close POS button > user is redirected to POS Terminal where this ticket would be displayed in the list. 

Taxes will be calculated as follows:

  • The tax will be calculated on the basis of location of Default Business Partner associated to respective POS Terminal
  • Similarly, for the No Sales Tax products, the No Sales Tax defined for that particular location will be applied
  • If the POS terminal does not have Default Business Partner defined then it will show an error message saying "Please configure Business Partner in POS Terminal window"
  • SmartPOS will give No Tax Found error if:
    • Tax Rate is not defined
    • The "Region From" location in Tax Rate window is not the same as Organization region
  • The Tax Exempt checkbox on the SmartPOS window will exempt all taxes on the ticket
  • The total applied tax on the products will be visible at the bottom right corner of SmartPOS window. Products specific tax rates will not be displayed

To mark this ticket as Tax Exempt, place a checkmark in the Tax Exempt field and then enter the FEIN number.

Note: If you want to specify a customer for tax exemption for all the POS tickets which would be created for them then
Menu Path: Sales > Sales Data > Customers 
Select the SO Tax Exempt check box and provide value for the Federal Tax ID

Whenever this customer selected on POS ticket – Tax Exempt check box will be auto checked and FEIN number also auto populated as per filled in customer details.

To apply a line level discount, highlight the product line, click Discounts and enter the "dollar amount" or "% being discounted". If percentage is not checked, the value is considered dollars. 

The discount button availability is controlled in the organization "POS Configuration". 

Or if the discounts button is not displayed, just enter the discount value as a dollar amount or select the percentage check box in the detail product line to enter the amount as a percentage.

Validation is applied that Sales rep cannot exceed its limit for applying the discount specified at Business Partner level.

Payment Processing

When ready to accept payment, click Pay.

This opens up the payment screen, where you can put in the Tender Type and Amount Received. Tender types may include cash, check, and credit card.

When ready, click Add Payment

Once you click Add Payment, the system will let you know how much change to give (If cash was chosen as the tender type).

If tender type of Check is chosen, the system will open up fields to put in the check information.

Key Fields:

Name

Description

Check No

Required: Assigns entered value as Payment No on Payment record

ID#

Required: Assigns entered value as Check Id# on Payment record

Other Check Related Fields

Optional: Information is not required

If tender type of Credit Card is chosen the appropriate fields will display as well. 

Key Fields:

Name

Description

Credit Card Type

Required: displays on Invoice and Payment record

Authorization Code

Required: displays on Receipt and Payment record

When the transaction is complete, click OK.

Multiple tender type payments in 1 ticket are allowed.  In this example, both cash and credit card payment were accepted for a single ticket. 

Receipt Printing

Once OK is clicked, the "Receipt" for printing will appear. Click the printer icon in the upper right corner to print the receipt.

When you click back on the SmartPOS tab at the top, you will now be back at the "Landing Page" to click New for another transaction. 

Credit card receipts will print the Authorization Code entered in the Payment window, as shown below:

Receipt Emailing

Select the envelope icon in the light gray tool bar to email the receipt. 

This will pop-up the Send Mail window shown below. The receipt will be attached as a pdf file and notes may be added to the email body.  Additional documents may be attached to the email by selecting the paper clip icon in the lower gray bar.

The To and Email fields will display the customers’ default contact if one exists, otherwise you may manually enter a name and email address.  This email process applies to all documents within CBOS.  

Other Transactions

Cash Movements

The Cash Movement application can be used to enter and process transactions moving cash from one terminal to another and for adjustments to a closed cash end of day report. 

Menu Path:   Sales > Point of Sale > Transactions > Cash Movements

This brings you to the cash movement screen, which allows you to select the terminal, movement type (in or out), and dollar amount that you are moving in or out of the selected terminal. 

Cash In:

Cash Out:

Select Process to complete your transaction.

Adjustments

Adjustment entries to the End of Day Close Cash can be made using the Cash Movements window and selecting the Adjustment check box.

Then select the Close Cash end of day to associate the adjustment with.

The End of Day Report End of Day Report Line tab displays the adjustment to close cash:

Sales Returns

The Sales Returns application can be used to enter and process transactions for goods and services being returned from a customer. 

Menu Path: Sales > Point of Sale > Transactions > SmartPOS Sales Returns 

This brings you to the sales returns screen where you can either enter or search for the invoice you wish to process a return against. 

First, select the Terminal that you wish to process the return against.  The terminal selection list includes terminals associated with your logged in warehouse and the POS Terminal user assignment. 

If you know the Invoice number, just enter it and tab or click out of the Invoice field to display the information associated with that invoice.

To search for an invoice number, select the green icon in the invoice field and a new search window will display.  Enter one or more criteria to narrow your search if you wish and then select the search button. 

Select the invoice document number and click the OK button to continue processing the return. 

On this window, the Business Partner, Date, Warehouse, and Refund Amount values default and are read only.  The Refund Amount may be recalculated based upon the quantity to be returned being changed.

You must select the RMA Type and optionally check the Affects Inventory box to determine whether you want to return the item(s) to inventory or just create an AR Credit Memo. 

The Tender Type value defaults to either cash or credit card based upon the selected invoices original payment method.  The value does not default for selected invoices having an original payment method of check.  Typically, the user would select cash as the tender type for these types of refunds.  The Credit Card Type also defaults based upon the original invoices card type. 

If the Tender Type is "Credit Card", then the Authorization Code value must be entered for the return transaction. 

Note: If the Affects Inventory checkbox is selected, an RMA product return will be created. If not selected, only an AR Credit Memo will be created. 

After selecting one or more-line items to return to stock, you will have the ability to update the return quantity for each line. 

Select the Process button to create the return transactions. 

The process creates an Invoice having Document Type as "AR Credit Memo" and opens up the Invoice window for review.  The AR Credit Memo will reference the return tender type (cash or credit card) as its payment rule as well as the credit card type when applicable. 

It also creates a negativeCustomer Payment record and allocates the AR Credit Memo to it. The customer payment record includes the tender type and credit card type with authorization code for credit card returns. 

A Customer RMA record is also created by the return process to facilitate the creation of the AR Credit Memo and the optional Product Return.  

If "Affects Inventory" is selected, it also creates an RMA Product return record. This record is used to facilitate the inventory movement back to stock for the return goods. 

End of Day Close 

The End of Day Close application can be used to close out and reconcile cash transactions for a specified terminal. 

Menu Path: Sales > Point of Sale > Transactions > End of Day Close  

This brings you to the end of day close screen where you can select the terminal to close out. 

The end day date defaults to the current date & time, and the start day date defaults to last date/ time that the selected Terminal was last closed.

The user must be logged in to the "Warehouse" associated with the terminal and have "Shop Manager role" access to complete the "End of Day" process for the selected terminal.  

Initial window display after Terminal has been selected:

Users may then enter the Actual Cash On-Hand and Actual Checks On-Hand for the selected Terminal and the system will calculate the "Over / (Short)" amount and the "Closing Cash Balance" amount.  The terminal can be closed out with over / short amounts existing.

If the actual entered cash on hand varies from the calculated amount an informational message will display.

Window display after Actual Cash On-Hand and Actual Checks On-Hand have been entered:

Window display after Closing Cash Balance and Closing Checks Balance have been updated:

Select the Close Cash button to process End of Day Close and the End of Day Report window will automatically open and the End of Day Close window field values will be updated.

End of Day Report:

Key Fields:

Name

Description

Opening Cash Balance

From prior closing cash balance.

Opening Check Balance

From prior closing check balance.

   Note: For sum and number fields below include transactions created between the last close cash & current close cash fields below.

Cash Sales

Sum of all cash tender type payments.

Cash Tickets

Number of all cash tender type payments.

Credit Card Sales

Sum of all credit card tender type payments.

Credit Card Tickets

Number of all credit card tender type payments.

Check Sales

Sum of all check tender type payments.

Check Tickets

Number of all check tender type payments.

Total Sales

Calculated: Cash Sales + Credit Card Sales + Check Sales

Cash In

Sum of all Cash Movements In.

Cash Out

Sum of all Cash Movements Out.

Cash Refunds

Sum of AR Credit Memo’s where tender type is cash.

Cash Refund Tickets

Number of AR Credit Memo’s where tender type is cash.

Credit Card Refunds

Sum of AR Credit Memo’s where tender type is credit card.

Credit Card Refund Tickets

Number of AR Credit Memo’s where tender type is credit card.

Calculated Cash On Hand

Calculated: Opening Cash Balance + Cash Sales + Cash In – Cash Out - Cash Refunds

Calculated Checks On Hand

Calculated: Opening Check Balance + Check Sales

Actual Cash On Hand

Entered by user

Actual Checks On Hand

Entered by user

Cash Over/(Short)

Calculated: Calculated Cash On Hand – Actual Cash On Hand

Checks Over/(Short)

Calculated: Calculated Checks On Hand – Actual Checks On Hand

Cash Deposit

Calculated: Actual Cash On Hand – Closing Cash Balance

Checks Deposit

Calculated: Actual Checks On Hand – Closing Checks Balance

Closing Cash Balance

Updated by user; carry over to next day.

Closing Checks Balance

Updated by user; carry over to next day.

Select Print to print out the report. 

Reports 

End of Day Report

The "End of Day Report" may also be run on an as needed basis. This report summarizes the opening balances, daily activity, and ending balances for a selected terminal by date / time.

Menu Path: Sales > Point of Sale > Reports > End of Day Report 

List view: 

Edit view:

End of Day Report Line – child tab

If any cash movement adjustments occurred, they would be displayed here. 

End of Day Transaction – child tab - transaction(tickets) will be displayed

Cash In / Cash Out – child tab

Sales POS Report

The Sales POS Report provides the user with several filters to select from before executing the report itself.  These parameters may be saved and used to re-run the report.

Menu Path: Sales > Point of Sale > Reports > Sales POS Report 

Report parameter selection window:

Report result window:

Report Wizard:

In addition to having user assigned parameters when running this report, the report wizard allows you to configure the report output.  Select the wand icon to open the wizard.

Report formats may be copied and saved under a different "format name" which would allow you to customize the copied format leaving the original format in tack.  Report results may be displayed by the various saved formats.

Select the Copy Print Format button to create a new print format.  It will initially be saved as the "existing format name – copy", but may be renamed utilizing the Customize Report function described below. 

Payment Details Report

The Payment Details Report

Menu Path: Sales > Reports > Payment Details Report  

Report parameter selection window:

Report result window:

Report Wizard:

In addition to having user assigned parameters when running this report, the report wizard allows you to configure the report output. 

In this example, we will create a new print format by selecting the Copy Print Format button.  This will allow us to modify the new format while leaving the original in tack. 

The new print format will be appended with a "– Copy".

This format may now be modified using the Report Wizard without affecting the original print format. Select the "save" icon after making changes and then select the green check box to display the print format version.

Once changes are made to this copied format, the "name" of the print format and other changes may be updated using the "Customize Report" utility. Select the "Wrench & Screw Driver" icon in the gray toolbar to open the customize report utility. 

Here you may update the print format name to associate the version to a user or department for example. In this example, we have updated the print format to "Payment Details – Sean’s Version".  You may also assign a "Default" report version. 

When the report is re-run, you may select which print format version you would like to see: