A/R History

The Accounts Receivable (A/R) history screen provides an 'at a glance' summary of the receivables history for a Customer. From the Customer Profile screen, click on the or press F2.

ar_history_screen2.jpg

The A/R history screen provides the following:

ar_hist_unapplied_detail.jpg

pending_scrn2.jpg

 

Display Payments

The system can display a screen listing payments only. This is extremely helpful when assisting a customer find a missed payment. Click or press . The Display Payments screen will be displayed.

 ar_hist_payments.jpg

 

Check History

To display the Invoices a specific check paid, you can double click on the check number -

 ar_hist_check_no_double_click2.jpg

OR

Go to the Check# ar_hist_check_no2.jpg field and type the check # (the check # may be the word 'CASH', VISA, etc - whatever you see in the A/R History screen), Click or press , the Check History screen will be displayed.

The Check # field will NOT be displayed if the customer is Balance Forward since Check History is only available for Open Item (O/I), Open Statement (O/S) and Open Accounting (O/A) type customers.

 

ar_check_history2.jpg

 

Invoice Payment History

To determine what checks paid a particular invoice you can double click on the invoice number -

ar_hist_invoice_double_click2.jpg

OR

Go to the Invoice # ar_hist_invoice_box2.jpg field and type in the invoice number and click or press OR highlight the line and click on ar_hist_view_inv_hist.jpg and the Invoice History screen will be displayed.  

The Invoice # field will NOT be displayed if the customer is Balance Forward since Invoice History is only available for Open Item (O/I), Open Statement (O/S) and Open Accounting (O/A) type customers..

ar_invoice_history.jpg

 

Display an Invoice

From the Invoice Payment History screen (above), click or press to Display the Invoice.

From the A/R History screen, you can highlight an invoice line and click on ar_hist_view_pdf_bill.jpg to see an actual Invoice in PDF format.

 

Email a PDF Bill

From the A/R History screen, you can highlight an invoice or statement line and click on ar_hist_email_pdf_bill.jpg to email an actual bill (Statement or Invoice) in PDF format.

ex_red_sm.jpgThis is an add on module.  Please contact our sales department at 888-763-8725 for more information.  If you do not have this activated, then the option below would display as ar_hist_no_pdf.jpg.

ar_hist_email_pdf_bill2.jpg

When you select the line and click on ar_hist_email_pdf_bill.jpg the following screen will appear asking for the email address to send the bill to.

ar_hist_email_pdf_bill2_email.jpg

Enter the email address and select Enter.jpg or ar_hist_continue.jpg.  The following message should appear:

ar_hist_pdf_processing_msg.jpg

You can press Enter.jpg to clear this screen.  An internet browser should be open with the following message:

ar_hist_email_success_msg.jpg

The customer will get an email with the PDF bill attached.  The "from" email address, subject line and body of the email are all configured when you set up PDF billing on your system.

 

Offsets

From the Sales History screen you have the option to Mark Offset sale records that you don't want to appear on the customers bill.  These are sale records that you may have billed incorrectly and created a reversing S&A to offset the incorrect charge.  When you process a Mark Offset transaction, the system will mark each record with an Offset Control # that can be referenced from the A/R history screen.  This will show you exactly what was included in the Mark Offset transaction.

From the A/R History screen, select ar_hist_offsets_f10.jpg.  A screen will be displayed that shows all of the Offset Transactions that have been posted to the account.

ar_hist_offsets_all.jpg

It includes the Offset Control # so you can see which records were grouped together in each Offset transaction.

If you want to view a single Offset transaction, enter the Offset Control # into the ar_hist_offsets_one.jpg field and hit Enter.jpg and the Sales Offset screen will be displayed for just that Control #.

ar_hist_offsets_one_display.jpg

 

Call Back Feature

Used as a reminder to call a customer in the future (corresponds to the Call Back Report).

ar_hist_call_back2.jpg

In the Comments section, type in a comment that helps you identify what the follow up call needs to reference.

In the Next Call field enter the date you want to follow up on.

Click or press to accept.

Click or press to add the comment to the Notepad (for tracking purposes). You will get a message on the bottom of the screen:  Be careful not to click on multiple times because a note will be added each time you click on the option.  The default notepad code for the note is A/R.

call_back_note.jpg

 

Reports & Reprints

Click or press the button, the print request screen will be displayed.

ar_hist_print_request2.jpg

To print a History recap - enter the date range you want: ar_hist_history_recap.jpg

To print a Invoice History - enter the date range you want: ar_hist_invoice_history.jpg

