DuckDB Sync
How to use DuckDB Sync in Platform Settings: access, working steps, fields, related records and troubleshooting.
Purpose and access
Review platform defaults and dependencies within the administrator’s authority. Record the reason and tested impact of changes. Authentication, session settings and security-sensitive configuration need a controlled change process.
This page is a record page in System Admin → Platform Settings. Use the link above to open the configured destination; permissions are checked by the destination service.
Before you start
Prepare the required information: Doctype.
Confirm the company, party, dates, units and source references that apply. Select existing links carefully and check for an existing record before creating a duplicate.
Working steps
- Open DuckDB Sync from System Admin → Platform Settings, or use ERP Search.
- Filter the list and open the relevant record. To add a record, use Add/New when your role provides that action.
- Complete the editable fields described below. Required fields and validation conditions must be satisfied; read-only values are set by the system or their source records.
- Add the required child rows. Review each row’s identifiers, linked records and values, using the child-table field reference below.
- Save the record and address validation messages. Reload and verify the saved values and relationships.
- When the draft is complete and you are authorized, submit it through the available approval process. Submission can create operational or accounting effects. Use the permitted cancellation/amendment process for later corrections.
Field reference
These fields come from the installed ERP definition. Hidden fields and password inputs are omitted. Additional conditions, custom scripts and workflow rules can make a field required or read-only in a particular context.
| Field | Type / behavior | How to use it |
|---|---|---|
Doctypedoc_type | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: DocType |
Filenamefilename | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
DB Tablesdb_tables | Table Optional | Add the relevant child rows and review required columns, quantities and references before saving. Linked record: DuckDB Sync Item |
Amended Fromamended_from | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: DuckDB Sync |
Child tables
DB Tables — child-row fields
| Field | Type / behavior | How to use it |
|---|---|---|
Tabletable | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Syncedsynced | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Troubleshooting
- Not permitted: verify the account, role and source-document permission. Do not share an administrator login.
- Missing record or address: inspect the relevant Link or Dynamic Link fields; a matching title alone does not establish a relationship.
- Cannot save or change status: review required fields, read-only values, document status and the configured approval transition.
- Unexpected report or portal result: review company/date filters, source-document submission and the approved party or Employee link.