How to Create a New Customer in SYSPRO
how to create a new customer in syspro
Also searched as
- syspro customer maintenance
- add customer syspro accounts receivable
- syspro new customer setup terms tax
- syspro create customer ar
Short answer
Create a customer in SYSPRO from the Accounts Receivable module using Customer Maintenance: enter a unique customer code, name and address, then complete the terms, tax, currency, salesperson, branch and pricing fields before saving. Most order entry errors on new customers trace back to missing terms, tax status or price code, so set them at creation.
Applies to: SYSPRO 7 and SYSPRO 8; field availability depends on installed modules and setup options
Create the customer
- 1Open the Accounts Receivable module and choose Customer Maintenance (menu labels vary slightly by version).
- 2Enter a new customer code, following your site's coding convention, and choose to add a new record.
- 3Fill in the name, address, contact and communication details, including the email used for invoices and statements.
- 4Set the customer class and terms code so aging, finance charges and due dates calculate correctly.
- 5Set the tax status or tax code and, if applicable, tax registration numbers such as VAT or GST ID.
- 6Set the currency, salesperson, branch or area, price code and credit limit, plus any ship-to addresses needed for sales orders.
- 7Save, then reopen the record to confirm the fields stuck, and create a test quotation or sales order to confirm nothing blocks order entry.
Fields that matter
Customer code is the key, and it cannot be freely renamed once transactions exist, so agree the format before the first customer is created. Many sites use a prefix by region or an alphabetic abbreviation plus a number.
Terms and tax decide how invoices behave. Terms drive due dates and discount calculations, while the tax status decides whether the customer is charged tax or treated as exempt or export. Wrong tax setup surfaces later as posting differences, so confirm with finance.
Currency is a trap: a customer in a foreign currency changes how invoices, receipts and revaluation work. Set it once and avoid switching after transactions are posted.
Ship-to, pricing and credit
If the customer receives goods at multiple sites, set up the ship-to addresses so sales order entry can select them. Delivery details held on the customer feed through to documents.
The price code and any contract pricing decide what price order entry proposes. A missing price code often leads to a zero or list price on the first order. Credit limits and credit hold settings determine whether orders are blocked, so decide who owns them.
Bulk or automated creation
If you are loading many customers from a legacy system, use the SYSPRO import tools or the e.net business object for customer maintenance instead of typing records. Validate a handful first. The business object enforces the same rules as the screen, which is the right way to avoid bad data.
Many sites add a approval step: a requester raises the request, finance checks credit and tax details, and an administrator creates the record. Keep the audit trail in a ticket or form.
Try it here, free
SYSPRO SQL Query Generator
Generate read-only SQL Server queries against common SYSPRO tables. Fill in database and filters, then copy the code.
Common pitfalls
- !Creating duplicates because nobody searched by name, email or tax number first.
- !Leaving terms or tax code blank and finding it during first invoicing.
- !Choosing the wrong currency and being unable to change it after postings.
- !Giving order entry clerks the right to change credit limits.
- !Bulk loading with no test batch.
How an ERP-grounded AI assistant handles this
An ERPray assistant on the SYSPRO database can check for likely duplicate customers (same name, email or tax number) before a record is created, and flag new customers missing terms, tax code or price code. It is read-only by default, and any write-back such as creating the customer would need human approval. For a handful of customers a month, the standard screen is enough.
Frequently asked questions
Where do I add a customer in SYSPRO?
In the Accounts Receivable module, use Customer Maintenance. The menu label can differ by version, so search the program list for customer maintenance if you cannot find it. Your operator needs permission to that program, otherwise ask your administrator.
Can I change a SYSPRO customer code later?
Generally not simply. Once a customer has transactions, the code is referenced across modules. Treat it as permanent, and create the correct code up front. If you must change it, ask your SYSPRO partner about supported options.
Why can't I enter a sales order for my new customer?
Typical causes are credit hold, missing terms, a missing tax code or an invalid price code. Open the customer record and check each of these, and check whether the customer is flagged as on hold or inactive.
Can customers be imported into SYSPRO in bulk?
Yes, through the import utilities or the customer maintenance business object, which applies the same validation as the screen. Test with a small batch, check the results in Customer Maintenance and then load the remainder.
Related
How to Create a SYSPRO Sales Order with the SORTOI Business Object
SORTOI is the SYSPRO e.net business object that enters sales orders from outside the SYSPRO client. You log on to get a session id, call the business object with a Parameter XML and a Document XML describing the order header and lines, then read the XML that comes back for warnings and the new sales order number. Always test in a non-production company first.
AdvancedSYSPRO API integration: e.net business objects, REST, EDI and Office
SYSPRO integrates mainly through e.net Solutions, a set of business objects that take and return XML, exposed through COM, .NET and web service interfaces including a REST style service in recent SYSPRO 8 releases. EDI and Office integration cover document exchange and spreadsheet work. Pick the route by direction, volume and who owns the code.
AdvancedSYSPRO Debit Note Table: Finding AP and AR Transaction Tables
SYSPRO stores supplier invoices and related documents in the Accounts Payable tables and customer documents in the Accounts Receivable tables, with the SQL Server names prefixed by module such as Ap and Ar (for example ApSupplier, ApInvoice, ArCustomer). We cannot confirm one dedicated debit note table across releases, so identify yours by querying the catalog and testing with a known document.
How-toHow to void a check (cheque) in SYSPRO
In SYSPRO you cancel an unreconciled cheque with the cheque cancellation or payment reversal route in Accounts Payable and Cash Book, which reinstates the supplier invoices and reverses the bank entry. A cheque already reconciled to the bank, or in a closed period, needs a reversal entry instead.
How-toSYSPRO reporting API: e.net, SRS server-side reporting, Crystal Reports and SRS preview problems
SYSPRO gives you three reporting routes: the e.net Solutions business object API (XML in, XML out) for programmatic data, SYSPRO Reporting Services (SRS) for designed reports run on the server, and Crystal-based or SQL-based custom reports. If the SRS preview does not work, check the services, the runtime and bitness, the SQL permissions and the client and server versions in that order.
Error fixError validating SYSPRO online profile: what it means and how to fix it
A profile validation error means the SYSPRO client or service could not confirm the operator, company, licence or database connection it was handed at logon. Check the service and licence first, then the operator and company, then the database and disk, in that order. Storage errors are usually full disks, a locked SQL file or a tempdb problem rather than a SYSPRO bug.
AI for ERPAI for SYSPRO, Grounded in Your Own Manufacturing Data
Add AI to SYSPRO without moving your manufacturing data to a public model. On-premise and private-cloud LLMs for SYSPRO in Australia, NA, and beyond.
AI for ERPAI for quote-to-cash in manufacturing and job shop ERPs
AI reads incoming RFQs, drafts quotes from your ERP's own cost and pricing history, and flags parts your shop has never quoted before, keeping the estimator in control.
AI for ERPNatural Language Query for ERP Data: Ask SAP, Infor, or Oracle a Question in Plain English
See how natural language query over SAP, Infor, Oracle, and NetSuite data works: grounded text-to-SQL, role-based permissions, and a visible audit trail.
Stuck on SYSPRO?
Talk to engineers who work inside SYSPRO every week, and who build private AI that answers these questions from your own ERP data.
Keep exploring
Free tools
- SYSPRO SQL Query GeneratorGenerate read-only SQL Server queries against common SYSPRO tables. Fill in database and filters, then copy the code.
- SYSPRO MRP ChecklistA checklist of the master data, parameters and review steps that decide whether SYSPRO MRP output can be trusted.
- SYSPRO Data Migration Mapping WorksheetTrack each master data object from legacy system to SYSPRO with transform rules, owner and sign off status.
ERP fixes and how-tos
- SYSPRO Debit Note Table: Finding AP and AR Transaction TablesWhere SYSPRO stores debit notes and AP and AR transactions in SQL Server, how to discover the right tables and columns safely, and sample read-only queries.
- How to Add AI to SYSPRO On-Prem Without Moving Your DataReference architecture for adding a private AI assistant to on-prem SYSPRO: SQL Server read replica, e.net business objects, retrieval, local GPU and audit.
- How to Install SYSPRO 8: Prerequisites, SQL Server and First UseSYSPRO 8 install overview for admins: server and SQL Server prerequisites, installer steps, creating the first company, operators, and first-use orientation.
AI on your ERP
- AI for SYSPRO, Grounded in Your Own Manufacturing DataAdd AI to SYSPRO without moving your manufacturing data to a public model. On-premise and private-cloud LLMs for SYSPRO in Australia, NA, and beyond.
- AI for SYSPRO production and job costingHow AI reads SYSPRO WIP jobs, labor and material postings to explain job cost variances and late work orders, with read-only access and on-prem hosting.
Integrations
- How to add an AI chatbot to SYSPROAdd an AI chatbot to SYSPRO for staff and customers: grounded in e.NET and SQL data, role-aware answers, portal embedding, and fully on-prem with open models.
- How to add WhatsApp to SYSPROHow to add WhatsApp to SYSPRO: use e.net business objects and SQL Server data to send order, shipment and approval messages and capture replies back into SYSPRO.