• Home
  • Home
home/Knowledge Base/QC User Manual/Add New Export Payout
Popular Search:Getting Started

Add New Export Payout

2 views 0 June 22, 2021 kbadmin

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:

  1. Click

The Export Payout – Add page is displayed. This definition expects you to enter detail in various steps, by clicking  or  buttons.

  1. 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.
  1. Click button to setup connection with the selected external source.
  2. Click button to integrate with the selected options.
  3. 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.

Was this helpful?

Yes  No
Related Articles
  • Payee Other information
  • Access Sales by Customer Job – Transaction Summary
  • Sales by Customer Job – Transaction Summary
  • Access Sales by Customer – Transaction Detail
  • Sales by Customer – Transaction Detail
  • Access Payees Incentive Commissions Report by Manager
Leave A Comment Cancel reply

Cloud Tags
Download Information Master Data Products
QC User Manual
  • Add New Export Payout
  • Payee Other information
  • Access Sales by Customer Job – Transaction Summary
  • Sales by Customer Job – Transaction Summary
  • Access Sales by Customer – Transaction Detail
  • Sales by Customer – Transaction Detail
View All 864  
Popular Articles
  • post – with header image
  • Where do i post support query?
  • post – article feedback
  • post – related articles
  • Introduction
KB Categories
  • QC User Manual
  • Billing
  • General Theme Questions
About QCommission

QCommission is a powerful, flexible sales commission software. It calculates your sales people’s compensation accurately and reduces errors.

Support Links
  • FAQ
  • Forums
  • KnowledgeBase
  • Documentation
Useful Help Links
  • Community Home
  • Item support
  • Refunds
  • Market API
Frequent Visit Links
  • Licenses
  • Terms
  • Refunds
  • Privacy Policy
  • Privacy Policy
  • Terms of Use
  • Copyright @ 2021 CellarStone Inc. All Rights Reserved.

Popular Search:Getting Started