Our Sales Reps sell product on a hand written pre-printed Packing Slip and then submits the Packing Slip to our office. Our office invoices the information on the Packing Slips and adds a comment, "Billed from PS# 123". I am considering adding an Optional Field in OE for the purpose of adding the Packing Slip number.

Monthly we run a gridview report using the table:

SR Trans with AR, OE Head, IC

This report provides everything we need to calculate commissions for our sales reps, except for the Packing Slip #. It would be huge help if this report could show us the Packing Slip number that we entered in OE.

I don't see the optional fields in OE available in this table that we're using for commission reports. What field can we use then to enter the Packing Slip number into so that we can have it appear on the commission report? We considered the reference field, however, we need that field for customer who use PO numbers.

Any ideas?
I want to add one more field (PS#). This number is the number our sales reps use on their hand written packing slips when they sell the product.

Hi Susan,

If you used the GV table "OE Sales Order Header Master" you would have access to the Optional Fields.

But then I wouldn't have Standard Cost which I need for the purposes of calculating commissions.

Oh, sorry. I thought you were running a GV with 3 separate tables. But you're actually using a single composite tables that combines SR, AR, OE and IC?

Yes.. a single composite table that gives me all the fields I need to produce a commission report... except for PS#.

I will use OEHeadComment2. This works!