Naarvin reads SAP Business One 9.3 and later, on HANA or SQL Server, through the Service Layer with a read-only Business One user. One connection reads one company database: its chart of accounts, journal entries, business partners, and A/R and A/P invoices and credit memos with what is still unpaid. The Service Layer must be reachable over HTTPS from the internet; if it is not, export your books to an SFTP folder instead.
What does Naarvin read from SAP Business One?
| Data | How it lands in Naarvin |
|---|---|
| Company | Name, local currency and country, from the company administration data |
| Chart of accounts | Title accounts are not postable; balance-sheet accounts are typed by the level-1 drawer they sit under |
| Journal entries | With their lines in local currency, foreign-currency amounts kept, and distribution rules and projects as cost centres and projects |
| Business partners | Customers and suppliers with VAT number, e-mail, phone and country |
| A/R and A/P documents | Invoices and credit memos with the amount still unpaid, and their lines with VAT |
Invoices and credit memos feed receivables and payables aging, and the lines with VAT support the VAT return work in Naarvin.
Does the Service Layer have to face the internet?
Yes, for this connection. Naarvin reaches the Service Layer only over the internet, so it must be published over HTTPS with a valid certificate: a hosted Business One, or a reverse proxy in front of the Service Layer port (50000 by default). Naarvin signs in with a session, carries it on each request and signs out when the sync ends.
If you would rather not publish it, export your accounts, journal entries, invoices and bills as files in Naarvin's import templates into a folder, and connect that folder instead: see the SFTP folder connection.
How do you connect SAP Business One?
- Create a Business One user for NaarvinWith read-only authorizations for the chart of accounts, journal entries, business partners and A/R and A/P documents.
- Publish the Service LayerOver HTTPS with a valid certificate, reachable from the internet.
- Enter the connection in NaarvinThe Service Layer address, the company database name, and the user name and password. The password is encrypted when saved and never shown again.
- Link the companyTo a new or existing company in Naarvin in the same local currency, then confirm the account mapping.
For several company databases, add one connection for each. Our team does these steps with you during onboarding.
How often does it sync, and what does each sync read?
On the schedule you set, from every 15 minutes to once a week, or on demand. Journal entries carry no change date Naarvin can follow, so every later sync re-reads them from the first day of the month before the last sync, and entries removed inside that window are marked deleted. A/R and A/P documents are read in full every time, so what is unpaid stays current; their lines are read on full syncs.
What does the Business One connection not do?
- It does not read payments on account, so money received or paid but not yet applied does not show in the aging.
- An open A/P invoice without a paid-to-date amount is taken at its total and flagged "amount due unconfirmed", and payments hold it until a person confirms what is due.
- It does not write to Business One. Approved journals are exported as a CSV file, one row per line, for your own journal import, and recorded in Naarvin with the Business One reference.
- It is built and is checked in a first sync with your own company before you rely on it.
Questions people ask
Our Business One runs on our own server. Can Naarvin still read it?
Yes, if the Service Layer is published over HTTPS with a valid certificate, for example through a reverse proxy. If not, export your books to an SFTP folder and connect that instead.
We have several company databases. Is that one connection?
No, one connection reads one company database. Add a connection for each; all of them land in one finance model in Naarvin.
How are distribution rules and projects used?
Distribution rules on journal lines become cost centres and projects become projects in Naarvin, so reports can be split the way you already post.