Aldi Direct Import

Freight Forwarder (FF) Documents

Creating the FF Documents

• Fulfill the sales order (mark picked)
  • Measurement and weights must be completed
• Print CI and PL
  • Save on shared drive
  • S:\Direct Import\Aldi\[PO number]
  • File name format: CI – xxxx (xxxx = PO number)

Emailing the FF Documents

• Email CI and PL to FF. (see email example in the shared drive)
  • Example: S:\Accounting\Accounting Procedure Manual\Direct Import\DI Procedures & Sample Docs\Freight Forwarder Emails
• On the Direct Import Tracking, Open saved search in NetSuite, update the FF Docs column with the date the docs were being emailed to the FF.

Complete Item Fulfillment

• Mark item fulfillment packed
• Mark item fullfillment shipped (only if CRD has arrived)

Preparing Consolidated Invoice

• If the freight forwarder requests a consolidated invoices, there is a saved search and excel template to use.
• Run saved search
• Filter saved search for invoice date range

• Export saved search to excel using excel icon

• Open excel consolidated invoice template
  • S:\Direct Import\Aldi\Consolidated Invoice Template
• Enter the first invoice number into cell J10 on the template spreadsheet
• Enter the invoice date into cell J12 on the template spreadsheet
• Copy and paste the item information from the exported saved search (columns C thru K) to template spreadsheet (starting with line 21)

Bank/Customer Documents

Sending Invoice to Customer

• After the order is billed, NetSuite will send an email to di@advantus.com.
• Determine the location.
  • The location is the Ship To Address Book code on each sales order.

• Email the correct A/P representative depending on location with the documents for payment.
  • The list of the AP representatives are on the shared drive.
    • S:\Direct Import\Aldi\1 Guidelines\Accounts Payable Contacts.

• On the Direct Import Tracking, Billed saved search in NetSuite, update the Bank Date column with the date the invoice was emailed.