Sales Order Information
11-06-2024
8946
Closed
TWG7240046W
Notes
2,534 BIN-CLR units
*fill 1,234 units from stock
*fill remaining 1,300 units from China

FRANZIA

*We will order the die-cut inserts from China.  Customer may also need normal graphics that come with the bins but Daniel working to verify.

*The bins and die cut inserts will be sent to Valley for fulfillment.  Melissa L has been discussing this with Valley already.  Valley will assemble the die cut inserts and place them inside the interior of the bins themselves

NOTE FROM DANIEL: @Erica Wuest, per our covo, I will tell client that we should be able to get them the 1,291 units by mid January as long as we can have art by the end of this week (11/8).  Based on our timing we just discussed this would mean:
Frank could have units done by 12/13 (5 weeks)
Units would get to MPIO by 1/3 (3 weeks via an expedited LCL)
Units would get to their ship to locations by 1/15 (allows about 2 weeks for domestic shipping).
See line item
*Artwork received on 11/11

artwork to be placed directly into bins
   
n/a
Ship on iSEE account.
iSEE to charge customer for shipping.

Once shipped, we need to upload tracking document in the tracking folder in sharepoint (Daniel and Melissa L have access to sharepoint).  Instructions on how to do so are on slide #2 in the "TWG-Tracking..." doc: https://app.hubspot.com/file-preview/22821650/file/182674003805/
 This tracking will need to go into the P1 folder.  Ideally client would like us to simply add a column to their original ship list sent (not the one Jess reformats and puts into our ship list format) and add a column for tracking (we may need to add 2 columns...one for the carrier and one for the tracking #).  
However, client did say they don't want us to have to do a lot of manual work here so if there is a way to send them what they need in a different format (i.e. maybe something we can just download out of quickbase) client may be open to that but Daniel would have to confirm. 

*Jess worked off shipping calculator to determine how these should ship (both ground and LTL; on ship list column O, but this might change if box dimensions are different due to artwork)

Charge customer $$13,109.45 for shipping
ap@avidinc.com, Rachelle.Rudloff@thewinegroup.com, kstrecker@avidinc.com
The invoice must include the job #, print QTY & rate.
Supporting Notes & Docs
Created on Nov.  6, 2024 at  1:03 PM (CST). Last updated by LaRose, Melissa on Jan. 22, 2025 at  4:05 PM (CST). Owned by VonderHaar, Jessica.
Jessica VonderHaar
Melissa LaRose
Show fields from Show fields from Show fields from a related table
Report Name *
Description
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
Please wait while your new report is saved...
Field label
Column heading override
Justification
What does auto mean?
Fields in:

Fields to Extract:
Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quickbase often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quickbase finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quickbase needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

  • If you want to create three separate Acme records (Acme-New York, Acme-Dallas and Acme-Portland) click the Conform link at the top of the column.
  • If the dissimilar entries are mistakes (say Acme only has one office in New York and the other locations are data-entry errors) go back into your table and correct the inconsistencies—in this case, changing all locations to New York. Then try the conversion again.

Read more about converting a column into a table.