Articles in this section

Quantity/UnitCount Balance

Avatar
Kotaro Kishimoto
  • Updated
Follow

In AccountRight 2019.4 release, we introduced the quantity tracking feature to expose the UnitCount property in below endpoints:

+ /{cf_uri}/Banking/SpendMoneyTxn
+ /{cf_uri}/Banking/ReceiveMoneyTxn
+ /{cf_uri}/GeneralLedger/JournalTransaction


The UnitCount property offers an option to process a transaction with a unit value per line, which can be utilised for livestock counting and tracking in the farming industry for example. The quantity field (i.e. UnitCount property) is currently only available new Essentials UI and not supported in AccountRight UI. 

In AccountRight 2020.2 release, we are introducing the UnitCount property in the /{cf_uri}/GeneralLedger/AccountRegister endpoint, which returns the calculated unit count balances for accounts and parented header accounts for the given period. Note that null will be returned if no transaction was made with quantity value assigned. The value of 0 will be returned if the overall calculated unit count balance for the given period balances out to be 0 (e.g. an expense account that had 3 transactions: +5 units, +5units and -10 units in the same month will return 0 for the period).

ATTENTION!: The UnitCount property that had been exposed for Sales quote/invoice and Purchase bill transactions in the hybrid layout release will not be reflected to calculate the balance of the UnitCount property in /{cf_uri}/GeneralLedger/AccountRegister endpoint.

Sample scenario:

Processed 2 receive money transactions and 1 Sales invoice as below:

1st Receive money transaction: 1st May 2020 with 10 units on the sales line
mceclip0.png

2nd Receive money transaction 2nd May 2020 with 5 units on the sales line
mceclip1.png

1st Sales invoice transaction: 3rd May 2020 with 5 units on the sales line
mceclip2.png

Assuming there are only 3 transactions in May 2020, below is a sample payload for the /{cf_uri}/GeneralLedger/AccountRegister GET request:

