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