Sage 200cloud limitations

Details of Sage 200cloud limitations and how Codat handles these.

Grouping of tax rates for line items

Due to a Sage 200cloud limitation, line items on invoices, credit notes, bills, and bill credit notes are grouped into separate lines for tax rates:

  • A Goods Summary line
  • A Tax Summary - Standard rate for each tax code.

Total amounts and total tax amounts are shown for each line.

Example invoice

{
      "id": "93454",
      "invoiceNumber": "0000000126",
      "customerRef": {
        "id": "0001"
      },
      "issueDate": "2020-08-03T00:00:00",
      "dueDate": "2020-09-03T00:00:00",
      "sourceModifiedDate": "2020-08-03T14:34:24.117",
      "currency": "USD",
      "currencyRate": 0.6577216521967903183372796632,
      "lineItems": [
        {
          "description": "Tax Summary - Standard rate",
          "unitAmount": 0,
          "quantity": 0,
          "discountAmount": 0.00,
          "subTotal": 0,
          "taxAmount": 27.97536000,
          "totalAmount": 27.97536000,
          "taxRateRef": {
            "id": "1729"
          }
        },
        {
          "description": "Goods Summary",
          "unitAmount": 0,
          "quantity": 0,
          "discountAmount": 0.00,
          "subTotal": 139.88,
          "taxAmount": 0,
          "totalAmount": 139.88,
          "tracking": {
            "categoryRefs": [
              {
                "id": "__COST_CENTRES/01"
              },
              {
                "id": "__DEPARTMENTS/1"
              },
              {
                "id": "__COST_CENTRES/022"
              }
            ],
            "isBilledTo": "Unknown"
          }
        }
      ],
      "totalDiscount": 0.00,
      "subTotal": 139.88,
      "totalTaxAmount": 27.98,
      "totalAmount": 167.86,
      "amountDue": 167.86,
      "discountPercentage": 0.00,
      "status": "Submitted",
      "note": "0000000126"
    }

Did this page help you?