Skip to main content
Sparkrock's Customer Success Center

Generating Vendor Payables from the Payroll Expense Ledger

This topic explains how to generate vendor payable from the Payroll Expense Ledger

Running the Process

To run the process:

  1. Click Tell Me and search for Post Payroll Liabilities and select the page from the drop-down list.
    The Post Payroll Liabilities to Accounts Payable dialog displays.
    post_payroll_liabilities_to_accounts_payable.png
  2. To create a vendor payable for a specific HR Deduction Code, enter a filter in the Code field.
  3. To create a vendor payable for a certain vendor, enter a filter in the Payable Vendor No. field.
  4. To create a vendor payable for a certain payable posting option, specify a filter in the Payable Posting Option field.
  5. In the Date Filter field, enter a date range you want to run the process for in the format MMDDYY. For example, 083019.
    This could be from one day after the last payroll period to the end of the current payroll period or the start of a month and the end of a month (i.e. 080119..083019).
  6. Click OK.
    When the process completes it returns a message saying how many invoices were created:
    clipboard_ec29c6c5c972cf291aaa9bd05c3c7275d.png

The Results

Deduction Ledger Entries

After the Post Payroll Liabilities to Accounts Payable process runs, it updates the Deduction Ledger Entries if that HR Deduction Code met the filter criteria from the report request page and Posted to A/P is TRUE. This prevents the same Deduction Ledger Entry from being sent to a Vendor Ledger multiple times.

clipboard_e44399cecc2d5d5291f0aa36b41d65229.png

Vendor Ledger Entries

You can view the result of the Post Payroll Liabilities to Accounts Payable process on the Vendor Ledger Entries page: 

  • The Vendor Ledger Entry's Vendor No. comes from the Payable Vendor No. field on the HR Deduction Code page.
  • The Vendor Ledger Entry's Document No. comes from a Number Series field on the Advanced HR Setup page.  
  • The Vendor Ledger Entry 's External Document No. is determined by the Payable Posting Option field on the HR Deduction Setup page. 
  • The Vendor Ledger Entry's Payment Method Code is determined by the Payment Method Code of the Vendor associated with the HR Deduction Code.
    clipboard_e91775dca23a5134fd65fd43af2b1b5e4.png
  • Was this article helpful?