Import the Schedule

Create the new Quote.
Go to the Cost Sheets tab.


Press 'Import Quote Lines'.



Browse to find the saved 'Txt' file
Press OK
This will automatically create the Cost Sheets from the imported file.
Where there are errors you will be given a message and the reason for the errors. Note that nothing will import until it can import the whole file.




In this case there was data missing in Line 23.
This is highlights a problem with saving excel spreadsheets as Txt files. It adds dummy rows at the end.
If this happens open the file in Notepad, delete the blank rows and resave.



In this case there are two blank rows



Import results.




Note that if you want to control the Work Centre by Cost Sheet enter the Work Centre on the Cost Sheet and tick 'Default Parent Work Centre on Schedules'


The Seq is a system generated number incrementing by 10 to give each of the line the priority order.