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

• 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 ...

• 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, ...

• BM1501 Bill of Material Feature/Option Configuration Maintenance

  BM1501 Bill of Material Feature/Option Configuration Maintenance ← Bill of Material / Work Order Plus Feature/Option Configuration File Maintenance Application Overview The Feature/Option Configuration File Maintenance application enables the user to ...

• ARTYPMNT Accounts Receivable Customer Type File Maintenance

  Customer Type File Maintenance Application Overview The purpose of this program is to classify customers by type for pricing, commission, reporting and analysis purposes, and for sorting as needed. If you enabled COP shipping label in Global Setup -> ...

• 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 ...