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 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): Product Category (Required)          
(Column B): Location (Required)                  
(Column C): Sales Acct No. (Required)            
(Column D): Cost Of Goods Sold Acct No. (Required)

Note: If Profit Center Usage in COP Setup is set to "O," only the main account number for the sales and cost of goods sold account should be provided.

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:

Product Cat Must Be Entered - The field cannot be blank in the CSV file.

Product Cat Size Exceeds Maximum Length of 3

Product Cat Not Found

Location No Must Be Entered

Location Size Exceeds Maximum Length of 2

Location Not Found

Record Already Exists, Cannot Be Added

Sales Account Not On File

COGS Account Not On File

Posting COGS Not Supported. Field Must Be Blank

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 with main accounts.

  Here is an example of the Interface Journal with full accounts.  

Programs Added: CP11IS, CP11IP

Programs Modified: CP1101

CLS

• Related Articles

• CP1101 Customer Order Processing Product Cat/Loc Acct File Maintenance

  Product Cat/Loc Acct File Maintenance Application Overview This application allows you to assign sales and cost of goods sold account numbers to product categories by location. In Customer Order Processing, sales account numbers and cost of goods ...

• BM0100 Bill of Material Product Structure File Maintenance

  BM0100 Bill of Material Product Structure File Maintenance ← Bill of Material / Work Order Plus Product Structure File Maintenance Application Overview This application enables the user to maintain the Product Structure File. Numbers of related ...

• ARACTMNT Accounts Receivable Account File Maintenance

  A/R Account File Maintenance Application Overview There are many places throughout the Accounts Receivable package where you will need to enter a General Ledger account number to designate where some transaction amount is to be recorded. To reduce ...

• IM1501 Inventory Management Product Category File Maintenance

  Product Category File Maintenance Application Overview The Product Category File Maintenance application maintains a convenient table of inventory item product categories, i.e. grouping similar items together. The category is used on reports, or on ...

• ARCUSMNT Accounts Receivable Customer File Maintenance

  Customer File Maintenance Application Overview The Customer File is a very important file. It stores the basic information about every customer you do business with. Almost every major application in the A/R package uses the Customer file to ensure ...