When my team makes a drop ship order for a certain vendor, I need the rate and total for each line item on the Purchase Order to match the rate and total for each line item on the Sales Order. Standalone purchase orders should use the purchase price as expected .How can I accomplish this?

AI generated answer (using internal Slack threads):

To accomplish matching the rate and total for each line item on the Purchase Order to the rate and total for each line item on the Sales Order, you can use SuiteScript to automate this process. Here's a high-level approach: 1. Create a User Event Script: This script will be triggered when a Sales Order is created or edited. The script will capture the line item details including the rate and total. 2. Create a Scheduled Script: This script will run at a scheduled time (for example, every night). It will search for all Purchase Orders that were created that day. For each Purchase Order, it will find the corresponding Sales Order using the

applying transaction join

and match the line items based on the

line id

or

line sequence number

. 3. Update the Purchase Order: If the line item rate or total on the Purchase Order does not match the corresponding line item on the Sales Order, the script will update the Purchase Order to match the Sales Order. Remember to be extra careful and add a filter about the applying link type to ensure you're updating the correct line items. For standalone purchase orders, you can add a condition in your script to check if there's a corresponding Sales Order. If not, the script can use the purchase price as expected. Also, you might want to look into the

Allow Overage on Item Receipts

account preference (Setup > Accounting Preferences > Order Management) to handle situations where the item receipt quantity doesn't match the purchase order quantity. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******