UPDATE_LEDGER
Updates a balance ledger with current transaction details.
Example Usage
UPDATE_LEDGER(item.Accounts_ID, item.Debit, Reference, item.Description)
UPDATE_LEDGER(item.Accounts_ID, -item.Credit, Reference, item.Description)
Overview
Function signature
UPDATE_LEDGER(resourceid, amount, name, description)
Category
Database
Return data type
bool
Arguments
| Name | DataType | List Options | Description |
|---|---|---|---|
resourceid | int | The unique ID of a resource in the Ledger's Resource table | |
amount | float | The amount to add to the ledger balance | |
name | string | A name for the ledger entry, usually from the transaction header data or a related resource | |
description | string | A description for the ledger entry, usually from the transaction details or items |