Purchase invoices — Free
Period, partner, totals and due dates.
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.
Invoices by posting period, excluding canceled invoices and cancellation documents. Credit notes, payments and journal reports are separate concepts, not silently included. Open/closed document status does not by itself certify payment. Foreign-currency values may be zero for local-currency documents. Free has rich same-row details, no invoice-line links and no 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.
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: Purchase invoices
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": "E6C78281-1613-53FA-BC4F-57A280AE999F",
"kind": "sqlServer",
"requiredObjects": [
"dbo.OPCH"
],
"requiresCustomSQL": false
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05BBEE1C-9832-5C04-8237-2BFCDD38859E",
"key": "DocDate",
"type": "date"
},
{
"direction": "ascending",
"id": "30EE327E-4AAC-5408-83F6-C6ADA9B93CD4",
"key": "DocEntry",
"type": "number"
}
],
"id": "1997FAE4-DA84-5BA3-B032-1F50869ECC13",
"mappings": [
{
"commonFieldKey": "",
"key": "DocEntry",
"label": "Internal document key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocEntry",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocNum",
"label": "Document number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocNum",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocType",
"label": "Type (I: items; S: services)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocStatus",
"label": "Status (O: open; C: closed)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocDate",
"label": "Posting date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocDueDate",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocDueDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CardCode",
"label": "Business partner code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CardCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CardName",
"label": "Business partner",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CardName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NumAtCard",
"label": "Partner reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NumAtCard",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocCur",
"label": "Document currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocCur",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocTotal",
"label": "Total — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocTotal",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocTotalFC",
"label": "Total — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocTotalFC",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PaidToDate",
"label": "Paid / credited — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PaidToDate",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaidFC",
"label": "Paid / credited — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PaidFC",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VatSum",
"label": "Tax — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VatSum",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VatSumFC",
"label": "Tax — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VatSumFC",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Comments",
"label": "Remarks",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Comments",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransId",
"label": "Internal journal key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransId",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CANCELED",
"label": "Cancellation code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CANCELED",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Purchase invoices",
"primaryKey": "DocEntry",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"DocNum",
"DocType",
"DocStatus",
"CardCode",
"CardName",
"NumAtCard",
"DocCur",
"Comments"
],
"sourceID": "E6C78281-1613-53FA-BC4F-57A280AE999F",
"sqlQuery": "",
"tableName": "dbo.OPCH"
}
],
"pages": [
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocStatus",
"label": "Status (O / C)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocDate",
"label": "Posting date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocDueDate",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NumAtCard",
"label": "Partner reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocCur",
"label": "Document currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocTotal",
"label": "Total — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocTotalFC",
"label": "Total — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "1997FAE4-DA84-5BA3-B032-1F50869ECC13",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "DocNum",
"label": "Document number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "DocType",
"label": "Type (I: items; S: services)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "DocStatus",
"label": "Status (O: open; C: closed)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and references",
"detailRole": "information",
"isVisible": true,
"key": "DocDate",
"label": "Posting date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and references",
"detailRole": "information",
"isVisible": true,
"key": "DocDueDate",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "CardCode",
"label": "Business partner code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "CardName",
"label": "Business partner",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and references",
"detailRole": "information",
"isVisible": true,
"key": "NumAtCard",
"label": "Partner reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "DocCur",
"label": "Document currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — local currency",
"detailRole": "information",
"isVisible": true,
"key": "DocTotal",
"label": "Total — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "DocTotalFC",
"label": "Total — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — local currency",
"detailRole": "information",
"isVisible": true,
"key": "PaidToDate",
"label": "Paid / credited — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "PaidFC",
"label": "Paid / credited — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — local currency",
"detailRole": "information",
"isVisible": true,
"key": "VatSum",
"label": "Tax — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "VatSumFC",
"label": "Tax — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Remarks",
"detailRole": "information",
"isVisible": true,
"key": "Comments",
"label": "Remarks",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [
{
"dateLastDays": 7,
"dateMode": "fixedDate",
"id": "8C050408-F559-588B-BC91-EC6B5F27DC08",
"key": "CANCELED",
"op": "equals",
"type": "text",
"value": "N"
}
],
"id": "1BC37472-D0F1-50A5-B7C5-6486C513374B",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "07C96302-DA17-5840-8258-63AA4CC2C030",
"includeAllOption": false,
"key": "DocDate",
"title": "Period",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "05BBEE1C-9832-5C04-8237-2BFCDD38859E",
"key": "DocDate",
"type": "date"
},
{
"direction": "ascending",
"id": "30EE327E-4AAC-5408-83F6-C6ADA9B93CD4",
"key": "DocEntry",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "DocNum",
"systemImage": "doc.text",
"title": "Purchase invoices",
"titleKey": "CardName"
}
],
"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\nInvoices by posting period, excluding canceled invoices and cancellation documents. Credit notes, payments and journal reports are separate concepts, not silently included. Open/closed document status does not by itself certify payment. Foreign-currency values may be zero for local-currency documents. Free has rich same-row details, no invoice-line links and no 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\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": "DC99FDF1-7B98-53CF-AE4B-A729A77D252B",
"rootButtonCount": 1,
"summary": "Period, partner, totals and due dates.",
"tags": [
"SAP Business One",
"SQL Server",
"free"
],
"title": "Purchase invoices — Free"
}
}