www.microkey.com

Hong Kong

This Help File Page was last Modified on 12/07/2018

  • Scroll to top of this topic Scroll to Top of Page

  • Print the current topic Print Topic

  • Send feedback on this topic by email Email Feedback

  • No expanding elements on this page Show/Hide Expanders

**************************************************************

* INSTRUCTIONS FOR HONG KONG PAY IMPORT *

**************************************************************

This Chapter is still being revised!

 

Hong Kong

 File Type:  Drafts Bank Accounts Only

 -  Requires HKBankAccount field in Bank Table

 -  Produces Comma Delimted File

 -  Output Fields

         1.    Hard Coded Value = 'R'

         2.    Subscriber.BillPayer

         3.    InvoiceHeader.InvoiceNumber

         4.    Subscriber.RoutingNumber

         5.    Subscriber.BankAccountNumber

         6.    InvoiceHeader.BalanceDue

         7.    Draft Date - Format=mm/dd/yy

         8.    Subscriber.SubscriberName

         9.    Hard Coded Value = 'M'

         10.  Bank.EFTID

 

 

 

When your Company selects Hong Kong as the File Type to be used for Auto Draft Processing, the options available to be selected are:

 

HelpFilesPostAutoDrafts-HongKong

Post Auto Drafts - Hong Kong options

 

Period To Post - Define what Recurring Billing Period is being processed for Pre-Authorized Auto Drafts.

Year - Use the Drop-Down Selection List to Choose the Year that is being processed for Pre-Authorized Auto Drafts.

Month - Use the Drop-Down Selection List to Choose the Month that is being processed for Pre-Authorized Auto Drafts.

Cycle - If the Multiple Billing Cycles feature has been implemented, use the Drop-Down Selection List to Choose the Recurring Billing Cycle that is being processed for Pre-Authorized Auto Drafts.

Batch No. - By default, it will be the calendar number of Today. Change this Batch Number, as needed.

Bank - The correct Bank Name will be automatically inserted based on the Bank assigned to the selected Recurring Billing Cycle.

Pay Date - By default, it will be Today

Use the Drop-Down Calendar/Date Entry field  to Choose the Date these Invoices will be marked as Paid within the Accounts Receivable System.

This Pay Date should be on or after the Draft Date entered next.

Draft Date - By default, it will be Today

Use the Drop-Down Calendar/Date Entry field to Choose the Date that these Amounts will be Withdrawn (Drafted) from the Subscriber's Bank account.

This Draft Date should be on or before the Draft Date entered previously.

Generate EFT File - You will need an EFT file generated, so Click this Generate EFT File? box.

File Type - Use the Drop-Down Selection List to Choose the Hong Kong EFT system.

Post Credit Cards? - Do Not Check this box

This Auto Draft processor will only post EFT Cash Deductions.

 

Understanding the Hong Kong File Format

File Type: Hong Kong - For Drafting Bank Accounts Only

Requires the Account # entry in the Hong Kong sub-tab of the Bank Table

 

HelpFilesBankEFTInfoTab-HongKongAccount

 

Produces a Comma Delimited text file.

 

Auto Draft file's Output Fields

           1.    Hard Coded Value = 'R'

         2.    Subscriber>Bill Payer

         3.    Invoice Header>Invoice Number

         4.    Subscriber>Routing Number

         5.    Subscriber>Bank Account Number

         6.    Invoice Header>Balance Due

         7.    Post Auto Draft>Draft Date - Format = mm/dd/yy (e.g., '02/01/18')

         8.    Subscriber>Subscriber Name

         9.    Hard Coded Value = 'M'

         10.  Bank>Hong Kong sub-tab>Account #