This Help File Page was last Modified on 05/19/2017
This Help File Page was last Modified on 05/19/2017
❑Having the capability to Import a batch of Receipts from Dealers, large Companies, and Governmental Agencies which have a large number of Accounts that are being monitored and serviced by your Company, and have those Receipts automatically Allocated during that Import procedure, saves time and money for both parties.
•With the addition of the ability to Allocate portions of those Receipts to specifically designated Invoice Line Items incorporated into this Import process, this utility has become very valuable to those Alarm Companies that need it.
•However, not everyone uses the same file format when processing these receipts.
•The Payment Import Form provides for the:
✓Definition of any number of Payment Import file formats.
✓Selection of the appropriate Payment Import file definition.
✓Selection of the Payment Import file with the actual Receipts Data.
✓Loading those Receipts contained in the Payment Import file.
1.Open the Payment Import Form.
2.Define Payment Import file format, if required.
3.Select the required Payment Import file definition.
4.Select the Payment Import file with the actual Receipts Data.
5.Select the appropriate Bank account into which these Receipts will be deposited.
6.Load the Payment Import file with the actual Receipts Data.
7.Process the Receipts Data.
❑Open the Payment Import Form:
a)From the Backstage Menu System Select Maintenance and Choose Receivables then Click the Pay Import option, then Select Import, or
b)From the Quick Access Menu, Select Maintenance and Choose Receivables then Click the Pay Import option, then Select Import
✓The Payment Import dialog will be displayed.
Payment Import dialog
❑Define Payment Import file format, if required:
•Click the Ellipse button on the right of the File Definition field.
•The Import Definitions dialog will be displayed.
Import Definitions form opened from the Payment Import dialog
•Click the New button to create a new Import Definition.
Enter the File Name for the New Import File definition
•Enter a name for this New Import File.
✓The Name you enter should have no extension - the system will apply a ".def" extension for this Import Definition.
✓This file will be created in the C:\Program Files(x86)\MKS\MKMS folder.
•Click OK to record the New Import File's name.
Field Definitions form used for entering a New Import File
✓The Field Definitions dialog will be displayed (see above).
•Field Definitions - Each field name in the Field list has three properties:
1.Default - If there is an assumed value for this field, enter that value here.
▪If there is no assumed default value, leave the property blank, but reserve a space for it in the Import Definition.
2.Location - The starting position, within each line of data, of this field name's information.
▪Each line of data represents a portion of the total Receipt Amount that is to be posted to an Invoice, or to a specific Line Item within an Invoice.
3.Length - The maximum length of this field name's data.
➢Note: The properties of each member of the Field list must be defined, even if one or more of those properties are blank, or zero (0).
•Click the Save button to record this set of Field Definitions for the New Import File.
❑Select the required Payment Import file definition:
•Once you have defined the required Import Definitions,
✓Click the Ellipse button on the right of the File Definition field.
▪The Import Definitions dialog will be displayed.
▪Click on (select) the Import Definition that is to be used.
▪Click the Select button on the Import Definitions dialog.
•The selected Import Definition will be inserted into the File Definition field on the Payment Import Form.
❑Select the Payment Import file with the actual Receipts Data:
•Click the Ellipse button on the right of the Import File field.
•Locate the actual Receipts Data file using the standard Windows Open interface.
Using the Standard Windows Open file dialog to locate the Payments Import file
•Select the desired file
•Click the Open button.
•That Payment Import file will be inserted into the Import File field on the Payment Import Form.
❑Select the appropriate Bank account in which these Receipts will be deposited:
•Select Bank - Using the Drop-Down Selection List provides Choose the Bank into which these Receipts will be deposited.
❑Load the Payment Import file with the actual Receipts Data:
•Load File - Click the Load File button to import the data into a temporary table within MKMS to await importation and processing within your database.
•Main tab - The Payment Import file will be processed and each payment within the file will be listed in the Main tab on the Payment Import Form.
•Messages tab - Error messages relating this data will be listed in the Messages tab on the Payment Import Form.
❑Process the Receipts Data into MKMS:
•Import - Click the Import button to import the data from the temporary table into MKMS, process those payments, and allocate them to the appropriate Invoices in your database.
•Exceptions tab - Processing exceptions (and errors) will be displayed in the Exceptions tab.
✓If the Exceptions tab does not appear, all Payment Import transactions processed as expected.