How To Integrate With Pepsi

This guide can be used to configure an electronic integration with Crunchtime and this vendor. This information is based on the last known setup and requirements from the vendor.

Submit a new request to: PBCNABEDITEAM@pepsico.com

Integration Points

• Purchase Order – Standard PO
• Confirm Receipt – not available
• Confirm Terms - not available
• Invoice – Standard e-invoice
• Bid Sheets – not available

Vendor Setup - Header

• Vendor Code – decided on by the customer; let the Vendor contact know the code to use
  • Pepsi Bottling Co supports some bottlers, but other independent bottlers may be supported under different integration partners. This will require separate Vendor records and connections. 
• VO Mode - SFTP
• Interface - Standard
• URL - sftp.net-chef.com/po (the vendor prefers to use the Crunchtime-hosted SFTP)
  • If using their server, ecgprdf.pbsg.com/inbound​​​​​​​​​​​​​​​​​​​​​, they will whitelist IP addresses

Vendor Setup – Location Details

• Account # - Customer account number
• Reference - not used. Repeat the Account #
• User Name/Password – Same credentials will be used by all locations

Vendor Setup – Charge and Credit Codes

This is a list of common codes found on invoices:

• Sales Tax
• State Charges
• Blue shells (returns/deposits)
• CO2 Empty (012000402692)
• CO2 FULL (012000400292)

Vendor Bids

• Vendor Product Numbers are 12-digit UPC numbers with possible leading zeros
• Vendor Units are primarily CS, EA, or GL
• Pepsi (PBC) will invoice Bibs by GL (rather than CS); Independent bottlers may invoice by the case (CS or CA -recommended to confirm with the bottler when setting up the integration)

Other Considerations

• A form will be required to fill out "EDI" details. These are technical details confirming file requirements and integration SFTP paths; Customer details must also be filled in
• IP addresses will need to be whitelisted to access the Pepsi FTP. This can take several weeks to get processed internally through Pepsi. Limited to 5 total - 1 of which should be for Crunchtime Production (66.151.178.6).
• Pepsi integration resources will break out the project into at least two teams: Order, Invoice. If the Invoice work is completed ahead of the Orders, Pepsi can accept emailed PDF orders and apply the PO# to the Invoice files.
  • Additional resources may get involved if the bottler is not part of the national Pepsi distribution network.
• Invoices have a 48-hour delay in processing due to the need to process the information through their AP system. Expect invoices no later than 12 PM EST, 2 days after delivery (see examples below)
  • If an order was placed yesterday 7/15 for delivery on 7/17, the invoice will arrive electronically in Crunchtime on 7/19. 
  • Go live for the integration is today (7/16). An order was placed on 7/13 and delivered yesterday, 7/15. The invoice will NOT be electronically transmitted to Crunchtime.
  • Go live for the integration is today (7/16). An order was placed on 7/13 and will be delivered today, 7/16. The invoice will arrive electronically in Crunchtime on 7/18.
• Credits can be included in the feed. Pepsi will ask if SUR (Single Unit Returns) Credits can be accepted in the feed. If yes, they will process at the same time as Invoices, and will not include the PO #; the Vendor Bid must be configured with the Allow Split flag so the invoices can process.
• Pepsi may have the ability to send a Post Delivery Advice file in place of the invoice file, 24 hours after delivery, but it could have different functionality. 
• Per Pepsi, all locations must go live at the same time. Pepsi also requires a 2-week lead time to go live. They will also provide the Production SFTP password on the go-live date.
• Invoice files will be grouped by bottler; 1 file for all invoices
• Some independent bottlers, such as Varsity Beverages, split orders between bib products and bottles/cans. Please confirm how the bottler handles their products when setting up the integration. Users may need to create separate orders by product in this scenario. 
• Invoice #’s are recycled every 6 months. Be aware of the possibility of duplicate invoices (consider enabling the pricing rules setting to allow duplicate invoice numbers)
• Many of the UPC numbers can be found from this site maintained by Pepsi: https://www.pepsicopartners.com/pepsico/en/USD/BEVERAGES/Soft-Drinks/c/softDrinks?root=beverages