Journal entries — Pro
Posting period, journal references and remarks; debits, credits and account lines.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.
Based on the official SAP Business One 10.0 SDK reference and synthetic tests. Screenshots show native Cifru with fictional DEMO rows, not a live SAP connection. At import, map your authorized company source, run the read/compatibility test and check edition, fields, permissions and results before business use.
Journal entries, including reversal entries if present, by posting period. This is not a statutory trial balance or a replacement for fiscal reporting. Header totals sum native line debits and credits in local currency. Each journal opens its own lines with account name, counterpart code, foreign currency and explanations. No debit/credit sign inversion or guessed account classification.
Why Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorized source and your Cifru plan.
SAP Business One 10.0 on Microsoft SQL Server only; not SAP HANA. Connect to one authorized company database using a restricted read-only account. Local-currency and foreign-currency amounts are distinct; no invented currency conversion or cross-currency total. Up to 2,000 rows per read; narrow the period or filters for large datasets. Live reads, no periodic background refresh. Detail buttons read only the selected context. Technical join keys are hidden.
Field legend on Free: status O = Open, C = Closed; type I = Items, S = Services. Commercial numbers are shown as identifiers; hidden internal keys drive all related reads. Partner currency settings are not labels for local balances. Do not combine foreign amounts across currencies. Native credit limits are not unused credit. Product activity flags alone do not apply validity dates. Stock drilldowns show the current item in all warehouses, not just the document warehouse or historical stock. Service lines have no product or stock dossier; their original line Details remain available. Document totals can include rounding, freight, withholding or header-level adjustments; do not assume they always equal the sum of net lines and line taxes. SQL Server 2012 or newer is needed for custom SQL CONCAT/DATALENGTH where used. The 2,000-row cap does not guarantee a cheap server scan. Public documentation: https://help.sap.com/docs/SAP_BUSINESS_ONE
Screenshots
What this package creates
1 Home1 Details2 lists1 sources to map
- Home: Journal entries
- Details: Journal lines
- Sub-button: Journal lines
Sources are mapped locally and verified before applying.
Custom queriesPRO2 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT h.[TransId], h.[Number], h.[RefDate], h.[DueDate], h.[TaxDate], h.[Memo], h.[Ref1], h.[Ref2], COALESCE(SUM(l.Debit), 0) AS DebitTotal, COALESCE(SUM(l.Credit), 0) AS CreditTotal, COUNT(l.Line_ID) AS LineCount FROM dbo.OJDT h LEFT JOIN dbo.JDT1 l ON l.TransId = h.TransId WHERE h.RefDate >= :date_from AND h.RefDate < :date_until GROUP BY h.[TransId], h.[Number], h.[RefDate], h.[DueDate], h.[TaxDate], h.[Memo], h.[Ref1], h.[Ref2]
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(CAST(l.TransId AS varchar(20)), N':', CAST(l.Line_ID AS varchar(20))) AS row_id, l.[TransId], l.[Line_ID], l.[Account], l.[Debit], l.[Credit], l.[FCDebit], l.[FCCredit], l.[FCCurrency], l.[ShortName], l.[ContraAct], l.[LineMemo], l.[RefDate], l.[DueDate], a.AcctName FROM dbo.JDT1 l LEFT JOIN dbo.OACT a ON a.AcctCode = l.Account WHERE l.TransId = :journal
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "SAP Business One 10.0 — SQL Server",
"id": "08FB28E8-D5D1-5BB4-B045-2D6C3EB966BC",
"kind": "sqlServer",
"requiredObjects": [
"dbo.JDT1",
"dbo.OACT",
"dbo.OJDT"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "SAP Business One",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "DC6918DD-B9C5-5093-8BCD-C6DCDD05EF9E",
"key": "RefDate",
"type": "date"
},
{
"direction": "ascending",
"id": "B67B2B41-C528-578D-8212-3AD26F79108C",
"key": "TransId",
"type": "number"
}
],
"id": "CF49114D-7099-53C1-B2FC-0B1995D06EE7",
"mappings": [
{
"commonFieldKey": "",
"key": "TransId",
"label": "Internal journal key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransId",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Number",
"label": "Journal number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Number",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RefDate",
"label": "Posting date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RefDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DueDate",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DueDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TaxDate",
"label": "Document date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TaxDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Memo",
"label": "Journal remarks",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Memo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Ref1",
"label": "Reference 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Ref1",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Ref2",
"label": "Reference 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Ref2",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DebitTotal",
"label": "Total debits — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DebitTotal",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CreditTotal",
"label": "Total credits — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CreditTotal",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineCount",
"label": "Journal lines",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineCount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Journal entries",
"primaryKey": "TransId",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "RefDate",
"id": "3A141EE2-D860-5A6D-8E26-ABDE0568EDED",
"name": "date_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "RefDate",
"id": "69AF88BB-E3E0-5681-822F-178332568AB8",
"name": "date_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Number",
"Memo",
"Ref1",
"Ref2"
],
"sourceID": "08FB28E8-D5D1-5BB4-B045-2D6C3EB966BC",
"sqlQuery": "SELECT h.[TransId], h.[Number], h.[RefDate], h.[DueDate], h.[TaxDate], h.[Memo], h.[Ref1], h.[Ref2], COALESCE(SUM(l.Debit), 0) AS DebitTotal, COALESCE(SUM(l.Credit), 0) AS CreditTotal, COUNT(l.Line_ID) AS LineCount FROM dbo.OJDT h LEFT JOIN dbo.JDT1 l ON l.TransId = h.TransId WHERE h.RefDate >= :date_from AND h.RefDate < :date_until GROUP BY h.[TransId], h.[Number], h.[RefDate], h.[DueDate], h.[TaxDate], h.[Memo], h.[Ref1], h.[Ref2]",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "SAP Business One",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "C105670C-E610-57DE-825C-AE40BA1E17D2",
"key": "Line_ID",
"type": "number"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "36F622AC-1D86-5724-9DAD-2987402DEFD7",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "Internal row key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransId",
"label": "Internal journal key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransId",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Line_ID",
"label": "Internal journal line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Line_ID",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Account",
"label": "G/L account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Account",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Debit",
"label": "Debit — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Debit",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Credit",
"label": "Credit — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Credit",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FCDebit",
"label": "Debit — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FCDebit",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FCCredit",
"label": "Credit — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FCCredit",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FCCurrency",
"label": "Foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FCCurrency",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ShortName",
"label": "Partner / account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ShortName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ContraAct",
"label": "Offset account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ContraAct",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineMemo",
"label": "Line remarks",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineMemo",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "RefDate",
"label": "Posting date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RefDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DueDate",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DueDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AcctName",
"label": "Account name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AcctName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Journal lines",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TransId",
"id": "472DE5BA-3553-584C-B3AD-F0BD15E3D7DC",
"name": "journal",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Account",
"FCCurrency",
"ShortName",
"ContraAct",
"LineMemo",
"AcctName"
],
"sourceID": "08FB28E8-D5D1-5BB4-B045-2D6C3EB966BC",
"sqlQuery": "SELECT CONCAT(CAST(l.TransId AS varchar(20)), N':', CAST(l.Line_ID AS varchar(20))) AS row_id, l.[TransId], l.[Line_ID], l.[Account], l.[Debit], l.[Credit], l.[FCDebit], l.[FCCredit], l.[FCCurrency], l.[ShortName], l.[ContraAct], l.[LineMemo], l.[RefDate], l.[DueDate], a.AcctName FROM dbo.JDT1 l LEFT JOIN dbo.OACT a ON a.AcctCode = l.Account WHERE l.TransId = :journal",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "7F669BE2-548F-54F4-A303-F294C2181C84",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "E1EEF82D-7093-5EFC-A2AF-DF15E0E59E41",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "36F622AC-1D86-5724-9DAD-2987402DEFD7",
"title": "Journal lines",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "RefDate",
"label": "Posting date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TaxDate",
"label": "Document date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Ref1",
"label": "Reference 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Ref2",
"label": "Reference 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DebitTotal",
"label": "Total debits — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CreditTotal",
"label": "Total credits — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Journal lines",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "CF49114D-7099-53C1-B2FC-0B1995D06EE7",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "Number",
"label": "Journal number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and references",
"detailRole": "information",
"isVisible": true,
"key": "RefDate",
"label": "Posting date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and references",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and references",
"detailRole": "information",
"isVisible": true,
"key": "TaxDate",
"label": "Document date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Remarks",
"detailRole": "information",
"isVisible": true,
"key": "Memo",
"label": "Journal remarks",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and references",
"detailRole": "information",
"isVisible": true,
"key": "Ref1",
"label": "Reference 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and references",
"detailRole": "information",
"isVisible": true,
"key": "Ref2",
"label": "Reference 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — local currency",
"detailRole": "information",
"isVisible": true,
"key": "DebitTotal",
"label": "Total debits — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — local currency",
"detailRole": "information",
"isVisible": true,
"key": "CreditTotal",
"label": "Total credits — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Journal lines",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "4C8E420A-2FF9-52EC-A358-9A8F35012495",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "770E1B0C-6DB1-5EC4-8F16-22651C22DF26",
"includeAllOption": false,
"key": "RefDate",
"title": "Period",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "DC6918DD-B9C5-5093-8BCD-C6DCDD05EF9E",
"key": "RefDate",
"type": "date"
},
{
"direction": "ascending",
"id": "B67B2B41-C528-578D-8212-3AD26F79108C",
"key": "TransId",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "Number",
"systemImage": "tablecells",
"title": "Journal entries",
"titleKey": "Memo"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Debit",
"label": "Debit — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Credit",
"label": "Credit — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FCDebit",
"label": "Debit — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FCCredit",
"label": "Credit — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FCCurrency",
"label": "Foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ShortName",
"label": "Partner / account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineMemo",
"label": "Line remarks",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "36F622AC-1D86-5724-9DAD-2987402DEFD7",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "Account",
"label": "G/L account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — local currency",
"detailRole": "information",
"isVisible": true,
"key": "Debit",
"label": "Debit — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — local currency",
"detailRole": "information",
"isVisible": true,
"key": "Credit",
"label": "Credit — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "FCDebit",
"label": "Debit — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "FCCredit",
"label": "Credit — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "FCCurrency",
"label": "Foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "ShortName",
"label": "Partner / account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "ContraAct",
"label": "Offset account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Remarks",
"detailRole": "information",
"isVisible": true,
"key": "LineMemo",
"label": "Line remarks",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and references",
"detailRole": "information",
"isVisible": true,
"key": "RefDate",
"label": "Posting date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and references",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "AcctName",
"label": "Account name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "E788FA2C-71F2-557B-9763-DAE436346A3C",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "C105670C-E610-57DE-825C-AE40BA1E17D2",
"key": "Line_ID",
"type": "number"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "Account",
"systemImage": "tablecells",
"title": "Journal lines",
"titleKey": "AcctName"
}
],
"relations": [
{
"childDatasetID": "36F622AC-1D86-5724-9DAD-2987402DEFD7",
"childKey": "TransId",
"id": "E1EEF82D-7093-5EFC-A2AF-DF15E0E59E41",
"name": "Journal lines",
"parentDatasetID": "CF49114D-7099-53C1-B2FC-0B1995D06EE7",
"parentKey": "TransId"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "SAP Business One",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-03T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.\n\nBased on the official SAP Business One 10.0 SDK reference and synthetic tests. Screenshots show native Cifru with fictional DEMO rows, not a live SAP connection. At import, map your authorized company source, run the read/compatibility test and check edition, fields, permissions and results before business use.\n\nJournal entries, including reversal entries if present, by posting period. This is not a statutory trial balance or a replacement for fiscal reporting. Header totals sum native line debits and credits in local currency. Each journal opens its own lines with account name, counterpart code, foreign currency and explanations. No debit/credit sign inversion or guessed account classification.\n\nWhy Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorized source and your Cifru plan.\n\nSAP Business One 10.0 on Microsoft SQL Server only; not SAP HANA. Connect to one authorized company database using a restricted read-only account. Local-currency and foreign-currency amounts are distinct; no invented currency conversion or cross-currency total. Up to 2,000 rows per read; narrow the period or filters for large datasets. Live reads, no periodic background refresh. Detail buttons read only the selected context. Technical join keys are hidden.\n\nField legend on Free: status O = Open, C = Closed; type I = Items, S = Services. Commercial numbers are shown as identifiers; hidden internal keys drive all related reads. Partner currency settings are not labels for local balances. Do not combine foreign amounts across currencies. Native credit limits are not unused credit. Product activity flags alone do not apply validity dates. Stock drilldowns show the current item in all warehouses, not just the document warehouse or historical stock. Service lines have no product or stock dossier; their original line Details remain available. Document totals can include rounding, freight, withholding or header-level adjustments; do not assume they always equal the sum of net lines and line taxes. SQL Server 2012 or newer is needed for custom SQL CONCAT/DATALENGTH where used. The 2,000-row cap does not guarantee a cheap server scan. Public documentation: https://help.sap.com/docs/SAP_BUSINESS_ONE",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "6B0971E9-3FF2-556B-93F2-8C4828D713DE",
"rootButtonCount": 1,
"summary": "Posting period, journal references and remarks; debits, credits and account lines.",
"tags": [
"SAP Business One",
"SQL Server",
"pro"
],
"title": "Journal entries — Pro"
}
}