Loading
Connect in real time with the Trailblazer Community in Slack Open BetaRead More
Sync Goods Received Notes to Inventory

Sync Goods Received Notes to Inventory

The manual entry of received goods into warehouse stock is replaced by a single automated action.

Required Editions

Available in: Lightning Experience

Available in: Enterprise, Unlimited, and Developer Editions

User Permissions Needed
To sync inventory: Manage Goods Received Notes
Note
Note Ensure that the Inventory Search and Transfer is enabled in Setup.

To sync a GRN to inventory:

  1. Open a Goods Received Note that is in Approved status.
  2. Click the Update Inventory button. A confirmation dialog appears summarizing the items to be synced.
  3. Click Confirm.
Note
Note
  • The system prevents syncing if the GRN is in Draft, Pending, or Cancelled status.
  • Automatically calculates Shortage or Excess quantities by comparing the invoice quantity vs. the physically received quantity.
  • Updates the Quantity on Hand and Quantity Unusable for the corresponding Product Item record.
  • For batch-tracked products, updates Quantity On Hand and Quantity Unusable for the corresponding Product Batch Item record.
  • For serialized products, updates the location and status for Serialized Product records linked to the GRN. Serialized products marked as Is Unusable on the GRN item populate the Is Unusable and Unusable Type fields on the Serialized Product record.
  • Creates Product Item Transaction records to track quantity-on-hand changes.
  • Creates Product Item Additional Transaction records to track quantity-unusable changes, with Product Item State set to Unusable and Unusable Quantity Type populated. This automatically creates or updates the corresponding Product Item Quantity Detail record (or Product Batch Item Quantity Detail record for batch-tracked products), which holds the current unusable quantity breakdown by type.
  • If the Quantity Received on a PO Line Item is less than the Ordered Quantity, the status automatically changes to Partially Received. If it meets or exceeds, it changes to Received.

Incremental Syncing

If a discrepancy is found after the initial sync, you can adjust inventory without re-syncing the entire GRN.

To perform an incremental sync:

  • Update the applicable record for the correction:
    • Update the Quantity Received or Unusable Quantity on the GRN line item with the corrected value.
    • For unusable quantity breakdowns by type, update the Quantity on the related Goods Received Note Item Unusable Quantity Detail or Goods Received Note Item Product Batch Unusable Quantity Detail records.
    • For serialized products, update Is Unusable and Unusable Type on the related Goods Received Note Item Serialized Product (GRNISP) record.
  • Click Update Inventory.

The system calculates the difference using the Last Synced Inventory Received Quantity field on the GRN Item or GRN Item Production Batch record. When unusable quantities are broken down by type, the system also uses the Last Synced Quantity field on the related Unusable Quantity Detail records. For serialized products, the system uses the Last Synced Unusable Type field on the GRN Item Serialized Product record to detect changes to Is Unusable and Unusable Type. The system then adjusts the warehouse stock by that delta (positive or negative).

Note
Note After sync, the Quantity Received and Unusable Quantity fields on GRN Items become read-only to maintain audit integrity. To make corrections, create adjustment transactions or use inventory count processes.
 
Loading
Salesforce Help | Article