Skip to content

Tax Exemption Certificates for Acumatica

Every account flagged exempt in Acumatica with no certificate on file, or an expired one, on one list. A request is drafted and sent by a person, the certificate the customer returns is read and checked, and the exempt flag in Acumatica stays as your team sets it.

CreditUpdated Oct 202620 ERPs

See it work on Acumatica.

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

Exempt · nothing valid on file
Illustrative
CustomerExempt in AcumaticaOn fileExpiresExempt sales, 12 moStatus
Shoreline ElectricYes · resaleNonenone$84,200Missing
Westfield MasonryYes · resaleResale cert, 2022Jun 30, 2026$41,600Expired
Mill Creek CarpentryYes · resaleCert · Mill Creek Carpentry IncMar 31, 2028$12,300Name differs
Bayview DecksYes · resaleResale cert, 2024Dec 31, 2026$27,900Expiring
Oak Hill BuildersYes · resaleResale cert, 2025Dec 31, 2027$156,800Valid

Every account Acumatica flags exempt, against what is on file. Worst first.

1 / 4

The problem, as it happens in Acumatica.

A contractor says “we’re exempt” at the counter, the exempt flag gets set on the customer record in Acumatica, and the certificate is coming, they’ll bring it next time. Three years of tax-free sales later, the folder has a certificate for a different legal name, one that expired, and nothing at all for a third of the accounts Acumatica says are exempt.

Nobody tracks the gap until the auditor pulls the exempt sales report and asks for the paper. Every exempt sale without a certificate is tax the dealer owes, with interest, on a customer who may be out of business. The flag was set in a minute; the certificate behind it was nobody’s job.

How it works.

  1. 1

    Exempt accounts against the file

    Every customer record flagged exempt in Acumatica, read nightly, against the certificates on file: none, expired, expiring, wrong legal name, wrong state for where the goods ship. A list, worst first, with the exempt sales behind each one.

  2. 2

    A request is drafted

    A short note to the customer asking for the certificate, with the state’s form linked and a page under your name to upload it. A person sends it. Reminders are drafted on a schedule, each one sent by a person.

  3. 3

    The certificate is read and checked

    What the customer returns, by upload, email or photo, is read: state, certificate number, exemption type, expiry, legal name and address against the customer record. Each check is shown as a pass or a question, for a person to accept or send back.

  4. 4

    Filed against the account

    The accepted certificate, its expiry and who accepted it, on the account. The exempt flag in Acumatica stays as your team sets it; where a certificate fails, the list says so and a person decides what to do with the flag.

How it connects to Acumatica.

Lunica reads the customer record, its tax status and ship-to addresses, and the exempt sales by account through Acumatica’s OData and REST endpoints, under a role that can only read, nightly. Certificates already scanned into the files attached to the record are read where you point Lunica at them, so the first list starts from what you have, not from zero.

Nothing is written to Acumatica by Lunica and nothing is sent on its own. The request and every reminder are drafts until a person sends them. An accepted certificate is filed against the account on the Lunica server, on one server inside your network, whether Acumatica is in the cloud or on your own server. Where the expiry is kept on the customer record, it is keyed by your team, and the exempt flag is set or cleared only by your team.

What a week looks like.

  • Every exempt account with nothing valid on file, on one list, worst first.
  • Requests go out in your words, sent by a person, with a page to upload to.
  • Each certificate checked for state, number, expiry and legal name before it is filed.
  • Expiries come up before they pass, not at the audit.

Questions

Does Lunica change the exempt flag in Acumatica?

No. It shows which exempt accounts have no valid certificate. The flag on the customer record is set or cleared by your team.

Does it validate the certificate with the state?

It checks the certificate’s format, expiry, exemption type and the legal name against the customer record. Where a state offers a public lookup, the result is shown beside the certificate for a person to confirm. The state’s rules are still yours to apply.

What about multi-state and drop shipments?

The ship-to address on each exempt sale is read from Acumatica, so a certificate for one state doesn’t cover goods shipped to another, and the list says which state is missing.

Do customers get reminders automatically?

No. Reminders are drafted on the schedule you set, and each one is sent by a person. The schedule is a spec your admins edit.

Where does the certificate live?

On the Lunica server, against the account, with its expiry and who accepted it. Certificates already in the files attached to the record stay there and are read where you point Lunica at them.

Can it handle resale certificates and direct-pay permits?

Yes. Resale, direct pay, government, nonprofit and the exemption types your states use are each read for what they require, and the account carries which one it holds.

Does it need a server?

Lunica runs on one server inside your network, whether Acumatica is in the cloud or on your own server, set up and maintained by Lunica. It reads Acumatica through Acumatica’s OData and REST endpoints, under a role that can only read. There is no inbound connection from outside your network.

What does Lunica read in Acumatica?

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

Can it post to Acumatica?

Nothing lands in Acumatica without a person. What belongs in Acumatica goes back as an Acumatica API call or import scenario where one exists, or keyed by your team from what Lunica prepared.

What about our documents?

Invoice copies and scans keep living in the files attached to the record. Lunica reads them when a workflow needs one and never writes to them.

The same workflow, on another ERP.

Tax Exemption Certificates is written for every system on the list. You’re reading the Acumatica version.

See it on your Acumatica data.

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