Please enable JavaScript to run this help system!
Execu/Tech Systems, Inc.
Knowledgebase
Search:
850-747-0581
Email
Website
Contents
Index
Search
Page Properties
Page Keywords
Page Visibility
Preview For Mobile Device
Lightbox Code & Preview
Save
Cancel
Saving...
Welcome
What's New
System Requirements
Computer Hardware
Other Hardware
Operating Systems
Windows XP Support Ends
Server 2003 Support Ends
Windows 7 Support Ends
Server 2008 Support Ends
TLS 1.2 Requirements
Data Security
Firewall Settings
Credit Card Interfaces
Shift4 Fix (June 19, 2020)
Installation Checklists
Software Update Requirements
Post-Update Requirements
Questions and Answers
Common Questions
Common Mistakes
Sending a Screen Shot
Recording step by step
Glossary
Data Flow
Execu/Tech Services
Execu/Suite Hotel PMS
Setup Execu/Suite Hotel PMS
Installation
Data Preparation
Software Installation
Software Installation - Server
Software Installation - Client
Software Reinstall / Move
Create Shortcut Manually
Your Company Setup
Zip Code Database
License Access Code
Manager Menu / Setup
Getting Started
Hotel Control Files Setup
Parameter Record
Season Record
Rooms
Room Types
Tax Codes
Charge Codes
Payment Codes
Guest Packages
Market Segment Codes
Source of Business Codes
Corporate File
Guest Profile Tools
Housekeeping Codes
Yield Management
Meeting Room Parameters
User Defined Comments
Graphical Room View
Auto-Trace Setup
Wholesalers and Travel Agencies
Setup Bullet Points & Notes
Rooms, Room Types, Rates
Charge, Payment, Tax Codes
Guest Packages
User IDs & Security Levels
Parameters & Policies
Guest Profile Tabs and Fields
Market and Source Codes
System Maintenance
Company Setup
User ID Setup
Menu Level Password Setup
User I.D. / Security Setup
PMS Employee Setup
PMS Menu Permissions
Security Levels
Other Settings
Configuration Settings
CRM Sync
Edit HTML Templates
Editing HTML Letters, Documents and Forms
Email Settings
ETHTMLPrint (Print Folios, Reg Card, Cancellation, etc.)
Thank-you emails
Enable PDF Saving
Hotel Logo
Import Rate Spreadsheets
Master Folios
MENUINI.FIL Configuration
Terminal ID Number Codes-Batch Terminals
Procedures Execu/Suite PMS
Guest Name Changes-Profile
Front Desk Operations
Front Desk Menu
Availability
Guest Profile
Check In
Credit Card Procedures
Check-In CC Preauth Video
Check In Master Folio
Packages
Guest Folio
Changes - Room, etc.
Posting Charges & Payments
Check Out
Check Out w/ Credit Card-Video
Housekeeping
Front Desk Reports & Printouts
Reservations Operations
Reservations Menu
Availability
New Reservations
Guest Profile
Advance Deposits
Credit Card Video-Res
CC Adv. Dep Refund Video
Share-withs
Changing Reservations
Cancellations and No-Shows
Guest Opt-out
Reservation Reports & Printouts
Sample Reports
Trace Reports
Groups
Night Audit
Night Audit FAQ
Night Audit Procedures
Night Audit Bullet Points
Night Audit Reports
Folio Detail Export
Clearing Adv. Deposits Remaining
Guest History
Manager Reports
Manager Procedures
Adjusting Statistics-AM Report
Audit Archive Report Viewer
Other Manager Tasks
Travel Agency Processing
Travel Agency Setup
Travel Agency Reports
Travel Agency Checks
Report Generator
How-To Videos and Tutorials
Assign Master Folio to Guest or Group
Change Terminal Number
Check In a Guest
Check Out a Guest
ETShortcutWizard
Export Guest Contact Info
Guest Profile Creation
Housekeeping Screen - Changing Status
Interface - Create a Scheduled Task
Software Update
Posting Charge or Payment to Folio
Transfer Charge or Payment to a Folio
Voiding Charge or Payment in Folio
How-To Documents
Post CC After Check-out
Credit Card Reminders
Change Company Code
Software Update without download
Execu/Suite CRS
Initial Setup
Menu and Navigation
Rooms Setup
Inventory & Availability
Viewing Inventory & Availability
Default Inventory
House Inventory
Periods of Closure
Events and Groups
Room Type Variations/Adjustments
Stop Sale Limits
Availability by Rate Category
Availability by Channel
Allotments
Booking Rules & Closure Date Rules
Calendar quick changes
Minimum Stay Policies
Automated Revenue Rules
Occupancy Rules
Channel / IDS Rules
Products/Rates Setup
Payments - Cancellations
Groups
Setup
Booking
Lookup
Channel Manager
Corporate Client Setup
Services Setup
Marina and RV Settings
Interfaces
OTA / HTNG
OTA / HTNG Installation and Configuration
OTA / HTNG 2 Way Push
OTA / HTNG 1 & 2 Way Pull
OTA / HTNG Functions and Limitations
OTA / HTNG PMS Settings
OTA / HTNG ROH (Run Of House)
OTA / HTNG Troubleshooting
OTA / HTNG Logs
Phone, Movie, POS, etc.
Comtrol® Interfaces
Comtrol® Network Requirements
Comtrol® Install
Comtrol® Setup
Comtrol® Testing
Comtrol® Resync
Comtrol® Troubleshooting
Legacy Interfaces
Legacy Interface Installation
Communication Settings
Phone Interface Resync
Troubleshooting Serial Connections
Micros POS Interface
Execu/Touch Point Of Sale
Execu/Touch POS Administrator
POS to Hotel Data Flow
Store Record
Departments/ Revenue Centers
Payment Records
Discount Records
Menu Items
Item Modifiers
Item Categories
Combinations (Value Meals)
Employee Records
Employee Work Codes
Void Codes
Table Setup
Terminal Records
Printer Setup
Item Button (Keyboard) Setup
How To - POS Admin
Create POS Item
Execu/Touch POS Procedures
F&B Open a Check
F&B Close a Check
Separate Checks
Split Checks
Split Tendering
Retail Procedures
Reports
Supervisor
Paid-Out Tips and Other
Create TAB
Transfer Checks
Video-Credit Cards in POS
Print Bar Codes
Advance Deposit in POS
Execu/Touch POS Miscellaneous
POS Cash Management
Dining Reservations
Tableside Wireless Tablets
Edit/ Purge History Records
Add Comment to POS Guest Receipt
Configure Bar Code Printer and Labels
Suppress Remote Printing
Use Employee Login Cards
Encode Employee Login Cards
Activities Deposits POS Setup
Export POS Check Detail (GAPOCKH.TXT)
FUEL sales in POS
POS Copy / Delete Records (GAPOCOPY)
POS Copy all records to another store
POS Copy records from GAPOCNTL.OLD
POS Delete Records
POS Change item fixed tax amount
POS Reset Table Types
POS Resynch employee/password records
POS Copy ONE record to another store
POS Convert gapo999.fin's
Printers and Cash Drawers
POS Printer Setup
POS Printer Troubleshooting
Cash Drawer Setup
Payment Processing
EMV Credit Card Processing
WorldPay Credit Card Processing
WorldPay Critical Setup Info
WorldPay EMV PIN Pad Setup
WorldPay EMV Cloud Config
WorldPay EMV Failure Messages
WorldPay EMV PIN Pad Troubleshooting
WorldPay EMV Data Flow
WorldPay (Non-EMV) Data Flow
WorldPay Receipt Printer Setup
Shift4 Credit Card Processing
Shift4 Card Readers
Magtek Programming
Shift4 Data Flow
Shift4 Installation
Shift4 UTG Install
Shift4 EMV Setup
Shift4 AuthToken, AccessToken, AccessBlock
Shift4 PMS/POS Setup (MENUS4CO)
Shift4 PMS/POS Setup (Payment Codes)
Shift4 PMS/POS Setup (Other Settings)
Shift4 i4Go V2
Using Shift4 i4Go
Shift4 i4Go V2 Requirements
Shift4 i4Go V2 Errors
Shift4 i4Go V2 PMS / POS Settings
Shift4 i4Go V2 Internet Explorer Trusted Zone
Shift4 SSL Certificates
Shift4 Receipt Printer Setup
Shift4 Troubleshooting
Shift4 UTG IP Address and Port
Shift4 Error Codes
Test Shift4 UTG Connection with Telnet
Credit Card Procedures
Switching Gateways/Providers
Inventory Control
Inventory Overview
Inventory Setup
Store, Locations, Classes-Categories
Inventory Items
Recipe File
Inventory Processing
Physical Inventory Entry
Physical Inventory Handheld Scanner
Purchase Orders
Miscellaneous Postings
Enter Waste Adjustments
Batch Updating
Display Item Detail
Inventory Integration
Integration to POS
Integration to A/P
Integration to GL
Inventory Reports
Time & Attendance
Direct Bill / City Ledger
Setup
Control Files Setup
Customer Setup
Membership Billing
Direct Bill - Execu/Suite PMS Interface
Direct Bill - Execu/Touch POS Interface
Direct Bill - General Ledger Interface
Procedures
Hotel DB Transfers
Transaction Batches
Open Item Payments
Manual Postings
Fix Out of Balance Direct Bill Accounts
Late Fees
Member Billing
Reports and Statements
Sample Reports
Customer Aged Trial Balance
Customer Detail Report
Transaction Batch Update Report
Open Item Statements
Balance Forward Statements
A/R Report Generator
Events and Catering
Getting Started
Event Setup
Sample Reports
Gift Cards (Execu/Gift)
Execu/Gift Setup and Configuration
Selling/Issuing Gift Cards
Redeeming Gift Cards
Manual Entry / Edit / Delete
Donated Gift Cards
Reward cards
Encode Gift Cards
Back Office
General Ledger
GL Setup
GL Processing
GL Integration
GL Reports
Accounts Payable
A/P Setup
A/P Processing
A/P Reports
Condo
Condo Overview
Condo Setup
Condo Procedures
Condo Reports
Payroll
Payroll Setup
PR - GL Interface Setup
Company
Federal Tax Tables
Employee Setup
PR-TimeClock Interface Setup
Payroll Procedures
Payroll Reports
3rd Party Accounting Interfaces
GL Export
DataPlus
QuickBooks
Errors / Fixes
cbl.out Program Missing
Class Not Registered
Cobol Errors
Common System Issues
Company Selection Keeps Appearing
Detail File Update Error
Error: 80040154
Find Software Application Folder
Folio Stops Printing (HTMLPRNT.EXE)
Forms Print to Wrong Printer
Forms Print Too Large
Memory Access Violation
Microsoft .NET Framework
Microsoft.Office.Interop
Missing or Broken Shortcut / Icon
Network Benchmark
Rebuild Corrupted File
Rebuild Cross Reference
Register Programs and Controls
Restarting Servers and Terminals
Run Program By Name
Run-time error '429'
Run-time error '-2147319779'
Program Warnings
Cannot Run More Than Once
Could Not Read Card
Current time not set up
In Reorg - Not Posted
Invalid Company Code
Invalid Room Type
Keyboard Record Not Set Up
Record Busy Message
Software License Warning
Terminal Record Not Set Up
Shift4 Errors
Slow / Stuck Software
Start Program Missing
Support File Uploader
Unable to Select Printers
User Account Control (UAC)
What's My Terminal Number?
Execu/Vault
Remote Connection (RemoteET)
Uninstall Old Remote Connection App
Sample Reports
Year-End Procedures
Fiscal Year
Master Folios Year-End
Seasons and Rates
Advance Deposits
Server and System Health
PCI Compliance
City Ledger - Direct Bill
General Ledger
Accounts Payable
Payroll
Backup and Storage
Training
New Modules
Cloud Hosting
Cloud Hosting Access
Cloud Launcher Install
Cloud Launcher Setup
Cloud Launcher Update
Cloud Access for Mac
Cloud Hosting Preparation
Network / Hardware Requirements
Important Issues
Document Access
WebRes
WebRes - Installation
WebRes - Credit Card Processing
WebRes - Shift4
WebRes - Vantiv
WebRes - Customize / Configure
WebRes - Cancellation Policy
WebRes - Confirmation Page and Email
WebRes - Errors / Troubleshooting
Execu/Spa
Execu/Suite Activities
Software Launcher
Running ETUpdate from update.zip
Search
:
Index
Bookmark
Print This Article
Login
Edit Page
Publish Draft
Delete Draft
Compare Draft
Edit Header
Home
>
Direct Bill / City Ledger
>
Procedures
>
Open Item Payments
Payments for Open Item
accounts are posted in Direct Bill > Customer Processing > Enter Open Item Payments.
Note: For Balance Forward Payments, see
Manual Postings
.
Entering Open Item Payments
Posting Zero Payments (applied to matching debits and credits)
Fixing Out of Balance Accounts (Account balance does not match sum of open items)
Applying Overpayments (payment is greater than invoices applied)
Back to top
Entering Open Item Payments
The customer balance displays at the top left. The unpaid, overpaid, or partially paid invoices are on the right.
When the screen opens your cursor will be at "
Customer code
". Enter the customer code or select from the look-up.
Enter the payment date at the prompt.
Enter a valid
transaction code
for the payment. If this is a credit card payment processed through Element PS or Shift4 you can type "/" and press <Enter> to bring up the credit card prompt.
Enter a reference number unless this is a credit card payment processed through Element PS or Shift4. If this is a credit card payment, leave this field blank.
Enter the payment amount. Unless you are applying a credit (refund or offset) you do not need to type the minus sign. If this is a normal payment, just enter the amount. The system will add the minus sign, thus deducting the amount from the balance due.
For invoice to pay you can type the invoice number or the sequence number. You also can click the invoice to pay. If paying multiple invoices (excluding credit invoices) click all of the invoices to which this payment will apply.
When you click the invoice to pay it will turn blue. See below.
After selecting the invoice(s) click the "Invoice/seq to pay" field. The cursor will move to the "Amount to pay this invoice" field as shown above. If you are paying the full amount, press Enter. If this is a partial payment, enter the amount and press Enter. The invoice will turn red and your cursor will move to the first "Ok?" prompt as shown below.
After pressing Enter at the first "OK?" prompt your cursor will return to the "Invoice/seq to pay" field.
Make sure the "Unapplied" amount is .00 (zero). If there are no more invoices to pay with this payment and the unapplied amount is zero, press Enter. The cursor will move to the second "Ok?" field as shown below.
If everything is OK, press Enter again and your cursor will return to the top.
When you center the customer code and press Enter after doing the above steps, the invoice will not show up as unpaid.
Remember to print and update your transaction batch!
As show below, the transaction batch shows the payment along with a list of all invoices paid by that transaction. Keep this report.
Posting Zero Payments (applied to matching debits and credits)
Fixing Out of Balance Accounts (Account balance does not match sum of open items)
Applying Overpayments (payment is greater than invoices applied)
Back to top of page
Back to top of section
Posting Zero Payments (applied to matching debits and credits)
At times you will have credit invoices. In the example below, a DB payment was posted to a folio and then a credit was posted to it, giving the account a sum of zero between the two invoices.
The two invoices will show up as unpaid even though they cancel each other out in the sum of invoices. To make these invoices show as paid, you will post a zero payment and apply it to both invoices. The credit invoice
MUST
be applied first. In the example below, an invoice and a credit invoice both are unpaid although the customer balance is zero.
Enter the payment date, payment code, and reference as usual. For the payment amount enter .00 (zero) or just press Enter.
Your cursor will move to "invoice to pay". Click the credit invoice first. You
must
apply the credit invoice first.
After clicking the invoice, click in the "invoice/seq to pay" field and continue as usual. The invoice will turn red.
As you see below, at this time the applied amount is -125.00 and the unapplied amount is 125.00.
Click the debit invoice and continue.
Continue to press Enter.
Continue to Press Enter until your cursor is at the second "Ok?" prompt. If the unapplied amount is zero, press Enter to accept the transaction.
When you have finished, the invoices will no longer show up as unpaid.
Below is the customer detail display for the above transaction. First is the original invoice. Second is the credit invoice. Third is the zero payment applied to the two invoices.
Entering Open Item Payments
Fixing Out of Balance Accounts (Account balance does not match sum of open items)
Applying Overpayments (payment is greater than invoices applied)
Back to top of page
Back to top of section
Fixing Out of Balance Accounts (Account balance does not match sum of open items)
In the example below you will see that the balance on the Customer Detail screen does not match the Balance on the Enter Open Item Payments screen. This is something that can happen, for example, if you have network problems and there is a brief interruption in the data communication. In this instance, a payment applied to the invoice but did not post to the customer's account.
In the image above, the payment of $431.10 was applied to Invoice 01134-0001 and the invoice no longer shows up as unpaid. The balance is correct.
In the image below, the payment of $431.10 did not post although the invoice shows as paid. The balance is off by the amount of the payment.
To fix this, do not go to Enter Open Item Payments. Go instead to "Enter Transactions".
Enter the customer code and press Enter and then enter P in the "Type" column and press Enter. As show below, a popup will tell you "No bal forward payment for an open item acc". To override this, type F and press Enter.
NOTE
: Only do this when correcting an out-of-balance account as described herein. Otherwise post all open item payments in the Enter Open Item Payment screen.
Enter the transaction date, valid transaction code, amount, reference and comment, pressing Enter after each entry. When you cursor is in the OK column, press Enter again to move your cursor to the next line.
If you do not press Enter in the OK column, you will not save the transaction.
Below is the customer detail display, showing the "forced" payment.
Note: If you are using Execu/Tech's Back Office General Ledger, you will need to see if the original payment transaction posted to General Ledger. If it did, you can delete this transaction from the G/L batch (not the direct bill batch).
Remember to update your direct bill transaction batch when you're finished. If you wish, you can wait until the end of the day if you have additional transactions to post.
See also
Fix Out of Balance Direct Bill Accounts
.
Entering Open Item Payments
Posting Zero Payments (applied to matching debits and credits)
Applying Overpayments (payment is greater than invoices applied)
Back to top of page
Back to top of section
Applying Overpayments (payment is greater than invoices applied)
If a customer overpays, you must apply the full payment amount, even if it is greater than the sum of invoices.
In the following example, the balance is $175.38 - the same as open items (unpaid invoices). However, a payment of $350.76 was received.
Enter the payment date at the prompt.
Enter a valid transaction code as usual.
Enter the payment amount.
Select the invoice to pay.
IMPORTANT:
When you get to "Amount to pay this invoice" enter the full payment amount, not the amount of the invoice. You
must
apply the entire payment or you will not be able to save the transaction.
Later, when there is another invoice to apply the payment to, you can post a zero payment and reapply the payment, distributing it between the two invoices as shown in the steps below. This way, the two invoices won't continue showing up as unpaid.
The payment amount will be zero.
Select the first invoice. Enter the invoice amount in the "Amount to pay this invoice" field:
Note that part of the payment has been applied and part has not been applied. You need to select the second invoice now, and apply the payment to it.
In the customer detail display, the first line shows the first invoice. The second line shows the overpayment. The third line shows the second invoice. The fourth line shows the zero payment with the zero payment applied to the two invoices, "undoing" the overpayment of the first invoice.
Entering Open Item Payments
Posting Zero Payments (applied to matching debits and credits)
Fixing Out of Balance Accounts (Account balance does not match sum of open items)
Back to top of page
Back to top of section
Article ID
open_item_payments
Views
3843
Last Modified
12/19/2014 4:30 PM
Copyright © Execu/Tech Systems, Inc. All Rights Reserved.
{1}
##LOC[OK]##
{1}
##LOC[OK]##
##LOC[Cancel]##
{1}
##LOC[OK]##
##LOC[Cancel]##