1. 2.2 - GL Project
ERPConnector
ERPConnector - Public doc
  • ERPConnector - Public doc
  • 1 - Informations générales
    • 1.1 - Survol
    • 1.2 - CodeLicence, Company, CléSecrete
    • 1.3 - Authentification
    • 1.4 - Versions de l'API
      • GetBasicApiInfo
    • 1.5 - Header + Query Param
      • Header - COMPANY_CODE
      • Header - RETURN_FULL_PAYLOAD
      • PUT vs POST
      • Query - $select
      • Pagination dans l'API
  • 2 - Accounting (GL)
    • 2.1 - GL Account
      • GL Account
    • 2.2 - GL Project
      • GLProject
        GET
      • GLProjectBalance
        GET
      • Create GLProjet
        POST
    • 2.3 - GL Journal Entry
      • GL Journal Entry
      • GL Journal Entry (Sage50)
  • 3 - Account Receivable (Customers)
    • 3.1 - Customer (client)
      • Customer
      • Create customer
      • Modify Customer
    • 3.2 - Customer Group
      • CustomerGroup
    • 3.3 - Customer Order (Commandes cliente)
      • CustomerOrder
      • CustomerOrder
      • CustomerOrder
    • 3.4 - Customer Invoice (Facture client)
      • CustomerInvoices
      • Create CustomerInvoice
      • Create CustomerInvoice (AR Invoice)
    • 3.5 - SalesRep (Vendeurs)
      • SalesRep
    • 3.6 - Territory (Territoires)
      • Territory
    • 3.7 - PaymentMode (Mode de paiement)
      • CustomerPaymentMode
    • 3.8 - Customer Project
      • Project
    • 3.9 - Customer Bid (Soumission cliente)
      • Get CustomerBid
      • Create CustomerBid
    • 3.10 - Customer Invoice Payment (Règlement facture cliente)
      • Get CustomerInvoicePayment
      • Create CustomerInvoicePayment (Acomba)
    • 3.11 - Customer Service Contract (Contrat de service)
      • Get CustomerInvoicePayment Copy
    • 3.12 - CustomerARInvoices (Transaction GL Cliente)
      • Extract InvoiceAR
      • Create CustomerInvoice (AR Invoice) Copy
  • 4 - Account Payable (Compte Payable/fournisseur)
    • 4.1 - Supplier (Fournisseur)
      • Supplier
      • Create Supplier
      • Modify Supplier
    • 4.2 - Supplier Invoice (Facture Fournisseur)
      • SupplierInvoice
      • Supplier Invoice
    • 4.3 - Supplier Order (Achat fournisseur)
      • SupplierOrder
      • Create SupplierOrder
    • 4.4 - Supplier Invoice Payment (Paiement Fournisseur)
      • SupplierInvoicePayment
      • SupplierInvoicePayment (Avantage)
    • 4.5 - Product Supplier (Produit-Fournisseur)
      • Get Supplier Products
      • Create SupplierProduct
      • Modify SupplierProduct
    • 4.6 - SupplierOrderReceipt (Réception Achat)
      • SupplierOrderReceipt (Réception Acomba)
  • 5 - Inventory (Produits)
    • 5.1 - Product (Produit)
      • Product - Get METADATA information
      • Product
      • Product Creation
      • Product Modif
    • 5.2 - ProductGroup (Groupe de produit)
      • ProductGroup
    • 5.3 - Product Trail
      • ProductTrail
      • Create ProductTrail
    • 5.4 - Product Serial
      • Get - Product Serial (Acomba)
  • 6 - HR (Ressource Humaine)
    • 6.1 - Employee
      • Employee
    • 6.2 - Employee Payroll
      • Employee Payroll
  • 7 - ERPConnectorTask (Direct)
    • GET SupplierOrder (achat) ErpConnectorTask
    • Extract Customer
    • Extract Customer
    • GET Supplier - ErpConnectorTask
  • 8 - Miscellaneous
    • 8.1 - Taxes
      • Tax
      • TaxGroup
    • 8.2 - Company Info
      • CompanyInfo
    • 8.3 WorkOrder (Servicentre / Servex)
      • 8.3.1 WorkOrder Sub Entities (Servex)
        • Get WorkOrderStatus (Servex)
        • Get WorkOrderTechnician (Servex)
        • Get WorkOrderDispatcher (Servex)
      • Get WorkOrder
      • Post WorkOrder (Servex)
    • 8.4 Equipment (Servicentre)
      • Get Equipment
    • 8.5 Activity (Avantage)
      • Get Activity
    • 8.6 FinancialTransaction (QBO)
      • Read FinancialTransaction (QBO - BankDeposit)
      • Create FinancialTransaction (QBO - BankDeposit)
  • 99 - System
    • Quickbooks Online
      • QuickBooks - GetRefreshQBOAccessTokens
      • QuickBooks - Get QBO GetQBOConnexionInfo
      • QuickBooks - Auth - ConnectToQBORedirect
      • QuickBooks - ExecuteRawSQL
    • Relational Database
      • Relational Db - ExecuteRawSQL
    • Acomba
      • Test ERP Connection
  1. 2.2 - GL Project

