Accounts Receivable > Transaction Processing > AR Payments Import

AR Payments Import

You use this program to import payment details for invoices.

This program is typically used to speed up the allocation of invoice payments in a high volume environment and to automate the capturing of invoice payments when the remittance advice is received electronically.

Toolbar and menu

Field Description
New This is enabled once a payment has been imported and you want to import another payment.
Import

Validates the contents of the import file and import the records if there are no errors.

Once imported the GL journal is created and the payment is reflected against the customer.
Print

Print the AR Cash journal created from the import. This is only available once the record is successfully imported.
Save Form Values This option is only enabled in Design mode (see Automation Design). Your selections are saved and applied when the program is run in automated mode.

Payment Details

Field Description
Payment Details  
Customer The customer for whom you are importing invoice payments.
Calculate payment amount

Calculate the payment amount prior to performing the validate function.

The payment amount will equal the sum of the Net Amount column in the Details pane.

If this option is not selected a payment amount must be entered.
Payment amount Enter the amount of the payment received from the customer.
Reference/Check

Enter a reference number or the number on the customer's check.

This option is mandatory for TPM customers.
Payment date

Indicate the date on which the payment is recorded on the customer's account.
Journal notation Optionally enter a note against the journal.
Payment narration Enter an additional note against the payment.
Create discount notes

Create a discount credit or debit note for the settlement discount processed as part of the payment transaction.

Ensure that the Print credit/debit notes for settlement discount option is enabled (Accounts Receivable Setup) to use this function.
Exchange rate method

This only applies when processing a payment for a foreign currency customer.

  • Select Default rate for the entire run to define a default exchange rate for the entire payment.

  • Select Original invoice rate to process the payment at the same exchange rate that was used when the invoice was raised.
Default rate for entire run Select this to define a default exchange rate for the entire payment.
Original invoice rate

Select this to process the payment at the same exchange rate that was used when the invoice was raised.
Exchange rate variance Enter the General Ledger code to which exchange variances must be posted for the payment.

This defaults to the exchange rate variance account in your General Ledger Integration options (General Ledger Integration). If this is not defined, then the Currency variance account defined in the AR Currency Variance GL Interface program is displayed.
Exchange rate Enter the exchange rate to use for this payment.
Transaction options  
Post to Cashbook in detail

Create payment transactions in the cash book.

This option is enabled under the following conditions:

  • The Cash Book module is installed
  • Integration to Cash Book is defined as Posted by cash journal (Accounts Receivable Setup)
  • The operator is allowed to override the integration level (i.e. from Posted by cash journal to Posted in detail) at the time of capturing payments (Accounts Receivable Setup).
Reset credit status Reset the customer's credit status (AR Customer Maintenance) once you post the current payment.
Allow overwrite branch

Enable this to indicate the AR branch to which the adjustment must be processed.

Ensure that you have enabled the Allow branch overwrite in payment and adjustment option (Accounts Receivable Setup) to use this function.
Overwrite branch

Indicate the AR branch to which the payment must be posted.

This only applies when the Allow overwrite branch option is enabled.
Period

Indicate the period and year to which the transaction will be processed, but can be changed using the Change Period option (see Change Posting Period).
Change period

Select this to use the Change Posting Period program to indicate the month to which you want to post transactions.
Create new journal

Create a new journal for each import.

If not selected, one journal will be created on the first import and subsequent imports appended to it until you exit the program.

The GL journals are only created on exiting the program.

Bank Deposit Details

Enter the details that will be printed on the bank deposit slip for customer payments.

These details only apply if you indicated that a bank deposit slip is required (Accounts Receivable Setup).

Field Description
Bank Indicate the bank into which the payment was received or will be deposited.
Account description The description of the Bank entered
Account number The account number of the Bank entered.
Payment type Indicate the payment method used.
Drawer's name Enter the name of the drawer on the check
Drawer's bank Enter the bank on which the check was drawn.
Drawer's branch Enter the bank branch on which the check was drawn.
Bank currency Indicates the currency code of the Bank entered.
Bank charges amount

Indicates the amount of bank charges associated with the deposit.

Ensure that you enabled the Enter bank charges in AR payments option against the selected Bank (Banks) to use this function.
Bank exchange rate

Indicates the exchange rate to use for the bank charges.

