sms_error_-_field_breakoutsub_not_found [Support]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.





==Error==



Table: Field 'BreakOutSub' not found.



===== Explanation =====



This error will appear if an update failed to add some extra fields to the Account Code Database table that are needed in later versions to allow users to break out Income by the base price, modifier price, install price, and discounts. 



{{::sms_-_error_table_field_breakoutsub_not_found.png?nolink&|}}



==Risk==



High - This will modify your data, if you are not trained on SQL and database manipulation you should not proceed. 



===== Resolution =====
  - Backup the current Data folder.
  - Add the following fields to the Account Code Database by running the sql provided below:
    * BreakOutSub Boolean
    * BaseText Char(50)
    * ModifierText Char(50)
    * DiscountText Char(50)
    * InstallText Char(50)
    * OmitFromExport Boolean
    * ModifiedByComputer Char(25)
    * ModifiedDate TimeStamp



<code sql>
ALTER TABLE "Account Code Database"
DROP ModifiedByComputer, DROP ModifiedDate
;
ALTER TABLE "Account Code Database"
ADD BreakOutSub Boolean
, ADD BaseText Char(50)
, ADD ModifierText Char(50)
, ADD DiscountText Char(50)
, ADD InstallText Char(50)
, ADD OmitFromExport Boolean
, ADD ModifiedByComputer Char(25)
, ADD ModifiedDate TimeStamp
;
UPDATE "Account Code Database"
SET BreakOutSub = FALSE, OmitFromExport = FALSE
;
CREATE INDEX ModifiedDateIndex ON "Account Code Database" (ModifiedDate)
;
</code>