Computed cost/Assigned expense accounts removed via a table update. These glaccounts are deprecated and are no longer used.
GL Table has been renamed to Ledger and a SQL View named “GL” has been created to display the same information from the old GL table. This change will minimize the amount of report changes needed. Unless off balance sheet/computed costs are specifically needed, reports should use the GL View instead of the Ledger Table.
Added OffBalanceSheet Field to Ledger table. OffBalanceSheet serves as filter for View GL where OffBalanceSheet = 0
New OffBalanceSheet Field set retroactively to 1 in the Ledger table for computed cost entries.
Asset Account for parts set to use the Unclassified Inventory account as default account if the part tracks costs but does not have an asset/accrual account set.
DefaultAssetAccountID and DefaultAssetAccountClassTypeID Fields added to PricingElement Table. These fields used now by Part Categories instead of DefaultIncomeAccountID, DefaultIncomeClassTypeID
DefaultAssetAccoundID set for part categories being marked with income accounts instead of asset accounts.
Part Category Tab was added to replace the existing Part Category Frame. New screen acts more like the part and product tabs to simplify setup process. This will move relevant information to a tab instead of having to expand a collapsed section to see the information.
Part Category Accounting Tab was created, which consolidates and explains the accounting features as they relate to parts and part categories.
Created Part Category Tags Tab. This will consolidate the tag based information on the part category into one tab. This will be accessible on it's own tab without having other information to clutter or hide it.
Part/Sub-Categories Tab has been created. This tab was added in as the previous location of this data was on the “1st” tab of the previous implementation. Leaving this on its own tab saves load time, as the data doesn't load until a user wishes to see the Part/Sub Categories info.
Removed GL Account information from the costs tab of the part setup.
Removed GL Account information from the part tab of the part setup.
Advanced Tab in the Part Frame has added buttons and checkboxes for Accounting and Tag tags.
Part Info Adjustment screen has part accounting columns added. Having the additional accounting fields on the part info adjustment grid will allow users to see which accounts are tied to which parts. Additionally, the user will be able to see if the part uses the category defaults or if it is an overridden value.
Removed The Assigned Expenses frame.
Replaced the Part Category frame with a new tabbed frame to standardize setup frames with part and product frames. The data on the Part Category Frame is now contained on the new tabs.
Save process changed to set OffBalanceSheet field in Ledger table when using parts that do not accrue costs.
Save Process for parts now sets the asset account to the unclassified inventory account by default if the part tracks costs, but does not accrue costs.
Part Category Save procedure has been adjusted to default the unclassified Inventory account when the category is set to track costs but not set to accrue costs.
Updated the Order Analysis Report to use the Ledger table instead of the GL table.
Verified that the Chart of Accounts report and the GL Export reports are not including Off Balance Sheet entries.