Cetec + Go Fig
Connect Cetec ERP to Go Fig for cloud manufacturing analytics and operational intelligence.
Cetec ERP is a cloud-native manufacturing system built for small and mid-size shops that outgrew QuickBooks but do not want the weight of a tier-one ERP. Its screens are fast for shop-floor users but its reporting is intentionally thin, most customers end up pulling CSVs or building SQL views to answer even basic margin and on-time-delivery questions. Go Fig connects to Cetec's REST API and its underlying data dictionary, lands every work order, BOM, receipt, invoice, and labor punch in your Financial Intelligence Graph, then lets Celeste and your team run segmentation, cost-to-produce, and cash-conversion analysis on top. Work-order-level data joins cleanly to your accounting system so gross margin ties back to the exact jobs that shipped in the period.
Key facts
- Sync grain
- Work-order and labor-punch level
- Historical backfill
- Full tenant history (typically 3 to 5 years)
- Refresh cadence
- Hourly incremental, on-demand for close
- Multi-tenant
- Multiple Cetec instances supported
- BOM revisions
- Full revision history preserved
What you can do with Cetec data in Go Fig
Job-level margin by customer
Join Cetec work-order cost rollups (material, labor, burden) to the invoiced revenue for the same job to see true gross margin per customer, product family, or order type.
On-time delivery and schedule attainment
Track promised-ship versus actual-ship dates, scrap rates, and WIP aging across the shop. Combine with capacity data to flag chronically late work centers.
Inventory and procurement diagnostics
Analyze slow-moving inventory, PO price variance, and vendor lead-time drift so finance can size working-capital headroom and the buyer can renegotiate terms with the right evidence.
Data available from Cetec
Go Fig extracts and normalizes the following data from your Cetec account:
How to connect Cetec
Create a dedicated integration user in Cetec
In Cetec, add a user named 'gofig-integration' and grant reporting-level read permissions on the modules you want to sync. Cetec scopes API access by user, so this keeps audit trails clean and lets you rotate credentials without touching other logins.
Generate the API token and share your tenant URL
Inside the new user's profile, generate an API token. Paste it into Go Fig along with your Cetec tenant URL (typically yourcompany.cetecerp.com). Go Fig tests connectivity against the data dictionary endpoint before storing the credential.
Select modules and time window
Choose which modules to sync (work orders, invoices, POs, inventory, labor). For historical backfill, specify how far back to pull, most manufacturers load three to five years of closed work orders so cost-to-produce trends have enough signal.
Join to your accounting system
If QuickBooks, Sage, or NetSuite is already connected, Go Fig will auto-match Cetec customers to accounting customers on name and email. Celeste then produces a job-level P&L that ties shop-floor cost back to GL revenue, which is the report Cetec's native UI cannot assemble.
Authentication: Cetec API token tied to a named user with read access to the modules you expose. Because Cetec scopes permissions by user, most manufacturers create a dedicated 'gofig-integration' user with reporting-level permissions so the token can be rotated or revoked without affecting shop-floor logins.
Common Questions About Cetec Integration
How does Go Fig handle Cetec's flat-table API?
Cetec exposes data as a set of flat endpoints that closely mirror the database tables (ordline, part, prcpart, transaction). Go Fig pages through each endpoint using Cetec's limit/offset parameters, reconstructs parent-child relationships (work order to operation to labor punch) in the warehouse, and normalizes the shop-floor model so it looks like a proper fact-dimension schema downstream. You do not need to understand Cetec's internal tables to query the data.
Can Go Fig reconcile Cetec WIP to the general ledger?
Yes, this is a common close-week use case. Go Fig aggregates open work-order cost (material issued, labor applied, burden applied) and stages it against the WIP GL balance in QuickBooks, Sage, or NetSuite. Variances are flagged at the work-order level so the controller can drill straight to the source transaction, which is typically a miscoded labor punch or an unposted receipt.
How often does Cetec data refresh inside Go Fig?
Hourly incremental sync by default, anchored on the last_updated column Cetec exposes on most tables. Close-week dashboards can run an on-demand sync of work orders and invoices so month-end margin reports reflect the latest labor punches. Full reindex runs nightly.
Our BOMs change constantly, does Go Fig track revisions?
Yes. Cetec stores BOM revisions as distinct part records (part number plus revision). Go Fig syncs the full history so you can compare standard cost under the revision that was active when the job ran, not today's revision. This matters when you are diagnosing margin drift on a long-running product family.
Does Go Fig support multiple Cetec tenants?
Yes. Manufacturers running Cetec across multiple plants or legal entities typically have one tenant per entity. Go Fig connects to each tenant with its own token, tags the data with an entity identifier, and lets you build consolidated or entity-specific views. Intercompany transactions can be flagged via customer or vendor name matching across tenants.
Industries running Cetec with Go Fig
Strategic CFOs in these industries typically stitch Cetec into their Financial Intelligence Graph alongside their ERP and operational systems.
Ready to connect Cetec?
See how your Cetec data looks in Go Fig with a personalized demo.
Book a Demo