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."

Inventory Items with Picture Links Report

Wondering how to keep track of what an inventory item looks like?

Using the "image link" field in the inventory item catalog, you can pull the picture into various custom reports. Here is an example of one I did for Proven Winner (r) combo's. We have also made reports for our plastic containers and tags.

Note that the item will only show if you have a picture link attached to it. This report also shows the combination information (how many plugs of each type goes into the combo).

Download .rpt file here

For those of you wanting to add pictures to your own reports...
Here is how you insert the picture into a custom report.

Here are the settings I used. I tried the other option for "bean view" but this one seemed to work better.

You have to edit the formula on the 2nd property to select your image field.

That's it!

SDS Update for Global Harmonized System (Chemicals)

The new SDS sheets are just around the corner... How is your company planning to keep track of the new chemical sheets for the Globally Harmonized System (GHS)? The SDS sheets (formerly known as MSDS sheets) are available online for free from most chemical manufacturers. What we would like to do is save those in a spot on our network and have a link in the inventory item file image link field. 

Currently we cannot save ".pdf" files to the image link. I have a request in (Issue No 4617) to add ".pdf" as a filetype for this field. If we can get those links in, I can make a custom report which shows all the SDS sheet links for each chemical. 

Now if I can just come up with something for tracking chemical applications....

Hotfix Version

What hotfix are you on? We are currently running 4.06.27

Kmart Box Label Format

Kmart DS Label Format Download
For all you users who need the new Kmart label, here it is! You have to have the barcode fonts installed for it to work correctly.