Monday, October 21, 2013

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


No comments:

Post a Comment

Note: Only a member of this blog may post a comment.