Field reference
Stock Reconciliation
How to use Stock Reconciliation in Inventory: access, working steps, fields, related records and troubleshooting.
Purpose and access
Use stock transactions to record receipts, issues, transfers and reconciliation. Confirm warehouses, units, batches and serial numbers before submission. Use the stock ledger to investigate movements rather than editing an item to simulate stock.
This page is a record page in Supply Chain → Inventory. Use the link above to open the configured destination; permissions are checked by the destination service.
ERP links open in a new tab. Sign in with your own account; record visibility, actions and approval authority follow your assigned permissions. Screens can differ by company and configuration.
Before you start
Prepare the required information: Series, Company, Purpose, Posting Date, Posting Time, Items.
Confirm the company, party, dates, units and source references that apply. Select existing links carefully and check for an existing record before creating a duplicate.
Working steps
- Open Stock Reconciliation from Supply Chain → Inventory, or use ERP Search.
- Filter the list and open the relevant record. To add a record, use Add/New when your role provides that action.
- Complete the editable fields described below. Required fields and validation conditions must be satisfied; read-only values are set by the system or their source records.
- Add the required child rows. Review each row’s identifiers, linked records and values, using the child-table field reference below.
- Save the record and address validation messages. Reload and verify the saved values and relationships.
- When the draft is complete and you are authorized, submit it through the available approval process. Submission can create operational or accounting effects. Use the permitted cancellation/amendment process for later corrections.
Field reference
These fields come from the installed ERP definition. Hidden fields and password inputs are omitted. Additional conditions, custom scripts and workflow rules can make a field required or read-only in a particular context.
| Field | Type / behavior | How to use it |
|---|---|---|
Seriesnaming_series | Select Required | Choose one of the configured list values. Status fields may be controlled by the record workflow.Available choices
|
Companycompany | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Company |
Purposepurpose | Select Required | Choose one of the configured list values. Status fields may be controlled by the record workflow.Available choices
|
Posting Dateposting_date | Date Required | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Posting Timeposting_time | Time Required | Record the time in the format accepted by the field. |
Edit Posting Date and Timeset_posting_time | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Default Warehouseset_warehouse | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Warehouse |
Scan Barcodescan_barcode | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Last Scanned Warehouselast_scanned_warehouse | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Scan Modescan_mode | Check Optional | Disables auto-fetching of existing quantity |
Itemsitems | Table Required | Add the relevant child rows and review required columns, quantities and references before saving. Linked record: Stock Reconciliation Item |
Difference Accountexpense_account | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Account |
Difference Amountdifference_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Amended Fromamended_from | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Stock Reconciliation |
Cost Centercost_center | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Cost Center |
Child tables
Items — child-row fields
| Field | Type / behavior | How to use it |
|---|---|---|
Barcodebarcode | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Has Item Scannedhas_item_scanned | Data Optional · Read-only | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Item Codeitem_code | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Item |
Item Nameitem_name | Data Optional · Read-only | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Item Groupitem_group | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Item Group |
Warehousewarehouse | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Warehouse |
Quantityqty | Float Optional | Enter a numeric value using the required unit and precision. |
Stock UOMstock_uom | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: UOM |
Valuation Ratevaluation_rate | Currency Optional | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Amountamount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Allow Zero Valuation Rateallow_zero_valuation_rate | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Use Serial No / Batch Fieldsuse_serial_batch_fields | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Reconcile All Serial Nos / Batchesreconcile_all_serial_batch | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Serial / Batch Bundleserial_and_batch_bundle | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Serial and Batch Bundle |
Current Serial / Batch Bundlecurrent_serial_and_batch_bundle | Link Optional · Read-only | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Serial and Batch Bundle |
Serial Noserial_no | Long Text Optional | Complete the value according to the field label and the record’s validation rules. |
Batch Nobatch_no | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Batch |
Current Qtycurrent_qty | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Current Amountcurrent_amount | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Current Valuation Ratecurrent_valuation_rate | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Current Serial Nocurrent_serial_no | Long Text Optional · Read-only | Complete the value according to the field label and the record’s validation rules. |
Quantity Differencequantity_difference | Read Only Optional | System-provided value; correct its source record or calculation rather than overwriting the displayed result. |
Amount Differenceamount_difference | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Troubleshooting
- Not permitted: verify the account, role and source-document permission. Do not share an administrator login.
- Missing record or address: inspect the relevant Link or Dynamic Link fields; a matching title alone does not establish a relationship.
- Cannot save or change status: review required fields, read-only values, document status and the configured approval transition.
- Unexpected report or portal result: review company/date filters, source-document submission and the approved party or Employee link.