Get Inventory Reconciliation Day Detail
GET/api/ledger/reconciliation/inventory/day-detail
For one earmarked inventory control account on one day, returns the reconciled figures for that day (SKU inventory value, provider GL balance, and their divergence) plus the underlying detail that produced them: the provider journal lines posted to the account that day and the inventory movements that changed SKU's value that day. Use it to trace a divergence to its source documents — reads materialized/cached data only, no live provider call.
This endpoint currently requires session authentication; Personal Access Token scope support is in progress.
Authentication: Requires Bearer token.
Response fields: as_of_date, nominal_code_id, code, name, provider_account_name, sku_value, sku_quantity, provider_balance, divergence, provider_net_total (sum of the day's provider journal-line net amounts), sku_value_delta_total (sum of the day's movement value deltas), provider_lines[] (journal_number, journal_date, source_type, source_id, account_code, account_name, net_amount, gross_amount, tax_amount), sku_movements[] (id, movement_date, type, warehouse_name, product_sku, product_name, quantity, unit_cost, value_delta, reference, link_type, link_id).
Each provider line and SKU movement carries a match_group: lines of the same signed amount are paired (shared match_group id) and null means unmatched. Matched pairs net to zero, so the day's gap is exactly unmatched_provider_total minus unmatched_sku_total — an unmatched provider line was booked in the accounting GL with no SKU-side movement, and an unmatched SKU movement changed SKU inventory but has not reached the GL. matched_count and matched_amount summarise what reconciles.
displaced_value is how much of the day's inventory value the general ledger has not recognised yet because an accounting lock date pushed its posting to a later day. sku_value already excludes it so both sides of the day sit on the same calendar; the amount is reported here so the day can explain why its stock is worth more than its ledger says. It is 0 on books with no displacement.
Request
Responses
- 200
- 401
- 403
- 429
OK
Response Headers
Unauthenticated — the bearer token is missing, revoked, expired, or malformed. Never retry automatically; fix the credential. See the Errors guide.
Forbidden — the token lacks a required scope, the endpoint is not available to API tokens, or the user behind the token lacks the permission. A human must adjust the token scopes or user permissions; do not retry.
Rate limited — platform limit is 1,000 requests/min; individual tokens may carry lower limits. Honor the Retry-After header before retrying. See the Rate Limits guide.