Journal entries — Free
Posting period, journal references and stored header totals in local, foreign and system currency.
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. Free displays journal headers with same-row details, without related lines or custom SQL.
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.
Free also shows the stored journal header totals in local, foreign and system currency, plus transaction currency. These are original OJDT values, not computed line debit/credit totals. No cross-currency total or inferred conversion is added.
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 Home0 Details1 lists1 sources to map
- Home: Journal entries
Sources are mapped locally and verified before applying.
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "SAP Business One 10.0 — SQL Server",
"id": "6472F225-6198-524C-BF04-B6B74393FA8B",
"kind": "sqlServer",
"requiredObjects": [
"dbo.OJDT"
],
"requiresCustomSQL": false
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"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": "750F1B26-15C2-5ED9-BC59-38CB4FFA09D1",
"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": "LocTotal",
"label": "Header total — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LocTotal",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FcTotal",
"label": "Header total — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FcTotal",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SysTotal",
"label": "Header total — system currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SysTotal",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransCurr",
"label": "Transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransCurr",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Journal entries",
"primaryKey": "TransId",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Number",
"Memo",
"Ref1",
"Ref2",
"TransCurr"
],
"sourceID": "6472F225-6198-524C-BF04-B6B74393FA8B",
"sqlQuery": "",
"tableName": "dbo.OJDT"
}
],
"pages": [
{
"actions": [],
"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": "LocTotal",
"label": "Header total — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TransCurr",
"label": "Transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "750F1B26-15C2-5ED9-BC59-38CB4FFA09D1",
"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": "LocTotal",
"label": "Header total — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "FcTotal",
"label": "Header total — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — system currency",
"detailRole": "information",
"isVisible": true,
"key": "SysTotal",
"label": "Header total — system currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "TransCurr",
"label": "Transaction currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "82C2EBFC-1254-52E2-875F-13B742788094",
"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"
}
],
"relations": [],
"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. Free displays journal headers with same-row details, without related lines or custom SQL.\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\nFree also shows the stored journal header totals in local, foreign and system currency, plus transaction currency. These are original OJDT values, not computed line debit/credit totals. No cross-currency total or inferred conversion is added.\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": "free",
"packageID": "D23524BC-5D3A-5B8A-8D03-E2AA47CCE0DC",
"rootButtonCount": 1,
"summary": "Posting period, journal references and remarks.",
"tags": [
"SAP Business One",
"SQL Server",
"free"
],
"title": "Journal entries — Free"
}
}