GLProjectBalance

GET
https://gateway.erpconnector.ca/api/Entity/GLProjectBalance

GET /Entity/GLProjectBalance#

This endpoint retrieves GL project balance data based on the specified filter.

Request#

Method: GET
URL: {{OnlineERP_URL}}/Entity/GLProjectBalance
Query Parameters:
$filter: Filter condition to retrieve GL project balance data where 'ValeurAuCompte' is not equal to 0.

Response#

The response will be a JSON object with the following schema:
{
  "type": "array",
  "items": {
    "type": "object",
    "properties": {
      "GLProjectBalanceId": {
        "type": "string"
      },
      "GLAccountId": {
        "type": "string"
      },
      "GLAccountNo": {
        "type": "string"
      },
      "GLProjectId": {
        "type": "string"
      },
      "GLProjectNo": {
        "type": "string"
      },
      "Fiche_DerniereModification": {
        "type": "string"
      },
      "ProjectBalanceAmount": {
        "type": "array",
        "items": {
          "type": "object",
          "properties": {
            "NoPeriode": {
              "type": "number"
            },
            "ValeurAuCompte": {
              "type": "number"
            }
          }
        }
      }
    }
  }
}
The response will have a status code of 200.

Request

Authorization
Send your HTTP requests with an
Authorization
header that contains the word Basic followed by a space and a base64-encoded string username:password
Example:
Authorization: Basic *****************
Header Params

Responses

🟢200
application/json
Bodyapplication/json