To print a Check # History - enter the date range you want: ar_hist_check_history.jpg

ex_red_sm.jpgInvoice and Check History reports cannot be generated on Balance Forward (B/F) type customers.  It is intended for Open Item (O/I), Open Statement (O/S) and Open Accounting (O/A) type customers only.

To reprint an Invoice # - type in the Invoice number: ar_hist_reprint_inv.jpg

To reprint a Statement - enter the date for the Statement: ar_hist_reprint_stmt.jpg

Once one of the options has been filled out, click or press and the system will print your selection.

 

Batch Credit Card Payments

batch_box.jpg

cc_pmt_button.jpg - If your company accepts credit cards and you are authorized to take on-line credit card payments, then you should see this option on your screen.  When selected, you will be brought into the charge card processing screen.

chg_card_processing2.jpg

After entering all the correct information, press Enter.jpg and the icon for the credit card agency you are using will display.  Here is an example if you are using Authorize.net:

auth_net_icon.jpg

Click on the icon to validate.  If approved, an authorization number will be sent back letting i-Pak know that the transaction was successful.  ***Note: Depending on how your Company Authorize.Net record is setup, you will either get this pop up showing the Authorization Code, or it will just print on the receipt.

 

auth_code_msg.jpg

 

If there was a problem, the interface will prompt you with a message describing the problem.  

Example Error Message:

auth_code_error_msg.jpg

 

If you do get an authorization number,  i-Pak will store the Authorization number and transaction Id.  If this is a B/F customer, after the payment is authorized, you will be brought back into the A/R history screen.  If this is an O/I or O/S customer, you will be brought into the Open Item Batch Entry screen where you can select which invoices to apply the payment to.  For all accounting types, the payment will remain in the Batch until posted by an authorized user.  The Batch id will start with an * and created with the User ID set up in the Company Master Credit Card Batch User Id field.

 

info_blue_sm.jpgA User must have Cash Receipt (on-line) security of 2 or 4 as well as Charge Card Option = Active-Get Auth#, or Manual Auth#  in order to see this option.

 

interactive_box.jpg

Interactive Cash Receipts

When you click on the Cash Receipt ar_hist_inter_cr.jpg option under the Interactive section, the On-Line Cash Receipt Entry/Post screen will appear.

info_blue_sm.jpgA User must have Cash Receipt (on-line) security of 3 or 4 to see this option.

ar_hist_online_cr.jpg

From this screen you can post an interactive payment directly onto the customers accounts.  The screen will display the Customer #, Customer/Billing Name and Service Address, and what Accounting Type this account is listed as.  The pending_redbox.jpg icon will display if any pending Cash Receipts or Sales & Adjustement batches exist for this customer.  

The customers Remaining Balance Due (including any unposted PENDING transactions) is displayed for reference and is defaulted into the Payment Amount field.  The Payment Amount can be changed if the customer chooses to pay a different amount.

Payment Type:

Cash:  If accepting a CASH transaction, this is the only information you will see on the screen.

ar_hist_inter_cr_posted_msg.jpg

 

Check: If accepting a CHECK transaction, the following additional fields will appear on your screen:

ar_hist_inter_cr_check2.jpg

ar_hist_inter_cr_posted_msg.jpg

 

Credit Card: If accepting a CREDIT CARD transaction, the process will work just like the BATCH CC PAYMENT option described above.  The only difference is that the payment will be posted immediately instead of being entered into a Batch to Post at a later time.

ex_red_sm.jpgThe Convenience Fee (aka Payment Fee) is only shown and posted during BATCH credit card transactions.  It will not get processed when using Interactive Credit Card payments.

 

E-Check:  If accepting an eCHECK transaction, the following additional fields will appear on your screen:

ar_hist_inter_cr_echeck.jpg

bank_routing_info.jpg

ar_hist_inter_cr_posted_msg.jpg

Interactive Deposit Receipt

Refundable deposits are deposits received that do NOT affect accounts receivable – they are not ‘pre pays’ or ‘cod payments’ or payments for roll carts. They are similar to security deposits and may be refunded or applied to a customers balance at a future point in time (i.e. when they cancel, if there is damage to a cart/container, or if the skip without paying).

The Interactive Deposit Receipt screen looks very similar to the screens documented above for Interactive Cash Receipts.  

When you click on the Deposit Receipt deposit_receipt.jpg option under the Interactive section, the On-Line Deposit Entry/Post screen will appear.

info_blue_sm.jpgA User must have Deposit Receipts security of 3 or 4 to see this option.