This only applies when entering a Payment for a foreign currency customer and the rate for the currency is not set to fixed (Currencies).

Options

Data source

Field Description
Import method  
From file Indicates you want to import data from a file.
Use data grid Indicates you want to enter data directly into the grid of the Details pane (you can paste the contents of an Excel spreadsheet into the grid).
File location  
Server Indicates the import file resides on the server.
Client Indicates the import file resides on the client.
File name Indicate the name of the import file (include the full path).
Review file Loads the contents of the import file into the Details pane. This enables you to validate the lines on the grid prior to importing the file. The Import button is enabled only when all lines are valid.

After processing completed

Field Description
Print the Details Generate a report of the contents of the Details entry grid.
Email the Details Generate an email of the contents of the Details entry grid.
Print the Import Results Generate a report of the contents of the Import Results pane.
Email the Import Results Generate an email of the contents of the Import Results pane.
Email recipients Indicates the email addresses of recipients to whom you want to email the information displayed in the output panes.
Delete file after use Indicates whether you want to delete the import file after all records are successfully imported.

In a client/server environment, both the import file on the server and the temporary import file created on the client are deleted.
Close the application Exits the program once processing is complete. Do not select this if you want to be able to view the information on screen when processing is complete or you want to print or email the contents of the Details and Import Results panes.

Information

This pane displays the distributed and undistributed values and is for information purposes only.

Column Description
Distributed amount This is the total value of the Net amount for invoices entered in the Details grid so far.
Undistributed amount This is the difference between the Total payment received and the Distributed amount.
Total payment received This is the value entered in the Payment amount field in the Payment Details pane

Details

Toolbar

Field Description
Validate This verifies whether there are any errors in the grid, without actually importing records.

Exclamation marks in the Validation status column indicates that one or more fields in the line are invalid. An explanatory error message is displayed when you hover your mouse pointer over the exclamation marks.
Print Prints the contents of the import file, or changes made in the grid.
Export to Excel Outputs data from the Details pane to an Excel spreadsheet.
Search text  
Clear Clears the contents in the search text field.
Edit  
Copy Copies the lines in the Details pane.
Paste (all columns) Ensure that you have data for all the columns that can appear in the data grid before selecting this option.
Paste (visible columns only) Pastes data into the columns that currently appear in the data grid, in the sequence that they appear.
Duplicate Copies the current row to the end of the data grid.
Find and Replace  

Listview

Field Description
Customer invoice

The invoice against which the payment must be processed.

To pay an invoice which has already been purged from the customer's account, you must enable the Re-established invoice check box to enter the invoice details and to automatically populate the Terms column.
Transaction The invoice transaction can be invoice, credit note or debit note.
Gross amount

Enter the gross amount of the payment you want to apply to this invoice.

[Note]

When you change the Gross amount, the Discount amount and the Tax amount (if applicable) are automatically recalculated.
Discount amount

This indicates the settlement discount amount applicable to the invoice.
Tax amount

This is the tax portion of the settlement discount or the withholding tax amount.

Net amount This is the net payment amount allocated to the invoice. This is the Gross amount less the Discount amount.
Invoice date The date on which the invoice became due for payment.
Customer PO The customer's purchase order number.
Terms The terms description is displayed. When re-establishing an invoice, the terms are displayed based on the customer's terms code when you enable the Re-established invoice check box.
Original value Enter the original amount of the invoice. This is only displayed if it is a re-established invoice.
Original discount

Enter the original discount given for the invoice.

This is only displayed if it is a re-established invoice.
Exchange rate This indicates the exchange rate to apply for the payment of the invoice and only applies to foreign currency customers.
Current balance This indicates the current balance of the invoice.
Reference Enter a reference for the payment.
Re-established invoice Indicate that the invoice is being re-established.
Unapplied payment

Select this to post a payment to the customer's account without allocating it to any invoice(s).

You this option when a customer makes a payment without indicating the invoices being paid, but you still want to reflect the payment on the customer's account.

Unapplied payments can be manually allocated to invoices at a later stage.
Invoice suffix

This is a numeric field in which you can enter up to 12 integers to the automatically applied prefix of _CR to make up a unique identification for the unapplied payment. For example if you enter 101, unique ID for the unapplied payment becomes _CR101.

The number of integers you can add depends on the presentation length defined for AR invoices in Set Key Information.