{
  "Items": [
  .
  .
{
      "UID": "8166ea2c-b389-4eec-b5d5-8bf66e35f458",
      "Account": {
        "UID": "d9abb585-ac58-4198-b567-e1c8e27498e1",
        "Name": "Current Assets",
        "DisplayID": "1-1000",
        "URI": "http://localhost:8080/AccountRight/fd7bc3e3-f008-4c8f-98f9-02c0f52c5794/GeneralLedger/Account/d9abb585-ac58-4198-b567-e1c8e27498e1"
      },
      "Year": 2020,
      "Month": 5,
      "Activity": 272.720000,
      "Adjustment": 0.000000,
      "YearEndActivity": 0.000000,
      "YearEndAdjustment": 0.000000,
      "UnitCount": null,
      "URI": "http://localhost:8080/AccountRight/fd7bc3e3-f008-4c8f-98f9-02c0f52c5794/GeneralLedger/AccountRegister/8166ea2c-b389-4eec-b5d5-8bf66e35f458",
      "RowVersion": "-2484298144448249856"
    },
  .
  .
 {
      "UID": "3e6adfb4-af05-4a4d-9351-33a2fbcbbea6",
      "Account": {
        "UID": "19a1c319-973b-4728-b247-a38a435f2840",
        "Name": "General Cheque Account 1",
        "DisplayID": "1-1110",
        "URI": "http://localhost:8080/AccountRight/fd7bc3e3-f008-4c8f-98f9-02c0f52c5794/GeneralLedger/Account/19a1c319-973b-4728-b247-a38a435f2840"
      },
      "Year": 2020,
      "Month": 5,
      "Activity": 136.360000,
      "Adjustment": 0.000000,
      "YearEndActivity": 0.000000,
      "YearEndAdjustment": 0.000000,
      "UnitCount": null,
      "URI": "http://localhost:8080/AccountRight/fd7bc3e3-f008-4c8f-98f9-02c0f52c5794/GeneralLedger/AccountRegister/3e6adfb4-af05-4a4d-9351-33a2fbcbbea6",
      "RowVersion": "-2556355738486177792"
    },
  .
  .
 {
      "UID": "74fc1a17-eeeb-44de-bdc0-03ea0a7f0792",
      "Account": {
        "UID": "f1aa791a-2c5e-4fcf-aa07-ab5c46d1ad9b",
        "Name": "Trade Debtors",
        "DisplayID": "1-1700",
        "URI": "http://localhost:8080/AccountRight/fd7bc3e3-f008-4c8f-98f9-02c0f52c5794/GeneralLedger/Account/f1aa791a-2c5e-4fcf-aa07-ab5c46d1ad9b"
      },
      "Year": 2020,
      "Month": 5,
      "Activity": 136.360000,
      "Adjustment": 0.000000,
      "YearEndActivity": 0.000000,
      "YearEndAdjustment": 0.000000,
      "UnitCount": null,
      "URI": "http://localhost:8080/AccountRight/fd7bc3e3-f008-4c8f-98f9-02c0f52c5794/GeneralLedger/AccountRegister/74fc1a17-eeeb-44de-bdc0-03ea0a7f0792",
      "RowVersion": "-2340182956372393984"
    },
  .
  .
{
      "UID": "5dc75ffc-7de4-4bc9-92ad-2e0a7913ea6c",
      "Account": {
        "UID": "8b5671bd-431f-48d5-ac49-0169c30ca22b",
        "Name": "Sales Income",
        "DisplayID": "4-1000",
        "URI": "http://localhost:8080/AccountRight/fd7bc3e3-f008-4c8f-98f9-02c0f52c5794/GeneralLedger/Account/8b5671bd-431f-48d5-ac49-0169c30ca22b"
      },
      "Year": 2020,
      "Month": 12,
      "Activity": 272.720000,
      "Adjustment": 0.000000,
      "YearEndActivity": 0.000000,
      "YearEndAdjustment": 0.000000,
      "UnitCount": 15.000000,
      "URI": "http://localhost:8080/AccountRight/fd7bc3e3-f008-4c8f-98f9-02c0f52c5794/GeneralLedger/AccountRegister/5dc75ffc-7de4-4bc9-92ad-2e0a7913ea6c",
      "RowVersion": "5081749229534183424"
    },
  .
  .

{
      "UID": "2dc75ffc-4de4-6bc9-92ad-2e0a7913ea6c",
      "Account": {
        "UID": "4b5671bd-431f-68d5-ac49-1169c30ca22b",
        "Name": "UnitCount Inc",
        "DisplayID": "4-9999",
        "URI": "http://localhost:8080/AccountRight/fd7bc3e3-f008-4c8f-98f9-02c0f52c5794/GeneralLedger/Account/4b5671bd-431f-68d5-ac49-1169c30ca22b"
      },
      "Year": 2020,
      "Month": 12,
      "Activity": 272.720000,
      "Adjustment": 0.000000,
      "YearEndActivity": 0.000000,
      "YearEndAdjustment": 0.000000,
      "UnitCount": 15.000000,
      "URI": "http://localhost:8080/AccountRight/fd7bc3e3-f008-4c8f-98f9-02c0f52c5794/GeneralLedger/AccountRegister/5dc75ffc-7de4-4bc9-92ad-2e0a7913ea6c",
      "RowVersion": "5081749229534183456"
    },
  .
  .
{
      "UID": "04340804-56dd-4236-b09d-450542460e18",
      "Account": {
        "UID": "ba60da97-26df-4700-9435-3752f65c2826",
        "Name": "GST Collected",
        "DisplayID": "2-3010",
        "URI": "http://localhost:8080/AccountRight/fd7bc3e3-f008-4c8f-98f9-02c0f52c5794/GeneralLedger/Account/ba60da97-26df-4700-9435-3752f65c2826"
      },
      "Year": 2020,
      "Month": 5,
      "Activity": 27.280000,
      "Adjustment": 0.000000,
      "YearEndActivity": 0.000000,
      "YearEndAdjustment": 0.000000,
      "UnitCount": null,
      "URI": "http://localhost:8080/AccountRight/fd7bc3e3-f008-4c8f-98f9-02c0f52c5794/GeneralLedger/AccountRegister/04340804-56dd-4236-b09d-450542460e18",
      "RowVersion": "5153806823572111360"
    },
  .
  .
  ]
}

Related articles

Comments

0 comments

Article is closed for comments.