Sage 200cloud limitations

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

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"
  }