Overview:
This article explains the logic and automation implemented to create Item Receipts from Purchase Orders (POs) in NetSuite only when items are marked as Fulfilled/Received. This ensures that receipts are not created for items that are not physically received or flagged for receipt.
Business Requirement:
When a new Purchase Order is created, the system should automatically create a corresponding Item Receipt only for those items where the Fulfilled/Received preference is enabled.
This helps:
- Prevent premature inventory updates.
- Improve accuracy in receiving workflows.
- Ensure only eligible items are included in the Item Receipt.
Technical Implementation:
User Event Script:
- Trigger: After Submit (on Create event) of Purchase Orders.
- Logic:
- Iterates through each line item in the PO.
- Checks the item’s ‘Fulfilled/Received’ checkbox (Preferences subtab in item record).
- Only includes those items where the checkbox is
truein the Item Receipt. - Automatically creates and submits the Item Receipt for those qualifying items.
Validation:
- Skips items with the checkbox not checked (false).
- Ensures that Item Receipts are not created for non-receivable lines (reduces errors in receiving and inventory).
Benefits:
- Reduces manual effort in receiving process.
- Avoids receipt duplication or errors.
- Aligns with real-world inventory movements and preferences.
Best Practices:
- Keep the Fulfilled/Received flag up to date on item records.
- Review item preferences periodically to ensure alignment with actual business rules.