Creates an expense report by submitting one or more expense line items. Accepts individual input parameters or an aggregate JSON payload.

Stored Procedure-Specific Information

To execute this stored procedure with individual parameters, enter:

    EXEC CreateExpenseReport externalid='driverSP_test015', entityid='31', trandate='2026-01-01', expenses='[
        {
            "expenseDate": "2026-01-15",
            "amount": 2345,
            "currency": {
                "id": "1"
            },
            "category": {
                "id": "1"
            },
            "projecttask": {"id": "1"},
            "memo": "Postman test expense2"
        }
    ]'

To execute this stored procedure with an aggregate JSON payload, enter:

    EXEC CreateExpenseReport aggregate='{
        "externalId": "driverSP_test015",
        "entity": {
            "id": "31"
        },
        "trandate": "2026-01-01",
        "expense": {
            "items": [
                {
                    "expenseDate": "2026-01-15",
                    "amount": 2345,
                    "currency": {
                        "id": "1"
                    },
                    "category": {
                        "id": "1"
                    },
                    "projecttask": {"id": "1"},
                    "memo": "Postman test expense2"
                }
            ]
        }
    }'

Input

Name	Type	Description
Externalid	String	A user-defined identifier for this expense report.
Entityid	String	The unique identifier for the entity (such as employee) submitting this expense report.
Trandate	Date	The date of the expense report, typically the date the expense was incurred or the report was created. This date is used to determine which accounting period the report is posted to.
Expenses	String	A JSON array of expense line items to include in the report. Each item may contain fields such as expenseDate, amount, currency, category, projecttask, and memo.
Aggregate	String	A JSON string containing the complete expense report payload, including entity, trandate, and expense line items. When specified, overrides all other input parameters.

Result Set Columns

Name	Type	Description
Successful	String	A true or false value indicating whether the operation was completed successfully.