We went live with our webstore on July 1. Now, we are looking back at our numbers for July and have a problem.
On all of the item fulfillments on sales orders that came from webstore, the Cost of Goods Sold on the item fulfillment transaction went to whatever department was listed on the item setup (or no department if the item didn’t have a department). This acts differently than Sales Orders that are entered by internal sales reps. When an internal sales rep enter a sales order, whatever department is on the sales order is the department that get the COGS when the item is fulfilled. This is how we want web orders to work as well. Currently, on orders from the webstore, the department on the Sales Order gets set correctly (we actually set it with a OnBeforeSubmit script) but the COGS department from the Item Fulfillment doesn’t get set from the sales order department. Instead it seems to use the department (or no department if no department was listed on the item setup) of the item to determine the COGS department for the Item Fulfillment transaction.
I’m using the same sales order form for both web orders and non-web orders. I’ve checked and the department is always correct on the Sales Order. The revenue gets put to the correct department based on the Sales Orders department. It’s just the Item Fulfillment transaction that doesn’t seem to use the department from the Sales Order. Any thoughts? I thought maybe it was a setting, but can’t find it if so.
Something else to help in troubleshooting. On five web orders, the COGS department on the Item Fulfillment transaction did followed the dept on the Sales Order. Turns out on all five of these orders, a sales rep had gone into the order and edited something on the order before the item was fulfilled. There is something about someone using the NetSuite UI that makes it work verses automatic web orders.
Thanks in advance, Joyce