HDTN-269774 - Import Failing for Category GL Accounts from csv

Issue No: IC-10058
Created 2/4/2022 12:52:24 PM
Type Bug
Priority Critical
Status Closed
Resolution Fixed
Fixed Version 20.1
Description *This issue relates to i21 Help Desk ticket:* [ HDTN-269774 - Import Failing for Category GL Accounts from csv|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-269774]     *STEPS :*   {color:#000000}1. Go to System Manager > Utilities > Imports and Conversions.{color}   {color:#000000}2. From the screen side navigation, click Inventory button.{color}   {color:#000000}3. In Items Panel, click Import Category GL Accounts button.{color}   {color:#000000}4. Locate the file to be imported.{color}   {color:#000000}5. Click Import button.{color}   {color:#000000}6. Verify Import Logs.{color}     *ISSUES :*   I am getting an error when trying to import the Category GL Accounts from csv. "Error validating Account ID: ####-##-###. The data reader is incompatible with the specified iRely.Inventory.Model.vyuGLAccount Detail." (Full error screen is attached)   I have attached the Inventory Import csv as well.   I am getting this in LSM's 99 and TE environments. TE = [https://azhost1.irely.com/lsmcoTE/#/SM/OriginConversion?menuId=11&moduleMenuId=1]   I verified the GL Account ID's against the Chart of Accounts (see attached). I am using the Import format from Sys Manager>Inventory>Import Category GL Accounts csv. The only thing I could think of was that the GL Account ID was in the wrong format. I thought it wanted the full GL Account ID 17290-01-000 for example. I tried just using the primary code 17290 and that failed for "GL Account ID does not exist".   I am not sure this is an Inventory issue or GL issue, but thought I would start with Inventory.     *ACCEPTANCE :*   User should do Import Category GL Accounts successfully and correctly.