CARRIER PAYMENTS

Step 1 (Exporting the data):

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

• inline:drenq2.gif

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

• inline:drenq3.gif

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

• inline:drenq4.gif

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

• inline:drenq5b.gif inline:drenq6b.gif inline:drenq7b.gif

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

• inline:drenq8b.gif

The report is then saved to file.

• inline:drenq9.gif

Step 2 (Downloading the data):

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

(Do NOT use Internet Explorer)

• inline:explorer1.gif

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.

• inline:explorer2.gif

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.

• inline:explorer4.gif

The file should automatically be transferred to your local machine.

• inline:explorer6.gif

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.

• inline:explorer10.gif

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

• inline:explorer11.gif

Step 5 (Processing the Carrier Payments):

Run the Carrier Payments import program:

• inline:drpaymin1.gif

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):

• inline:drpaymin3.gif

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

• inline:drpaymin4.gif

Step 6 (Reporting payments processed):

Run the Accounts Recievable Transaction Listing program:

• inline:drlstr1.gif

Select Detailed Reciepts From the Dayfile:

• inline:drlstr2b.gif

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

• inline:drlstr3.gif

Select the report output style required:

• inline:drlstr4.gif

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

• inline:drlstr5.gif

CategoryAllphones