Skip to main content

Importing Supplier Data Files

info

Before following these instructions, we recommend you view About Serial Costing first.

In this method, you'll import the information that you need to cost from a data file (either an Excel file or an EDI file in CSV format). The data file will include the PO numbers, supplier invoice numbers, models purchased, quantity and costs.

Before Starting

Importing the Supplier Data File

  1. Go to Purchasing > Serial Costing. Click Import.

    img

  2. Select the Template code from the dropdown.

    img

  3. The Import Folder field is populated with the import folder path that was entered when the template was created. If this path isn't correct, you can change it here.

    info

    You can select a single data file instead of a folder location if the invoice data is contained within one file. To do this, add the filename and extension to the end of the Import Folder path.

    img

  4. Click OK. A PDF opens reporting any errors or exceptions with the import.

    img

    info

    The import utility creates a log file during the import process, which is stored in your EPASS folder.img

  5. Repeat steps 1–4 to import invoices from additional suppliers.

    img

  6. The model data from each PO is loaded into the Serial Costing screen.

    img

    The Serial Costing screen is broken up into several columns of information:

    AEach model that was ordered on the POs.
    BThe quantity ordered and received.
    CThe quantity of serials that need to be costed.
    DThe quoted cost for each model.
    EYour cost (before costing).
  7. Click Expand All Rows to view the serials for each model.

    img

Costing Each Serial

Starting with the first model in the Serial Costing window, follow this method to cost.

  1. Verify that the amounts shown in Quoted Cost and Your Cost are the same.

    img

    tip

    Any discrepancies between the Quoted Cost and Your Cost amounts are highlighted in red. img

  2. Click the model's Cost checkbox.

    img

  3. Move on to the next model and then repeat steps 1 and 2.

    info

    If you don't want to cost a serial, clear its Cost check box. Any serials that do not have their Cost checkbox selected will not be costed. If there are any errors during the costing process (for example, Model record is locked), error messages are displayed in the white box above the progress bar.

  4. When you are finished, click Cost.

    img

  5. The Add AP Transaction window opens. Verify that all the information is correct in this window. If necessary, enter a Cost Center for each Distribution line. Click OK and repeat for any additional Add AP Transaction windows that open.

    img

    info

    In each Supplier’s settings (Supplier record > PO Variables tab) you can select to auto create the AP transaction without displaying it on screen. Make sure that you are comfortable with the settings before enabling this option.

    img

The costing process is now complete.

img

See Also