It is only available if you have enabled the Unapplied payment option.
Message  
Balance amount This indicates what the new invoice balance will be when the payment is posted.

Import Results

Displays a summary of the results of the validation/import.

This information can be printed or emailed providing you did not select to Close the application in the After processing completed section.

File layout for 7

Field Start position Field length and description
Customer invoice 1

20

Mandatory for standard and re-established invoices, credit and debit notes and unapplied payments.

If the invoice key type is numeric then leading zeros must be entered.
Transaction 21

1

I = Invoice

C = Credit note

D = Debit note

This is a mandatory field.
Gross amount 22 16

This is a mandatory field.
Discount amount 38 16
Tax amount 54 16
Net amount 70 16
Invoice date 86

6

Entry of the invoice date in YYYYMMDD format.
Customer PO 92 30
Original value 122 16
Original discount 138 16
Original invoice rate 154 13
Reference 167 50
Re-establish invoice 217

1

This is a checkbox field. If the value supplied is Y, the field will be checked.
Unapplied payment received 218

1

This is a checkbox field. If the value supplied is Y, the field will be checked.
Invoice suffix 219

17

By default this field is disabled. If the Unapplied payment option is selected, this field will be enabled, and mandatory.

Notes and warnings

eSignature considerations

Electronic Signatures provide security access, transaction logging and event triggering. This enables you to increase control over your system changes.

Access to the following eSignature transactions within this program can be restricted at Operator, Group, Role or Company level. You configure this using the Electronic Signatures program.

eSignature Transaction Description
AR Payment posted

Controls access for posting customer payments in the Payments and Adjustments, AR Payments Import and AR Payment Run programs.

Cash book transactions

This applies to the Post to Cashbook in detail option.

  • If you are posting to the cash book in detail, the following transactions for the payments processed are created in the Cash Book:

    • Individual transactions are created for each payment with a payment type of Check
    • A single transaction per journal is created for the total of all payments with a payment type of Cash
    • A single transaction is created per journal for the total of all local currency payments with a payment type of Other
    • Individual transactions are created for each foreign currency payment.

  • If you are not posting to the cash book in detail, then the following transactions for the payments processed are created in the Cash Book:

    • A single transaction is created per journal for the total of all payments made with a payment type of Cash or Check
    • A single transaction is created per journal for the total of all local currency payments with a payment type of Other
    • A single transaction per journal is created for the total of all foreign currency payment.

Printing the Import Results grid

  • XAML code has been applied to the Import Results grid to improve legibility of the resulting report when printing the grid.

    However, to produce a legible report, you should remove all columns except the Journal, Journal details, Customer details, Document details, Amounts, References and Dates columns.

Activity considerations

Operator access to the following activities within this program can be restricted. You configure this using the Operator Maintenance program.

Activity Description
Listview/Forms - Export or print data Controls whether an operator can print the contents of a listview and/or output the contents of a listview to an HTML page, XML document or Excel spreadsheet.
Maintain data in import programs Controls whether an operator can maintain import data in a data grid within any SYSPRO import program before the import is performed.
Allowed to import from client Controls whether an operator can use a SYSPRO import program to import data from a client machine (in a client/server environment).
File Browse on server (C/S system) Controls whether an operator use the browse function to load the Browse on Files and Folders program to locate files on the server in a client/server environment. Operators can still navigate to a file or folder on the server by typing in the full path name in the entry field.

Personalization considerations

  • Ensure that you have enabled the Show maximize button in caption for adjacent panes option (SYSPRO ribbon bar>Home>Personalize>Docking Panes) to display the maximize button on the Options, Payment Details, Bank Deposit Details and Information panes.

Re-established invoices

  • If using re-established invoices, the Invoice date, Customer PO, Original value, Original discount and Exchange rate columns are required. Ensure that these have not been removed from the Details pane.

Zero amounts

  • You cannot post a transaction for which the gross amount, tax amount and discount amount are all zero.

    Transactions with a total payment amount of zero can, however, be posted. For example if you re-establish an invoice with a negative amount and contra it with an existing invoice.

Application Help Pane

Application Help Panes provide step-by-step instructions for various functions within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program. The intention is that the pane provides information that is uncluttered and easy to navigate.

You can embed an Application Help Pane:

  • in the main SYSPRO menu

  • in any program with panes, if not using roles

  • when adding a role layout in Design Mode.