Liste des filtres par système

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