Supplier bill matches
A match of the quantity of a supplier bill line to a receipt.
Fields
The API name is what the API, MCP and the CLI use.
| Name | API name | Type | Required | Description |
|---|---|---|---|---|
| ID | id | Record ID | Yes | |
| Line item | financesbillitemId | Reference | Yes | |
| Entry | inventoryreceiptnoteitemId | Reference | Yes | |
| Day | date | Date | Yes | Calendar date for this value. |
| Quantity | quantity | Quantity | Yes | Quantity in the catalog unit after any unit conversion on the line. |
| Receipt value | receiptValue | Currency | Yes | Amount in accounting currency of the matched quantity at receipt cost. |
| Bill value | billValue | Currency | Yes | Amount in accounting currency of the matched quantity at bill price. |
| Price variance | priceVariance | Currency | Yes | Monetary amount in the applicable currency for this record. |
| Exchange variance | fxvariance | Signed amount | Yes | Functional gain when the bill rate is better than the receipt rate. A negative amount is a loss. It is price variance plus receipt value minus bill value. |
| Match difference | grniresidual | Currency | Yes | Bill value minus receipt value. It must equal price variance minus exchange variance. |
| Created by | createdBy | User | ||
| Created at | createdAt | Date and Time | Yes | |
| Updated by | updatedBy | User | ||
| Updated at | updatedAt | Date and Time | Yes | |
| Processed by | processedBy | User | ||
| Processed at | processedAt | Date and Time | ||
| Canceled by | canceledBy | User | ||
| Canceled at | canceledAt | Date and Time | ||
| Blocked by | blockedBy | User | ||
| Blocked at | blockedAt | Date and Time | ||
| Archived by | archivedBy | User | ||
| Archived at | archivedAt | Date and Time |
Relations
Owned records (solid line) are deleted with their owner. Grouped records (dashed line) can exist alone.
| Field | Points to | Kind |
|---|---|---|
Line item financesbillitemId | Supplier bill line items | owned by |
Entry inventoryreceiptnoteitemId | Goods receipt note entries | reference |
Actions
What you can do with a record. Every action also sends the webhook event financesbillitemmatches.<action>. Reads (find, get, count) work on every table.
| Name | API name | Description | Where |
|---|---|---|---|
| Create | create | Add a new bill match. | App · WebMCP · API · MCP · CLI |
| Edit | update | Save changes to this bill match. | App · API · MCP · CLI |
| Process | process | Post this bill match. You cannot undo it. | App · WebMCP · API · CLI |
| Cancel | cancel | Reverse the posted effect of this bill match. | App · API · MCP · CLI |
| Delete | delete | Delete this bill match and the data that belongs with it. This cannot be undone. | App · WebMCP · API · MCP · CLI |
States
How a record moves from state to state. Archive and block can happen in any state.