createAccountingEntryUsingCodes

Description

Creation of Accounting Entries by using business Codes instead of internal Sage Active ids.

This approach can be simpler because developers are likely more familiar with business codes as they directly relate to the business domain.
This reduces the need for additional database lookups to translate codes to IDs, which can result in faster performance due to caching.

Advantages

• Direct use of journal codes, third-party codes, and account codes, eliminating the need for Sage Active IDs.
• Automatic validation of the existence of journal codes, third-party codes, and account codes.
• Automatic detection of the third-party type (Client, Supplier, Employee) based on the sub-account class.
• Optimized performance through the utilization of an internal cache for fetching journal, third-party, and account IDs, thereby reducing the number of queries required.
• Simplified model definition with streamlined lines that eliminate the need to manage accountingEntryThirdParty and accountingEntryInvoice sub-resources.
• Automatic assignment of the description and document number from the header to the lines if not defined in the line.
• NEWNew Feature Recently Added Automatic creation of tax registers if the consistency of the transaction amounts allows it.
• Automatic summation of debit or credit from multiple lines of the same third party in the entry, merging them into a single entry line.
• Preservation of all business controls managed by Sage Active to ensure the integrity of the added entries.

mutation ($values:AccountingEntryCreateUsingCodesGLDtoInput!) {    
  createAccountingEntryUsingCodes (input: $values) {
    id
  }
}

{
  "values": {
    "description": "Facture FA0022",
    "date": "2023-01-01",
    "documentDate": "2022-12-16",
    "documentNumber": "FA0022",
    "journalTypeCode": "VTE",
    "accountingEntryLines": [
      {
        "thirdCode": "BAGUES",
        "description": "Facture FA0022 régularisation",
        "creditAmount": 0,
        "debitAmount": 158.25
        "subAccountCode": "411000000"
      },
      {
        "creditAmount": 150,
        "debitAmount": 0,
        "subAccountCode": "701005000"
      },
      {
        "creditAmount": 8.25,
        "debitAmount": 0,
        "subAccountCode": "445710500"
      }
    ]
  }
}

Tax registers

NEWNew Feature Recently Added Automatic creation of tax registers

The creation of tax registers for purchase and sales invoices is now automatic.
Registers are created if the prerequisites are met; otherwise, priority is given to the creation of the accounting entry without creating the registers, rather than allowing the Sage Active business controller to reject the entry for non-compliance with the registers.

The conditions are:

• Tax codes for revenue or expense accounts must be defined.
• The VAT accounts defined in the tax codes of these accounts must be those present in the entry.
• The VAT amount and the associated taxable base for the VAT account and the expense or revenue account must be consistent with the VAT rate of the tax code.
• Other management rules not respected or not yet accounted for by Sage Active.

Header

createAccountingEntryUsingCodes

createAccountingEntryUsingCodes/accountingEntryLines