How To Integrate With DMA

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: Matt Kot <Matt.kot@dmadelivers.com>

Integration Points

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

Vendor Setup - Header

• Vendor Code – Create vendor records per distributor. You must use DMA's Dist ID (see list below)
• VO Mode - SFTP
• Interface - Standard
• URL - sftp.arrowstream.com/Inbound

Vendor Setup – Location Details

• Account # - 3-4-digit distribution code (DMA's Dist ID) + (dash symbol) + the Distributor Customer 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:

Vendor Bids

• Market Names must match the Distributor Warehouse Name (see list below)
• Vendor Product Numbers are the distributor's product numbers
• Primary and Substitute Vendor Bids should have the Vendor Unit configured as CS; Splits would use EA.
• The Discontinued flag will not be sent in the weekly order guides. You must maintain end-dating bids as products discontinue.

Other Considerations

• DMA uses Arrowstream as its integrator. Requests for projects or changes can take several weeks to process through Arrowstream's queue
• DMA has developed the Confirm Terms file however, they stated in the past that in order to use it, all Crunchtime customers would receive the file in their feed. A survey was done in February 2024, and at the time, some customers did not want to get the file, so it was not deployed. If enabled, the Confirm Terms file is processed pretty quickly after the order is received and will be based on stock levels at that time.
• DMA also developed to the 259 Vendor Delivery Schedule import.
• Credits can be excluded when requested.
• If Products need to be added/removed from Order Guides, the customer will need to contact the Distributor (not DMA)
• Order Guides can be sent daily or weekly. DMA can configure the frequency based on customer requests
• If an invalid product number is sent in a Vendor Order file, DMA will still send it across to the distributor as is. What the distributor does with that may vary across distributors.
• If changes are requested to the Crunchtime developed file formats, it would affect ALL customers, as Arrowstream has mapped most of the details noted above as hardcoded standards
• When scheduling go live, if the feed exists already in another system, it will need to be turned off to start the feed to Crunchtime. DMA cannot manage parallel feeds.

Distributor Codes and Market Names