Factures fournisseurs — Free
Période, tiers et montants ; deux listes et détails de la facture.
NON OFFICIEL — NON VALIDÉ SUR UNE INSTALLATION ERP RÉELLE. Configuration issue de la documentation publique et testée avec des données synthétiques. À l’import, vérifier la version, les tables, les champs et les résultats avec votre administrateur Sage. Les captures natives Cifru montrent uniquement des données DEMO fictives.
Factures fournisseurs de Gestion commerciale, types 16 et 17. Les devis, commandes, bons de livraison, avoirs et archives ne sont pas mélangés aux factures. Une facture comptabilisée ou validée ne signifie pas automatiquement payée. Les montants sont natifs et les remises ne sont pas appliquées une seconde fois. Free : deux boutons indépendants, factures et factures comptabilisées. Le bouton « Fact. achats compta. » désigne uniquement les factures comptabilisées. Détails du même enregistrement, sans lignes liées ni SQL personnalisé.
Pourquoi Cifru ? Adaptez les configurations à votre façon de travailler. Choisissez les champs, filtres et détails utiles, et retrouvez sur votre téléphone des informations qui peuvent manquer dans l’application mobile de votre logiciel de gestion. Les possibilités dépendent des données accessibles dans votre source autorisée et de votre offre Cifru.
Sage 100 France 12.20, Gestion commerciale sur Microsoft SQL Server. Une base société autorisée et un compte de lecture seulement sont nécessaires. Aucun accès fourni par le développeur. Aucun mot de passe ni donnée métier dans ce paquet. Les montants sont les valeurs natives Sage : aucun taux inventé, aucune conversion ni somme entre sociétés ou devises différentes. Vérifier la devise de tenue et les paramètres de devise de la société. Les indices de devise Sage ne sont pas des codes ISO. Les tarifs article ne remplacent pas un prix négocié client/fournisseur. Lecture à la demande, sans rafraîchissement périodique ; maximum 2 000 lignes par lecture. Réduire la période ou les filtres si la limite est atteinte. Les identifiants internes servent aux liens et ne sont pas affichés.
Structure issue du manuel public 12.20 ; pas encore testé sur une base Sage sous licence. Les tables, colonnes, cbMarq, droits et performances doivent être vérifiés sur la version cible. Les modules et personnalisations peuvent différer. Les exemples DEMO ne certifient pas la compatibilité réelle. Documentation officielle : https://fr-kb.sage.com/
Lecture des champs : « Encours autorisé » est le plafond saisi sur la fiche tiers, pas le solde dû. Les indicateurs 0/1 signifient non/oui. Sur Free, suivi stock : 0 aucun, 1 série, 2 CMUP, 3 FIFO, 4 LIFO, 5 lot ; unité poids : 0 tonne, 1 quintal, 2 kilogramme, 3 gramme, 4 milligramme ; statut document : 0 saisie, 1 confirmé, 2 accepté. Un statut de document ne prouve ni paiement ni livraison. Sur Pro, les modes de taxe sont explicités : la valeur se lit avec son unité et sa nature, sans calculer une taxe supplémentaire.
Screenshots
What this package creates
2 Home0 Details2 lists1 sources to map
- Home: Factures achats
- Home: Fact. achats compta.
Sources are mapped locally and verified before applying.
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage 100 France — Gestion commerciale — SQL Server",
"id": "6A663F36-8CF3-5A61-80D6-094D0F7DAA29",
"kind": "sqlServer",
"requiredObjects": [
"dbo.F_DOCENTETE"
],
"requiresCustomSQL": false
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "284D6597-BCDD-52A0-9064-61983CBB6247",
"key": "DO_Date",
"type": "date"
},
{
"direction": "ascending",
"id": "171FA105-92C1-5ADF-8A91-B7EE747B1DD7",
"key": "cbMarq",
"type": "number"
}
],
"id": "269A683E-0516-5760-8389-2F3538C4BB4A",
"mappings": [
{
"commonFieldKey": "",
"key": "cbMarq",
"label": "Clé interne",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cbMarq",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Type",
"label": "Type interne",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Type",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Domaine",
"label": "Domaine interne",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Domaine",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Piece",
"label": "Numéro de pièce",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Piece",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Date",
"label": "Date du document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Date",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_Ref",
"label": "Référence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Ref",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_Tiers",
"label": "Code tiers",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Tiers",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Devise",
"label": "Indice devise Sage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Devise",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Cours",
"label": "Cours du document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Cours",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_DateLivr",
"label": "Livraison prévue",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_DateLivr",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Statut",
"label": "Statut natif",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Statut",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Contact",
"label": "Contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Contact",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_FactureFrs",
"label": "Facture fournisseur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_FactureFrs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_DateLivrRealisee",
"label": "Livraison réalisée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_DateLivrRealisee",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_TotalHT",
"label": "Total HT",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_TotalHT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_TotalHTNet",
"label": "Total HT net",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_TotalHTNet",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_TotalTTC",
"label": "Total TTC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_TotalTTC",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_NetAPayer",
"label": "Net à payer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_NetAPayer",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_MontantRegle",
"label": "Montant réglé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_MontantRegle",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_Valide",
"label": "Validé (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Valide",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Factures fournisseurs",
"primaryKey": "cbMarq",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"DO_Piece",
"DO_Ref",
"DO_Tiers",
"DO_Contact",
"DO_FactureFrs"
],
"sourceID": "6A663F36-8CF3-5A61-80D6-094D0F7DAA29",
"sqlQuery": "",
"tableName": "dbo.F_DOCENTETE"
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "284D6597-BCDD-52A0-9064-61983CBB6247",
"key": "DO_Date",
"type": "date"
},
{
"direction": "ascending",
"id": "171FA105-92C1-5ADF-8A91-B7EE747B1DD7",
"key": "cbMarq",
"type": "number"
}
],
"id": "A0B3A730-52C7-5811-A936-295DE8D94A51",
"mappings": [
{
"commonFieldKey": "",
"key": "cbMarq",
"label": "Clé interne",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cbMarq",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Type",
"label": "Type interne",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Type",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Domaine",
"label": "Domaine interne",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Domaine",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Piece",
"label": "Numéro de pièce",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Piece",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Date",
"label": "Date du document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Date",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_Ref",
"label": "Référence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Ref",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_Tiers",
"label": "Code tiers",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Tiers",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Devise",
"label": "Indice devise Sage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Devise",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Cours",
"label": "Cours du document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Cours",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_DateLivr",
"label": "Livraison prévue",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_DateLivr",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Statut",
"label": "Statut natif",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Statut",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_Contact",
"label": "Contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Contact",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_FactureFrs",
"label": "Facture fournisseur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_FactureFrs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_DateLivrRealisee",
"label": "Livraison réalisée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_DateLivrRealisee",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_TotalHT",
"label": "Total HT",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_TotalHT",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DO_TotalHTNet",
"label": "Total HT net",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_TotalHTNet",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_TotalTTC",
"label": "Total TTC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_TotalTTC",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_NetAPayer",
"label": "Net à payer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_NetAPayer",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_MontantRegle",
"label": "Montant réglé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_MontantRegle",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DO_Valide",
"label": "Validé (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DO_Valide",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Factures fournisseurs comptabilisées",
"primaryKey": "cbMarq",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"DO_Piece",
"DO_Ref",
"DO_Tiers",
"DO_Contact",
"DO_FactureFrs"
],
"sourceID": "6A663F36-8CF3-5A61-80D6-094D0F7DAA29",
"sqlQuery": "",
"tableName": "dbo.F_DOCENTETE"
}
],
"pages": [
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Date",
"label": "Date du document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Ref",
"label": "Référence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_TotalHTNet",
"label": "Total HT net",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_TotalTTC",
"label": "Total TTC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_NetAPayer",
"label": "Net à payer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_MontantRegle",
"label": "Montant réglé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "269A683E-0516-5760-8389-2F3538C4BB4A",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Piece",
"label": "Numéro de pièce",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Date",
"label": "Date du document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Ref",
"label": "Référence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Tiers",
"label": "Code tiers",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Devise",
"label": "Indice devise Sage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Cours",
"label": "Cours du document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_DateLivr",
"label": "Livraison prévue",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Statut",
"label": "Statut natif",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Contact",
"label": "Contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_FactureFrs",
"label": "Facture fournisseur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_DateLivrRealisee",
"label": "Livraison réalisée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_TotalHT",
"label": "Total HT",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_TotalHTNet",
"label": "Total HT net",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_TotalTTC",
"label": "Total TTC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_NetAPayer",
"label": "Net à payer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_MontantRegle",
"label": "Montant réglé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Valide",
"label": "Validé (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [
{
"dateLastDays": 7,
"dateMode": "fixedDate",
"id": "7E6C11D4-5187-574C-9D17-9B86907A43A5",
"key": "DO_Type",
"op": "equals",
"type": "number",
"value": "16"
},
{
"dateLastDays": 7,
"dateMode": "fixedDate",
"id": "8EFA62F5-F2F7-5635-8F47-B8EC775A644A",
"key": "DO_Domaine",
"op": "equals",
"type": "number",
"value": "1"
}
],
"id": "39DB3BFB-FAF3-5482-9FD8-3D6FA580F625",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "568EDC05-448E-581B-A944-EB3239C9ECBA",
"includeAllOption": false,
"key": "DO_Date",
"title": "Période",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "284D6597-BCDD-52A0-9064-61983CBB6247",
"key": "DO_Date",
"type": "date"
},
{
"direction": "ascending",
"id": "171FA105-92C1-5ADF-8A91-B7EE747B1DD7",
"key": "cbMarq",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "DO_Piece",
"systemImage": "doc.text",
"title": "Factures achats",
"titleKey": "DO_Tiers"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Date",
"label": "Date du document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Ref",
"label": "Référence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_TotalHTNet",
"label": "Total HT net",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_TotalTTC",
"label": "Total TTC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_NetAPayer",
"label": "Net à payer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_MontantRegle",
"label": "Montant réglé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "A0B3A730-52C7-5811-A936-295DE8D94A51",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Piece",
"label": "Numéro de pièce",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Date",
"label": "Date du document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Ref",
"label": "Référence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Tiers",
"label": "Code tiers",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Devise",
"label": "Indice devise Sage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Cours",
"label": "Cours du document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_DateLivr",
"label": "Livraison prévue",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Statut",
"label": "Statut natif",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Contact",
"label": "Contact",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_FactureFrs",
"label": "Facture fournisseur",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_DateLivrRealisee",
"label": "Livraison réalisée",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_TotalHT",
"label": "Total HT",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_TotalHTNet",
"label": "Total HT net",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_TotalTTC",
"label": "Total TTC",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_NetAPayer",
"label": "Net à payer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_MontantRegle",
"label": "Montant réglé",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DO_Valide",
"label": "Validé (0 non, 1 oui)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [
{
"dateLastDays": 7,
"dateMode": "fixedDate",
"id": "52C609CD-616E-51C0-A0E0-B23ACC1D0A47",
"key": "DO_Type",
"op": "equals",
"type": "number",
"value": "17"
},
{
"dateLastDays": 7,
"dateMode": "fixedDate",
"id": "D56595BB-B48C-5FB0-99BC-4A91C534D33E",
"key": "DO_Domaine",
"op": "equals",
"type": "number",
"value": "1"
}
],
"id": "DE9EAC59-633B-5851-AAEC-AB41BEAFA710",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "568EDC05-448E-581B-A944-EB3239C9ECBA",
"includeAllOption": false,
"key": "DO_Date",
"title": "Période",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "284D6597-BCDD-52A0-9064-61983CBB6247",
"key": "DO_Date",
"type": "date"
},
{
"direction": "ascending",
"id": "171FA105-92C1-5ADF-8A91-B7EE747B1DD7",
"key": "cbMarq",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "DO_Piece",
"systemImage": "doc.text",
"title": "Fact. achats compta.",
"titleKey": "DO_Tiers"
}
],
"relations": [],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Sage 100 France",
"configurationLanguages": [
"fr"
],
"countries": [
"FR"
],
"createdAt": "2026-10-02T00:00:00Z",
"description": "NON OFFICIEL — NON VALIDÉ SUR UNE INSTALLATION ERP RÉELLE. Configuration issue de la documentation publique et testée avec des données synthétiques. À l’import, vérifier la version, les tables, les champs et les résultats avec votre administrateur Sage. Les captures natives Cifru montrent uniquement des données DEMO fictives.\n\nFactures fournisseurs de Gestion commerciale, types 16 et 17. Les devis, commandes, bons de livraison, avoirs et archives ne sont pas mélangés aux factures. Une facture comptabilisée ou validée ne signifie pas automatiquement payée. Les montants sont natifs et les remises ne sont pas appliquées une seconde fois. Free : deux boutons indépendants, factures et factures comptabilisées. Le bouton « Fact. achats compta. » désigne uniquement les factures comptabilisées. Détails du même enregistrement, sans lignes liées ni SQL personnalisé.\n\nPourquoi Cifru ? Adaptez les configurations à votre façon de travailler. Choisissez les champs, filtres et détails utiles, et retrouvez sur votre téléphone des informations qui peuvent manquer dans l’application mobile de votre logiciel de gestion. Les possibilités dépendent des données accessibles dans votre source autorisée et de votre offre Cifru.\n\nSage 100 France 12.20, Gestion commerciale sur Microsoft SQL Server. Une base société autorisée et un compte de lecture seulement sont nécessaires. Aucun accès fourni par le développeur. Aucun mot de passe ni donnée métier dans ce paquet. Les montants sont les valeurs natives Sage : aucun taux inventé, aucune conversion ni somme entre sociétés ou devises différentes. Vérifier la devise de tenue et les paramètres de devise de la société. Les indices de devise Sage ne sont pas des codes ISO. Les tarifs article ne remplacent pas un prix négocié client/fournisseur. Lecture à la demande, sans rafraîchissement périodique ; maximum 2 000 lignes par lecture. Réduire la période ou les filtres si la limite est atteinte. Les identifiants internes servent aux liens et ne sont pas affichés.\n\nStructure issue du manuel public 12.20 ; pas encore testé sur une base Sage sous licence. Les tables, colonnes, cbMarq, droits et performances doivent être vérifiés sur la version cible. Les modules et personnalisations peuvent différer. Les exemples DEMO ne certifient pas la compatibilité réelle. Documentation officielle : https://fr-kb.sage.com/\n\nLecture des champs : « Encours autorisé » est le plafond saisi sur la fiche tiers, pas le solde dû. Les indicateurs 0/1 signifient non/oui. Sur Free, suivi stock : 0 aucun, 1 série, 2 CMUP, 3 FIFO, 4 LIFO, 5 lot ; unité poids : 0 tonne, 1 quintal, 2 kilogramme, 3 gramme, 4 milligramme ; statut document : 0 saisie, 1 confirmé, 2 accepté. Un statut de document ne prouve ni paiement ni livraison. Sur Pro, les modes de taxe sont explicités : la valeur se lit avec son unité et sa nature, sans calculer une taxe supplémentaire.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "free",
"packageID": "20E459D2-1C66-598C-95ED-CF55110E2D96",
"rootButtonCount": 2,
"summary": "Période, tiers et montants ; deux listes et détails de la facture.",
"tags": [
"Sage 100",
"SQL Server",
"Gestion commerciale",
"free"
],
"title": "Factures fournisseurs — Free"
}
}