This setting designates a specific option name to use in order to track lot premiums in Sage Timberline® Office Accounting.
The option name that is designated in the Lot Premium Mapping field will be designated as the lot premium and populate with the lot premium amount for the division. At the time the sales configuration received from the sales center is approved in WMS, the designated option name automatically sets up on the job in WMS. At the time the information is sent to Sage Timberline Office Accounting, the corresponding extra (option) automatically sets up on the job in Job Cost with the associated lot premium amount. This process allows the user to track the lot premium amount separately from the base house selling price.
At the time the sales configuration received from the sales center is approved in WMS, the base house selling price will include the lot premium amount by default. The lot premium amount will not be tracked separately in WMS or in Sage Timberline Office Accounting.
Go to Setup > Divisions > Sales Center Integration.
In the Lot Premium field, type the desired OPTION_NAME. In the database, WMS stores the 9-digit option code in the OPTION_NAME field, therefore you will type a number in the Lot Premium Mapping field.
In this example, the search is for 800000002 (Lot Premium). Or, if you do not know a number, you can search for the OPTION_DESCRIPTION of "lot premium," assuming it was named that by the Accounting department.
If the OPTION_NAME exists, the option code and name will appear next the field.
|
Note |
|
NOTE: If the option number does not exist, a warning will appear next to the Lot Premium field. If this happens, contact either BuilderMT Support Services or a BuilderMT Consultant. |
In WMS, go to Tools > SQL Pad.
In the left Database Tables pane, scroll down and open the SALESOPTIONS table.
Select the middle Data tab.
Click the column headerOPTION_NAME, which opens the Locate Field Value dialog.
In the topField Value field, type in the option's number from the database. Or, if you do not know a number, you can search for the OPTION_DESCRIPTION of "lot premium," assuming it was named that by the Accounting department.
In this example, the search is for the option number 800000002, which is the Lot Premium.
In the Locate Field Value dialog, select the Partial Match Anywhere option to widen the search parameters.
Click Next.
Confirm the correct options row is highlighted in the SQL Pad Data table.
Return to the Setup > Divisions > Sales Center Integration tab.
In theLot Premium field, type the numerical value of the OPTION_NAME field obtained from the SQL Data table.
In this example, "8000000002" is entered.
Press the validation button to the right.
If the exists, the option code and name will appear next to the field, such as "8000000002 - Lot Premium."
|
Note |
|
NOTE: If the option does not exist, a warning will appear next to the Lot Premium field. If this happens, contact either BuilderMT Support Services or a BuilderMT consultant. |
Division Sales Center Integration Settings