I've got a ServerSide script running on all Sales Orders. I'm attempting to access each Item Cost (or Purchase Price) to calculated Gross Profit. I can't seem to find a way to access the Item Cost from any orders generated from my website. I've tried accessing 'porate' and 'averagecost', but neither are populated with web orders. I've tried adding a Custom Column that is not stored with the record that is sourced from the Item -> Purchase Price field - doesn't work. All of this works perfectly fine if I'm putting in the same order via the UI. Could it be a permissions problem? From the website, I'm just a customer. From the UI, I'm an administrator.
Thanks,
Scott