Module | Alterations |
Organize > Companies > Edit Contacts | Custom Properties - Missing column CODE2 added to the UCPVALSContact table in cases where it was missing. |
Purchases > Requisitions | Authorized flag - Logic for the Authorized flag has been altered to display the correct status |
Purchases > Requisitions | Budget authorised amount - Calculation altered to display the correct figure when altering a line's quantity or amount |
Purchases > Authorise Requisition | Authorisation list - This list is cleared before an user re-authorises a requisition (to prevent duplicates) |
Purchases > Orders > Outstanding Requirements | Add selected to PO - The Purchase Order is now saved as draft when converting from a requisition by selecting this button. |
Purchases > Purchase Orders | Budget purchase order amount - Calculation altered to display the correct figure |
Purchases > Order > Purchase Order | Nominal for <TEXTITEM> - The item's nominal is set to the system's default purchase nominal account |
Purchases > Goods and Services Received | Receiving Stock - No longer possible to un-receive items such that the total received items would be less than the invoiced amount. You must also enter a correct batch no for batch tracked items when un-receiving. |
Purchases > Purchase Invoice for Order | Purchase Order Invoice -VAT calculates to match value being entered |
Sales > Sales Orders | Budget amounts - Calculations altered to display the correct figures. Budget figures are also recalculated when altering the cost centre, department or quantity |
Sales > SO Pre Select Browse | Sales Order Pre Select Browse - Held for stock orders can no longer be opened. Prevents allocation of non-existent stock. |
Sales > Counter Sales > Counter Sales | Incidental Payment - 'missing methods' error message no longer appears when selecting an account while creating an incidental payment. |
Sales > Invoice Direct | Nominal for <TEXTITEM> - The item's nominal is only retrieved from the customer account if the system has been set up to do so (SaleNomFrom on the system parameters screen). The system's default sales nominal account is used otherwise |
Sales > Staff Commission | Calculation altered - Staff Commission is calculated against the stock item's actual buy & sell prices rather than an estimated buy price |
Sales > Statement Run | Begin & end transaction - Each statement generated inside the statement run is now done inside a begin & end transaction to prevent any table locks which could cause errors |
Nominal > Budgets | Budget calculations - Total Spend calculation altered to return Total Commitment + Total Invoiced |
Nominal > Budgets | Budget breakdown details - Authorised Requisitions now return the requisition date & required date rather than the Sales Order date and despatch date. |
Nominal > Browse Latest Transactions | Default skin - New default skin which orders transactions by item ref descending and lines are marked as read only (new skin) |
Stock > Ledger Maintenance > Categories > Bin Numbers | Deleting bin numbers - Foreign key added to bin numbers to prevent users from deleting a record if it has been set against an item on the Stock Reorder Levels screen. This caused an issue when receiving the goods. |
Reporting > Standard Reports > Nominal > P&L Reports | Budget comparison - Budget allocated amounts are now displayed with the correct signage. The 'Budgets up to & including this period' option will display the budget allocations for the selected period range if the 'Accounting Periods' option has also been selected. All budgets made up of nominal collections are excluded from this comparison |
Reporting > Standard Reports > Nominal > P&L Reports | Column headers - The descriptions on column headers have been altered to include the selected period and year end dates |
Reporting > Standard Reports > Nominal > VAT > VAT Report | VAT Report by period - now works in the same way as by date - uses the end date of the selected period. |
Open Door Reports | List column headers - Column header height extended to fit the description when it has been passed through a parameter. Calculation altered for the column header heights when the 'Headers After Breaks' option has been set . |
Tools > Copy Company > Create Copy Company | Database permissions - System can now always access the Master Database to check if any other processes were going on. |
Stock Cost procedure | Stock cost for wine systems - Wine systems which haven't been set up with a stock cost estimated type of FIFO now return the average cost of a particular stock type across all depots when the cost is zero for a particular type & depot. The old method used to calculate average price of all stock types combined across all depots for an item. |
Module | Functionality |
Purchases > Requisitions | Fixed Asset requisitions - A back to back Sales Order is now created for fixed asset requisitions. This allows users to leave the supplier field empty until they enter one on the Outstanding Requisitions screen. Fixed asset nominal groupings will also go through the same procedure, but the user must select a specific nominal on the requisition if a supplier has also been set before it can be sent for authorization. |
Purchases > Requisitions | Fixed Asset requisitions - The fixed asset category is passed through to the Purchase Order |
Purchases > Requisitions | Purchase Order link - The PO number linked to the requisition is now stored against it |
Purchases > Requisitions | Total Spend - Calculation altered to Total Commitment + Total Posted on the requisition. This also affects the budget check calculation as it's Total Spend + Current Requisition. (New skin) |
Purchases > Requisitions | Requisition Date - A message box will notify the user that the requisition date cannot be altered after the initial save |
Purchases > Goods and Services Received | Goods and Services Received -User can type the quantity into the received box as well as use the buttons and/or Batch facility |
Purchases > Purchase Credits | Purchase Credits -Each Credit has the Credit note and Supplier account included in the description |
Sales > Quotations and Orders | Quotations & Orders - Manual override switch to use the discount for a line entered rather than the discount associated to a customer/prospect |
Sales > Sales Orders | Sales Order Despatch And Invoice - Now possible to despatch and invoice from a sales order when no stock has been allocated (providing there is enough stock in the system). |
Nominal > Journals | Journal dates - Date of a posted Journal can be altered. This is achieved by automatically reversing the journal and then creating a new journal based on the date entered. |
Nominal > Journals | Auto Reverse - Reversal year and period can be set by the user whereas it used to post to either the next open period or next period (set by system parameter) |
Nominal > Budgets | Budget breakdown details - Budget totals are now calculated by summing up the details returned from the BudgetBreakdown procedure. BudgetBreakdown now returns details for draft, unauthorized and authorized requisitions, purchase orders and posted. Status, Year, Period, Nominal, TypeID and Username are also returned from the procedure. Budget Used reports have been altered to take these changes into effect (new reports). Also a new budget details skin. |
Nominal > Budgets | Budgets Lines - Drilldown facility on individual columns right through to the source of each entry. |
Nominal > Ledger Maintenance > Company Data > Staff > Email Settings | Reload email settings - System reloads an user's email settings after they've been altered on the staff member screen. User no longer has to log out & back in to use the new settings |
Nominal Transactions | Alter nominal description - Option to alter the description for one or all lines in a transaction |
Nominal Structure | Mandatory accounts - Default Disputed Items, Default Discount Allowed and Default Discount Received nominal accounts are no longer mandatory when creating a new trading company |
Stock > Ledger Maintenance > Stock Item Maintenance | Reserved stock codes - <TEXTITEM> and <<CHARGE>> are now marked as reserved codes. System prevents users from creating and saving stock items with these codes |
Stock > Exception Prices | Exception Prices - Prospects can have Exception Prices and these will also transfer over if the Prospect is converted to a Customer |
Reporting > Standard Reports > Nominal > P&L Reports | New formatted reports - They no longer contains the nominal section descriptions (Income & Expenditure) or the sub group total descriptions. Negative figures are displayed in brackets and in red font. Ability to add a Gross Profit running total to the report by entering a P&L Report Description on the Nominal > Ledger Maintenance > Nominal Ledger Heading screen (new skin). A new Nominal Heading called 'Direct Costs' will be created for new trading companies with 'Gross Profit' defaulted as its P&L Report Description. Parameter selection screen also has a new layout with updated descriptions and an option to display the figures with decimal places or rounded to whole numbers (new skin) |
Open Door Reports | List Properties - Ability to set font colours of detail & totals |
Open Door Reports | List Properties - Option to set the font of negative figures to a different colour |
Open Door Reports | List Properties - Option to set an over line, underline or double underline on all total figures |
Open Door Reports | List Properties - Option to align all total descriptions to the left, centre or right |
Open Door Reports | List Properties - Option to set a custom description for the Grand Total |
Open Door Reports | List Properties - Option to display column headers after column breaks |
Open Door Reports | List Properties - Option to display Running Grand Totals |
Open Door Reports | List Properties - Option to hide columns by unchecking the visible option on the Column Info screen |
Open Door Reports | Report Layout - Ability to set colour and thickness of lines & boxes |
Open Door Reports | List Properties - Report layout is automatically refreshed after closing the list properties screen |
Open Door Reports | Dash Gauge - The yellow colour coded values on the dash gauges are now displayed as orange as yellow was hard to read on a white background. A new 'Caption As Range Colour' property has also been added to the properties screen which will display values for all ranges in black if deselected. (New skin - nbfDashOptions) |
Open Door Reports > Export to Excel 2007 | Exporting documents to Excel 2007 - Open Door Reporter list formatting & fonts are exported to Excel - alignment, colours, over line, underline, double underline etc. |
Tools > Import | Nominal Groupings import - Import available for Nominal Groupings. Menu option ToolsImportNominalGroupings |
Tools > Import > Stock Headers | Field checks - Import file must either contain the ServiceItem or the StockTracked flags. File cannot contain both as they contradict each other. File cannot contain both BatchInSingles and SerialTracked flags either as they point to the same database field |
Tools > Our Companies > System Parameter | Auto Budget collections - New option to switch on Auto Budget collections. User can name the Income and Expense collections. They're automatically maintained when used |
Menu > Web links | Website support & updates notes links - Menu option HelpMynOnWeb now takes you directly to our software updates notes page on the web while HelpSupportOnWeb takes you to the LogMeIn123 page. These can be customized in the AppConfig folder (Website and SupportWebsite) |
Screen layout | Min, max and close - All Browse screen now have the min, max and close window buttons available |
Logon | Delete connection - Associated files in the Config directory are sent to the recycle bin when deleting a connection |