Skip to content

Lien Waivers for Sage 100

A waiver request comes in with the draw. Lunica reads the job’s invoices and payments in Sage 100, drafts the conditional or unconditional waiver in the state’s form for the amount actually paid, and a person checks it, signs and sends it.

CreditUpdated Oct 202620 ERPs

See it work on Sage 100.

Click through the steps. Fictional data, in Sage 100’s terms; the real thing runs on Sage 100.

Request · Harbor Point Builders
Illustrative
Tom Reilly, Harbor Point BuildersConditional · progress

Draw 3 on the Route 9 warehouse closes Friday. Need a conditional progress waiver through Sep 30 for $28,640 so the lender releases it. Can you send today?

Matched to job Route 9 warehouse under 01-HARB01 · 4 invoices in the period

Read from the email: job, draw amount, period, which form.

1 / 4

The problem, as it happens in Sage 100.

The GC’s office emails on the 25th: waiver for this month’s draw, need it today or the check doesn’t cut. Whoever is at the AR desk opens the job in Sage 100, adds up the invoices they think are in the draw, finds last month’s waiver, changes the date and the amount, and signs. Conditional or unconditional is whichever the last one was.

The waiver that gave up rights on invoices that were never paid doesn’t show up anywhere. The unconditional one signed before the check cleared, the final waiver on a job that still had a special order open, the amount that was a thousand off: each one surfaces only when the job goes bad, and by then the paper says the dealer was paid.

How it works.

  1. 1

    The request comes in

    A GC or title company asks by email or on their form, with the draw amount and the period. Lunica reads it, finds the job under the customer maintenance record and the invoices in the period, and matches the draw to what Sage 100 shows paid.

  2. 2

    The waiver is drafted

    Conditional or unconditional, progress or final, in the state’s form, for the invoices actually paid or about to be. The through-date, the amount and the exceptions, like a special order not yet invoiced, come from Sage 100, and a rule refuses any figure that isn’t there.

  3. 3

    A person checks the amount and signs

    The desk shows the waiver beside the invoices and the payment it covers. If the check hasn’t cleared, only the conditional form is offered. Your credit manager edits, signs and sends it, or declines the request with a note.

  4. 4

    The signed waiver is filed against the job

    Each waiver with its type, through-date, amount and the invoices it covers, on the job, next to the notice and the job form. When the final waiver comes up, the job’s whole waiver history is beside it.

How it connects to Sage 100.

Lunica reads the jobs under each customer maintenance record, their invoices, payments and open orders through Sage 100’s ODBC driver, under a user that can only read, so a draw request is matched to the invoices in its period and to the payments Sage 100 has applied against them. Unapplied cash and open special orders are shown as exceptions, never waived by accident.

Nothing is written to Sage 100 by Lunica and nothing is sent on its own. The waiver is a draft until a person signs and sends it; the signed copy is filed against the job on the Lunica server, on one Windows server inside your network, beside the Sage 100 server. Where your team marks the waiver on the job in Sage 100, that is keyed by a person.

What a week looks like.

  • Every waiver request on one list with the draw, the period and the job.
  • Amounts come from the invoices and payments in Sage 100, not from last month’s PDF.
  • Unconditional waivers are offered only for payments that have cleared.
  • The job’s waiver history is on file for the final waiver and for counsel.

Questions

Does Lunica sign or send waivers?

No. It drafts the waiver and shows the invoices behind the amount. A person checks it, signs and sends it, and the signed copy is filed against the job.

Which forms does it use?

The state’s statutory form where the state has one, and your own form where it doesn’t. Forms are a spec your admins can read and change, with history and revert.

How does it know what’s been paid?

From Sage 100’s payments applied to the job’s invoices. A payment in hand but not yet posted shows as unapplied, and only a conditional waiver is offered against it.

What about joint checks and pay-when-paid?

A joint check is read like any other payment once Sage 100 has it applied. Until then the draft is conditional, and the desk sees that the payment is expected, not received.

Can a GC send a waiver on their own form?

Yes. Lunica reads the request, draws the figures from Sage 100, and drafts on your form or the state’s. Whether to sign theirs instead is a decision for a person.

Does it write the waiver to Sage 100?

No. The waiver is filed on the Lunica server against the job. If you note waivers on the job in Sage 100, your team keys that.

Does it need a server?

Lunica runs on one Windows server inside your network, beside the Sage 100 server, set up and maintained by Lunica. It reads Sage 100 through Sage 100’s ODBC driver, under a user that can only read. There is no inbound connection from outside your network.

What does Lunica read in Sage 100?

The customer maintenance record, open items and terms, purchase orders and receipts, the item record, quotes and order history, as each workflow needs them. Read-only, and only the rows a task is about.

Can it post to Sage 100?

Nothing lands in Sage 100 without a person. What belongs in Sage 100 goes back as a Sage 100 import or Visual Integrator job where one exists, or keyed by your team from what Lunica prepared.

What about our documents?

Invoice copies and scans keep living in Paperless Office. Lunica reads them when a workflow needs one and never writes to them.

The same workflow, on another ERP.

Lien Waivers is written for every system on the list. You’re reading the Sage 100 version.

See it on your Sage 100 data.

Thirty minutes. We walk the workflow on Sage 100 data, then map it to yours.