[SL] SL Subcontract Worksheet

1. Initialize the Worksheet

1. Open the SL Worksheet form in your system.
2. Select “File” → “Initialize Worksheet.”
3. Enter the following details:
   • Job Cost Company (JC Co#) and Job: Specify which company and job you’re dealing with.
   • Include all Subcontracts for the jobs listed, or choose a specific range.
   • AP Transaction Defaults: Payment control code, AP reference number, description, CM account, invoice date, and due date.
4. Click “Update” on the worksheet initialization form.
5. The form will show how many subcontracts have been added to your worksheet.

2. View and Work with Subcontracts

1. In the Job field, enter the job you just initialized.
2. Scroll through to see all the subcontracts now in the worksheet.
3. Select a subcontractor create an invoice for:
   • Retainage Adjustment: Configure if applicable.
   • Payment Amount: Enter the amount you plan to pay for each line item.
4. Reference Number: Add a reference number for the invoice.
5. Mark the invoice as “Ready.”
6. Click “Save”. This flags it as ready to send to Accounts Payable.

3. Preview and Update to Accounts Payable

1. Preview what will be sent to AP:
   • Select “File” → “SL to AP Update Preview.”
   • Choose the subcontracts you want to preview.
   • Review the details of the upcoming AP transactions.
2. If everything looks correct, close the preview report launcher.
3. Update to Accounts Payable:
   • Select “File” → “Update to Accounts Payable.”
   • Choose “Update to AP Transaction Entry.”
   • Specify the batch/month to send the invoices into.
   • In the SL Update to AP form:
     • Specify the job you want to send.
     • Make sure user restrictions allow the update.
     • Click “Update.” The invoice is added to a batch.
   • Close the SL Update to AP form.

4. Process in Accounts Payable

1. Open the AP module to view the batch:
   • Use Transaction Entry or the AP Batch Process form.
2. In the AP Batch Process form:
   • Specify the batch month and batch number.
   • Click “Validate” to check for errors.
   • Click “Post” to finalize the invoice postings.

5. Clear the Worksheet (Optional)

If you have no more invoices to send:

1. Select “File” → “Clear Worksheet.”
2. Choose which subcontracts to clear (e.g., all subcontracts for the jobs above).
3. Click “Update.”
4. Confirm how many subcontracts are being cleared and click “Close.”