There is a feature inside of Quickbooks Enterprise that is designed for this. It is called Enhanced inventory receiving (EIR). Although this feature will do what you want, it is a feature that can not be turned off. Please be sure to try in a backup file first to make sure you want to change to this method.
How to enable EIR
- From the Edit menu, choose Preferences and select Items & Inventory.
- Go to the Company Preferences tab and select Enable under "Enhanced Inventory Receiving" section.
- Review the warning message and select Continue, then OK.
- You will be prompted to back up your company file.
- Depending on the size of your company file, it may take a while to complete this process
- When finished, QuickBooks Desktop will provide a summary of changes that happened during this process.
To see the full article and all of the information regarding Enhanced Inventory Receiving please visit the following link: https://quickbooks.intuit.com/learn-support/en-us/help-article/product-preferences/turn-enhanced-inv...
