My.Notes


Release: 443; Jun 2015


Alterations

ModuleAlterations
Organize > Companies > Edit ContactsCustom Properties - Missing column CODE2 added to the UCPVALSContact table in cases where it was missing.
Purchases > RequisitionsAuthorized flag - Logic for the Authorized flag has been altered to display the correct status
Purchases > RequisitionsBudget authorised amount - Calculation altered to display the correct figure when altering a line's quantity or amount
Purchases > Authorise RequisitionAuthorisation list - This list is cleared before an user re-authorises a requisition (to prevent duplicates)
Purchases > Orders > Outstanding RequirementsAdd selected to PO - The Purchase Order is now saved as draft when converting from a requisition by selecting this button.
Purchases > Purchase OrdersBudget purchase order amount - Calculation altered to display the correct figure
Purchases > Order > Purchase OrderNominal for <TEXTITEM> - The item's nominal is set to the system's default purchase nominal account
Purchases > Goods and Services ReceivedReceiving 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 OrderPurchase Order Invoice -VAT calculates to match value being entered
Sales > Sales OrdersBudget 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 BrowseSales Order Pre Select Browse - Held for stock orders can no longer be opened. Prevents allocation of non-existent stock.
Sales > Counter Sales > Counter SalesIncidental Payment - 'missing methods' error message no longer appears when selecting an account while creating an incidental payment.
Sales > Invoice DirectNominal 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 CommissionCalculation altered - Staff Commission is calculated against the stock item's actual buy & sell prices rather than an estimated buy price
Sales > Statement RunBegin & 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 > BudgetsBudget calculations - Total Spend calculation altered to return Total Commitment + Total Invoiced
Nominal > BudgetsBudget breakdown details - Authorised Requisitions now return the requisition date & required date rather than the Sales Order date and despatch date.
Nominal > Browse Latest TransactionsDefault 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 NumbersDeleting 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 ReportsBudget 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 ReportsColumn headers - The descriptions on column headers have been altered to include the selected period and year end dates
Reporting > Standard Reports > Nominal > VAT > VAT ReportVAT Report by period - now works in the same way as by date - uses the end date of the selected period.
Open Door ReportsList 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 CompanyDatabase permissions - System can now always access the Master Database to check if any other processes were going on.
Stock Cost procedureStock 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.



Features

ModuleFunctionality
Purchases > RequisitionsFixed 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 > RequisitionsFixed Asset requisitions - The fixed asset category is passed through to the Purchase Order
Purchases > RequisitionsPurchase Order link - The PO number linked to the requisition is now stored against it
Purchases > RequisitionsTotal 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 > RequisitionsRequisition Date - A message box will notify the user that the requisition date cannot be altered after the initial save
Purchases > Goods and Services ReceivedGoods and Services Received -User can type the quantity into the received box as well as use the buttons and/or Batch facility
Purchases > Purchase CreditsPurchase Credits -Each Credit has the Credit note and Supplier account included in the description
Sales > Quotations and OrdersQuotations & Orders - Manual override switch to use the discount for a line entered rather than the discount associated to a customer/prospect
Sales > Sales OrdersSales 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 > JournalsJournal 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 > JournalsAuto 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 > BudgetsBudget 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 > BudgetsBudgets Lines - Drilldown facility on individual columns right through to the source of each entry.
Nominal > Ledger Maintenance > Company Data > Staff > Email SettingsReload 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 TransactionsAlter nominal description - Option to alter the description for one or all lines in a transaction
Nominal StructureMandatory 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 MaintenanceReserved 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 PricesException 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 ReportsNew 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 ReportsList Properties - Ability to set font colours of detail & totals
Open Door ReportsList Properties - Option to set the font of negative figures to a different colour
Open Door ReportsList Properties - Option to set an over line, underline or double underline on all total figures
Open Door ReportsList Properties - Option to align all total descriptions to the left, centre or right
Open Door ReportsList Properties - Option to set a custom description for the Grand Total
Open Door ReportsList Properties - Option to display column headers after column breaks
Open Door ReportsList Properties - Option to display Running Grand Totals
Open Door ReportsList Properties - Option to hide columns by unchecking the visible option on the Column Info screen
Open Door ReportsReport Layout - Ability to set colour and thickness of lines & boxes
Open Door ReportsList Properties - Report layout is automatically refreshed after closing the list properties screen
Open Door ReportsDash 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 2007Exporting documents to Excel 2007 - Open Door Reporter list formatting & fonts are exported to Excel - alignment, colours, over line, underline, double underline etc.
Tools > ImportNominal Groupings import - Import available for Nominal Groupings. Menu option ToolsImportNominalGroupings
Tools > Import > Stock HeadersField 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 ParameterAuto 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 linksWebsite 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 layoutMin, max and close - All Browse screen now have the min, max and close window buttons available
LogonDelete connection - Associated files in the Config directory are sent to the recycle bin when deleting a connection