Feature - Import for Material Cost Type Location Account File

Release Date: 12/16/22

Version: 8.5 and Above

This feature allows the user to import records for the Inventory Management Material Cost Type Location Account file. A new Import menu option has been added.

After choosing the Import option, a new screen is shown with a Pre-Interface, Interface, and Layout option. The Layout option shows the required layout for the CSV file used in the import process.

The required fields are:

(Column A): Material Cost Type (Required)                  
(Column B): Location (Required)                            
(Column C): Inv Asset Acct (Required)                      
(Column D): Purchase Price Variance Acct (Required)        
(Column E): Use Standard Variance?                        
(Column F): Standard Variance Acct (Required If Column E = Y)

The application supports two interface modes - Pre-Interface and Interface.

1. Import CSV File Path & Name -- Enter the full path and file name of the CSV file to be processed. The application will remember the last file name entered.  

2. CSV File Contains Header Row ? -- If the CSV file contains a header row, enter Y. Otherwise, enter N. The application will remember the last entry.

Possible errors conditions:

Error : Matl Cost Type Must Be Entered

Error : Matl Cost Type Size Exceeds Maximum Length of 1

Error : Matl Cost Type Not Found

Error : Location No Must Be Entered

Error : Location Size Exceeds Maximum Length of 2

Error : Location Not Found

Error : Record Already Exists, Cannot Be Added

Error : Inventory Account Not On File

Error : Purchase Price Var Account Not On File

Error : Use Std Variance Must Be Set To Y Or N

Error : Std Cost Var Acct Must Be Blank If Use Std Variance Set To N

Error : Std Cost Var Acct Must Be Provided If Use Std Variance Set To Y

Error : Std Cost Var Account Not On File

The Pre-Interface and the Interface Journals will print the data from the CSV file and any pertinent error messages. Here is an example of the Interface Journal.

Programs Added: IM17IS, IM17IP

Programs Modified: IM1701

CLS

• Related Articles

• Feature - Import for Product Category / Location Account File

  Release Date: 12/16/22 Version: 8.5 and Above This feature allows the user to import records for the Customer Order Processing Product Category Location Account file. A new Import menu option has been added. After choosing the Import option, a new ...

• Feature - Customer CSV Import

  Release date: 9/25/2019 Version: 8.5 and up For the Customer CSV Import, select AR --> Utility --> Customer/eContact import --> customer/econtact Import --> Customer import This new screen program will have three menu options: Pre-Interface, ...

• Feature - New Item Import Through CSV File

  Program Original Release Date: 05/15/2007 Document Release Date: 08/21/2020 Version: 7.5 & Up The feature can be accessed in I/M, Utility, and New Item Import. It allows you to import new items from either an ASCII or CSV file. This document only ...

• Feature - Added CSV File Creation to Print Costed Bill of Material Report

  Release Date: 3/14/2019 Version: 8.2 and Up Added CSV file creation to Print Costed Bill of Material report. Go to BM --> Processing --> Print Costed Bill of Material If the CSV file output is desired, enter "Y for "Export to CSV File?" then enter a ...

• BM1601 Bill of Material Feature/Option Configuration Inquiry

  BM1601 Bill of Material Feature/Option Configuration Inquiry ← Bill of Material / Work Order Plus Feature/Option Configuration Inquiry Application Overview The Feature/Option Configuration Inquiry application provides an easy way to display various ...