The Add New Export Payout option enables you to create new Export Payout records in the database. Perform the following procedure to create a new Export Payout record:
- Click
The Export Payout – Add page is displayed. This definition expects you to enter detail in various steps, by clicking or
buttons.
- Populate the form with required details as tabulated:
Field | Description |
Fields marked with (*) are mandatory. | |
Export Payout – Step 1 | |
Specification ID | Enter a unique ID representing the Export Payout. |
Export Payout – Step 2 | |
Export Destination Type | Click the drop down list adjacent to this field and select the destination type. The available values are the following:
· Fixed Width · Delimited · Excel · QuickBooks · QuickBooks Online · SalesForce |
Export Payout – Step 3 | |
Note: The fields in this Step 3 are displayed according to your selection in Step 2.
· Fixed Width: Enter required details for Configuration for Export. o Export payout data for the period of: Click the drop down list and select the required value. o Display field name at first row: Click the drop down list and select the option as Yes or No. o Select the radio button adjacent to Generate Summary Payout File or Generate Detail File field. · Delimited: Enter required details for Configuration for Export. o Export payout data for the period of: Click the drop down list and select the required value. o Display field name at first row: Click the drop down list and select the option as Yes or No. o Select the radio button adjacent to Generate Summary Payout File or Generate Detail File field. · Excel: Enter required details for Configuration for Export. o Export payout data for the period of: Click the drop down list and select the required value. o Display field name at first row: Click the drop down list and select the option as Yes or No. o Select the radio button adjacent to Generate Summary Payout File or Generate Detail File field. · QuickBooks: Select the check box adjacent to the Integration Method as Export Invoice, Export Payout, or both. · QuickBooks Online: : Select the check box adjacent to the Integration Method as Export Invoice, Export Payout, or both. · SalesForce: Enter the user name and password in respective fields for Build Connection for Sales Force Export. |
|
When QuickBooks or QuickBooks Online is selected:
Export Invoice: Proceed to Export Payout – Step 4. Export Payout: · Select the Commission Name from the drop down list. Available values are the following: o AP Commission – When you select this option, the payout of those payees who are set as non-employees in the payee screen will get exported to Quickbooks as Bill. o Payroll Commission – When you select this option, the payout of those payees who are set as employees in the payee screen will get exported to Quickbooks as commissions in payroll section under employee. o AP and Payroll Commission – This is the options is chosen when you have payees where some of them are employees and some of them or non-employees. o Receive Payments Depends on this selection, next field is populated. · AP Commission: Enter required value in Associated Value of AP Commission field. · Payroll Commission: Enter required value in Associated Value of Payroll Commission field. · AP and Payroll Commission: Enter required value in Associated Value of AP Commission field and Associated Value of Payroll Commission fields. · Receive Payments: Enter required value in Associated Value of AP Commission field. Export Credit Options: · Select the Method to apply credit against invoice from the drop down list. Available options are FIFO (First In First Out) and LIFO (Last In First Out). · Select the check box adjacent to Create Credit Memo field, if you want to create credit memo. · Select the item for credit memo from the drop down list adjacent to Item For Credit Memo field. |
|
Export Payout – Step 4 | |
Execution Query | Click the drop down list adjacent to Pre Execute Query and Post Execute Query fields and select required values. |
- Click
button to setup connection with the selected external source.
- Click
button to integrate with the selected options.
- Click
button to complete the definition.
You can also view the error report by clicking the Error Log Report link. The error log displays Summary and Detail information.