Empty Check Missing Grow Seasons

So if you're like us, you constantly find yourself adding new varieties, new containers, and new production items to the system. Ideally you enter all the pertinent grow information at that time too, but in reality.... it doesn't always happen! So what we did is make an "empty check" report which shows items with missing grow seasons.

Download here!

Here is the formula I used in the Record Selection Formula Editor:
isnull( {grow_season.id}  )

and  {production_item.record_status} =1

The joins were pretty simple but I had to make one of the joins a "full outer" join instead of the default "inner" join.

Purchase Order Format

Hotfix 4.06.36 has a new field in the Purchase Order Report Set called "Customer UPC." This means that when you select a customer on the purchase order line item, you can display the upc from the customer item properties instead of from the vendor item properties table. **Great news** for those of you using purchase orders for buying finished goods because it means you don't have to double enter upc information that is already setup on the customer side! Selecting the customer will also show the customer's SKU. Currently it does not update the retail price correctly from the customer settings but I have a request in to Sharon for that.
**update** Sharon showed me how to fix the retail price. You can pull the retail from the customer item settings by using the field named "retail." For us, we also have a "Retail" field setup as a profile field under the Vendor Item Settings which you can use also. Email me if you want more info!

Here is a purchase order which shows the "select customer" on its line items.

Old field: UPC1 (still available)

New field: Customer UPC

Originally your purchase order report format won't show the new field unless you go in and refresh the table. This happens anytime they add a new field to a table or a report set. This is how you refresh your table in I-Net, just click on the double arrow symbol.

**I put a suppression formula on the UPC field so that if the select customer is selected, the vendor items UPC does not show but the customer UPC does, and vice versa.
Download Purchase Order RPT Format

Kmart Label

Kathleen,

Where do you get the Code 128C?

Scott,
That was under the middle window, in the "User Defined formulas."