Liste des filtres supportés par chacun des systèmes
Catégorie | Entité | Acomba![]() |
Avantage![]() |
QuickBooks![]() |
Sage 50![]() |
Servicentre![]() |
---|---|---|---|---|---|---|
Account Payable | AccountPayableSettings | 1,9* | ** | |||
Supplier | 1,5,6,7,8,9* | 1,2,3,4,5,6,7,8 | 1,4,5,6,7,8* | ** | ||
SupplierInvoice | 1,5,6,7,8,9* | 1,2,3,4,5,6,7,8,9 | 1,4,5,6,7,8* | 1,5,6,7,8* | ||
SupplierInvoicePayment | 1,2,3,4,5,6,7,8,9 | |||||
SupplierOrder | 1,5,6,7,8,9* | 1,2,3,4,5,6,7,8 | ||||
SupplierOrderReceipt | ||||||
SupplierProduct | 1,5,6,7,8* | |||||
Account Receivable | Customer | 1,5,6,7,8,9* | 1,2,3,4,5,6,7,8 | 1,4,5,6,7,8* | ||
CustomerBid | 1,5,6,7,8,9* | |||||
CustomerInvoice | 1,5,6,7,8,9* | 1,2,3,4,5,6,7,8 | 1,4,5,6,7,8* | |||
CustomerInvoicePayment | * | |||||
CustomerOrder | 1,5,6,7,8,9* | 1,2,3,4,5,6,7,8 | ||||
Project | ** | 1,2,3,4,5,6,7,8 | ||||
Accounting | GLAccount | 1,4,9* | ** | ** | ||
GLJournalEntry | 1,2,3,4,5,6,7,8,9 | |||||
GLProject | 1;4* | |||||
GLProjectBalance | 4* | |||||
Human Ressources | Employee | ** | ||||
Payroll | * | |||||
Inventory | Product | 1,5,6,7,8,9* | 1,4,5,6,7,8* | |||
ProductCategory | 1,4,5,6,7,8* | |||||
ProductGroup | 1,5,6,7,8,9* | 1,4,5,6,7,8* | ||||
ProductTrail | * | |||||
Miscellaneous | Activity | ** | ||||
CompanyInfo | ** | |||||
Equipment | ** | |||||
FinancialTransaction | 1,4,5,6,7,8* | |||||
Tax | 1,4,5,6,7,8* | |||||
WorkOrder | ** |
Légende des symboles
- 1 : Opérateur Equals supporté
- 2 : Opérateur Contains supporté
- 3 : Opérateur DoesntContains supporté
- 4 : Opérateur NotEquals supporté
- 5 : Opérateur SmallerThan supporté
- 6 : Opérateur GreaterThan supporté
- 7 : Opérateur SmallerOrEquals supporté
- 8 : Opérateur GreaterOrEquals supporté
- 9 : Opérateur InList supporté
- * : Filtre limité à certaines restriction (définie plus bas)
- ** : Aucun filtre n’est supporté
Liste des restrictions des filtres
Acomba – AccountPayableSettings: ErpInternalId Equals |
Acomba – AccountPayableSettings: ErpInternalId InList |
Acomba – GLProject: ValeurAuCompte NotEquals 0 |
Acomba – GLProject: TypeProjet Equals ‘Projet’ |
Acomba – GLProject: TypeProjet NotEquals ‘Projet’ |
Acomba – GLProjectBalance: ValeurAuCompte NotEquals 0 |
Acomba – GLAccount: ValeurAuCompte NotEquals 0 |
Acomba – GLAccount: NoCompteGL Equals |
Acomba – GLAccount : NoCompteGL InList |
Acomba – Customer: NoClient Equals |
Acomba – Customer: NoClient InList |
Acomba – Customer: NoUniqueSystemeSource Equals |
Acomba – Customer: NoUniqueSystemeSource InList |
Acomba – Customer: Fiche_DerniereModification GreaterOrEquals |
Acomba – Customer: Fiche_DerniereModification GreaterThan |
Acomba – Customer: Fiche_DerniereModification SmallerOrEquals |
Acomba – Customer: Fiche_DerniereModification SmallerThan |
Acomba – Product: NoProduit Equals |
Acomba – Product: NoProduit InList |
Acomba – Product: NoUniqueSystemeSource Equals |
Acomba – Product: NoUniqueSystemeSource InList |
Acomba – Product: Fiche_DerniereModification GreaterOrEquals |
Acomba – Product: Fiche_DerniereModification GreaterThan |
Acomba – Product: Fiche_DerniereModification SmallerOrEquals |
Acomba – Product: Fiche_DerniereModification SmallerThan |
Acomba – Product: EstActif Equals true |
Acomba – Product: EstActif Equals false |
Acomba – ProductGroup: CodeGroupe Equals |
Acomba – ProductGroup: CodeGroupe InList |
Acomba – ProductGroup: NoUniqueSystemeSource Equals |
Acomba – ProductGroup: NoUniqueSystemeSource InList |
Acomba – ProductGroup: Fiche_DerniereModification GreaterOrEquals |
Acomba – ProductGroup: Fiche_DerniereModification GreaterThan |
Acomba – ProductGroup: Fiche_DerniereModification SmallerOrEquals |
Acomba – ProductGroup: Fiche_DerniereModification SmallerThan |
Acomba – Supplier: NoFournisseur Equals |
Acomba – Supplier: NoFournisseur InList |
Acomba – Supplier: Fiche_DerniereModification GreaterOrEquals |
Acomba – Supplier: Fiche_DerniereModification GreaterThan |
Acomba – Supplier: Fiche_DerniereModification SmallerOrEquals |
Acomba – Supplier: Fiche_DerniereModification SmallerThan |
Acomba – Supplier: EstActif Equals true |
Acomba – Supplier: EstActif Equals false |
Acomba – SupplierProduct: No_Fournisseur Equals |
Acomba – SupplierProduct: NoProduit_Fournisseur Equals |
Acomba – SupplierProduct: CodeUPC_Fournisseur Equals |
Acomba – SupplierProduct: Fiche_DerniereModification GreaterOrEquals |
Acomba – SupplierProduct: Fiche_DerniereModification GreaterThan |
Acomba – SupplierProduct: Fiche_DerniereModification SmallerOrEquals |
Acomba – SupplierProduct: Fiche_DerniereModification SmallerThan |
Acomba – CustomerInvoicePayment : CUSTOM_FILTER_UNPAID_INVOICES_ONLY |
Acomba – CustomerInvoice/CustomerOrder/SupplierOrder/CustomerBID/SupplierInvoice: NoFacture Equals |
Acomba – CustomerInvoice/CustomerOrder/SupplierOrder/CustomerBID/SupplierInvoice: NoFacture InList |
Acomba – CustomerInvoice/CustomerOrder/SupplierOrder/CustomerBID/SupplierInvoice: NoUniqueSystemeSource Equals |
Acomba – CustomerInvoice/CustomerOrder/SupplierOrder/CustomerBID/SupplierInvoice: NoUniqueSystemeSource InList |
Acomba – CustomerInvoice/CustomerOrder/SupplierOrder/CustomerBID/SupplierInvoice: Fiche_DerniereModification GreaterOrEquals |
Acomba – CustomerInvoice/CustomerOrder/SupplierOrder/CustomerBID/SupplierInvoice: Fiche_DerniereModification GreaterThan |
Acomba – CustomerInvoice/CustomerOrder/SupplierOrder/CustomerBID/SupplierInvoice: Fiche_DerniereModification SmallerOrEquals |
Acomba – CustomerInvoice/CustomerOrder/SupplierOrder/CustomerBID/SupplierInvoice: Fiche_DerniereModification SmallerThan |
Acomba – CustomerInvoice/CustomerOrder/SupplierOrder/CustomerBID: EstActif Equals true |
Acomba – CustomerInvoice/CustomerOrder/SupplierOrder/CustomerBID: EstActif Equals false |
Acomba – CustomerInvoice/CustomerOrder/SupplierOrder/CustomerBID/SupplierInvoice: DateFacture GreaterOrEquals |
Acomba – CustomerInvoice/CustomerOrder/SupplierOrder/CustomerBID/SupplierInvoice: DateFacture GreaterThan |
Acomba – CustomerInvoice/CustomerOrder/SupplierOrder/CustomerBID/SupplierInvoice: DateFacture SmallerOrEquals |
Acomba – CustomerInvoice/CustomerOrder/SupplierOrder/CustomerBID/SupplierInvoice: DateFacture SmallerThan |
Acomba – SupplierInvoice: Fournisseur_No Equals |
Acomba – ProductTrail – DateMouvement |
Acomba – Supplier – NoFournisseur Equals |
Acomba – Supplier – NoFournisseur InList |
Acomba – Supplier: NoUniqueSystemeSource Equals |
Acomba – Supplier: NoUniqueSystemeSource InList |
Acomba – Supplier: Fiche_DerniereModification GreaterOrEquals |
Acomba – Supplier: Fiche_DerniereModification GreaterThan |
Acomba – Supplier: Fiche_DerniereModification SmallerOrEquals |
Acomba – Supplier: Fiche_DerniereModification SmallerThan |
Avantage – Payroll- date_Emission |
QuickBooks – Les limitations des champs par entité ne sont pas répertoriées. |
Sage 50 – Supplier Invoice: NoFacture Equals |
Sage 50 – Supplier Invoice: NoUniqueSystemeSource Equals |
Sage 50 – Supplier Invoice: InfoClientFacturerA.NomClient Equals |
Sage 50 – Supplier Invoice: TotalFacture Equals |
Sage 50 – Supplier Invoice: DateFacture GreaterOrEquals |
Sage 50 – Supplier Invoice: DateFacture GreaterThan |
Sage 50 – Supplier Invoice: DateFacture SmallerOrEquals |
Sage 50 – Supplier Invoice: DateFacture SmallerThan |