ar_hist_online_dep.jpg

The Customers Current Deposit Information will be displayed on the screen.  This information comes from the Additional Information Tab.

Payment Types

Cash:  If accepting a CASH transaction, the following information will be displayed on your screen:

ar_hist_online_dep_cash.jpg

Amount - enter the amount to be deposited.

Bank G/L Code - this will default in from the Company master (or System Master if you allow Multiple Companies in one batch) but can be overridden if needed.

New Deposit Exp. - enter an expiration date if applicable.  This is not a mandatory field.

Print Receipt? - if check_mark_1.jpg then you will get a printed receipt in your spool file.

 

When you fill in the correct information and hit Enter.jpg, you will get the message ar_hist_online_dep_f11.jpg.  Click or press post_f11.jpg and the Deposit will be posted to the account.  You will see the message ar_hist_online_dep_post_msg.jpg at the bottom of your screen and there should be a new A/R history record showing the Deposit Amount.  The Deposit amount, Date received and Expiration Date are held in the Additional Information tab.

 

Check:  If accepting a Check transaction, the following information will be displayed on your screen:

ar_hist_online_dep_check.jpg

Amount - enter the amount to be deposited.

Check# - enter the check # associated with the deposit received.

Bank G/L Code - this will default in from the Company master (or System Master if you allow Multiple Companies in one batch) but can be overridden if needed.

New Deposit Exp. - enter an expiration date if applicable.  This is not a mandatory field.

Print Receipt? - if check_mark_1.jpg then you will get a printed receipt in your spool file.

 

When you fill in the correct information and hit Enter.jpg, you will get the message ar_hist_online_dep_f11.jpg.  Click or press post_f11.jpg and the Deposit will be posted to the account.  You will see the message ar_hist_online_dep_post_msg.jpg at the bottom of your screen and there should be a new A/R history record showing the Deposit Amount.  The Deposit amount, Date received and Expiration Date are held in the Additional Information tab.

 

Credit Card: See CC Payments above

ECheck: See EChecks above

 

Interactive Refund/Apply Deposit

 

ar_hist_inter_xfer_dep.jpg

This option allows you to either Transfer (Xfer) a Current Deposit into A/R or Transfer Money from A/R into a Deposit.  The screen will tell you the Current Balance Due for this customer as well as how much they have in their Additional Information tab as a Deposit Balance.  

Xfer from Dep to A/R:

Amount to Transfer:  Enter the amount of the Deposit you want to transfer.

Apply to Invoice#:  You can select to apply the deposit directly to an invoice #.  Click on open_inv_f22.jpg to see a list of Open Invoices for this customer if they are an O/S or O/I customer.  If they are B/F then this field will not display.

Print Receipt?   if check_mark_1.jpg then you will get a printed receipt in your spool file.

Click Enter.jpg and you will get the message ar_hist_inter_xfer_dep_post_msg.jpg.  Click or press  post_f5.jpg to Post.  You should see the message ar_hist_inter_xfer_dep_post_success.jpg on the bottom of your screen and an additional A/R history record should be created with the description "Refundable Deposit TRF".  The Deposit amount should be removed from the Additional Information tab as well and a Sales & Adjustment will have posted using the Size/Chg & GL codes set up in the Company Master.

ex_red_sm.jpgIf this is an O/S customer and you left the invoice# field blank, then you will get the message ar_hist_inter_xfer_ar_success.jpg and you won't see the additional A/R history record.  You can view the data in the Sales History screen.

Xfer from A/R to Dep:

Amount to Transfer:  Enter the amount you want to transfer from A/R into a Deposit.

Apply to Invoice#:  You can select to take the deposit directly from an invoice #.  Click on open_inv_f22.jpg to see a list of Open Invoices for this customer if they are an O/S or O/I customer.  If they are B/F then this field will not display.

Print Receipt?   if check_mark_1.jpg then you will get a printed receipt in your spool file.

Click Enter.jpg and you will get the message ar_hist_inter_xfer_dep_post_msg.jpg.  Click or press  post_f5.jpg to Post.  You should see the message  ar_hist_inter_xfer_ar_success_inv.jpg and the deposit will be updated with the new amount.   The A/R history screen will have a new record showing "Refundable Deposit TRF" and a Sales & Adjustment will have posted using the Size/Chg & GL codes set up in the Company Master.

ex_red_sm.jpgIf this is an O/S customer and you left the invoice# field blank, then you will get the message ar_hist_inter_xfer_ar_success.jpg and you won't see the additional A/R history record.  You can view the data in the Sales History screen.