The following table outlines which QuickBooks data items are converted to Sage 50 and which are not.
|
In QuickBooks |
In Sage 50 |
Comments |
|---|---|---|
|
Job Name |
Job ID |
Sage 50 will convert the first 20 characters of a job name and append a number to the ID to ensure unique IDs. |
|
Description |
Description |
Sage 50 will only convert the first 30 characters of a job description. |
|
Start Date |
Start Date |
|
|
Projected End |
Actual End Date |
If the End Date value is not present in QuickBooks, then Sage 50 will convert the QuickBooks Projected End to this field. Otherwise, the field will be blank. |
|
End Date |
Actual End Date |
|
|
Customer Name |
For Customer |
Sage 50 will convert the customer name associated with the job in the QuickBooks Customer:Jobs list as the customer ID. |
|
Note |
Comment |
Sage 50 will convert the first 2000 characters of a QuickBooks job note. |
|
Inactive |
Inactive |
|
|
Job Type |
Job Type |
Sage 50 will convert the first 8 characters of a QuickBooks job type. |
|
Custom Fields 1-15 |
Custom Fields 1-5 |
Sage 50 will convert the first five custom fields. |
|
N/A |
Supervisor % Complete PO Number Estimated Expense Estimated Revenue |
These fields are not available in QuickBooks or cannot be converted and must be updated in Sage 50. |