Reconcile a physical stock count
Open Stock Reconciliation and create a new record. Choose Stock Reconciliation as Purpose for an adjustment to existing stock.
Before you start
Use your authorized ERP account and the correct company. These screenshots use fictional staging records. Replace the example quantities, dates, warehouses and values with your approved business information. Submission affects the relevant workflow or stock ledger; review the draft first.
Addresses used in this tutorial
ERP_URL is your organization’s ERP address. ACADEMY_URL is the Academy base address: staging uses https://erpstaging.nexcommand.ai/academy; production uses https://academy.nexcommand.ai. Saved record IDs and temporary draft IDs differ between installations. Course IDs and element IDs in the example are not portable to another installation.
Step-by-step instructions
Choose Stock Reconciliation
Open Stock Reconciliation and create a new record. Choose Stock Reconciliation as Purpose for an adjustment to existing stock.
- Example / selection
- Stock Reconciliation
- Expected result
- The record is prepared for a physical count.
{ERP_URL}/desk/stock-reconciliation/new-stock-reconciliation-{TEMP_ID}
Fetch the warehouse items
Select the warehouse in Fetch Items and apply the selection.
- Example / selection
- DEMO Docs Receiving
- Expected result
- The existing stock rows are loaded.
{ERP_URL}/desk/stock-reconciliation/new-stock-reconciliation-{TEMP_ID}
Review the current quantity
Read the fetched item, warehouse, quantity and valuation rate before editing.
- Example / selection
- Current quantity 8; rate USD 125
- Expected result
- The baseline is visible.
{ERP_URL}/desk/stock-reconciliation/new-stock-reconciliation-{TEMP_ID}
Enter the counted balance
Enter the actual counted quantity, not the difference. Leave the cell to commit the edit.
- Example / selection
- Counted 7, not minus 1
- Expected result
- The reconciliation records the intended final balance.
{ERP_URL}/desk/stock-reconciliation/new-stock-reconciliation-{TEMP_ID}
Save and check the adjustment
Save. Review the difference amount and approved difference account.
- Example / selection
- Difference USD -125; Stock Adjustment account
- Expected result
- The draft represents the one-unit reduction.
{ERP_URL}/desk/stock-reconciliation/{RECORD_ID}
Confirm submission
Submit only after the count and account are reviewed.
- Example / selection
- MAT-RECO-2026-00002
- Expected result
- The adjustment is authorized.
{ERP_URL}/desk/stock-reconciliation/{RECORD_ID}
Verify Submitted
Check the document status and saved counted quantity.
- Example / selection
- 7 Nos
- Expected result
- The reconciliation is posted.
{ERP_URL}/desk/stock-reconciliation/{RECORD_ID}
Verify the final stock balance
Open View → Stock Ledger and inspect this voucher. Confirm the resulting balance and value adjustment.
- Example / selection
- Balance 7; value change USD -125
- Expected result
- The ledger agrees with the count.
{ERP_URL}/desk/query-report/Stock%20Ledger
Verified result
The submitted reconciliation and its stock ledger were verified: the receiving warehouse balance is seven with a USD 125 reduction.
Troubleshooting
Wait for Link search results and choose the exact record. Leave each edited field to commit its value. Check required dates in every item row. A saved draft and a submitted record are different states. If validation fails, correct the highlighted field and verify the saved result before continuing.