CARRIER PAYMENTS

Step 1 (Exporting the data):

Run Customer Enquiry for the carrier account in question (e.g. OPTUSREB)

Select O for Outstanding and press enter twice to select all outstanding transactions.

Press F1 (Cancel) and then Enter to save to a file

Say F to save to file, Y to remove column headings, Y for field delimited format, and then C for comma separated.

Save the file as the name of the carrier account with ".csv" appended. e.g: optusreb.csv

The report is then saved to file.

Step 2 (Downloading the data):

Open Windows Explorer, type ftp://61.29.41.94/ into the address bar, and hit Enter (or click Go).

(Do NOT use Internet Explorer)

Windows should display a promp asking for username and password for the server, use the username and password you normally connect to the CONTROL server with.

Windows will display a list of all the files in your directory. Find the one you just saved (e.g: optusreb.csv) and drag it to your desktop.

The file should automatically be transferred to your local machine.

Step 3 (Editing the spreadsheet):

At this point, the CSV file on your system should have the following columns:

• Line Number

• Transaction type

• Transaction Date

• Due Date

• Location prefix

• Ref1

• Ref2

• Total Amount

• Amount Owing

• Running total.

Many of these columns are not needed, but the import program expects them to still be there, so DON'T delete them.

After the running total column, the next three columns, to be inserted by you, in order, will be:

• Payment Amount

• Adjustment (discount) Amount

• Adjustment Reason Code

The Payment Amount is the amount actually paid by the carrier, and Adjustment Amount will normally make up the difference between that and the Amount Owing. i.e. Payment Amount + Adjustment Amount = Amount Owing (so if Payment Amount is greater than Amount Owing then the adjustment will be NEGATIVE).

Adjustment Reason Code is an integer between 1 and 18 inclusive from (Admin -> System Configuration -> Accounting -> Accounts Receivable - Other) indicating why Adjustment Amount is non-zero.

IT IS AN ERROR if an Adjustment Amount is given without an Adjustment Reason Code. if the import detects this, it will ignore that line.

When you are finished, make sure you save the file back in CSV format.

Step 4 (Uploading the edited file back to the CONTROL server):

Couldn't be easier. If you still have the window open from step 2, just drag and drop the file back where you got it from. If not, first connect to the server again as in Step 2 (downloading the data). A dialog box will appear confirming the action.

Click YES and the file will be sent back to the CONTROL server.

Step 5 (Processing the Carrier Payments):

Run the Carrier Payments import program:

Enter the carrier account code (e.g. OPTUSREB) exported in Step 1 (Exporting the data), and the filename uploaded again in Step 4 (Uploading the edited file back to the CONTROL server):

The file will then be imported into CONTROL and create the necessary payment transactions.

Step 6 (Reporting payments processed):

Run the Accounts Recievable Transaction Listing program:

Select Detailed Reciepts From the Dayfile:

Enter "From Customer Code" and "To Customer Code" as the Carrier Payments Account just imported, and answer N to "Tendered trans only?":

Select the report output style required:

CONTROL should then generate a report of all payment transactions generated for the Carrier Account today:

CategoryAllphones