Skip to main content

Import - Receiving

Tyler Wright
Updated

This article shows DVU users how to create a receiving order from a CSV file. It’s a four-step process:

  1. Download the CSV template.

  2. Add rows of data.

  3. Import the file.

  4. Convert the file and create one or more receiving orders.

Downloading the template

  1. Go to Home > Import.

  2. Click the Import Type field and select Receiving Channel.

  3. Click Download Template. The file saves to the local device.

Adding data

Open the file and enter the required data. Add one row for each receiving item. Save the file with a unique name.

Note Click here to view a sample file with one row of data.

The file has many data columns. The following are required columns:

  • Account

  • Item code

  • UOM

  • Warehouse ID

Note Click a link to learn how to find the Account ID and Warehouse ID.

Importing the file

  1. Open the Import page.

  2. Check one or both boxes to enable the configuration settings. (optional, see below).

  3. Select the file on the local device.

  4. Click the Import button and then OK in the confirmation popup window.

DVU loads the data into the table but not into the system. If the data looks complete, click the Import button. DVU moves the data to the Receiving Channel (see next step).

Note The platform does not save data on the Import page or the Receiving Channel page.

Convert the file

The final step is to convert the uploaded CSV data into one or more receiving orders.

  1. Go to Home > Channels > Receiving Channel.

  2. Use the search icon to display files for the account, or click the Refresh icon.

  3. Highlight one or more rows.

  4. Click the Create Receipt icon.

Tip Select all of the lines to batch move the items to the Receiving Orders page. DVU users can also select items individually or in smaller groups.

DVU moves each line to the Receiving Orders module and displays them on the main page. The Source/Channel reference is Import.

  • All information that comes from the Import function can be confirmed and edited in this step. Additionally, any information not in the receiving order can be added here.

Tip Items in the CSV file with different order numbers appear on the Receiving Orders page as separate lines. DVU combines items with the same order number into one receiving order.

Troubleshooting

If the page displays an error message:

  1. Go back to the original CSV file, make changes, and save the file.

  2. Come back to the Import page and click Choose Import file. DVU removes the rows of table data on the screen.

  3. Import the updated CSV file.

Item code doesn't exist

DVU displays this error message when it cannot find an item code in the account.

Note DVU cannot create new item codes from a CSV file.

DVU users can:

  • verify the item code in the CSV file, or …

  • add the item to the account, and then try again to upload the CSV file.

Reimport

The Reimport button is a time-saving feature when working with a file that has many line items. Click the button to move all properly formatted items to the Receiving Channel page and download a new CSV file that contains the line items with errors.

Repair the errors and then upload the file. If formatted accurately, DVU moves those files to the Receiving Channel page.

Related to

Related articles

Comments

0 comments

Please sign in to leave a comment.