Create the new Quote.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
Note: A common problem with saving excel spreadsheets as Txt files . It is that 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 Anchor
Note that if Re-save.
IMPORT RESULTS:
If you want to control the Work Centre by Cost Sheet enter , Enter the Work Centre on the Cost Sheet, and tick '"Default Parent Work Centre on Schedules' "
The Seq Sequence is a system generated number, incrementing by 10, to give each of the line lines the priority order.