Netting Payables and Receivables

Use this procedure to interface transactions for all vendor customer relationships that contain a vendor balance or a customer balance. Transactions are interfaced as a summary debit or credit memo to the linked customer or vendor.
  1. Sign in as Receivables Administrator or Receivables Manager.
  2. Select Manage Customers > Receivables & Payables Netting.
  3. Specify this information:
    Company
    Select a company number.
    Balance Option
    Select a balance option. These are the valid values:
    • Receivables To Payables: Use this option to process all open company-specific transactions from accounts receivable to accounts payable to the linked vendor.
    • Payables To Receivables: Use this option to process all open company-specific transactions from accounts payable to accounts receivable to the linked customer.
    • Lesser to Greater: Use this option to process all open company-specific transactions that contain a lesser balance of either the customer and vendor to the linked vendor or customer.
    • Greater to Lesser: Use option to process all open company-specific transactions that contain a greater balance of either the customer and vendor to the linked vendor or customer
  4. If you selected Receivables To Payables for the Balance Option, specify this information:
    Post Date
    Specify the post date for the transactions.
    Reason Type
    Select the reason type. Valid values are Cash Application Adjustment, Memo Entry, or Marked As Paid.
    Receivable Reason
    Specify the adjustment reason code.
    Payment Terms
    Select the payment terms.
    Authority Code
    Select the authority code.
    Invoice Date
    Specify the invoice date for the transactions.
    Process Level
    Select the process level.
    Accrual Code
    Select the accrual code.
    Operator
    Specify the operator.
    Due Date
    Specify the due date for the transactions.
    Description
    Specify a description.
  5. If you selected Payables To Receivables for the Balance Option, specify this information:
    Post Date
    Specify the post date for the transactions.
    Process Level
    Select the process level.
    Payment Terms
    Select the payment terms.
    Accrual Code
    Select the accrual code.
    Clearing Account
    Select the clearing account.
    Invoice Date
    Specify the invoice date for the transactions.
    Memo Reason
    Select the memo reason code.
    Due Date
    Specify the due date for the transactions.
    Description
    Specify a description.
  6. If you selected Lesser To Greater or Greater To Lesser in the Balance Optionfield, specify this information in the Accounts Payable To Accounts Receivable Details section:
    Post Date
    Specify the post date for the transactions.
    Process Level
    Select the process level.
    Payment Terms
    Select the payment terms.
    Accrual Code
    Select the accrual code.
    Clearing Account
    Select the clearing account.
    Invoice Date
    Specify the invoice date for the transactions.
    Memo Reason
    Select the memo reason code.
    Due Date
    Specify the due date for the transactions.
    Description
    Specify a description.
  7. In the Accounts Receivable To Accounts Payable Details section, specify this information:
    Post Date
    Specify the post date for the transactions.
    Process Level
    Select the process level.
    Payment Terms
    Select the payment terms.
    Accrual Code
    Select the accrual code.
    Clearing Account
    Select the clearing account.
    Invoice Date
    Specify the invoice date for the transactions.
    Memo Reason
    Select the memo reason code.
    Due Date
    Specify the due date for the transactions.
    Description
    Specify a description.
  8. Specify this information in the Accounts Receivable To Accounts Payable Details section:
    Post Date
    Specify the post date for the transactions.
    Reason Type
    Select the reason type: Cash Application Adjustment, Memo Entry, or Marked As Paid.
    Receivable Reason
    Specify the adjustment reason code.
    Payment Terms
    Select the payment terms.
    Authority Code
    Select the authority code.
    Invoice Date
    Specify the invoice date for the transactions.
    Process Level
    Select the process level.
    Accrual Code
    Select the accrual code.
    Operator
    Specify the operator.
    Due Date
    Specify the due date for the transactions.
    Description
    Specify a description.
  9. Click Submit.