Sales Order Information
09-12-2024
8791
Closed
Multiple PO's
Notes
200 HOOK-6.33IN-BLK units
80 PBAR-20CSD-10C-1024-45A units
80 HOOK-6.33IN-BLK units
80 graphics

NOTES FROM JASON:
-The label is to be applied. Description/picture of how they should be applied: https://app.hubspot.com/file-preview/22821650/file/178194109485/

-80 of the hooks are to be packed with the powerbars. Hooks are to be air freighted in and packed/re-shipped at accent.   Being used at CK Gulf.  

-Order sheet lists quantity in column V, item descriptions are in columns W, X & W for the items.  Powerbar is $35.00 ea   Hooks is $5.02 each and Label is $5.00 ea (applied)
NOTES FOR ERICA:
1) Is customer correct? Hubspot says "Pepsi Co" but there's no "Pepsi Co" customer in base

- Yes, customer is always PepsiCo Beverage Sales, LLC unless it's something like Nackard Pepsi, in which case Jason will have that info 


2) Does any additional info need to be given for transaver?

- Nope, this is good. 
- Additionally,I just sent you and Melissa an email of a previous transaver exchange. Melissa will already have this from her past as well, but just so you know what that looks like. We have to give them 3 days to make their BOL, and they will send earlier if they can. 


3) How do invoicing notes look? Do I need to include all the PO #'s?

- I added one email address to the invoicing notes. 
- When the orig ship list looks like the one that Jason provided, it's best to include all names affiliated with each PO. Thais is the market LPO (unsure exactly what that means), but he is the main one responsible for payment. 


4) Jason gave a bunch of info in "special notes" that I put in the generic notes. Wasn't 100% sure where the best place for these notes were

- this is good, nothing to change


5) Jason put warehouse as accent but then mentiones hooks being air freighted -- should I put the hooks from Frank or Dylan?

- hooks come from Dylan. 
- One thing we should clarify is if the 200 units going to two locations need to go to Accent, or if those can ship direct to customer and the 80 should go to Accent for repackaging. 


6) I was able to determine what should ship ground vs LTL for PowerBars, but I do not have information for the hooks. Please advise for the 2 locations that have only hooks going to them.

- the answer to # 5 will possibly resolve this question. 
- the 80 hooks will be added to the boxes of powerbar, so nothing to consider for shipping there. The hook won't change weight enough to requote.
Previous run on S/O #7075



Artwork ordered thru Accent 27/Sept: 

80 PowerBar decals - Pepsi

PO# 3880G
   
n/a
Ship via transaver 

*Ship all hooks to accent, and then ship accordingly from there.
PO#'s: 4500544357                    4500414951 4500414953                    4500412578 4500548478                    4500536956 4500548425                    4500548480 4500548481                    4500548530

Submit invoice to: nassapInvoiceSubmission@pepsico.com, Thomas.Ludford@pepsico.com, and thais.soares@pepsico.com
Supporting Notes & Docs
Created on Sept. 12, 2024 at 10:37 AM (CDT). Last updated by Agrawal, Samir on Nov. 27, 2024 at  9:43 AM (CST). Owned by VonderHaar, Jessica.
Jessica VonderHaar
Samir Agrawal
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.