Jovie found out that the cause of the error in the uploading is SKU 4408623. The SKU has a comma on the style field, as you know our data in textile is delimited by comma, it is read by SQL as another column cause of returning an error as we only have 21 columns in the table, but this item has 22 columns

I suggest that we should use the old EOM for IAS since we already fixed the SKU with the comma. I did run the old exe and encountered an error, report to Jovie the error and we decided to increase the part per file to five as the error is with the connection of pulling large data.

I successfully generated the text file into five parts and upload the inventory to a temp table. I also uploaded the text files generated from April 1 to compare it with today's generated text file. To validate if there are movements into the inventory and also to decide which is one to use.

It seems we did have movement on the text files generated today compared to the text files generated from April 1 as this was to expect due to the long days we did the test and debugging. Still, I preferred the generated text files from April 1 to be used from the EOM just to maintain the data accuracy of our inventory data.


Compare the data to JDA for validation and to check the data integrity of the inventory.
Random checking per brand of onhand


This is now resolved.