Target (03TAR)

Customer #: 03TAR
Main Contact: Tiffany Kindschy (ISD Advantus) tkindschy@advantus.com

Account is Auto-Approve/Manual Release

• Ships from: Jacksonville
• Orders come in through EDI – Monday
• Orders are to ship the following Monday

Steps to follow:

1. Once orders are received:
2. Check EDI Logs (Order Range, Price discrepancy log and Duplicate PO Log) received via email.
3. Make sure backorders orders have been filled.
4. Confirm any price variances with Tiffany Kindschy.
5. Confirm any duplicate POs with EDI and Tiffany.

Order Release Process

1. Check that the orders are in Full status.

2. Export the Excel sheet.
   • Remove columns in this order: A-B,G-I, H-I, J, K-M, M.

3. In NS confirm the orders have the following Monday as the ship date.

• If they do not, contact Tiffany to verify it is okay to ship on the new day.

Email

1. Copy the information from the Excel sheet and add to the body of a new email.
2. Send email to 12^th St Shipping and CC: Tiffany Kindschy and Virginia Alvers.

Current Account News

• As of Jan 2022, we have been cancelling all orders from Target until further notice.
• Please follow the instructions below:

Order Cancellation Process:

1. On your homepage, go to the Sales Orders (Open)portion, under the Quick Links section.
   1. Select the Open Sales Order Detail hyperlink.
   2. In the filter section put 03TAR in the customer box and click tab.
   3. Export the excel sheet.
      • Remove columns in this order: A-C, B-C, F, I-J, K-L.
      • Place a data filter on the full chart.
      • Select the A-Z sort option on the Order Number and expand selection.
      • Under the data tab select.
        1. At each range should have Order #.
        2. Use Function should be Sum.
        3. Add Subtotal you will need to select Cust PO # and Item.
      • Select the drop-down menu under the Order # column and search for “total.”
        1. Click ok.
        2. Do not select the first row; select from the second row down to the Grand Total.
        3. Go to the home tab, under the font section, select the paint can.
        4. Select the second lightest orange to fill the cells.
      • Remove the Filter from the chart.

4. Save the chart under S:\Customer Service\Team Folder\Tiphanie F\Accounts\03TAR

• Save the File as Target Cuts Month.Day.Year

Once this is completed send an email to Lauren Stevens <lauren@resultatisales.com>