4 Replies Latest reply on Sep 25, 2006 4:49 PM by Matt Wegner

    dtw 2005 sp01 document date

      when trying to import historical sales invoices the document date doesn't do anything it always uses todays date the format of the excel file is mm/dd/yyyy the format in business one is mm/dd/yyyy i am trying to import an invoices date 06/01/2006 and excel keeps changing it to 6/1/2006 so i tried to make it 11/15/2005 and it still dated the business one invoice today. oh i also set the current posting period to correspond to the date i am trying to import.