Request Request Example
Shell
JavaScript
Java
Swift
curl --location 'https://gateway.erpconnector.ca/api/Entity/GLProjectBalance' \
--header 'Authorization: Basic <encoded-value>'
Response Response Example
[
    {
        "GLProjectBalanceId": "2",
        "GLAccountId": "1",
        "GLAccountNo": "1000",
        "GLProjectId": "1",
        "GLProjectNo": "0",
        "Fiche_DerniereModification": "2006-03-16T10:22:51",
        "ProjectBalanceAmount": [
            {
                "NoPeriode": 1,
                "ValeurAuCompte": 116859.35
            },
            {
                "NoPeriode": 2,
                "ValeurAuCompte": 183986.67
            },
            {
                "NoPeriode": 3,
                "ValeurAuCompte": 132300.18
            },
            {
                "NoPeriode": 4,
                "ValeurAuCompte": 261614.49
            }
        ]
    },
    {
        "GLProjectBalanceId": "68",
        "GLAccountId": "6",
        "GLAccountNo": "1210",
        "GLProjectId": "1",
        "GLProjectNo": "0",
        "Fiche_DerniereModification": "2006-03-16T10:22:51",
        "ProjectBalanceAmount": [
            {
                "NoPeriode": 1,
                "ValeurAuCompte": 1199.06999999999
            },
            {
                "NoPeriode": 2,
                "ValeurAuCompte": 690.110000000022
            },
            {
                "NoPeriode": 3,
                "ValeurAuCompte": 3924.23000000001
            },
            {
                "NoPeriode": 4,
                "ValeurAuCompte": 11160.68
            }
        ]
    },
    {
        "GLProjectBalanceId": "20",
        "GLAccountId": "8",
        "GLAccountNo": "1220",
        "GLProjectId": "1",
        "GLProjectNo": "0",
        "Fiche_DerniereModification": "2006-03-16T10:22:51",
        "ProjectBalanceAmount": [
            {
                "NoPeriode": 1,
                "ValeurAuCompte": -11833.59
            },
            {
                "NoPeriode": 2,
                "ValeurAuCompte": 2824.86
            },
            {
                "NoPeriode": 3,
                "ValeurAuCompte": -3330.84000000002
            },
            {
                "NoPeriode": 4,
                "ValeurAuCompte": 21753
            }
        ]
    },
    {
        "GLProjectBalanceId": "69",
        "GLAccountId": "12",
        "GLAccountNo": "1230",
        "GLProjectId": "1",
        "GLProjectNo": "0",
        "Fiche_DerniereModification": "2006-03-16T10:22:51",
        "ProjectBalanceAmount": [
            {
                "NoPeriode": 1,
                "ValeurAuCompte": 1372.94
            },
            {
                "NoPeriode": 2,
                "ValeurAuCompte": 2099.73
            },
            {
                "NoPeriode": 3,
                "ValeurAuCompte": 1618.69
            },
            {
                "NoPeriode": 4,
                "ValeurAuCompte": 4000
            }
        ]
    },
    {
        "GLProjectBalanceId": "70",
        "GLAccountId": "14",
        "GLAccountNo": "1232",
        "GLProjectId": "1",
        "GLProjectNo": "0",
        "Fiche_DerniereModification": "2006-03-16T10:22:51",
        "ProjectBalanceAmount": [
            {
                "NoPeriode": 1,
                "ValeurAuCompte": 1766.74
            },
            {
                "NoPeriode": 2,
                "ValeurAuCompte": 966.48
            }
        ]
    },
    {
        "GLProjectBalanceId": "67",
        "GLAccountId": "17",
        "GLAccountNo": "1235",
        "GLProjectId": "1",
        "GLProjectNo": "0",
        "Fiche_DerniereModification": "2006-03-16T10:22:51",
        "ProjectBalanceAmount": [
            {
                "NoPeriode": 1,
                "ValeurAuCompte": 428.6
            }
        ]
    },
    {
        "GLProjectBalanceId": "159",
        "GLAccountId": "42",
        "GLAccountNo": "1619",
        "GLProjectId": "1",
        "GLProjectNo": "0",
        "Fiche_DerniereModification": "1899-12-30T00:00:00",
        "ProjectBalanceAmount": [
            {
                "NoPeriode": 1,
                "ValeurAuCompte": -2653
            },
            {
                "NoPeriode": 2,
                "ValeurAuCompte": -2653
            },
            {
                "NoPeriode": 3,
                "ValeurAuCompte": -2653
            }
        ]
    },
    {
        "GLProjectBalanceId": "98",
        "GLAccountId": "45",
        "GLAccountNo": "1629",
        "GLProjectId": "1",
        "GLProjectNo": "0",
        "Fiche_DerniereModification": "2006-03-16T10:22:51",
        "ProjectBalanceAmount": [
            {
                "NoPeriode": 1,
                "ValeurAuCompte": -725
            },
            {
                "NoPeriode": 2,
                "ValeurAuCompte": -725
            },
            {
                "NoPeriode": 3,
                "ValeurAuCompte": -725
            }
        ]
    },
    {
        "GLProjectBalanceId": "65",
        "GLAccountId": "46",
        "GLAccountNo": "1631",
        "GLProjectId": "1",
        "GLProjectNo": "0",
        "Fiche_DerniereModification": "2006-03-16T10:22:51",
        "ProjectBalanceAmount"
Previous
GLProject
Next
Create GLProjet
Built with