Accounts Receivable                     Payment Processing                     Handling Invalid Lockbox Records

Handling Invalid Lockbox Records

Depending on which bank file format your company is using, different pieces of information may be required to import the data into SedonaOffice as a customer payment. 

Using the Generic File format as an example, the invoice number is a required field.  In the illustration below, the last payment row displays the customer number as 0000, the customer name as Unknown.  In the far right column of the Import Lockbox File list is a column labeled Raw Data; the area circled in the screen shot below is the section that contains the customer number.  To try and locate the correct customer click on the gray button to the right of the Customer # field of the invalid record; this will open the customer lookup form.  Once you locate the correct customer number it will fill into the Customer # field.  Corrections may also be typed directly into the grid area of this form.  Once all corrections have been made, click the Validate Customers button located in the lower right area of this form.  Once all customers have been validated, click the Post button.

4275-1

                                                                      Page  1 of 2                                        Next Page