Stock Reconciliation
A stock count: the quantities counted in a store, which set the stock to what was found.
Area: Stock and stores · Why it is here: recipe merge_documents; sample S28; sample S41; retail core · Fields: 14 · Submitted (booked) records: send docstatus: 1 to book it as you create it, or submit a draft with submit.
iVendNext's own description: This tool helps you to update or fix the quantity and valuation of stock in the system. It is typically used to synchronise the system values and what actually exists in your warehouses.
Read and write it
Every call runs as your app's own user, with its key in one header, at the retailer's own address. The user reads and writes only what its role allows: your app's user, and the rights the retailer gives it.
Read a list (only name unless you ask for fields):
curl -s "https://⟨site⟩/api/resource/Stock%20Reconciliation?fields=%5B%22*%22%5D&limit_page_length=20" \
-H "Authorization: token ⟨api key⟩:⟨api secret⟩"
Read one, with its tables:
curl -s "https://⟨site⟩/api/resource/Stock%20Reconciliation/⟨name⟩" -H "Authorization: token ⟨api key⟩:⟨api secret⟩"
Create one (the required fields first), if your app's role may:
curl -s -X POST "https://⟨site⟩/api/resource/Stock%20Reconciliation" -H "Authorization: token ⟨api key⟩:⟨api secret⟩" \
-H "Content-Type: application/json" -d '{"naming_series": …, "company": …, "purpose": …, "posting_date": …, "posting_time": …, "items": …}'
Change one with PUT /api/resource/Stock%20Reconciliation/⟨name⟩ and the fields you change; a table sent there replaces its rows, so send its existing rows too. All the record calls and their answers: the API reference.
Samples that use it
s28_merge_and_history · s30_units_as_serials · s40_expiry_recall · s41_regulated_register · s45_restaurant_back_office
Fields
Read from the product at POS 2.1.0.667 (till app 60147699c): its own fields, the fields iVendNext adds to it, and iVendNext's changes to any of them. Read-only fields are set by iVendNext; a hidden one is not on the form but can be read. Every record also has name (its id, in the address), owner, creation, modified, modified_by and docstatus (0 a draft, 1 submitted, 2 cancelled), all read-only.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Series | naming_series |
Select | yes | one of: MAT-RECO-.YYYY.- | ||
| Company | company |
Link | yes | Company | ||
| Purpose | purpose |
Select | yes | one of: Opening Stock, Stock Reconciliation | ||
| Posting Date | posting_date |
Date | yes | |||
| Posting Time | posting_time |
Time | yes | |||
| Edit Posting Date and Time | set_posting_time |
Check | ||||
| Default Warehouse | set_warehouse |
Link | Warehouse | |||
| Scan Barcode | scan_barcode |
Data | ||||
| Scan Mode | scan_mode |
Check | ||||
| Items | items |
Table | yes | Stock Reconciliation Item | ||
| Difference Account | expense_account |
Link | Account | |||
| Difference Amount | difference_amount |
Currency | yes | |||
| Amended From | amended_from |
Link | yes | Stock Reconciliation | ||
| Cost Center | cost_center |
Link | Cost Center |
Table: Stock Reconciliation Item
The rows of items. Each row also has idx (its place), parent, parentfield and parenttype.
| Field | Field name | Type | Required | Read-only | Hidden | Links to |
|---|---|---|---|---|---|---|
| Barcode | barcode |
Data | ||||
| Has Item Scanned | has_item_scanned |
Data | yes | |||
| Item Code | item_code |
Link | yes | Item | ||
| Item Name | item_name |
Data | yes | |||
| Item Group | item_group |
Link | Item Group | |||
| Warehouse | warehouse |
Link | yes | Warehouse | ||
| Quantity | qty |
Float | ||||
| Valuation Rate | valuation_rate |
Currency | ||||
| Amount | amount |
Currency | yes | |||
| Allow Zero Valuation Rate | allow_zero_valuation_rate |
Check | yes | |||
| Use Serial No / Batch Fields | use_serial_batch_fields |
Check | ||||
| Reconcile All Serial Nos / Batches | reconcile_all_serial_batch |
Check | ||||
| Serial / Batch Bundle | serial_and_batch_bundle |
Link | Serial and Batch Bundle | |||
| Current Serial / Batch Bundle | current_serial_and_batch_bundle |
Link | yes | Serial and Batch Bundle | ||
| Serial No | serial_no |
Long Text | ||||
| Batch No | batch_no |
Link | Batch | |||
| Current Qty | current_qty |
Float | yes | |||
| Current Amount | current_amount |
Currency | yes | |||
| Current Valuation Rate | current_valuation_rate |
Currency | yes | |||
| Current Serial No | current_serial_no |
Long Text | yes | |||
| Quantity Difference | quantity_difference |
Read Only | yes | |||
| Amount Difference | amount_difference |
Currency | yes |