Reorder quantities start and ending period dates won't import? 1

[dbant2003]

I have created an import file in excel to import the reorder quantities for IC5.2A in MSSQL. The period startdate and period enddate won't import properly and the date that it shows is 06/01/1900. How to I enter the dates so that they import properly. The people running there PO's based on these quantities recieve zero vlaues even though there are values. I am assuming it is beacause the period start and end dates are incorrect. Thank you in advance

 

[jayconverse]

Did you convert between CSV and Excel? CSV uses a number like 20060601, but Excel should be a standard Excel date, like 6/1/06.

Jay Converse
IT Director
Systemlink, Inc.

 

[dbant2003]

No it wasn't converted between csv and excel.

 

[jayconverse]

I just looked at it, and reorder quantities don't use full dates, they only use Month/Day. Leave the year as 1900.

Jay Converse
IT Director
Systemlink, Inc.

 

[dbant2003]

Okay I did that but now I have other reorder records and it isn't picking the correct quantties now. For items that need reordering it is showing zero quantities.

 

[jayconverse]

I don't know what to say, I just tested again, and all my quantities are importing and changing as expected. Maybe you need to re-export a template and duplicate the format.

Jay Converse
IT Director
Systemlink, Inc.