Stock Ledger Entry
How to use Stock Ledger Entry 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 internal/admin record in Supply Chain → Inventory. Use the link above to open the configured destination; permissions are checked by the destination service.
Before you start
Review the current settings or existing records and prepare the information needed for the change.
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 Ledger Entry 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.
- Save the record and address validation messages. Reload and verify the saved values and relationships.
- Use any additional workflow actions only when the record and your role provide them. Saving this record does not automatically complete a related transaction or external action.
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 |
|---|---|---|
Item Codeitem_code | 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: Item |
Warehousewarehouse | 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: Warehouse |
Posting Dateposting_date | Date Optional · Read-only | Choose the business date required for this field. Confirm its relationship to other dates on the record. |
Posting Timeposting_time | Time Optional · Read-only | Record the time in the format accepted by the field. |
Posting Datetimeposting_datetime | Datetime Optional | Record the date and time in the configured system/user time zone. |
Is Adjustment Entryis_adjustment_entry | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Auto Created Serial and Batch Bundleauto_created_serial_and_batch_bundle | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Voucher Typevoucher_type | 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: DocType |
Voucher Novoucher_no | Dynamic Link Optional · Read-only | Select the record identified by the associated document-type field. Verify both the type and the linked record. |
Voucher Detail Novoucher_detail_no | Data Optional · Read-only | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Serial and 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 |
Dependant SLE Voucher Detail Nodependant_sle_voucher_detail_no | Data Optional | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Recalculate Incoming/Outgoing Raterecalculate_rate | Check Optional · Read-only | Enable or disable the named option only when it matches the intended record behavior. |
Qty Changeactual_qty | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Qty After Transactionqty_after_transaction | Float Optional · Read-only | Enter a numeric value using the required unit and precision. |
Incoming Rateincoming_rate | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Outgoing Rateoutgoing_rate | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Average Ratevaluation_rate | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Balance Stock Valuestock_value | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
Change in Stock Valuestock_value_difference | Currency Optional · Read-only | Enter the monetary amount in the applicable currency. Review the transaction and company currency before using the value. |
FIFO Stock Queue (qty, rate)stock_queue | Long Text Optional · Read-only | Complete the value according to the field label and the record’s validation rules. |
Companycompany | 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: Company |
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 |
Projectproject | Link Optional | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: Project |
Fiscal Yearfiscal_year | Data Optional · Read-only | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
Has Batch Nohas_batch_no | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Has Serial Nohas_serial_no | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Is Cancelledis_cancelled | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Serial Noserial_no | Long Text Optional · Read-only | Complete the value according to the field label and the record’s validation rules. |
Batch Nobatch_no | Data Optional · Read-only | Enter the identifier or short text requested by the label. Preserve external reference numbers accurately. |
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.