Description |
*Value:* Save customer time
* Customer would like to import multiple journal enteries at one time
* Customer would like to be able to be able to control the import of "header level" data
*Tasks:*
* Add an optional header level to the import
* Remove the fiscal period and month (first two columns of the import)
We would like to add a line to the gl import that is the "Header" record. this header record will allow us to import data to the "GL Header"
I suggest that if the first line of the import file is "Header" then you would know that you are importing a header and every time you saw a new header you would create a new transaction
if there was no header you would proceed as normal.
This is a sample of the new CSV
Header,1/1/2015,USD,2/1/2015,Adjsuting Journal for december,Journal Entry
26000.00000000,AP ,3329 ,1,20111201,00:00:00,RH1 RONALD HILL ,12012011 ,RH1 ,C,149.500000,0.000000,N
62250.00009008,AP ,3329 ,2,20111201,00:00:00,RH1 RONALD HILL ,12012011 ,RH1 ,D,41.150000,0.000000,N
62800.00009008,AP ,3329 ,3,20111201,00:00:00,RH1 RONALD HILL ,12012011 ,RH1 ,D,108.350000,0.000000,N
!pastedImage_d38511_0.png!
|