Jump to content

Sage 1000 - Sdata API: accounting entry with analytical breakdown


Recommended Posts

Posted

Hello

I'm trying to create accounting entry with analytical breakdown.

I managed to create this accounting entry  only on one analytical section. 

I need to split this accounting entry on multiple analytical section.

Do you have any ideas?

 

Kind regards

PS: this is the API payload. The accounting entry to be split is in third position (on account 602100) 

The properties are in french.. it seems that there is no english version

{
    "$": {"$transaction":["atomic"]},
    "$resources": [
        {
            "$httpMethod":"POST",
            "$url":"cptimport/tsessionimport",
            "$uuid":"session",
            "Caption":"Session import par API - 4",
            "CompteEquilibre":{"$url":"TCompteGeneral(codeCompte eq '10500000')"},
        },
        {
            "$httpMethod":"POST",
            "$url":"cptimport/timportecritures",
            "SessionImport":{"$uuid":"session"},
            "codeJournal": "ACH",
            "compteAuxiliaire": "0VOLKSW",
            "compteGeneral": "401050",
            "dateEcheance": "1899-12-30T00:00:00.000Z",
            "datePiece": "2021-04-28T23:00:00.000Z",
            "deviseEcriture": "EUR",
            "deviseTenueCompte": "EUR",
            "etablissement": "ET-1",
            "montant": 1200,
            "montantEnDevise": 1200,
            "numeroPiece": "AC2009/01-000148",
            "sens": "C",
            "typeCompte": "X",
            "typeEcriture": "Brouillard",
            "typePiece": "FAF"
        },
        {
            "$httpMethod":"POST",
            "$url":"cptimport/timportecritures",
            "SessionImport":{"$uuid":"session"},
            "codeJournal": "ACH",
            "compteGeneral": "445663",
            "dateEcheance": "1899-12-30T00:00:00.000Z",
            "datePiece": "2021-04-28T23:00:00.000Z",
            "deviseEcriture": "EUR",
            "deviseTenueCompte": "EUR",
            "etablissement": "ET-1",
            "montant": 200,
            "montantEnDevise": 200,
            "numeroPiece": "AC2009/01-000148",
            "sens": "D",
            "typeEcriture": "Brouillard",
            "typePiece": "FAF"
        },
        {
            "$httpMethod":"POST",
            "$url":"cptimport/timportecritures",
            "SessionImport":{"$uuid":"session"},
            "codeJournal": "ACH",
            "compteGeneral": "602100",
            "dateEcheance": "1899-12-30T00:00:00.000Z",
            "datePiece": "2021-04-28T23:00:00.000Z",
            "deviseEcriture": "EUR",
            "deviseTenueCompte": "EUR",
            "etablissement": "ET-1",
            "montant": 1000,
            "montantEnDevise": 1000,
            "numeroPiece": "AC2009/01-000148",
            "sens": "D",
            "typeEcriture": "Brouillard",
            "typePiece": "FAF",
            "axeAnalytique": "AXE_1",
            "sectionAnalytiqueAxe1": "1-CRD-ADM"
        },
        {
            "$": {"$transaction":["commit"]},
            "$httpMethod":"EXEC",
            "$url":"cptimportmouvement/TProcessusPlanifImport/Executer",
            "$uuid":"processus",
            "$resource" : {
                "codeSessionInf":"Session import par API - 4",
                "codeSessionSup":"Session import par API - 4",
                "importerExterne":true,
            }
        },
    ]
}

 

 

 

 

  • 2 weeks later...
  • Administrators
Posted

Hi Pascal,

Apologies for the delay in replying. 

For Sage 1000, your best bet is to head over to Sage City, which is another community for regional products. https://www.sagecity.com/fr/

There you'll be able to find support specifically to 1000.

 

Ben

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
×
×
  • Create New...