Dette trenger du kanskje ikke å gjøre!
Hvis du har kjøpt plattformen via en forhandler eller direkte fra ERP-Apps, er det mulig at grunnskjemaet allerede er konfigurert for deg.
Dette er det nødvendige Rossum-skjemaet for en kø for kontoutskriftsavstemming. Det er strukturelt forskjellig fra fakturakø-skjemaet — det inkluderer kontoutskriftslinjene, tabellene over avstemte/uavstemte linjer som brukes av avstemmingsmotoren, samt feltene for avstemmingsrelatert behandling.
For generelle instruksjoner om hvordan du sjekker, endrer eller limer inn et skjema i Rossum, se Sjekke / endre / legge til i skjema-JSON på hovedsiden for køskjemaer — prosessen er den samme, bare at den i stedet gjelder kontoutskriftskøen din.
Nødvendig skjema
Når du konfigurerer uttalelseskøen din, krever vi at skjemaet inneholder disse feltene.
Som nevnt ovenfor kan dette skjemaet kopieres og limes inn i Rossum JSON-editoren (og overskrive alt som allerede finnes der).
Hvis du trenger ekstra felt, vil vi bare ignorere dem under behandlingen, men konfigurasjonen må inneholde minst følgende:
[
{
"category": "section",
"id": "invoice_info_section",
"label": "Basic Information",
"children": [
{
"rir_field_names": ["document_type"],
"constraints": { "required": false },
"default_value": "supplier_statement",
"category": "datapoint",
"id": "document_type",
"label": "Document Type",
"type": "enum",
"options": [
{ "value": "supplier_statement", "label": "Supplier Statement" },
{ "value": "hb_statement", "label": "Housing Benefit Statement" },
{ "value": "bank_statement", "label": "Bank Statement" },
{ "value": "other", "label": "Other" }
]
},
{
"rir_field_names": [],
"constraints": { "required": true },
"default_value": null,
"category": "datapoint",
"id": "date_from",
"label": "Date From",
"type": "date",
"format": "D/M/YYYY"
},
{
"rir_field_names": [],
"constraints": { "required": false },
"default_value": null,
"category": "datapoint",
"id": "date_to",
"label": "Date To",
"type": "date",
"format": "D/M/YYYY"
}
]
},
{
"category": "section",
"id": "vendor_section",
"label": "Vendor & Customer",
"children": [
{
"rir_field_names": [],
"constraints": { "required": true },
"default_value": null,
"category": "datapoint",
"id": "vendor_match",
"label": "Vendor ID",
"disable_prediction": true,
"type": "enum",
"can_export": true,
"ui_configuration": { "type": "manual", "edit": "enabled" },
"options": [],
"enum_value_type": "string"
}
]
},
{
"category": "section",
"id": "line_items_section",
"label": "Identified Line Items",
"children": [
{
"rir_field_names": ["line_items"],
"category": "multivalue",
"id": "line_items",
"label": "Line Item",
"children": {
"category": "tuple",
"id": "line_item",
"label": "Line Item",
"children": [
{ "constraints": { "required": true }, "category": "datapoint", "id": "item_transaction_number", "label": "Inv / Trans Number", "type": "string" },
{ "constraints": { "required": true }, "category": "datapoint", "id": "item_transaction_date", "label": "Transaction Date", "type": "date", "format": "D/M/YYYY" },
{ "rir_field_names": ["table_column_description"], "constraints": { "required": false }, "category": "datapoint", "id": "item_description", "label": "Description", "type": "string" },
{ "constraints": { "required": false }, "category": "datapoint", "id": "item_additional_reference", "label": "Reference", "type": "string" },
{ "constraints": { "required": false }, "category": "datapoint", "id": "item_debit_amount", "label": "Debit Amount", "type": "number", "format": "#,##0.#" },
{ "constraints": { "required": false }, "category": "datapoint", "id": "item_credit_amount", "label": "Credit Amount", "type": "number", "format": "#,##0.#" },
{ "constraints": { "required": false }, "category": "datapoint", "id": "item_balance_amount", "label": "Balance Amount", "type": "number", "format": "#,##0.#" }
]
}
}
]
},
{
"category": "section",
"id": "matching_section",
"label": "Matching",
"disable_prediction": true,
"children": [
{
"category": "multivalue",
"id": "unmatched_table",
"label": "Un-Matched Lines",
"children": {
"category": "tuple",
"id": "un_matched_line",
"label": "Unmatched Line",
"children": [
{ "constraints": { "required": false }, "category": "datapoint", "id": "um_manual_match_to", "label": "Manual Match", "disable_prediction": true, "type": "string", "can_export": true, "ui_configuration": { "type": "data", "edit": "enabled" } },
{ "constraints": { "required": false }, "default_value": "", "category": "datapoint", "id": "um_force_unmatch", "label": "Force Unmatch", "type": "enum", "can_export": true, "ui_configuration": { "type": "data", "edit": "enabled" }, "options": [ { "value": "", "label": "" }, { "value": "FORCE", "label": "Force Unmatch" } ] },
{ "constraints": { "required": false }, "hidden": true, "category": "datapoint", "id": "um_line_guid", "label": "Internal GUID", "type": "string", "can_export": true, "ui_configuration": { "type": "data", "edit": "disabled" } }
]
}
},
{
"category": "multivalue",
"id": "matched_table",
"label": "Matched Lines",
"children": {
"category": "tuple",
"id": "matched_line",
"label": "Matched Line",
"children": [
{ "constraints": { "required": true }, "category": "datapoint", "id": "ma_matched_to", "label": "Matched To", "type": "string", "can_export": true, "ui_configuration": { "type": "data", "edit": "disabled" } },
{ "constraints": { "required": true }, "category": "datapoint", "id": "ma_matched_by", "label": "Matched By", "type": "string", "can_export": true, "ui_configuration": { "type": "data", "edit": "disabled" } },
{ "constraints": { "required": false }, "default_value": "", "category": "datapoint", "id": "ma_force_unmatch", "label": "Force Unmatch", "type": "enum", "can_export": true, "ui_configuration": { "type": "data", "edit": "enabled" }, "options": [ { "value": "", "label": "" }, { "value": "FORCE", "label": "Force Unmatch" } ] },
{ "constraints": { "required": false }, "hidden": true, "category": "datapoint", "id": "ma_line_guid", "label": "Internal GUID", "type": "string", "can_export": true, "ui_configuration": { "type": "data", "edit": "disabled" } }
]
}
}
]
},
{
"category": "section",
"id": "erp_processing_section",
"label": "Processing",
"children": [
{ "constraints": { "required": true }, "category": "datapoint", "id": "company_id", "label": "ERP Company Id", "type": "string", "can_export": true },
{ "constraints": { "required": false }, "category": "datapoint", "id": "override_warnings", "label": "Override Warnings", "disable_prediction": true, "type": "enum", "can_export": true, "ui_configuration": { "type": "manual", "edit": "enabled" }, "options": [ { "value": "YES", "label": "YES" }, { "value": "NO", "label": "NO" } ], "enum_value_type": "string" },
{ "constraints": { "required": true }, "default_value": "1", "category": "datapoint", "id": "cache_behaviour", "label": "Caching Behaviour", "disable_prediction": true, "type": "enum", "can_export": true, "ui_configuration": { "type": "manual", "edit": "enabled" }, "options": [ { "value": "1", "label": "Use caching" }, { "value": "0", "label": "Skip caches for this document" } ], "enum_value_type": "string" }
]
}
]
info
The fields above are a trimmed view of the full schema highlighting the parts unique to statement matching (the line items table, and the unmatched_table / matched_table matching grids). Your Rossum admin should obtain the complete, current schema file from ERP-Apps support to paste in directly, rather than typing this out by hand.
Notable fields
vendor_match— the supplier the statement has been matched to. This drives which transactions are pulled for matching, see the matching configuration.unmatched_table/matched_table— the grids shown in the Rossum screen for unmatched and matched lines respectively.um_manual_match_toandum_force_unmatch/ma_force_unmatchare editable by users to drive manual matching.company_id— required, used the same way as on the invoice schema to identify the ERP client/company for the statement.override_warnings— used in conjunction withelevateWarningsto allow export despite elevated warnings.