Prior to v3.0
| Version | 2.14.8 |
|---|---|
| Release Date | 02/10/2019 |
| Other Application Requirements | |
| Warnings or Notices |
| Issue key | Summary | Issue Type | Affects Version | Component/s | Description | Linked Calls | Configuration Needed | Licensed Module |
|---|---|---|---|---|---|---|---|---|
| VC-1993 | BI Enquiry 309 - Stock Valuation (En Primeur Stock) | Bug | 2.14.6 | Report Template | Stock Valuation Report displaying the EnPrimeurStock value incorrectly when an EP order is credited to 0 total order quantity. | VSUP-11136 | No | No |
| VC-1992 | Insight - VAT Codes | Bug | 3.0.0 | Android app | Insight should ignore out any unused VAT codes. | VSUP-10832 | No | No |
| VC-1984 | PO - Receipting (for EP SO type R) | Bug | 2.14.7 | POP | An EP SO allocated as type R creates a transfer type PO, this cannot be receipted if only some of the EP SO lines were allocated. | VSUP-11151 | No | No |
| VC-1977 | Report - Product Extract Total Singles Available is incorrect | Bug | 2.14.6 | Report Template | The Total Singles Available is including stock on Sales Orders. | VSUP-11145, VSUP-11078 | No | No |
| VC-1976 | SO - Order lines picked over multiple rotations | Bug | 2.14.6.1 | SOP | When Orders have been picked over multiple rotations this can cause additional lines to be added to the sales order and not be allocated correctly. | VSUP-11044 | No | No |
| VC-1965 | EPSO - Underbond R order | Bug | 2.14.6.1 | POP, SOP | When trying to do an EP Sales Order and using Underbond Type R - Customer Paid Reserves movement type, the free circulation / customs duty paid flags are not being set correctly for the received goods. | No | No | |
| VC-1962 | Credit - returning stock to DP warehouse | Bug | 2.14.6 | Stock Management | When doing a return to a duty paid warehouse, you are able to land the stock with underbond status flags. This results in CCT being calculated for the subsequent outbound movements. | No | No | |
| VC-1960 | Stock Adjustment - Tick/untick duty paid | Bug | 2.14.6 | General | When we untick and re-tick the Duty paid check box, an error pops up relating to the rotation already existing (even though it doesn't already exist), it prevents the user from adjusting the stock. | VSUP-10908 | No | No |
| VC-1958 | Order processed report - Incorrect "bottles ordered" | Bug | 2.14.6 | Report Template | The "bottles ordered" column is showing the same quantity for all lines, not the actual quantity against the line. | VSUP-10875 | No | No |
| VC-1956 | BI Enquiry 5 0 6 - (Sales By Products) 9 litres cases column incorrect | Bug | 2.14.6.1 | BI | Within the report 5 0 6 the sales case amounts are incorrect. | VSUP-10842 | No | No |
| Version | 2.14.7 |
|---|---|
| Release Date | 29/08/2019 |
| Other Application Requirements | |
| Warnings or Notices |
| Issue key | Summary | Issue Type | Affects Version | Component/s | Description | Linked Calls | Configuration Needed | Licensed Module |
|---|---|---|---|---|---|---|---|---|
| VC-1913 | SO - Collection Orders Carrier | Issue | 2.14.6 | SOP | When sending a Collection Order to VW and a Carrier is selected, the user currently needs to remember to set the following fields to ensure a successful EDI submission: * Tick "Fixed Booked Date" * Set the "Collection Time" A new "Collection Date" field will be added to the SO screen, and the user will be forced to enter this (along with the collection time) when submitting the orders to the warehouse. | No | No | |
| VC-1912 | SO - Line Items | Issue | 2.14.6 | SOP | Corrections to the column colour & margin information bubble. | No | No | |
| VC-1961 | SO - Unable to open | Bug | 2.14.6 | SOP | Unable to open any sales order which has credit card information stored. | VSUP-10883 | No | No |
| VC-1920 | Document Management - Audit Log Duplication | Bug | 2.14.5.2 | Warehouse interface | When viewing the Audit Log within the Document Management screen, the Incoming Files grid is showing files which have been processed. The Log is indicating that they are being re-processed time every time the service is running. The files in question have already been archived. | VSUP-10620 | No | No |
| VC-1915 | Stock Adjustment - Duplicating stock quantity | Bug | 2.14.5.2 | Stock Management | Duplicating the stock quantity when adjusting stock for products which have multiple stock location for a single stock record. | VSUP-10611 | ||
| VC-1904 | Stock Adjustment - Error | Bug | 2.14.5.2 | Stock Management | Stock adjustment screen reports an error message when a user attempts to adjust the stock. | VSUP-10831, VSUP-10449, VC-1889 | No | No |
| VC-1891 | Invoicing - VAT for UB Transfer | Bug | 2.14.3 | SOP | VAT is being charged on Transfer Underbond Sales Orders, if the 'Excise Paid' option is unticked after entering any detail. | VSUP-10474 | No | No |
| Version | 2.14.6 |
|---|---|
| Release Date | 15/07/2019 |
| Other Application Requirements | |
| Warnings or Notices |
| Issue key | Summary | Issue Type | Affects Version | Component/s | Description | Linked Calls | Configuration Needed | Licensed Module |
|---|---|---|---|---|---|---|---|---|
| VC-1902 | BI Reports - Held orders | Report | 2.14.5 | BI | A new system BI Report showing orders currently held. | RFC-575 | No | No |
| VC-1886 | Stock report - Product Descriptions | Report | 2.14.5 | BI | Have been made consistent where possible. SS SPC Vintage -> Year Non English Description Have all been added. | RFC-572 | No | No |
| VC-1858 | Day sales report | Report | 2.14.5 | BI | Development of a new BI report designed to summarise the selected day's sales, by account manager, customer, product. | No | No | |
| VC-1873 | SO - Customer Price List Prices | Issue | 2.14.5 | General | Customer Price List prices are not always used on templates when the price list range from is 1 case or above. Users are able to use 0 or above, but only for new price lists, or when deleting an existing price list line and re-keying it. | VSUP-10349 | No | No |
| VC-1868 | SOP Entry - Detail - Prices | Issue | 2.14.5 | SOP | The SOP entry does not tell you which price list is being used. This is important for customers who offer selective discount on standard prices but not on other prices as they are unable to identify which lines need to be updated. A new entry on the detail line will be added to show "Standard" Product Price "List" Price List "P-List" Promotional List Prices "Cust" Customer Contract Pricing Whatever price is used it will show the price list it obtained the price from. | No | No | |
| VC-1856 | Warehouse Submission | Issue | 2.14.5 | API | Update the warehouse orders submission and ensure that the "processed by" field is sent. | No | No | |
| VC-1903 | Report designer - user view | Improvement | 2.14.5.2 | General | Creation of a view showing system users, to use by customers with a report designer license. | VC-1902 | No | No |
| VC-1878 | SO - lines | Improvement | 2.14.5 | SOP | Various small tweaks to make more space for product descriptions, show both description fields, corrections to the margin calculation and formatting changes to it and the margin %. | VSUP-10484 | No | No |
| VC-1892 | BI Sales Margin Reports | Design Change | 2.14.5 | BI | The margin reports have since 2014 excluded all EP movements which have no stock movements from all margin reports. The problem is this distorts the sales values as it includes the costs for EP but not the sales value. This exclusion is being removed in order to show those sales even although the stock have not shipped. | VSUP-10457 | No | No |
| VC-1911 | PO - receipting more than ordered | Bug | 2.14.5.2 | POP, Warehouse interface | When the same product and rotation is used within a purchase order, when the goods received file is then processed it is causing duplication's on the last same line to happen. | VSTASK-1879, VSUP-10567 | No | No |
| VC-1900 | EP Price List - Various | Bug | 2.14.5.2 | Maintenance | Various issues encountered during EP price list creation / modification. | VC-1894 | No | No |
| VC-1898 | Incoming Files - Stock snapshot file | Bug | 2.14.5.2 | Warehouse interface | Stock snapshot file are not processing automatically if they are set to a specific tie or real time. | VSUP-10535 | No | No |
| VC-1896 | Financial credit note - reason | Bug | 2.14.6 | General | Financial Credit Note shows Credit Reason but the Credit Reason was removed from the SO form 3 years ago, the reason will be removed from the invoice. | VSUP-10491 | No | No |
| VC-1895 | Report - General Sales 5 0 3 - incorrect sign | Bug | 2.14.6 | Report Template | Cases and Actual Cases columns for credits are showing as positive instead of negative. | VSUP-10493 | No | No |
| VC-1894 | EP SO - Allocation | Bug | 2.14.5.2 | SOP | When allocating an En Primeur Sales Order, an error is encountered when pressing the Commit button. | VSUP-10470 | No | No |
| VC-1885 | Deliver Orders - Delivery Charge rounding | Bug | 2.14.5.1 | Warehouse interface | Within the "Deliver Orders" screen, Order Details By Warehouse section the 'Delv Charge' shown is a rounded version of the value received from the warehouse. This rounded figure is then used when storing the movements and visible against the margin reports. | VSUP-10429 | No | No |
| VC-1882 | EP SOP - Duty & VAT Invoice | Bug | 2.14.5 | SOP | The duty & vat invoice raised from a part delivered EP invoice is incorrect. | No | No | |
| VC-1872 | SO - Template not showing zero stock Products | Bug | 2.14.6 | General | Products without stock or o/s PO are not showing on the SO Template. | VSUP-10349 | No | No |
| VC-1864 | BI Enquiry 5 0 6 (Sales By Products) - MonthCust/ProdTotalCases quantities | Bug | 2.12.8 | BI | Ignoring the start date and/or end date while generating report. | VSUP-10232 | No | No |
| VC-1863 | BI Enquiry 616 (Sales Rep Yearly Comparison) - timeout | Bug | 2.14.3 | BI | BI Enquiry 616 causing timeout error when running for complete month. | VSUP-10248 | No | No |
| VC-1861 | Stock Transfer - Rotations mandatory | Bug | 2.14.5 | SOP | When Stock transfer orders are being sent to Warehouses that do not require rotations, the POs generated are failing to save after receipt as the screen is saying the Rotation is a mandatory field, this cannot be amended on a Stock Transfer PO. | VSUP-10230 | No | No |
| VC-1859 | BI Report 305 - Total on Order and Total SOP | Bug | 2.13.6.4 | BI | The following issues are present: 1. Total on Order : Should show Outstanding Purchase order quantity only, but it includes completed orders too. 2. Total SOP - SOP quantity is incorrect, it includes cancelled orders. | VSUP-10262 | No | No |
| VC-1854 | Transfer Order - PO not creating supplier | Bug | 2.14.5 | SOP | When a transfer order is allocated for a warehouse/currency combination for the first time it creates a new supplier, however, this is reporting an error at the allocation stage which prevents the order from being allocated. | VSUP-10230 | No | No |
| VC-1837 | SO - BMC error when creating SO submission | Bug | 2.14.4 | SOP | When trying to allocate a large order with multiple lines a BMC error can be reported when creating the SO Submission data. | VSUP-10167 | No | No |
| VC-1828 | Stock Transfer - Purchase Order Error | Bug | 2.14.3 | SOP | Opening PO before Delivering SO causes an error. | No | No |
| Version | 2.14.5 |
|---|---|
| Release Date | 31/05/2019 |
| Other Application Requirements | |
| Warnings or Notices |
| Issue key | Summary | Issue Type | Affects Version | Component/s | Description | Linked Calls | Configuration Needed | Licensed Module |
|---|---|---|---|---|---|---|---|---|
| VC-1845 | Report designer - SO lines view | Issue | 2.14.4 | BI | The SO line BI view used by users to create their own reports is not returning enough lines. | No | No | |
| VC-1834 | Deliver orders - Warehouse group | Design Change | 2.14.3.1 | General | Add 'Warehouse Group' and a filter option for it too, allowing customers to quickly 'Deliver all' for all orders in a specific warehouse group. | VSUP-10048 | No | No |
| VC-1830 | Report layouts - Font | Issue | 2.14.3 | General | The invoice / delivery note acknowledgement layouts etc should all be using a consistent default font, and respecting the font specified by the user in the report manager screen. Some fields (the ones which support non-latin characters) are ignoring the report manager. | VC-1692, VEDI-723 | No | No |
| VC-1824 | Sales Order - Own reserves remove 'Min Price' check | Bug | 2.13.6.3 | SOP | When processing a Sales Order for release of Customer reserves to the owning customer, remove the Minimum Sales Value Check, as the sales value for the item should be zero. | VSUP-9998 | No | No |
| Version | 2.14.4 |
|---|---|
| Release Date | 17/05/2019 |
| Other Application Requirements | |
| Warnings or Notices |
| Issue key | Summary | Issue Type | Affects Version | Component/s | Description | Linked Calls | Configuration Needed | Licensed Module |
|---|---|---|---|---|---|---|---|---|
| VC-1833 | Daily Web Extract - Failing to generate | Bug | 2.14.3.1 | General | The automated daily web extract is failing to create the files. | VSUP-10096 | No | No |
| VC-1832 | Warehouse Service - Delivering multiple orders can delete pick records | Bug | 2.14.3.1 | SOP | There is a scenario where when an Order Picking Confirmation file is being processed and one or more orders encounters an error it can cause orders to have their pick details removed and the orders left at a state where they cannot be delivered nor unallocated. | VSUP-10079 | No | No |
| VC-1831 | Allocation - Lock | Bug | 2.14.3 | General | The allocation screen lock does not appear to be creating a lock when more than one user opens the screen. | No | No |
| Version | 2.14.3 |
|---|---|
| Release Date | 10/05/2019 |
| Other Application Requirements | |
| Warnings or Notices |
| Issue key | Summary | Issue Type | Affects Version | Component/s | Description | Linked Calls | Configuration Needed | Licensed Module |
|---|---|---|---|---|---|---|---|---|
| VC-1821 | Allocation - Commit | Bug | 2.14.2.1 | SOP | User sometimes received an error when committing a sales order if certain fields have more text than expected (such as consignee name, PO ref etc). | VSUP-9959 | No | No |
| VC-1814 | PO - Duplicate Rotations | Bug | 2.13.6.3 | POP | The system is allowing the user to receipt a PO with same rotation for different products. | VSUP-9986, VSUP-9848 | No | No |
| VC-1813 | PO - Stock transfer IBV value | Bug | 2.13.6.3 | SOP | When carrying out a stock transfer, the IBV value on the PO is not populated and the PO states that it's mandatory when attempting to invoice it, this validation was only intended initially for a transfer into a new reserve. | VSUP-9426 | No | No |
| VC-1810 | SO - UB Warehouse details | Bug | 2.14.3 | SOP | Underbond SO allowed to be saved without UBWarehouse information, which means the SO Submission does not contain all the info. | VSUP-9739 | No | No |
| VC-1802 | Sales Order - Delivered qty duplicating | Bug | 2.13.6 | SOP | Sales order delivered qty quadrupled when a SO is processed and sent to the warehouse twice. | VSUP-9986, VSUP-9710 | No | No |
| VC-1797 | Product - Dynamic Product Code Admin | Bug | 2.14.1 | General | Unable to add new Single Size codes and when adding a new Dynamic Product Code Structure, it removes the Singles Size that the user enters. | No | No | |
| VC-1795 | Purchase Order - VAT Code | Bug | 2.13.6 | POP | Under certain circumstances the VAT Code is not being set again the purchase order detail lines. | VSUP-9553 | No | No |
| VC-1792 | BI enquiries - timing out | Bug | 2.13.6 | BI | Some BI Enquiries are timing out: - 506 Sales By Product - 512 Products | No | No | |
| VC-1788 | Frozen Stock BI enquiry - Error | Bug | 2.14.1 | BI | When trying to run BI Enquiry - Frozen Stock the user receives an error. | No | No | |
| VC-1775 | Interfaces - Customer Price List not uploading | Bug | 2.14.1 | Maintenance | When trying to upload Customer Price List Excel files in the Interfaces window the file is not being picked up and is not uploading with no indication as to why it failed. | VSUP-9927, VSUP-9387 | No | No |
| VC-1819 | Maintenance - Customer contact statistics | Issue | 2.14.3 | General, Maintenance | The Customer Statistics order Lines - should be showing the Lines per order. | No | No | |
| VC-1796 | Maintenance - Customer Contact | Issue | 2.14.1 | Maintenance | When using filters, the statistics, contacts and notes information is not refreshing when selecting the customer. | No | No | |
| VC-1780 | PO - Submissions Resubmit | Issue | 2.14.1 | POP | Unable to resubmit a Pre-advice to the Warehouse. | No | No | |
| VC-1769 | PO - IBV Value | Issue | 2.14.1 | General | When we receipt the PO and change the IBVValue field to 0.00, after we reopen the PO its actually showing the old value not the new one which we saved. | No | No | |
| VC-1768 | Stock transfers - holding | Issue | 2.13.6.2 | General | Stock Transfers should not be able to be put on hold. | VSUP-9534 | No | No |
| Version | 2.14.2 |
|---|---|
| Release Date | 05/04/2019 |
| Other Application Requirements | |
| Warnings or Notices |
| Issue key | Summary | Issue Type | Affects Version | Component/s | Description | Linked Calls | Configuration Needed | Licensed Module |
|---|---|---|---|---|---|---|---|---|
| VC-1787 | Invoicing - Sage Payment (SR) | Issue | 2.14.1 | API, SOP | When processing an API Order including Payments - the payment is not getting posted over to Sage and is failing submission. | No | No |
| Version | 2.14.1 |
|---|---|
| Release Date | 28/03/2019 |
| Other Application Requirements | |
| Warnings or Notices |
| Issue key | Summary | Issue Type | Affects Version | Component/s | Description | Linked Calls | Configuration Needed | Licensed Module |
|---|---|---|---|---|---|---|---|---|
| VC-1692 | Non Latin Characters | New Feature | 2.13.5 | General | Vision Commerce will now support the entry of non latin characters in selected fields: Customer: Name Address fields Delivery Instructions Pick Instructions Contacts: FirstName Surname Product: Second description field Tasting notes SO: Name Address fields Delivery Instructions Picking Instructions These will also be supported in the API and web extracts. | VC-1646, VW-4182 | No | No |
| VC-1489 | API - Sales Person Area Lookup | New Feature | 2.12.0 | General | New Feature to allow the API and new customer generation to lookup a postal code table and associate the new account with a specific sales person upon creation. | RFC-415 | No | No |
| VC-1498 | Customer Contact Maintenance | Improvement | 2.12.8 | General | Complete rewrite of the Customer Contact Maintenance screen (Maintenance > Customer Contact), including the following improvements: - Improved search ("call back" date, birthdays, marketing group, account manager, etc) - Quick access to customer records - Easy access to useful customer account / order information - Visibility of customers & contacts and notes which can be stored and viewed against both - Customisable screen / grid layout to suit your needs | RFC-419 | No | No |
| VC-1601 | Supplier - AWRS URN | HMRC | 2.13.1 | Maintenance | Changes required in relation to Excise Notice 2002: Alcohol Wholesaler Registration Scheme, in particular: "...as an approved wholesaler, you’re required to keep:â€â€¦â€ name and URN of suppliersâ€. The AWRS URN will be added to supplier maintenance. | No | No | |
| VC-1545 | Stock Snapshot | Design Change | 2.12.8 | Stock Management | The current stock snapshot routine needs further tuning. The system when loading a new import file should take a snapshot of the current data in VC at the time of the warehouse snapshot being loaded. The report should then be produced with either the snapshot being used OR the live stock data. | VC-1690 | No | No |
| VC-1749 | Carrier Consignments - Insurance | Bug | 2.13.5 | SOP | Carrier consignment submissions are sometimes requesting extra insurance when turned off. | VSUP-9360 | No | No |
| VC-1748 | SO - VAT rate default | Bug | 2.13.6 | SOP | When the 'Excise Paid' Option is deselected the VAT Code is defaulting correctly but the Rate is not. | VSUP-9383 | No | No |
| VC-1746 | SO - Replicate | Bug | 2.13.6.1 | SOP | A replicate Sales Order appears to create the address on the new Order from the Account address and the original Orders address. | VSUP-9380 | No | No |
| VC-1735 | Product Maintenance - Order Available | Bug | 2.13.5 | Maintenance | The 'Order Available' figure within the 'Warehouse Stock Levels' grid is shown incorrectly. | VSUP-9278 | No | No |
| VC-1729 | Tasting notes - Text obscured | Bug | 2.13.5 | General | The Menu and the Ribbon bar overlap the top 4 lines of the Tasting notes hiding the notes and cursor from view until 5 or more lines have been added. | VSUP-9238 | No | No |
| VC-1725 | SO - Pre Invoice | Bug | 2.13.0 | General | If you Pre-invoice a Sales Order any undelivered lines update to Status C when they should stay at Status O. | VSUP-9023 | No | No |
| VC-1757 | Document Management - Audit Log Duplications | Bug | 2.13.6 | General | When viewing the Audit Log within the Document Management screen the entries are being duplicated when there are no files to process. Thus is creating duplicate Exception Reports. | VSUP-9414 | No | No |
| VC-1754 | EDI Goods Received file - not processing | Bug | 2.13.6 | Stock Management | When Goods Received files are being processed in EDI, VC is not being updated with these receipts. | VSUP-9342 | No | No |
| VC-1750 | Credit Notes - Costs Incorrect | Bug | 2.13.6 | SOP | When crediting part of an order line's quantity, the costs shown against it when viewing the Stock Movements are based on the whole line quantity. | VSUP-9418 | No | No |
| VC-1741 | PO - Warehouse / Group | Issue | 2.14.0 | POP | Entering the Warehouse Group and Warehouse after entering the Purchase Order Details is causing issues. | No | No | |
| VC-1733 | Purchase Order - Surcharge | Issue | 2.13.6 | POP | When entering a Surcharge on PO that the Price includes VAT, it is using the Value and adding VAT on top again | No | No | |
| VC-1715 | PO - VAT | Issue | 2.13.5 | POP | Changes as per: https://visionsoftware.atlassian.net/wiki/spaces/VC/pages/406913025/Purchasing+-+VAT+Determination From 'Goods arrive - RECEIPTING OF STOCK' section regarding warehouse / duty flag changes and updating the VAT code field against the PO lines. | VC-1662 | No | No |
| VC-1701 | Supplier - Contact | Issue | 2.13.6 | POP | The supplier contact is not currently a mandatory field but this is mandatory for PO submissions to the warehouse resulting in POs failing and needing manual correction. | No | No | |
| VC-1691 | EP Order - Type R | Issue | 2.13.5 | SOP | Currently EP orders are not allowed to select UB Type 'R', this needs to be allowed. | VC-1686 | No | No |
| VC-1731 | Stock Movement Posting Report - Date | Issue | 2.13.6 | Report Template | On the Stock Movement Postings Report, the date is getting cut off | No | No | |
| VC-1631 | Grids - sorting | Issue | 2.13.3 | General | Various grids have been noticed to not sort columns correctly, for example warehouse submissions > sales orders awaiting submission > "release date". | VSUP-8430 | No | No |
| Version | 2.13.6 |
|---|---|
| Release Date | 28/02/2019 |
| Other Application Requirements | Compatible with Sage 2017 (still backwards compatible with previous versions) |
| Warnings or Notices |
| Version | 2.13.6 |
|---|---|
| Release Date | 28/02/2019 |
| Other Application Requirements | Compatible with Sage 2017 (still backwards compatible with previous versions) |
| Warnings or Notices |
| Issue key | Summary | Issue Type | Affects | Component/s | Description | Linked Calls | Configuration Needed | Licensed Module |
|---|---|---|---|---|---|---|---|---|
| VC-1685 | EP - Duty and VAT to raise on release not despatch | Design Change | 2.13.5 | SOP | When you release an EP order you want the customer to pay the duty and VAT, they already bought the stock, this seems to wait until the delivery confirmation is done. The timing of the D&V invoice is now based on the allocation not the delivery.As the stock is owned, the duty is payable NO MATTER WHAT HAPPENS NEXT. | No | No | |
| VC-1684 | EP - EPPO link to EPSO not insisting a rotation | Design Change | 2.13.5 | POP | Modify EP stock allocation screen logic, when order is EP and that EPSO is linked to one or more EPPOs then the process should try to allocate to the rotation which is in the linked EPPO. Linked rotation should auto populate on allocation. If user tries to add the rotation manually in Deliver Order screen and a not linked rotation is entered then we should show a warning "If you modify the pre-filled rotation, your profitability information may be affected. Do you want to proceed?". And if user presses YES then we should allow to proceed with that. EPPO can have multiple receipts of stock and therefore may have multiple rotations hence should allocate to multiple lines. Also if warehouse in linked EPPO and selected warehouse in EPSO are different then the auto population should not work and a insufficient stock error message to shown shown. This change is not applicable when warehouse not using rotation. | No | No | |
| VC-1680 | Goods Received files - not processing correctly | Design Change | 2.13.5 | POP | Goods Received files are stuck in processing if line has already been receipted *+Duplicate Issue+* Currently if there is some error in the file it sits in the Processing tab to reprocess and when reprocessed duplicate lines are inserted which causes duplicate lines to show in the exception report. Report modified to only show the latest line with the error *+Line Status+* The Status is still showing as 'Awaiting' even after its reprocessed. related to the above issue. *+Delete lines+* Errors like 'Purchase order line already receipted' occurs then that particular line will not be able to process hence should have the option to remove the line from the line before reprocessing. Currently not possible as we allow only selected POs (from Header grid) to be removed not lines. So we will extend the delete feature to also allow selected lines from a PO to be deleted, the 'Delete' button at the bottom should allow selected items from 'Header' and 'Detail' grids. Also make following changes to make the feature more clear. # Rename the button to 'Delete Selected' # Change the button validation error 'Please highlight the line you wish to delete.' to 'Please highlight the PO or PO line to delete.' # Currently when Delete button is pressed it deletes the selected PO without any warning and there is no option to revert if it was a mistake so before we remove a confirmation message as 'The selected records will be deleted from file. Do you want to proceed?' with YES or NO to be shown to the user. *+OK button+* OK button was originally designed to exclude orders temporarily (not remove) from processing. This will not work for the above scenario as its for the entire order only. Its not very clear from the screen what this does so make following changes to make it more clear. # Move 'OK' button functionality to 'Close' button functionality (remove OK button) and ensure that even if the user clicks the top right red cross to close the screen that it follows the same process. # If the user closes the screen after unselecting a record show them a warning style message "Some records have been unselected, these will not be processed if you continue. Do you want to continue?" yes / no. # Ensure that when processing in the main screen, it does not process any records which were 'unselected' in the 'View' screen. | VSUP-8948 | No | No |
| VC-1674 | EP - Stock receipt issue | Design Change | 2.13.3 | POP | This change is applicable to normal PO too not just to EPPO. The PO Warehouse Group and Warehouse will remain as the default. However should you wish to adjust this then the Receipting grid "warehouse" should list all warehouses appropriate for the type of stock, should the user wish to change it. The key things are * Reserve Warehouse * Underbond Warehouse If it is changed from the default it should show a warning box, allowing the change but showing Please confirm the warehouse change from : ABC Underbond - Yes Reserve - Yes to DEF Underbond - No Reserve - No CONFIRM or CANCEL | No | No | |
| VC-1670 | Stock customs duty flag issue | Issue | 2.13.3 | SOP | Changes to be made to the PO receipt logic of 'Stock Transfer (Sale)' PO (generated from Type R sales orders). Make sure the destination stock flags are same as of the source stock. | No | No | |
| VC-1668 | Reserve Trading - Stock availability view issue | Design Change | 2.13.3 | SOP | Changes to be made in the sales order product search. Search should only return the products under the selected warehouse and also with stock available. When selected warehouse is a Reserve warehouse then product search should only return products belongs to the selected customer. | No | No | |
| VC-1664 | Sales order issues | Issue | 2.13.3 | SOP | Product cost is being calculated wrongly in margin calculation, per unit cost to be used for this. | No | No | |
| VC-1660 | Stock Adjust - New Rotation message | Issue | 2.13.4 | Stock Management | When performing a Stock Adjust using a new rotation, the "new rotation informational" message appears repeatedly. | No | No | |
| VC-1565 | Sage 50c v25 integration | Improvement | 2.13.0 | General | Integration of the latest Sage Line 50 components. | No | No | |
| VC-1665 | IBV value amending | Design Change | 2.13.3 | SOP | It allows me to sell it to the customer in reserve at £0.00 however for D&V purposes we need a value when it is received into stock to be able to base the D&V on. This is actually not possible on the receipt as there is no field and the only field showing is the purchase value which is 0.00 there is no place to enter the value in the field used for D&V calculation Changes required in Purchase Order -> Receipting grid to add a new column 'IBV Value' as the last column This field will be available for all types of purchase orders and by default this will be filled with purchase value of the stock but not mandatory to fill in (zero will be acceptable). However for 'Stock Transfer (Sale)' purchase orders (came from Type R orders) this field will be mandatory (zero not acceptable) and it will be filled with the price it was sold to the customer (get from Type R SO). In all cases user can edit the value populated to this field. | No | No | |
| VC-1736 | Reports objects update | Change | 2.13.6 | Report Template | Update to the Crystal report references to version 13.0.3500.0. | No | No | |
| VC-1722 | Purchase Orders: Duplicate Rotations | Bug | 2.13.4 | POP | When receipting the same product and same rotation at the same time, duplicate rotations are created. | VSUP-8993 | No | No |
| VC-1721 | Sales Order - Orders stuck in Deliver orders | Bug | 2.13.5 | SOP | Sales order stuck in delivery order screen, when order pick stock from multiple rotations | VSUP-9017 | No | No |
| VC-1718 | Vision Product Stock Enquiry: Order Available Figure | Bug | 2.13.5 | Stock Management | When a Rotation's available stock goes into a minus, the Order Available figure is incorrect within the Product Details section of the form. | VSUP-8805 | No | No |
| VC-1714 | Product Maintenance - Is Retail Product | Bug | 2.13.5 | Maintenance | On the first attempt to untick or tick the Is Retail Product it is reverting back after clicking on Save | VSUP-8989 | No | No |
| VC-1713 | Sales Order: Error message | Bug | 2.13.5 | SOP | Creating an order using a BOM Product and Product that exist in the BOM Product throws an error message | No | No | |
| VC-1698 | Purchase Order: Not showing Rotation when adding to existing one. | Bug | 2.13.4 | POP | When receipting a Purchase Order and using an existing Rotation No, the Rotation No is not being shown on the Purchase Order Receipting Tab. | VSUP-8990/8865 | No | No |
| VC-1690 | Report - Stock Exception Reports | Bug | 2.13.5 | Stock Management | Stock Exception Report showing 0 physical stock when stocks are available in both VC and VW , which has created a variance for every product | VSUP-8756 | No | No |
| VC-1689 | Product Maintenance: Qty column | Bug | 2.13.4 | Maintenance | If you un-check the Show Outstanding Only field on the Sales Order tab the Qty column hides itself until you check the field again. | VSUP-8776 | No | No |
| VC-1675 | BI Enquires - Detail Margin By Product Type | Bug | 2.13.2 | BI | Detail Margin By Product Type returning negative value in Actual Cases column The Actual Cases column on the Detail Margin By Product Type report is being displayed as being a negative value when it should always be a positive value. Also reports listed below will also be resolved with this fix : - 503 General Sales Report - 605 Detail Margin by Product Type - 606 Sales Margin - 607 Sales Margin Exclusions | VSUP-8683 | No | No |
| Version | 2.13.5 |
|---|---|
| Release Date | 28/12/2018 |
| Other Application Requirements | Compatible with Sage 2017 (still backwards compatible with previous versions) |
| Warnings or Notices | To avoid conflicts with any closed accounting periods, certain data corrections (such as those relating to costs, accruals, margins etc) relating to bugs in this version are not being done automatically with the upgrade and will need to be requested if you wish for these to be done. |
| Issue key | Summary | Issue Type | Affects Version/s | Component/s | Description | Linked to | Config needed | Licensed |
|---|---|---|---|---|---|---|---|---|
| VC-1673 | Sales Orders: Type T transfer order Document Ref is blank when no CustomerPORef entered | Bug | 2.13.3, 2.13.4 | SOP | When keying a Sales Order of Type T (Transfer of stock) if a Customer PO Ref is not entered submission file is rejected by the warehouse. | No | No | |
| VC-1672 | Navigation - Product search | Bug | 2.13.3 | General | Product search from navigation was taking a long time | VSUP-8423 | No | No |
| VC-1653 | Allocation - INV Only | Issue | 2.13.3 | SOP | When using the Invoice only on the Allocation screen, the movements are not showing in the Stock Movement Enquiry screen. | VCC-624, VC-1346, VC-1651 | No | No |
| VC-1607 | Warehouse service - Report conversion | Issue | General | On some systems, the service stops when a file is received from the warehouse for processing. This relates to the VC reports / PDFs generated after processing the inbound file, these have been converted to another newer format to solve the issue. | No | No |
| Version | 2.13.4 |
|---|---|
| Release Date | 14/12/2018 |
| Other Application Requirements | Compatible with Sage 2017 (still backwards compatible with previous versions) |
| Warnings or Notices | To avoid conflicts with any closed accounting periods, certain data corrections (such as those relating to costs, accruals, margins etc) relating to bugs in this version are not being done automatically with the upgrade and will need to be requested if you wish for these to be done. |
| Issue key | Summary | Issue Type | Affects Version/s | Component/s | Description | Linked to | Config needed | Licensed |
|---|---|---|---|---|---|---|---|---|
| VC-1659 | Stock Movements: Not reducing stock by correct amount in certain circumstances | Bug | 2.13.0, 2.13.4 | Stock Management | If multiple orders are keyed for the same stock from the same rotation and are delivered from the same Order Picking Confirmation file at the exact same time the stock quantity is not being downdated correctly, resulting in the stock figures not balancing with the stock movements. | VSUP-8585 | No | No |
| VC-1658 | Goods Received | Report | 2.13.3 | BI | Goods Received Report 403 added | No | No | |
| VC-1657 | Sales Order: Outgoing Sales Order files are missing Collection information | Bug | 2.13.3 | SOP | The Sales Order File does not included the Collection information for the Warehouse. | VSUP-8614 | No | No |
| VC-1654 | Stock Reports | Report | 2.13.0 | BI | New Reports added 318 - Underbond Stock Listing 319 - Duty Paid Stock listing The above are due to customers entering UB rotation but marking stock as DP and vv. 320 - Customer Reserves IBV Value check for D&V Invoices This will show stock invoices being wrong for D&V invoices. | No | No | |
| VC-1652 | Stock transfer - Movements are duplicating | Bug | 2.13.2 | SOP | Stock movements are duplicating against a transfer order when manually receipting in specific circumstances. | VSUP-8517 | No | No |
| VC-1649 | Stock Adjust: Positive Adjust on to a new Rotation are giving an error. | Bug | 2.13.3 | Stock Management | You get an insufficient stock to make adjustment error when trying to Adjust Stock on to a new Rotation against a Product that already has Rotations. | No | No | |
| VC-1636 | Stock Allocation - Invoice Only Option | Bug | 2.13.2 | SOP | When the 'Inv Only' option is selected when allocating an Order, the Invoice is not appearing in Pending Invoices. | VC-1653, VSUP-8459 | No | No |
| VC-1635 | Purchase Orders: Delivery Address taking incorrect line for "Town" from Warehouse | Bug | 2.13.2, 2.13.3 | POP | The 3rd address field from the top in Warehouse Maintenance screen is coming through as the Town field on the Purchase Delivery Address. | VSUP-8462 | No | No |
| VC-1634 | Purchase Order - Partial receipting return wrong status | Bug | 2.13.2, 2.13.3 | POP | Status not correctly updating to order lines, when a Purchase Order create from VC and partially receipt from VW | VSUP-8343 | No | No |
| VC-1633 | Warehouse receipt - Rotation number | Bug | 2.13.2, 2.13.3 | POP | Rotation number not set correctly for the PO when receipted from the warehouse. | VSUP-8343 | No | No |
| VC-1591 | BI Enquiries: Report to show what Mixed Cases a product is in | Report | 2.13.0 | BI | Customers require a report or BI enquiry that show a wine and the mixed cases which include that product and the quantity, to exclude delisted. | RFC-487 | No | No |
| VC-1590 | BI Enquiry - Date filter | Report | 2.13.1 | BI | BI enquiry 621 GRP price in version 2.13.1 requires a date filter so that customers can run this report for various date ranges. | RFC-490 | No | No |
| Version | 2.13.3 |
|---|---|
| Release Date | 03/12/2018 |
| Other Application Requirements | Now compatible with Sage 2017 (still backwards compatible with previous versions) |
| Warnings or Notices | New Functionality has been released in line with EDI availability. See Vc-188 - speak to your warehouse for a secuity token to use this. |
| Issue key | Summary | Issue Type | Affects Version/s | Component/s | Description | Linked to | Config Needed | Licensed |
|---|---|---|---|---|---|---|---|---|
| VC-188 | Link to Vision Distribution - via API | New Feature | 3.0.0 | General | Your warehouse has to be on version 3.2.0 of Vision EDI for this functionality. You will require a token to be issued by the warehouse which is the security token to allow you access to the data. 1) VC system can now request delivery information directly from VDIst for a particular delivery. It will return the following information : order Status, booked date, load status, load date, confirmed departed at, confirmed delivered at, confirmed by, ePOD (YN), Scanned (YN), ETAFrom, ETATO, RevisedETAFrom, RevisedETATo, ActualTimeofDelivery. On the SO screen a new button will be added which will be able to retrieve information from Vision Distribution which tells the customer the status of the delivery. All communications between your system and the warehouse are fully encrypted. 2) VC system can request an ePOD or Scanned image for a delivery. This will initiate the request to be sent by email. As these requests are queued it can take up to 30 minutes for a request to return to you by email. If nothing is found you will still be told nothing is availale. When the reply is received it should goto the user making the request. An upload ability in VC for the Sales order has been added which then takes the image and places it into a store directory on the customers system under the SO UID number and then makes the image available on VC with the ability to be able to forward it to the customer at a future date. | No | No | |
| VC-1543 | Allocation - Carrier field defaulting | Issue | 2.12.8 | SOP | If an order doesn't have a carrier, which is added in the allocation screen, the order is not updated with the carrier defaults (such as service code), resulting in the users having to enter them manually in the 'Consignment Setup' screen. | VSUP-7381 | No | No |
| VC-1535 | Sales Order - Credit Note - Warehouse to Collect | Issue | 2.13.0 | SOP | When doing a Credit Note where the Warehouse is to collect, when saving the credit note it is removing the collection option from the order. | No | No | |
| VC-1525 | Stock -> Freeze Stock - Issue with EPSOs | Issue | 2.13.0 | General | When trying to freeze stock on a certain rotation, stock which has the same product code (but 'blank' rotation) and is on an EPSO is affecting the 'Available to Freeze' quantities | No | No | |
| VC-1517 | Deliver Orders screen - error when using 'Deliver All' option | Issue | 2.13.0 | General | Error message displayed when using the 'Deliver All' button - users can click 'OK' and re-try to deliver (which will be successful). | VSUP-7522 | No | No |
| VC-1514 | Stock can be landed on 2 different EPPOs under same Rotation. | Issue | 2.10.0 | General | Should the warehouse decide to land stock received which was ordered under two difference EPPO this was previously allowed with no reference to the possible issues The stock should be landed under seperate rotations. In the event this is not done then a warning will now be displayed, this will state that it is ONLY increasing the quantity on stock, the original stock record and its VALUES will remain unchanged. In order to not effect values you should either land on seperate or ensure that both PO's are buying the stock at the same price. | VSUP-6422 | No | No |
| VC-1512 | API Order Entry -> Fee Charging Defaults | Issue | 2.13.0 | General | If any fee settings are absent, the orders will fail. This issue is to ensure that where any fee settings are missing, the users will get a message informing them of this so that they can set it up. | No | No | |
| VC-1491 | Stock Snapshot Schedule Details radio buttons are in a different order. | Issue | 2.10.0 | General | On the Document Management screen the radio buttons in the Stock Snapshot Schedule Details section the Real Time and Manual radio buttons are the opposite way round to the Goods Received and Order Pick section radio buttons. | No | No | |
| VC-1570 | Bi Enquiries Names | Change | 2.13.1 | General | Names for the BI Enquiries have all been standardised | No | No | |
| VC-1526 | SO details VAT Code missing issue | Change | 2.12.8 | General | As a protection from old data, Sales Orders are checked to ensure the VAT code is applied otherwise you will receive a warning message. | VC-1521 | No | No |
| VC-1651 | Stock Sales Order as Excise Paid using Underbond Stock but it has not generated a Duty and VAT invoice. | Bug | 2.13.2 | General | Stock Sales Order from a customer reserve sending underbond stock on an Excise Paid order. This was not generating a duty and VAT invoice. | No | No | |
| VC-1630 | Sales Order: EP Orders are not showing for Submission once Allocated. | Bug | 2.13.2 | SOP | EP Orders should show for Submission to warehouse once they are allocated but are not. | VSUP-8430 | No | No |
| VC-1628 | Detail Margin - Surcharges | Bug | 2.13.2 | General | When viewing the 'Detail Margin' BI enquiry, the surcharges are showing a minus "sales value", where they should be a positive. | VSUP-8332 | No | No |
| VC-1626 | Despatch Movement - Product Cost per unit calculating incorrectly | Bug | 2.13.2 | SOP | This only effects customer who upgraded to v2.13.x Stock Movements are being calculated incorrectly for new transactions where the rotation was received before the upgrade. The Product Cost Per Unit on stock movements is being calculated incorrectly, resulting in a lower Product cost showing against the movement line. The cause has been identified and this was an accidental change on new receipts being recorded at full line value instead of per case value. A script for those effected is available and will be run with this upgrade to correct the figures | VSUP-8272 | No | No |
| VC-1616 | Stock Adjust: Unable to perform negative stock adjustment when Warehouse not set to use Rotations | Bug | 2.13.2 | Maintenance | If you add a negative stock adjustment when a warehouse does not use rotations An error is displayed on the screen. | VSUP-8429/8179 | No | No |
| VC-1612 | Credit: Credit notes are not showing in Pending Invoices. | Bug | 2.13.1 | SOP | After Processing a Credit Note this is not appearing within the SOP Documents form - Pending Invoices Tab. | VSUP-8093 | No | No |
| VC-1610 | ExCellar Orders not appearing in Pending Invoices | Bug | 2.13.1 | SOP | We have an issue with EX CELLER orders not appearing in pending invoice since switching to 2.13.x On investigating its found that the allocation and despatch of the Excellar orders are still happening but there is some issue with the despatch process which causes to not add entries to Delivery Despatch Detail table. | No | No | |
| VC-1602 | Warehouse submission - failing for orders with parcel carriers | Bug | 2.13.1 | General | When VC submits a SO to the warehouse, EDI is generating an error "Invalid collection delivery area" due to the carrier code being submitted instead of using the list of recognised warehouse collection delivery areas. | VSUP-7891 | No | No |
| VC-1588 | Sales Order - VAT error when editing | Bug | 2.12.8 | SOP | The Sales Order shows 0.00 VAT after changing from one Mixed Product to another (which means the Commerce Totals are incorrect). | VC-1027/VSUP-7827 | No | No |
| VC-1563 | Documents - 18 character product codes | Bug | 2.13.0 | POP | When using full length LWin Product Codes, the Sales Order Acknowledgement wraps the code (and leaves enough space but the PO Acknowledgement doesn't. | VSUP-7508 | No | No |
| VC-1561 | Product Maintenance : Component Prices are being set to 0 on Saving of Product | Bug | 2.12.8 | Maintenance | If you do not switch tabs before saving you will be presented with an error when de-listing a product. | VSUP-7518/7497 | No | No |
| VC-1559 | Replicate SO - Units/Singles | Bug | 2.13.1 | SOP | When replicating an order that will show that the stock is insufficient. From the Order Lines, it removes the Units and Singles. | VC-1537 | No | No |
| VC-1553 | Search for Product with Components returns all records | Bug | 2.12.8 | General | When an exact Product Code is entered to search on all Products are returned | VSUP-7348 | No | No |
| VC-1552 | Product with Components - Sales Analysis Units are incorrect | Bug | 2.12.8 | General | When Viewing the Sales Analysis the Units are being multiplied by 7. | VSUP-7362 | No | No |
| VC-1551 | Carrier -> Erroring when screen loading | Bug | 2.14.0 | General | There needs to be at least one carrier in the table | No | No | |
| VC-1540 | PO Supplier invoice : Amend Inv Units / Unit Prices | Bug | 2.12.8 | POP | When processing a suppliers invoice, the 'Inv Units' and 'Unit Price' fields are being disabled when the Save button is pressed, so these values can not be amended if the P.O.P VAT Analysis screen is closed. | VSUP-7023 | No | No |
| VC-1533 | Customer Maintenance - Default Carrier for API orders | Bug | 2.12.8 | API | If the customer has a default carrier set up this is not being applied when it comes to the allocation screen. | VSUP-6643 | No | No |
| VC-1529 | Order - Unable to save changes | Bug | 2.13.0 | General | Refers to older orders which have not been processed yet Failed to Save Sales order -> Syntax error: Missing operand after '=' operator. Error when making changes to some older orders, usually when trying to cancel them or taking off hold. | VSUP-7184/VCC-510/445 | No | No |
| Version | 2.13.2 |
|---|---|
| Release Date | 20/09/2018 |
| Other Application Requirements | Now compatible with Sage 2016 (still backwards compatible with previous versions) |
| Warnings or Notices | Please review VC-1541 carefully as this is a key change to the Transfers process VC-1540 should be reviewed this has changed several forms and implications to the values stored for each stock movement. |
| UID | Summary | Issue Type | Affects Version/s | Description | Support Links | Config Changes | License Required |
|---|---|---|---|---|---|---|---|
| VC-1562 | Report 622 - Product Gp Sales - using the Reporting Dates | Report | 2.13.0 | New Report has been added 622 Retail Sales Profit [S][E] (Grp Sales Price) Renamed existing report 621 to say 621 Retail Sales Profit ALL (Grp Sales Price) 621 will report all sales forever 622 will us the report dates based on the order date. | No | No | |
| VC-1549 | BI Report 621 | Report | 2.12.8 | The report was looking where cases > 1 this has been modified to >=1 Also added the delisted field. | No | No | |
| VC-1582 | Transfer Orders Type R | Issue | 2.13.1 | Errors when trying to open the Purchase order from a Stock Sale Order Type R once receipted by the Warehouse | VC-1541/VC-1450 | No | No |
| VC-1541 | Transfer Order Changes | Enhancement | 2.12.8 | Introduction of new Purchase order types as below. # Stock Transfer (Sale) (TS - For 'Type R' orders) # Stock Transfer Internal (TN - For 'Stock Transfer' orders) For internal transfer and Type R orders, currently PO is created when the SO is saved this will be moved to the allocation screen, so creation will be based on what is allocated allowing back order or part shipments to be better controlled. Also now each partial allocation will create a separate PO, it means now there can be multiple POs against one SO, the Open PO in the SO screen will allow links to all linked PO's In addition to the above we will also need to change the scope/flow of PO data modification for the internal transfer and type R order POs as mentioned in the workflow document Automated warehouse processing has now been updated to reflect and handle these changes automatically for all stock movements which is was not doing in the past | VC-1450 | No | No |
| VC-1534 | Stock Movement Enquiry with BOM Prods | Issue | 2.13.0 | When a Sales Order with the same Product Code in two different BOM Products it is not showing correctly on the Stock Movement Enquiry Screen. | No | No | |
| VC-1450 | Detail Costings | Enhancement | 2.12.7 | Various changes are required to costs recorded against movements so that they make more sense, this includes: Existing Data There are scripts to update existing data, these will only be run if the customer requests historical information to be amended. Existing stock records will be updated to reflect the values should be for the receipted stocks, this will then allow future movements from stock to use the new calculations and be consistend. Important Reading Link to the stock movements posting routine details for detail costings | VSUP-7577/ VC-1418 | No | No |
| VC-1557 | Purchase Freight Invoice | Change | 2.13.1 | On the Purchase Freight Invoice Screen - unable to use the F11. | No | No | |
| VC-1554 | Allocation - BOM Product | Change | 2.13.1 | Unable to allocate order with BOM products | No | No | |
| VC-1544 | Sales Order - After Allocating | Change | 2.13.1 | After allocating the Sales Order - It is showing Deliver Orders as not been allocated and also not showing in Submission screen. | No | No | |
| VC-1567 | Price Maintenance: BMC error when searching | Bug | 2.13.0 | Certain customers are having issues with the Price Maintenance where it is taking a long time to load the screen which is resulting in a BMC error that most likely relates to a timeout. | VSUP-7531 | No | No |
| VC-1566 | Report: General Sales Report is repeating analysis codes | Bug | 2.13.0 | Instead of displaying the Customer and Product Analysis information correctly, the General Sales Report (5 0 3) is showing the same two values across many columns. | VSUP-7386 | No | No |
| VC-1556 | Sales Order: Price not recalculating when Deferring Duty | Bug | 2.13.0 | When amending the duty deferment on a sales order the line price is not being recalculated to remove the duty element. | VSUP-7423 | No | No |
| VC-1539 | Allocation Screen: Item weight being calculated incorrectly | Bug | 2.12.8 | The Stock Allocation screen is calculating the weight on the assumption that only full cases are being ordered. If order is keyed as less than 1 case per product the weight is being calculated wrong. | VSUP-6937 | No | No |
| VC-1537 | Sales Order: When Replicating the order insufficient stock icon is not being displayed correctly. | Bug | 2.12.8 | When replicating a Sales Order if the new order has insufficient stock (red circle with exclamation mark) warnings for the first order line, subsequent lines which do not have sufficient stock do not show this symbol against them. | VSUP-6766 | No | No |
| VC-1528 | Carrier - Send stock value for insurance | Bug | 2.13.0 | Stock value wasn't being submitted even though the send stock value option was ticked. | No | No | |
| VC-1520 | Sage postings - 2 receipts messages created for one SO | Bug | 2.12.8 | This related to postings into Sage for Payments made on the web site. It was causing multiple receipts to be sent over to sage for one sales invoice because it was not checking whether it had already posted the payment information | VSUP-6431 | No | No |
| VC-1478 | Invoicing: Time Out when trying to run Reserve Invoicing for some dates. | Bug | 2.11.2 | When running Reserve Storage Invoicing for past dates where there are a lot of records to process, the process is timing out. | VSUP-5036 | No | No |
Version 2.13.0 (30/05/18)
| Issue key | Summary | Issue Type | Affects Version/s | Description | Linked to | Config Needed | License Needed |
|---|---|---|---|---|---|---|---|
| VC-1499 | BI - Sales Profit Report | Report | 2.12.8 | Add a new BI Report. | RFC-414 | No | No |
| VC-702 | BI - Speed up Stock Audit Trail Report | Report | 2.4.2 | The Stock audit Trail Report takes a long time to run due to not being able to select a product before running it. | No | No | |
| VC-700 | BI - Stock Summary By Region | Report | 2.4.2 | Some columns on the Stock Summary by Region Report do not make sense so changes will be made to make this more user friendly. | No | No | |
| VC-1486 | GDPR | New Feature | 2.13.0 | Tools implemented to allow easier control of PII (Personally Identifiable Information) for the new GDPR regulations, in line with our intentions published in January 2018: https://visionsoftware.atlassian.net/wiki/spaces/GI/pages/176979978/GDPR+Implementation Customer & Delivery address maintenance: - 'Legal type' added to differentiate between business customer accounts and 'natural persons' to which the new regulation applies - GDPR option to support customers who wish to maintain their anonymity and for customers who wish to be forgotten (archived customers). - Control added to User Maintenance to authorise which users are allowed access to anonymous customer information - Auditing who accessed anonymous customer data and when Reporting: - Reports / enquiries showing PII now exclude anonymous customers Security: - Enhanced background security measures, tighter restriction of access controls to application and user database access ...further changes coming to further tighten access and controls to PII. | VW-3712 | No | No |
| VC-1475 | BI Enquiries: Sales 5.11 | Issue | 2.12.8 | This report is timing out, it takes 37 seconds to run which within the application means it times out. Improved the performance on this report it needs to load in at least half that time. | VSUP-4096 | No | No |
| VC-1455 | <Region Year> screen | Issue | 2.12.8 | Selecting any region from the F11 lookup does not populate the Region field on the screen. | No | No | |
| VC-1450 | Detail Costings | Issue | 2.12.7 | Various changes are required to costs recorded against movements so that they make more sense, when the users view the enquiry, this includes: *Receipts* - Costs recorded for receipts - Ability to record a freight cost or not, and control if it's fixed or standard costs - Ability to record an insurance standard cost or not (it could be included in the freight) *Despatches* - Fixes for costs recorded for spirits - RHD taken from the warehouse group at the time of despatch instead of receipt *Returns & stock transfers* - Product cost on receipt should be the sum of costs *Stock transfers only* - Movement out missing insurance, freight, CCT - Movement in should be treated similarly to a return - Bear in mind UB > DP, DP > DP, DP > UB transfer types * + Various anomalies in the calculations* Existing data will be corrected where possible. | VC-1418 | No | No |
| VC-1397 | New Customer - Duplicate code used | Issue | 2.12.3 | When adding a new customer code onto the system. Should you enter a code which already exists the error message is not in plain english. Modified the message to say "Account Code Already Exists" | RFC-242 | No | No |
| VC-1393 | BI Enquiries: General Sales Report performance | Issue | 2.11.2 | Update the the General Sales Report could use the BI End Date and improve performance. | VSUP-3337 | No | No |
| VC-950 | Interface exports for delisted products | Issue | 2.12.7 | The interface product output will not output delisted products, this will be a change to the default output with no ability for the customer to change this. | RFC-76 | No | No |
| VC-1494 | Integrate VBI 1.1.0 | Improvement | 2.12.8 | Add the latest VBI into VC application. | No | No | |
| VC-1470 | UK Mail on Netdispatch | Improvement | 2.12.8 | We have added UK Mail from Metapack to Net Dispatch | RFC-284 | No | No |
| VC-1418 | Stock movements & warehouse file processing | Improvement | 2.12.7 | Background improvements to the processes which create the stock movements (the ones visible in the 'Stock Movement Enquiry') to clean up and make these quicker. Warehouse file processing has also been visited to use these improvements and speed this up too. | No | No | |
| VC-1119 | PO Acknowledgement - Collection address for shipper | Improvement | 2.12.7 | Addition of the ability to show an alternative collection/pickup address on purchase orders. If used then it would show on the purchase order form and also the PO acknowledgement. The purpose is when sending a copy to a haulier, to inform them of an alternative address to collect the purchase order items from rather than the suppliers default account. It would not over write any of the existing fields and would only be used if needed. The table of addresses will not be associated to the suppliers as you may find many suppliers are in the same warehouse so if you select an alternative collection address then it would allow you to select any from the list. | No | No | |
| VC-1118 | Supplier - Bank account details | Improvement | 2.12.7 | We currently hold the following bank account details for the suppliers: - Account Name - Sort Code - Account Number - BACS ref We will be enhancing VC to also store the following: - IBAN - BIC / SWIFT - Roll number - Non UK sort code - Additional reference ...which will sync with Sage Line 200 and Sage Line 50. | No | No | |
| VC-1038 | Rotation Notes / Condition of Stock | Improvement | 2.12.7 | The addition of Rotation notes and Warehouse Rotation notes is to be added to the system. The ability to edit the Vision rotation notes should be possible but the warehouse rotation notes would not be able to be changed. When entering a purchase order it should be possible to enter a line note which will carry forward to the stock landing. The product form, stock tab, we will display the rotation notes to the right of the rotation numbers, there will also be the ability to view the warehouse notes if there are any, this will just be displayed as a second line underneath the vision rotation notes. The notes will also be added to the Stock Record Card BI enquiry. It is also important to be able to see this when searching to add a line to an SO and also on the SO to be able to link into the notes. | RFC-135 | No | No |
| VC-1027 | API - Order total difference with VC calculation | Improvement | 2.11.0 | When an API order is first saved, or later edited, the VC 'Order VAT' and 'Grand Total' could change and result in a difference with the totals received by the API. This doesn't cause a problem with the accounts system posting, as VC will always use the values posted by the API, however it could have an effect on VC reports not giving a true reflection of margins for example. As such a check will be introduced when saving/editing an API order, if the API Tax does not match the VC VAT, or the API Total doesn't match the VC Grand Total, then the user will be reminded giving them an opportunity to correct the values manually. | No | No | |
| VC-592 | Export prices - Delisted field | Improvement | 2.13.0 | The Export Product prices option from Interfaces on the Maintenance menu is to include the Delisted flag from the product This would allow easier sorting of the list to see which prices need to be updated. | No | No | |
| VC-587 | Sales Order Margin options | Improvement | 2.12.7 | New column is sales order line for the margin to be shown as %. | No | No | |
| VC-433 | EP PO Qty Change - Check SO | Improvement | 2.12.7 | If the qty is adjusted on an EPPO then the system should check if the reduction in purchase is > the sold amount then do not allow it. | No | No | |
| VC-1469 | Sales Order Details | Change | 2.12.8 | New field in the db now records which price list was used for the price. If from product price then this would be blank. | No | No | |
| VC-1448 | Re-align Sales Order address lines. | Change | 2.12.7 | The Address fields on the Sales Orders screen need to be re-aligned so that warning icons show. | No | No | |
| VC-842 | Data retention should clear down Reports under all categories | Change | 2.12.7 | Warehouse > Documents > Configuration we are setting the data retention period. This should clear up the files and the reports but is currently only clearing up one of them. Changes should be made to clear up everything as this impacts on speed. | No | No | |
| VC-1521 | SOP Docs - Pending invoice | Bug | 2.12.8 | Error received when trying to raise an invoice. | VSUP-6431 | No | No |
| VC-1519 | Purchase Freight Invoice : Cost being split against PO Lines is including VAT incorrectly | Bug | 2.12.8 | When a freight Invoice is entered, the value split across the Purchase Order lines is the "Invoice Grand Total field" when it should be the Invoice Grand Total minus the Invoice VAT figure. OR the GBP equivalents if a foreign currency Freight Invoice. It should act in this way because the VAT is not a direct cost of the product. At present when viewing a Stock Valuation it is including this VAT element is shown within the products cost. | VSUP-6379 | No | No |
| VC-1493 | Replicate SO Button Error | Bug | 2.12.8 | When trying to Save an Order created with the Replicate SO button "You have not entered all the required information to create a Sales Order" message is shown when the Order is correct filled in. | VSUP-5949 | No | No |
| VC-1485 | Sage - posting accounts payment | Bug | 2.12.8 | When sales Invoices with surcharges are being posted over to Sage the order amount and the surcharges are being posted in the same batch but as two separate transactions, the payment is also posted but is only allocated against one of the lines leaving the payment for the surcharge unallocated. | VSUP-5567 | No | No |
| VC-1484 | Goods Received file - Update PO | Bug | 2.12.7 | Orders processed as Transfer In by Warehouse and sent to Commerce as Goods In 'TRA' has caused Transfer In movements but has not update the Purchase Orders in Commerce. | VSUP-5341 | No | No |
| VC-1483 | Product Codes update following search | Bug | 2.12.8 | Pressing F11 to search for new Products in the Price List Maintenance finds results via Navigation Panel but selecting a Product Code does not copy it to the Price List. | VSUP-5654 | No | No |
| VC-1481 | Carrier - Service code | Bug | 2.12.8 | Can't save carrier without a standard default service code | VSUP-5536 | No | No |
| VC-1478 | Invoicing: Time Out for Reserve Invoicing | Bug | 2.11.2 | When running Reserve Storage Invoicing for past dates where there are a lot of records to process, the process is timing out. | VSUP-5036 | No | No |
| VC-1474 | SOP - same Product in two different BOM | Bug | 2.12.8 | When a Sales Order with the same Product Code in two different BOM Products is updated by an Orders Processed file, it is not updating all lines fully. | VSUP-4950 | No | No |
| VC-1473 | Web Interface - VAT Code and VAT Rate fields | Bug | 2.12.8 | Although the Vat totals show correctly a Sales Order comes over from a Web API the VAT Code and VAT Rate fields are blank. This causes issues if the Order is amended. | VSUP-5002 | No | No |
| VC-1472 | Financial Sales Order Credit | Bug | 2.12.8 | When raising a Financial Sales Order: Credit Note for a Mixed Product the line total is displaying one price but the Invoice generated is displaying a different value, the Sage posting is sending over the amount on the Invoice. | VSUP-6423 | No | No |
| VC-1471 | Consignment Numbers | Bug | 2.12.8 | If there is a problem with a Service Code, Vision Live does not provide Commerce with a Consignment Number. | VSUP-4911 | No | No |
| VC-1468 | Product Maintenance - Region code | Bug | 2.12.8 | when amending the region code an error occurs. | VSUP-4894 | No | No |
| VC-1466 | SOP Returns > Column error | Bug | 2.12.6 | When trying to credit a Mixed Product an error is thrown to the screen when clicking Process Credit after entering the singles quantity. | VSUP-4845 | No | No |
Version 2.12.8 RollUP - (20/01/2017)
| UID | Summary | Issue Type | Affects Version/s | Fix Version/s | Description | Linked to | Configuration Required | License Required | Warning of Requirements |
|---|---|---|---|---|---|---|---|---|---|
| VC-1146 | Delivery Point Account Ref adjustment | Report | 2.11.2 | 2.12.2 | After looking at the Sales Invoice templates and Delivery note templates wit some customers it was decided to tidy up the DP Account ref field as it does look out of place on the notes. - Sales Invoices templates - Move the field to a more sensible location (I.E. under the Delivery Address label) - Delivery Notes templates - Move the DP Ref to below the 'Deliver to' label - Add the account name as the first line of the address. Changes will need to be applied to all templates | RFC-220 | No | No | |
| VC-1037 | Zero stock rotations on Customer Reserves | Report | 2.11.0 | 2.12.3 | Changes made to the Customer Maintenance Reserve stock form to remove zero stocks (VC-799) have not been reflected in the report or the PDF output. These will be suppressed on the output | RFC-141 | No | No | |
| VC-1345 | Order allocation - component products for API orders | New Feature | 2.12.0 | 2.12.2 | Orders for component products are not allocating correctly. | No | No | ||
| VC-630 | Product Stock Enquiry | New Feature | 2.4.2 | 2.12.8 | Add a new Product Stock Enquiry - based on the stock enquiry (enquiries menu) This should be a new option called Product Stock Enquiry It should look similar to Stock Enquiry but the Product field should be optional to enter and if left blank all products within the specified warehouse should be returned. It should only return ONE row per product showing all the stock within the warehouse regardless of how many different rotations there are. It should not show the fields relating to costs (unit cost, freight cost, insurance cost) and should not show the rotation number and the account. It should just show the fields as shown on the bottom panel of the product warehouse stock levels panel (on PO, in stock, frozen, trading reserve, n/trading reserve, unpaid reserve, on SO, allocated, available, EPPO, EPSO, order available). The calculation used for these must be the same as in the product warehouse stock levels so that the same results are returned - basically the aim is to see this information but for all products within a warehouse rather than just one product at a time. | No | No | ||
| VC-1454 | ExCellar | Issue | 2.12.7 | 2.12.8 | As ExCellar orders were always to be under bond only, the VAT code should always be E. | VC-1344 | No | No | |
| VC-1445 | WEB Extract: Show Available to sell | Issue | 2.12.7 | 2.12.8 | The fields on the web extract TSinglesAvailable Int 12 Y (TotalConvertedSingles) Y The total stock in bottles available to sell. TCaseAvailable Int 12 Y (AvailableStock) Y This is the total available singles / Singles per case (rounded down) Available to Sell is Total Stock - Orders Committed - Orders Not Committed (including held) | RFC-301 | No | No | |
| VC-1430 | Refresh on Stock Sales Order | Issue | 2.12.7 | 2.12.8 | Click the Refresh button does not appear to refresh the Order or the screen. | No | No | ||
| VC-1425 | To Collect Field on SOP Returns size | Issue | 2.12.7 | 2.12.8 | The To Collect field word wraps if the Warehouse name is too long and needs more space. | No | No | ||
| VC-1423 | Maintenance > Mixed Cases Build Screen | Issue | 2.12.7 | 2.12.8 | Issues found with the Mixed Case Build screen | No | No | ||
| VC-1421 | Report: Customer Reserve Trading database logon error | Issue | 2.11.2 | 2.12.8 | When trying to run the Customer Reserve trading report, some users have been reporting that they are getting an error about a database logon failure. | VSUP-3754 | No | No | |
| VC-1413 | SO - EDI file failing | Issue | 2.12.6 | 2.12.8 | EDI is failing submissions where only some orders have a <DO> segment, a workaround will be put into VC to fix this until VEDI can be fixed. | No | No | ||
| VC-1409 | Sage Posting & Web API - Credit Card Payments for Sage L50 | Issue | 2.12.5 | 2.12.8 | Integration of credit card payments for Sage L50. | Yes | No | ||
| VC-1408 | Allocation - Send to carrier error | Issue | 2.12.5 | 2.12.8 | Receiving error when you have allocate an order that does not need to be send to carrier. | No | No | ||
| VC-1391 | Sage Posting & Web API - Credit Card Payments for Sage L50 | Issue | 2.12.4 | 2.12.4 | VC-841 integrated Credit Card Payments for Sage L200, here we will integrate these payments for Sage L50. | VC-1144 | No | No | |
| VC-1390 | API > Order > Changing Customer Code | Issue | 2.12.4 | 2.12.4 | API Order - the customer is changing when saving into VC. | No | No | ||
| VC-1388 | API Interfaces > Duplicates | Issue | 2.12.4 | 2.12.8 | Various scenarios can occur where duplicate customer records are created and cannot be removed. | No | No | ||
| VC-1387 | API > Field Lengths | Issue | 2.12.4 | 2.12.8 | When using more than max length in the API, it not saving the customer correctly. | No | No | ||
| VC-1386 | API - Invalid Customer on Orders | Issue | 2.12.4 | 2.12.7 | When using an invalid customer on an order, it is not failing it is changing the Customer Code. | No | No | ||
| VC-1385 | Stock calculation on WEB extract | Issue | 2.12.4 | 2.12.4 | Web extract is providing the total IN STOCK and not the "Available" | No | No | ||
| VC-1382 | Delivery windows & booked dates | Issue | 2.12.3 | 2.12.8 | VC-1369 continued. 1. The customer API is defaulting the customer earliest / latest times and it should not be doing this 2. The customer maintenance screen must not make the earliest / latest times mandatory and the user should be able to clear these if they are entered 3. The order screen should be the same and so should the delivery point screen. 4. The booked date and release date for orders submitted via the API is defaulting to 01/01/1900, this is not consistent with the SO screen. 5. The allocation screen is showing the booked date even when 'Fixed Booked Date' is not selected against the order. | VC-1369 / IMP-118 / VSUP-3590 | No | No | |
| VC-1374 | Carrier admin | Issue | 2.12.1 | 2.12.8 | To make carrier admin easier, and not spread all over the place, the following admin screens will be moved to the Navigation > System > Carrier screen: Admin > Carrier Warehouse Groups Admin > Carrier Service Codes | No | No | ||
| VC-1369 | SO - Earliest / latest times | Issue | 2.12.2 | 2.12.3 | On the order the 2x delivery time windows must not be mandatory, the user should be able to leave these as blank, and in this scenario the order file submitted to the warehouse must not default the times. | No | No | ||
| VC-1362 | Price List Maintenance | Issue | 2.12.2 | 2.12.8 | There are two sections called Product Prices on the Price List Maintenance screen. The left hand one should read "Products" | No | No | ||
| VC-1361 | Sales order - data invalid for submission to carrier | Issue | 2.12.1 | 2.12.2 | We've noticed some sales order data is invalid, so when this is submitted to the parcel carrier (via Vision Live), the carrier rejects it and the user is forced to fix the incorrect entries and resubmit. We want the interaction to be minimal here, so we will make some changes to make this more seamless. | No | No | ||
| VC-1360 | BOM Master Product - In SO Line Notes | Issue | 2.12.1 | 2.12.2 | We need to send the BOM Master Product Code andDescription through on the SO Line Notes field when sending a product line on the warehouse file. | IMP-105 | No | No | |
| VC-1357 | API - Error on order import | Issue | 2.12.1 | 2.12.2 | Getting this error when submitting an order on Rude's system. {code:java} "ErrorCode": "6001", "Message": "Submission recognised and passed validation, however an error occurred while saving your data into our system. SQL Error occured while Importing Orders. -> An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as \"\" or [] are not allowed. Change the alias to a valid name.\r\nAn object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as \"\" or [] are not allowed. Change the alias to a valid name.\r\n INSERT INTO #PeriodExchangeRates\r\n\t\t\t\t SELECT * \r\n\t\t\t\t FROM OPENQUERY([],' \r\n\t\t\t\t\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\t\t\t\t\tsCurrencyISOCode.Code, \r\n\t\t\t\t\t\t\t\t\t\t\tCASE \r\n\t\t\t\t\t\t\t\t\t\t\tWHEN sCurrency.ThisIsBaseCurrency = 1 THEN 1 \r\n\t\t\t\t\t\t\t\t\t\t\tELSE sPeriodExchangeRate.OneUnitEquals END AS ExchangeRate \r\n\t\t\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\t\t[].dbo.SYSCurrencyISOCode sCurrencyISOCode\r\n\t\t\t\t\t\t\t\t\tINNER JOIN [].dbo.SYSCurrency sCurrency ON sCurrencyISOCode.SYSCurrencyISOCodeID = sCurrency.SYSCurrencyISOCodeID \r\n\t\t\t\t\t\t\t\t\tINNER JOIN [].dbo.SYSPeriodExchangeRate sPeriodExchangeRate \tON sCurrency.SYSCurrencyID = sPeriodExchangeRate.SYSCurrencyID\r\n\t\t\t\t\t\t\t\t\tWHERE (sCurrency.SYSExchangeRateTypeID = 1) AND \r\n\t\t\t\t\t\t\t\t\t\t\tsPeriodExchangeRate.StartDate <= getdate() AND \r\n\t\t\t\t\t\t\t\t\t\t\tsPeriodExchangeRate.ExpiryDate >= getdate()\r\n\t\t\t\t\t\t\t\t\t')\r\nSALES ORDER NUMBER GENERATION\r\n \r\nSTOCK ORDER\r\n155", "StatusCode": "Error" {code} | No | No | ||
| VC-1351 | API - Fields not Mapping | Issue | 2.12.0 | 2.12.1 | The following fields are not mapping into the sales order - email address (billing email) - contact number (billing phone) | No | No | ||
| VC-1293 | Navigation Issues - Multiple | Issue | 2.12.0 | 2.12.8 | Various checks by support team during testing provided a number of small issues mainly asthetics and logics. These have all been addressed. | No | No | ||
| VC-1292 | Admin Issues - Multiple | Issue | 2.12.0 | 2.12.8 | Various checks by support team during testing provided a number of small issues mainly asthetics and logics. These have all been addressed. | No | No | ||
| VC-1275 | Stock Menu issues - multiple | Issue | 2.12.0 | 2.12.8 | Various checks by support team during testing provided a number of small issues mainly asthetics and logics. These have all been addressed. | No | No | ||
| VC-1203 | Enquiries Issues - Multiple | Issue | 2.12.0 | 2.12.8 | Various checks by support team during testing provided a number of small issues mainly asthetics and logics. These have all been addressed. | No | No | ||
| VC-1199 | Sales Order Issues - multiple | Issue | 2.11.0 | 2.12.8 | Various checks by support team during testing provided a number of small issues mainly asthetics and logics. These have all been addressed. | No | No | ||
| VC-1180 | Maintenance Issues - Multiple | Issue | 2.12.0 | 2.12.8 | Various checks by support team during testing provided a number of small issues mainly asthetics and logics. These have all been addressed. | No | No | ||
| VC-1178 | API - Orders missing data | Issue | 2.12.0 | 2.12.2 | Orders saved from the API are missing the following data when saving: - Excise deferment number - Customs deferment number These should be defaulted the same way they are from the orders screen, if these are not populated this causes problems later on down the line. | No | No | ||
| VC-1171 | Purchase Order Issues - multiple | Issue | 2.12.0 | 2.12.8 | Various checks by support team during testing provided a number of small issues mainly asthetics and logics. These have all been addressed. | No | No | ||
| VC-1166 | API - Orders delivery message | Issue | 2.12.0 | 2.12.1 | It appears the API which has a field length of 250 is being truncated at 30 characters for the delivery message. Example is SO 83 in VC it is "This is a test delivery instru" The original message in Magento was "This is a test delivery instruction" | IMP-93 | No | No | |
| VC-1162 | Interfaces - API Order ID | Issue | 2.12.0 | 2.12.1 | Make the column wider. | No | No | ||
| VC-1161 | API - Batch of customers / orders fail | Issue | 2.12.0 | 2.12.1 | When a batch of customers or batch of orders are posted, and one of them fails, it puts the whole batch inside interfaces screen. | No | No | ||
| VC-1160 | API - Order analysis | Issue | 2.12.0 | 2.12.1 | If there is nothing submitted in the order fields 'Type' or 'AccountManager' the value from the customer should be taken and saved against the order. | No | No | ||
| VC-1159 | API - Order 'price' | Issue | 2.12.0 | 2.12.1 | When 'quantity is in cases' is ticked, the price submitted is the case price, VC is taking this as the singles price, plus the addition of the 'SubPrice' field. | No | No | ||
| VC-1153 | Import Service - Not returning full error message | Issue | 2.12.0 | 2.12.1 | Import service API not seems to be returning the full error messages especially when there is a SQL error. | No | No | ||
| VC-1152 | Import Service - Use of special characters in XML | Issue | 2.12.0 | 2.12.1 | Special characters like ô is causing the XML processing to fail for both order and customer XMLs. This is noticed when there is below tag in the XML. <?xml version="1.0" encoding="UTF-8"?> | No | No | ||
| VC-1151 | Warehouse Submission Search - Timeout | Issue | 2.12.0 | 2.12.1 | Warehouse Submission Search seems to timeout at Rude wines. | No | No | ||
| VC-1150 | API - Order 'quantity' | Issue | 2.12.0 | 2.12.1 | The API should allow 0 order quantity if SubQuantity > 0. | No | No | Requires VC Import service. | |
| VC-1147 | Commerce Web CSV - Product_CaseUB/Product_SingleUB | Issue | 2.12.0 | 2.12.1 | Incorrect value in fields Product_CaseUB/Product_SingleUB showing minus amount. | No | No | ||
| VC-1143 | Customer Price List: No save prompt when exiting screen | Issue | 2.11.1 | 2.12.3 | When making changes on Customer Price List maintenance, if the screen is exited without clicking save the screen will NOT display a save prompt and will just close without saving the changes | VSUP-2650 | No | No | |
| VC-1140 | API - Field lengths | Issue | 2.12.0 | 2.12.1 | Field lengths are not being validated currently, so when for example the Customer Code is over the length allowed it is not showing an error code nor is it saving. | No | No | ||
| VC-1139 | API Interfaces - Duplicates | Issue | 2.12.0 | 2.12.1 | Various scenarios can occur where duplicate customer records are created and cannot be removed. | No | No | ||
| VC-1123 | Help > Helpdesk | Issue | 2.11.2 | 2.12.3 | The link is using the old helpdesk. | No | No | ||
| VC-1158 | Web extract- mixed products | Improvement | 2.12.0 | 2.12.1 | Add the switch to allow mixed products to be output on the web extract, these are currently excluded. | No | No | DailyWebExtract.exe has a new 5th parameter now for including mixed products to the products extracts file. New option to include mixed products on the web extract added, please set as appropriate. | |
| VC-1144 | Sage Posting & Web API - Credit Card Payments for Sage L50 | Improvement | 2.12.0 | 2.12.2 | VC-841 integrated Credit Card Payments for Sage L200, here we will integrate these payments for Sage L50. | VC-841 | No | No | Sage Service release required. |
| VC-896 | Sage 2017 & 2018 (50c) integration | Improvement | 2.12.7 | 2.12.8 | Integration with the latest version of Sage 50 Accounts. | No | No | ||
| VC-448 | Price List Maintenance | Improvement | 2.12.7 | 2.12.8 | Add the delisted field onto the Product Price grid (bottom left) and a filter option to show / hide delisted products. Add a new function which will delete from the price list those items which are delisted and no stock is available. | No | No | ||
| VC-1457 | Purchase Orders - Freight Invoices | Bug | 2.12.7 | 2.12.8 | VAT is not being applied to freight invoices posted to the accounts system. | VSUP-4265 | No | No | |
| VC-1456 | Margin reports - GP% | Bug | 2.12.7 | 2.12.8 | The GP% is incorrectly shown on some reports where there are multiple despatches for a single order line, and also showing at 100th of what it should be. | No | No | ||
| VC-1449 | Customers created in VC from WebAPI-> Sage | Bug | 2.12.6 | 2.12.8 | Customer Accounts in VC that are created from the WebAPI are not automatically creating a matching Account in Sage. | VSUP-4122 | No | No | |
| VC-1447 | Freight Cost on Pre-Advices | Bug | 2.12.7 | 2.12.8 | Freight Cost on Pre-Advices is not displayed correctly on the Stock Valuation By Rotation Enquiry If a pre-advice is entered which will incur a 'decimal' freight cost (for example £3.35), when you check the Stock Valuation By Rotation enquiry, this will show as £3.00 | No | No | ||
| VC-1446 | BI Enquiries> 5 sales> 5 1 1 Sales by product | Bug | 2.12.7 | 2.12.8 | Report timing out when running | VSUP-4096 | No | No | |
| VC-1444 | Purchase Order: Errors opening some transfer p orders | Bug | 2.11.2 | 2.12.8 | An error is thrown when trying to open some transfer Purchase Orders. | VSUP-4012 | No | No | |
| VC-1431 | BI Enquires - Sales Rep Yearly comparison performance | Bug | 2.12.7 | 2.12.8 | When running the Sales Rep yearly comparison report on a larger data in order to prevent a timeout the report can only be run for a 12 month period. | VSUP-3998 | No | No | |
| VC-1429 | Sales Order > Component products Allocated tick boxes | Bug | 2.12.7 | 2.12.8 | When using a Product with components on a Sales order, on the components window the IsAllocated boxes will remain ticked even the order is unallocated. | No | No | ||
| VC-1424 | Consignment Setup: Consignment numbers being removed. | Bug | 2.12.6 | 2.12.8 | When sending multiple orders to a carrier, if one order has an issue against it, the consignment number will not be shown in Commerce or Warehousing, however the non failures still get sent to the carrier. | No | No | ||
| VC-1422 | Credit note - Incorrect price posted to sage | Bug | 2.12.2 | 2.12.8 | In certain circumstances when creating a credit note it will double the price being credited. | No | No | ||
| VC-1417 | Consignment setup: Error | Bug | 2.12.6 | 2.12.7 | On certain orders when sending an order to the carrier, when updating the consignment setup an error is thrown stopping the user from progressing from this screen | No | No | ||
| VC-1416 | Overnight files - Orders processed file | Bug | 2.12.6 | 2.12.7 | Orders processed file not updating all orders | No | No | ||
| VC-1415 | VC_Test_Bug_dev5 | Bug | 2.12.6 | 2.12.7 | This is a test bug | No | No | ||
| VC-1412 | Replicated Sales Order showing insufficient stock on mixed products. | Bug | 2.12.5 | 2.12.7 | If you replicate an SO that has Mixed Products, an insufficient stock warning is shown against the mixed product even though it doesn't need a stock level. | VSUP-3642 | No | No | |
| VC-1411 | Overnight files - Orders processed file | Bug | 2.12.5 | 2.12.6 | Orders processed file not processing all lines. | No | No | ||
| VC-1410 | Clicking Credit button in Historical Invoices causes an error | Bug | 2.12.6 | 2.12.8 | In Historical Invoices, if you click the Credit Button shown against an Invoice (to credit duty and vat) shows an error message. | VSUP-3591 | No | No | |
| VC-1406 | Sales Order - Replicate SO error | Bug | 2.12.4 | 2.12.8 | In certain instances when trying to replicate an SO It is throwing an error and is not allowing the user to replicate the selected order | No | No | ||
| VC-1405 | Sales order - submitting wrong carrier label information to EDI | Bug | 2.12.5 | 2.12.6 | The wrong carrier label information is being sent to VEDI from the VC submissions screen. | No | No | ||
| VC-1403 | SO - Altering prices for mixed case products | Bug | 2.12.4 | 2.12.8 | After added a mixed case product to an SO, change the quantity, the user cannot alter the unit or single price. After changing it and leaving the field, it reverts to the previous price. This is different behaviour to normal products which are working correctly. | No | No | ||
| VC-1402 | EP Credit Logic | Bug | 2.12.3 | 2.12.7 | EP Credit Logic is not sensible. EP Credits should only be provided if the stock has not been allocated and sent, the reason being is that the duty payment and subsequent potential storage prior to duty payment makes the credit extremely complex. Its always been iterated that EP Credits once despatched should be manual but on a recent release this logic was missed when the credit logic was modified. EP Credits will be modified to allow a credit pre-allocation only. If the stock is despatched then you will have to purchase from your customer or arrange a fianancial credit and manually change the stock or if it is in reserve stocks then transfer and credit. | No | No | ||
| VC-1401 | Goods received - timeout error | Bug | 2.12.4 | 2.12.6 | Some users are receiving a timeout error when processing a goods received file. | No | No | ||
| VC-1400 | Allocation - No of packs | Bug | 2.12.4 | 2.12.8 | The packing scenarios calculation is incorrectly calculating the number of packs sent to APC. | No | No | ||
| VC-1399 | Allocation - Send to carrier error | Bug | 2.12.4 | 2.12.5 | Allocating an order after updating them to use the APC carrier, the screen opens asking for the service code and additional service code, after the user enters these and clicks 'Update' an error is received. | No | No | ||
| VC-1398 | Reserve Stock Transfer: When Warehouse Gr Code > 8 chars | Bug | 2.11.2 | 2.12.8 | If a warehouse group code has 8 characters in it then any order type that needs to create a supplier will throw an error onto the screen and does not let the order be saved. | VSUP-3519 | No | No | |
| VC-1395 | Stock Transfer: Order Form Complexities | Bug | 2.11.2 | 2.12.8 | Stock Transfer: Warehouse will not populate if ExcisePaid field is checked first. If you uncheck the Duty Paid flag on a Stock Transfer Order before you choose a Warehouse Group and Warehouse, there are no warehouses to choose from. | VSUP-3442 | No | No | |
| VC-1394 | Error sending to carrier | Bug | 2.12.4 | 2.12.4 | When clicking 'Update' in the 'Consignment Setup' screen (which is launched from the stock allocation screen) an error is displayed, this seems to happen after the user enters the service code and additional service code and clicking 'Update' | No | No | ||
| VC-1384 | Allocation - Parcel carrier submission weights | Bug | 2.12.3 | 2.12.4 | Weights submitted to the parcel carrier are incorrect for mixed case products, they are double what they should be. | No | No | ||
| VC-1383 | SO allocation - after cancelling the allocation and reallocating | Bug | 2.12.3 | 2.12.4 | After allocating an order, then sending to carrier, errors were encountered in the carrier submission so the user closed the 'Vision Live' screen and the allocation screen and opted not to save changes. Then they went back into the screen, allocated again, but the line colour went to yellow this time instead of green, after clicking 'Details' it showed that all lines on the order had been fully allocated and were green, so it should've been green in the main allocation screen too. | No | No | ||
| VC-1381 | Document manager - PDF cleanup process | Bug | 2.12.2 | 2.12.4 | When trying to view two different PDF's at the same time an error occurs when VC attempts to delete the existing PDF in the directory. | No | No | ||
| VC-1380 | API - Interfaces cannot save order | Bug | 2.12.3 | 2.12.4 | Double clicking the order in the Interfaces > API > Order we cannot save some orders. | No | No | ||
| VC-1379 | Consignment submission - Number of packs | Bug | 2.12.3 | 2.12.4 | The number of packs appears to be calculating incorrectly. | No | No | Setup Packaging types in Maintenance -> Create Packaging. Setup the 'Default Packaging' for all Parcel Carriers. Above options must setup for the Consignment Packs calculation to work. | |
| VC-1377 | Documents - Order picked confirmed files | Bug | 2.12.2 | 2.12.4 | Mixed case products not being delivered by the warehousing order pick confirmation files | No | No | ||
| VC-1376 | Purchase Order - Amendment | Bug | 2.12.3 | 2.12.4 | After amending the purchase order I should then see this in the Warehouse submissions (if applicable) to resend, but this is not happening. | No | No | ||
| VC-1375 | Error when Altering PO | Bug | 2.12.3 | 2.12.4 | I opened a PO and then proceeded to alter it. When it was saved an error was displayed which stated that the order had been modified by another user. What I had done is generated the purchase order on the POP screen. | No | No | ||
| VC-1372 | Web extract (mixed products) & BI Mixed Case Availability | Bug | 2.12.2 | 2.12.4 | Web Extract - VC-1158 continued. BI "Mixed Case Availability" - Calculation correction. | No | No | New System Config option added - "Web Extract - Include Mixed Products in Product Extract", please set this appropriately for the customer from the Admin -> System Configuration Options screen. Also please note that we've removed the 5th parameter from DailyWebExtract.exe as mentioned in VC-1158 | |
| VC-1371 | Old Stock Transfer Orders: Clicking Open Purchase Order button causes error | Bug | 2.12.1 | 2.12.7 | Old Stock Transfer Orders cause unhandled exception when clicking the Open Purchase Order button. | VSUP-3116 | No | No | |
| VC-1368 | SO WH Submission - SO Line Notes for mixed products | Bug | 2.12.2 | 2.12.3 | The SO Line Notes are cutting off at 20 characters and should be allowing the full 120. | No | No | ||
| VC-1367 | Stock calculation on WEB extract | Bug | 2.12.1 | 2.12.2 | Web extract is providing the total IN STOCK and not the "Available" | IMP-111 | No | No | |
| VC-1364 | Warehouse submission - SO consignment numbers | Bug | 2.12.1 | 2.12.2 | The SO XML submission to the warehouse is sending ConsignmentNumber but the EDI spec states ConsignmentNo. As such the field isn't getting imported by the warehouse system currently. | No | No | ||
| VC-1363 | Supplier Maintenance screen\Transactions tab\Current field needs to be wider. | Bug | 2.12.2 | 2.12.7 | Current field is not currently wide enough and needs to be at least 3 digits wider . | No | No | ||
| VC-1359 | Sales Order BOM Issues | Bug | 2.12.1 | 2.12.2 | The Components tab on the Sales order is showing double the amount of items than it should it appears to show once for each line and then repeats itself again. This is effecting the allocation This is also effecting the outbound file to the warehouse. | IMP-107 | No | No | |
| VC-1358 | Customer API | Bug | 2.12.0 | 2.12.2 | Reference to VC-1090 Customer Contact is not being created with an email address in it. | No | No | ||
| VC-1356 | Product Extract - "TSinglesAvailable" | Bug | 2.12.1 | 2.12.2 | The TSinglesAvailable field is always showing as 0 since recent changes. | No | No | ||
| VC-1344 | ExCellar - Default VAT code | Bug | 2.11.2 | 2.12.8 | Ex-Cellar Orders were designed for purchases from a foreign source. As such should the supplier be UK based and stock UK sourced be delivered directly to the customer the VAT is not being set correctly. The VAT element on the order needs to be set based on where the stock is coming from. | No | No | ||
| VC-1274 | Stock Bugs - Multiple | Bug | 2.12.0 | 2.12.7 | All Bugs noticed during the VC testing run through July 2017 | No | No | ||
| VC-1170 | Purchase Order Bugs - Multiple | Bug | 2.12.0 | 2.12.7 | Purchase Order Bugs - Multiple | No | No | ||
| VC-1169 | Allocation - BMC error | Bug | 2.12.0 | 2.12.1 | A BMC unknown internal application error is encountered when committing an allocated API order. | No | No | ||
| VC-1168 | API - Order failing with constraint error for payments | Bug | 2.12.0 | 2.12.1 | A 'duplicate key' (constraints) error is being reported when saving orders directly from the API. | No | No | ||
| VC-1167 | Order - 'Total VAT' not including surcharges | Bug | 2.12.0 | 2.12.1 | The 'Total VAT' displayed at the bottom of the order form (and on the API tab 'Total VAT') does not appear to be including VAT for surcharges with a VAT rate applicable (and inc VAT unticked). | IMP-96 | No | No | |
| VC-1165 | Ordering - API orders unable to allocate | Bug | 2.12.0 | 2.12.2 | Unable to allocate API orders, they appear but it does nothing. | No | No | ||
| VC-1164 | API - Order not available in allocation screen | Bug | 2.12.0 | 2.12.1 | Orders received and saved directly into VC by the API are not showing in the allocation screen. | No | No | ||
| VC-1157 | Sales Order: Delivery times showing am instead of PM on Delivery Note. | Bug | 2.11.2 | 2.12.3 | Sales order: Delivery times set as PM (in 24 hour format) on the Sales Order are showing as AM (in 24 hour format) on the Delivery Note. | No | No | ||
| VC-1142 | Sales Order: Replicating Order with insufficient stock does not put order on Hold | Bug | 2.11.1 | 2.12.3 | When replicating a Sale Order where one of the lines has insufficient stock to be completed will throw a message to the screen but does not put the order on hold. | VSUP-2650 | No | No | |
| VC-1141 | Ex Cellar - Unable to create a credit note | Bug | 2.11.2 | 2.12.3 | After completing an EX cellar order trying to create a credit note will not allow you to enter any information past the reason. | No | No | ||
| VC-1135 | Reserve Stock Report Values - Variance column showing incorrectly | Bug | 2.11.2 | 2.12.3 | When calculating the variance column on the reserve stock values report the calculation is the wrong way which results in negative values when they should now be there. | VSUP-2594 | No | No | |
| VC-1134 | PI XML - Issues noticed with the generation of XML messages | Bug | 2.11.2 | 2.12.3 | Customer has reported Purchase Order Invoices that have failed to post over to Sage, after checking the PI XML it can be seen there are scenarios where the PI XML can be missing data. | VSUP-2569 | No | No | |
| VC-1132 | Order Picking Confirmation file timing out when Importing | Bug | 2.11.2 | 2.12.8 | Customer had an issue with an Order Picking Confirmation (OPC) file where the VCWS was timing out when processing the OPC file. Looks to be the same issue as VC-986 | VSUP-2535 | No | No | |
| VC-1128 | POP Documents - PO Acknowledgements | Bug | 2.12.1 | 2.12.3 | Can't print multiple PO Acknowledgements at once if a shipper export email is present. | No | No | ||
| VC-1127 | Goods Received Transfer orders not Auto Receipting | Bug | 2.11.2 | 2.12.8 | Goods Received files are not auto-receipting in Purchase orders for the TRA receipt type | VSUP-2477 | No | No | |
| VC-1122 | Ordering - API orders 'Total VAT' | Bug | 2.12.1 | The 'Total VAT' displayed at the bottom of API orders is incorrect, it doesn't seem to be calculated at all. | No | No |
Version 2.12 (12/07/2017)
| Issue key | Summary | Issue Type | Affects Version/s | Description | Linked To | Configuration Needed | Licensed Module |
|---|---|---|---|---|---|---|---|
| VC-1088 | API - Direct save | New Feature | Removed the need for users of the API to accept orders and customers into the system. Orders and customers will be able to be saved directly into the system, bypassing the current 'Interfaces' screen. This will be a configurable option so they can either go straight in, or be held in Interfaces for you to load manually. If your system is configured for the records to go straight in, but it wasn't possible (for whatever reason), it will fall back to saving to the interfaces screen to be loaded in manually. Mandatory / Optional / Defaulted / Conditional attributes are to be added to our submission specification and the API will: - Validate that all mandatory fields are provided, otherwise an error response is given - Validate that conditional fields are populated as and when required - Defaulted fields are defaulted to values you set in VC if not provided | VC-1090 | No | Yes | |
| VC-1115 | Dynamic Product Code - Unable to save product | Issue | 2.11.2 | Maintenance > Create > Dynamic Product After clicking 'Save' the data is loaded into the product maintenance screen, 'Auto Generate' is ticked. If the user clicks save an error is displayed, the user is unable to save the product until they untick 'Auto Generate'. | No | No | |
| VC-1114 | Web API - Analysis Codes | Issue | Further work on API inbound was carried out 1. New codes will be created for all 7 analysis fields on the customer posting 2. The status field is not being set to 'Live'. | No | No | ||
| VC-1093 | General - old F11 / F12 navigation results | Issue | 2.11.2 | Old F11 / F12 navigation results remain at the bottom of the screen after used. If you then try to double click one of the records when you're later in another screen, an error is displayed. | No | No | |
| VC-1136 | API - Order 'special message text' | Improvement | The API will now support the submission of 'special message text' (1&2) for orders. | No | No | ||
| VC-1124 | API - LineTax | Improvement | LineTax is a new field being added to the API order fields. LineTotal = ex VAT LineTax = VAT amount | No | No | ||
| VC-1104 | VBI Report Designer | Improvement | Line total and Line total GBP now added to the VBI data available for reporting for report designers. | No | No | ||
| VC-1095 | Product Group - Fragile | Improvement | The 'Fragile' field shown on the 'Product Group' screen will be changed to 'Fragile for Parcel Carriers'. | No | No | ||
| VC-1094 | Warehouse Submissions / Document Management | Improvement | In the Warehouse Submissions screen & Document Management screen, all 'Warehouse Groups' are displayed in the drop down menu, when only the ones with 'Send or Received File Extract' ticked need to show. | No | No | ||
| VC-1091 | Product Maintenance - Stock info (duty status) | Improvement | When rotations markers are incorrect, it's not currently possible to see which stock records in this screen are duty paid or not, a new column will be added to the right of the 'Rotation No' show this. | No | No | ||
| VC-1090 | Customer maintenance | Improvement | Creation: 1. When creating a new customer, the first contact will be auto created based on the main customer information entered. Creation / Amend: 2. Ability to set default 'Carrier' for each customer, this is used when creating a manual order, and in the API when orders are RECEIVED, linked to: VC-1088. | No | No | ||
| VC-1089 | Customer contact maintenance - CRM options | Improvement | 2.12.0 | Maintenance > Customer Contact Several improvements to be made, including: 1. Fix the 'Postcode' lookup which does not seem to work 2. Birthday Up To will no longer be defaulted 3. Account manager filter field to be added (defaulted to empty) 4. Date of next call to be added to the right of the 'Date Created' field at the bottom, which will also be available as a new filter field 'To call from' & 'To call to' (both defaulted to empty) ...allowing a salesman to go in, select his name, select the date he was supposed to contact customers from and return all customers he needs to call. 5. Both grids to be updated to the latest grids. This will allow users to see the fields they want to see (in the 'Contacts' grid only) and save that as their default layout for the screen, which also removes / improves the horizontal scrollbar. 6. Make screen wider | No | No | |
| VC-1087 | Product Maintenance - Sales Analysis | Improvement | Account manager will be added as an optional filter option to the 'Sales Analysis' screen (available from Product Maintenance). This will be retrieved from the "Account manager" specified against the sales order header. | No | No | ||
| VC-1137 | LWIN Error | Bug | 2.11.2 | Even when a customer is not using LWIN the system produces an error message and the only way around it is to put something into the LWIN field. It should not be asking for this to be filled if 1) Vision Live is not in use 2) should not be erroring if it is left blank The error should only show if there is a duplicate but it must be more than a blank. | IMP-79 | No | No |
| VC-1131 | Commerce Web CSV | Bug | 2.11.2 | Comparing the spec to the actual file produced reveals some differences, these need to be addressed: Weight is in the specification but not in the file, this will be added at the end of the existing fields (in case any existing customers are using the column position instead of column name for importing). Will check to make sure we are not missing any others too. Region - Should be showing the region's code Region_Name - Should be showing the region's name. Refer to: https://visionsoftware.atlassian.net/wiki/display/VC/Web+Extract+CSV | IMP-73 | No | No |
| VC-1125 | SO - Mixed products | Bug | When entering a pre mixed product on to a sales order, another section is shown at the bottom of the screen showing the make up of the case. This has some columns which shouldn't be there. | No | No | ||
| VC-1121 | Shipper - Not sending email | Bug | 2.11.2 | If supplier doesn't have an email set up against it the shipper email won't send. | No | No | |
| VC-1120 | Sales Order: Deleting line from order | Bug | 2.11.1 | When deleting a line in VC but removing the product code and the tab'ing will delete the line incorrectly, and will remove the line below. | VSUP-2397 | No | No |
| VC-1117 | Web extract - Incorrect product type | Bug | The product type displayed is incorrect, it should be coming from the commodity code linked to the product (if the product has a commodity code). | No | No | ||
| VC-1116 | PO - Editing - Resubmission to warehouse | Bug | After sending a PO to the warehouse, and then editing it, it will now be marked for re-submission | No | No | ||
| VC-1113 | LiveX Market Values: Not saving | Bug | When requesting a LiveX 'Update Market Values' from Customer Maintenance > Reserve Stock the valuation is retrieved and shows in the grid however once the customer is saved the valuation is being removed. | VSUP-2323 | No | No | |
| VC-1112 | Primary Bank Account always shows GBP account. | Bug | 2.11.1 | Primary Bank Account changes to GBP account on screen when Saved | VSUP-2377 | No | No |
| VC-1110 | Purchase Order - Freight Invoicing | Bug | On Purchase Order > Freight Invoicing receiving error when clicking Process | No | No |
Version 2.11.2 (23/05/2017)
| Issue key | Summary | Issue Type | Affects Version/s | Affects Version/s | Description | Custom field (FusionUID) | Custom field (Configuration Needed) | Custom field (Licensed Module) |
|---|---|---|---|---|---|---|---|---|
| VC-1108 | Invoice Email text formatting missing. | Bug | 2.11.1 | The accompanying email for invoices is showing the text in Report Manager correctly but not on the email itself. | No | No | ||
| VC-1107 | Credit Note Returns: Unable to return Duty paid stock | Bug | When Creating a return to a Duty paid warehouse for Duty paid stock. The system will throw an error message which will disable you from returning the stock | No | No | |||
| VC-1106 | Dynamic Product Admin | Bug | Get an error message when trying to save. When trying to edit message appeared. | No | No | |||
| VC-1102 | VBI updates | Issue | VBI will be updated to the latest version available in this release. | No | No | |||
| VC-1086 | SO - Parcel Carrier | Issue | Fixed Booked Date is defaulted to ticked and this should not be the case. This is causing problems with submissions to parcel carriers where it's sending the order date as the booked date and using that as the expected delivery date. | No | No | |||
| VC-1085 | Allocation - Parcel carriers | Issue | Various small issues resolved when using parcel carriers from the allocation screen. | No | No | |||
| VC-1084 | SO - UB price on DP order | Bug | On a duty paid sales order, after entering the product code the price is shown, enter the quantity and the price changes to the under bond price on the customer price list. | No | No | |||
| VC-1082 | Parcel Carrier - Submission issues | Issue | Various issues with the consignment submission to parcel carriers resolved. | No | No | |||
| VC-1080 | Database Log on Error- Warehouse 'orders picked confirmed' | Bug | 2.11.1 | Getting Database logon failed error we we try to view the order pick confirmed report | No | No | ||
| VC-1079 | Shipper - Error creating new record | Bug | When saving a new shipper, the following error is displayed and prevents the user from saving: "Errors have been found on this form, please check." ...yet no fields are highlighted showing that they need to be filled, the 'Sage Account' was also wiped. | No | No | |||
| VC-1072 | System configuration options - Alternate trading names grid | Issue | This is not using the same theme as other grids in the application. | No | No | |||
| VC-1071 | Product Maintenance - Package Desc rounding | Issue | The yellow package description field shown in product maintenance is currently rounding to 1 decimal place, this doesn't work when you're using a 13.75cl bottle for example. | No | No | |||
| VC-1066 | Core - Version control | Improvement | Back end changes to improve our version control processes. | No | No | |||
| VC-1063 | EX Orders: UB Delivery Address required incorrectly. | Bug | 2.10.0 | 2.11.0 | Validation should not be expecting an Underbond Delivery Address for an ExCellar order. | VSUP-1780 | No | No |
| VC-1062 | ExCellar Order numbers are not formatting correctly. | Bug | ExCellar Purchase Order numbers are no longer showing as 'EX' and then a number. | No | No | |||
| VC-1061 | ExCellar Orders - Supplier changes to ExCGBP on first save. | Bug | 2.10.0 | 2.11.0 | On first save the entered supplier changes to Account: ExCGBP and Purchase order is created for this supplier. | VSUP-1780 | No | No |
Version 2.11.1 (30/04/2017)
| Issue key | Summary | Issue Type | Affects Version/s | Affects Version/s | Description | issue link | Configuration Needed | Licensed Module |
|---|---|---|---|---|---|---|---|---|
| VC-1068 | Stock Transfer Order - Purchase Order | Bug | 2.11.1 | Purchase order's created from Stock Transfer orders should not always be automatically receipting when the destination is set to use EDI files or use rotations. If you transfer stock into another account where the receiving warehouse is set to receive EDI files OR the receiving warehouse requires ROTATIONS then - PO should be created for the stock move, this is INTERNAL an Internal Supplier needs to be added to the system for this and recorded in the DB to reuse the same one each time. - SO should wait for the orders processed, it should not auto process the receipt if the above conditions apply….. - PO should wait for the goods received file to arrive, this should book the stock in You can not auto receipt it how would you expect to get the rotation numbers (if required) onto the new stock. | No | No | ||
| VC-1065 | Product Stock Enquiry - Not opening | Bug | The menu option Enquiries > Product Stock Enquiry when clicked is not opening anything, this isn't supposed to appear until the next version so will be removed. | No | No | |||
| VC-1057 | API - Unable to amend order details | Bug | 2.5.3 | When opening an order from the API interface you are unable to edit any details without first saving, closing the order, then re-opening it | No | No | ||
| VC-1056 | Stock Exception Report | Bug | 2.10.0 | 2.11.0 | Stock snapshot with missing rotation not displayed on stock exception reportI f a rotation exists in the warehouse in VC which does not exist in the stock snapshot file received from the warehouse, the stock exception report is not displaying these rotations at all. | No | No | |
| VC-1054 | Stock Transfer Order - Save Error | Bug | An error relating to issues retrieving supplier details when saving a Stock Transfer Order for some Warehouse Groups. To replicate 1) Create a new Stock Transfer Order and choose 'Office Stocks' as Warehouse Group and Office as Warehouse 2) Choose a Delivery Point 3) Add a Line Item 4) Click Save and you get the error message | VSUP-1651 | No | No | ||
| VC-1053 | Order - Country Code disappears | Bug | 2.10.0 | 2.5.3 | When trying to create an order from the Vision Interfaces\API\Orders tab, click DP check box blanks the Country Code field on the address. Validation then prevents Saving the Order without the Country Code. | VSUP-1650 | No | No |
| VC-1052 | PO Ack - French language sending in english | Bug | 2.10.0 | Although the PO Acknowledgement is display in French on screen, clicking email from the acknowledgement on the screen sends in English. | No | No | ||
| VC-1041 | DP Whse - Allows UB stock to be returned | Bug | 2.10.0 | 2.11.0 | Issue has been noticed where a Duty Paid warehouse will allow UB stock to be credited back into it on a Return to Stock credit note reason. As the warehouse is duty paid is should not allow UB stock to be landed. | No | No | |
| VC-1039 | Customer reserve storage invoicing | Bug | When trying to run Paid Reserve Storage Invoicing, an error is displayed when opening the screen, and also an error is received when running the invoice data off which causes the process to rollback and not populate everything correctly. | VSUP-1258 | No | No | ||
| VC-1026 | Customer/Contract Price List | Bug | 2.10.0 | On 2.10.0 a Product on a Customer/Contract Price List does not use the Customer/Contract Price List pricing unless the From Qty > 0 | No | No | ||
| VC-1016 | Closing VC during allocating stock | Bug | Closing VC by either end task or clicking the X on the main application and X on the prompt to save when allocating stock doesn't clear the allocation lock | No | No | |||
| VC-1015 | Shippers - Sage account field F11 | Bug | 2.10.0 | In the Shipper Maintenance screen, pressing F11 in the Sage Account field shows a list of Customers - it should be showing a list of Suppliers. | VSUP-1303 | No | No | |
| VC-1014 | PO - F11 search not working after invalid Supplier Account code entered | Bug | 2.10.0 | Navigation Search not working after Pressing F11 on Supplier Account field after an invalid Supplier Account entered. | No | No | ||
| VC-1011 | Shipper Maintenance | Bug | 2.10.0 | When creating a shipper there is the option to add a Currency and/or a Sage Account, but the shipper can be saved without this information. However if you choose to save the Shipper without entering this information you will be unable to use the Shipper in the Purchase Freight Invoice screen as an error is received saying: "Shipper selected does not have a valid VAT code/Currency, Please set VAT code/Currency for the shipper" This information cannot be changed after the first save however since the fields are write-protected | No | No | ||
| VC-1010 | International Bank Details on Pro-Forma | Bug | Related to VC-965 When loading a Pro-Forma invoice International Bank details are not being shown on the invoices despite the details being present | VSUP-1298 | No | No | ||
| VC-1008 | Available Column on Product Maintenance | Bug | 2.10.0 | The Product Maintenance\Warehouse Stock Levels\Available column updates incorrectly when Stock is allocated to a Sales Order | No | No | ||
| VC-1074 | Adding of Customer Code to Order Web API | Improvement | 2.11.0 | This is a requirement to add Customer Code (in addition to Customer ID) on the Order API. | No | No | ||
| VC-1064 | Web extract v4 | Improvement | The product web extract v3 was updated to v4 This introduces a tasting note extract. | No | No | |||
| VC-996 | Customer Web API | Improvement | We have identified 4 fields which are not being set by the API The additional fields are needed as a basic requirement and are VAT Code Currency Status Account Code These are to be added | IMP-6 | No | No | ||
| VC-1076 | Sage 200 - Wait and retry | Issue | 2.11.0 | When all Sage 200 licenses are in use, messages posted from VC fail, instead they should be held, wait, and retry. | No | No | ||
| VC-1075 | Consignment setup - defaulting | Issue | After selecting the warehouse to pickup from, the cut offs are not always used correctly to default the pickup date and expected delivery dates. Also, when only one warehouse is available to pickup from, it should be defaulted to this. | No | No | |||
| VC-1070 | Price List Maintenance - Qty bands | Issue | 2.11.1 | Show the 'Qty to' in the price list maintenance qty bands; currently only 'Qty from' is shown. | No | No | ||
| VC-1069 | Customer search slow | Issue | The customer navigation search is slow when there are many customer records stored. | No | No | |||
| VC-1060 | Creating a PO - receiving an error | Issue | 2.11.1 | When trying to create an PO - receiving an error. | No | No | ||
| VC-1055 | Postings to Sage waiting | Issue | When a posting is attempted to Sage, if the user is already logged in or the available licenses are all used then we hold the posting and retry later, we've noticed that intermittently the messages are lost. We don't know if this is due to a service crash or restart, so changes will be made to the service so that messages can never be lost. In addition, when messages go to the waiting area to retry posting later, we will speed up the retry, as currently if there are 10 messages waiting to post, then it'll retry one, wait the configured time, then take the next one. This will be changed to retry all. | No | No | |||
| VC-1050 | Printing Of Carrier Labels In Allocation Screen | Issue | 2.11.0 | Print label in allocation screen, there are only required if picking up from office or similar. | No | No | ||
| VC-1048 | Consignment cancellation | Issue | 2.11.0 | Issues relating to the cancellation of consignment process fixed. | No | No | ||
| VC-1032 | References to specific warehouses | Issue | The system has some hard coded references to specific warehouses which will be removed. | No | No |
Version 2.11.0 (31/03/2017)
| Issue key | Issue Type | Summary | Affects Version/s | Description | Configuration Needed | Original ID | Licensed Module |
|---|---|---|---|---|---|---|---|
| VC-1031 | Bug | Sales Order - Previous Orders button | If you select a product for a Sales Order line using the Previous Orders button and enter more singles than the Single Per Case for that Product an error is displayed | No | VSUP-1335 | No | |
| VC-1025 | Bug | Customer - Delivery address | Customer - Delivery address ( pop up screen) is not showing country while creating new customer. | No | No | ||
| VC-1024 | Bug | Order Form - API - Line Discount% field | Order Form - Line Discount% field is not populated while importing data from Interface. | No | No | ||
| VC-1022 | Bug | Sales Order Lines - delete key | 2.10.0 | Trying to delete any Sales Order line (apart from last line on the order) displays an error. | No | VSUP-1373 | No |
| VC-1021 | Bug | Report - BI 3 1 2 - Grouping | 2.10.0 | Since VC-378 this report is now showing each individual transaction (the movement date is displayed), it should be grouping as it was before. At the same time VC-1019 report should be updated so that it isn't fixed to 180 days. | No | No | |
| VC-1012 | Bug | Sales Order - Prices and Contract pricing | Any products added to a Sales Order where that Product is on Customer Contract Price List (for the Customer on the Sales Order) is showing zero unit and singles price. - Products that are not on the Customer's Contract Price List are ok. | No | VSUP-1320 | No | |
| VC-997 | Bug | Product Maintenance | 2.10.0 | Some Product Descriptions are blank in Maintenance\Delist Products screen. Product Descriptions are only showing if both Product Description 1 and 2 exist (otherwise it is blank). | No | No | |
| VC-992 | Bug | Orders - Replication | 2.10.0 | On a completed sales order pressing replicate SO causes an error to appear | No | No | |
| VC-988 | Bug | Orders - Credit Notes | Cannot complete a credit note when using a Non-Return to Stock Credit Note Reason Customer had a credit note set-up (but not processed) for an order, using a Credit Note reason that was set up as 'Return To Stock = Yes', however before the Credit was processed the Credit note reason was changed to 'Return To Stock = No' which caused the SO to error when saving or making changed. The issue here looks to be when Crediting stock on an EP SO, as it looks to be trying to create a stock movement when it should not | No | No | ||
| VC-973 | Improvement | Product search - producer name drop down box | 2.6.1 | The product navigation search has a combo box for producer name, this can be quite long for some customers and currently it's not sorted into any particular order, making it difficult to find entries. | No | VSUP-649 | No |
| VC-921 | Improvement | Web API - Analysis codes | The Web API will now support the following: - Ability to send in the customer analysis codes - Ability to send in the order analysis code overrides - Ability for analysis codes to be auto created if they are not currently set up in VC | No | No | ||
| VC-906 | Improvement | EDI New Fields | Allow for the new DO section in the EDI transmission to Vision warehouses. Display the fields on the sales order form, allowing entry where possible for the new fields. | No | No | ||
| VC-854 | Improvement | Sales Order Navigation Search | Add the -Customer Ref -Email Address to the navigation and the search results. | No | No | ||
| VC-841 | Improvement | Sage Posting & Web API - Credit Card Payments | Improve the Sage posting, so that if a credit card payment is selected that the Sage 200 submission is sent containing the payment information to the correct bank account (Sage 50 support will come later). This will allow postings from Vision Commerce for Credit cards to be automatically allocated within Sage. This will work with the Commerce API for Web sites. When the credit card payment is made, the system should post this with the Sage postiing. When no credit card payment is made or only partially made the system needs to check the available credit account balance and decide whether to hold or allow the order to process. | Yes | No | ||
| VC-1051 | Issue | Parcel Carriers - Pickups | 2.11.0 | For pickups from customers, some fields are currently being submitted incorrectly to the parcel carriers. | No | No | |
| VC-986 | Issue | Warehouse - Order Picking Confirmation file - time out | Customer had an issue with an Order Picking Confirmation (OPC) file where the VCWS was timing out when processing the OPC file. | No | No | ||
| VC-909 | New Feature | Sage 200 Integration | We need the ability to read from Sage200 for all Sage enquiries. Also all postings through the Sage Accounts service need to be able to get to Sage200, however this would likely be the output of a file to load and not directly into the Sage200 system. | Yes | No | ||
| VC-873 | New Feature | Parcel carrier integration | Integration with the Vision Live Parcel Carrier Gateway allowing consignments to be submitted electronically to the following parcel carriers: - APC - Yodel - Royal Mail This works for collections from your office or warehouse address. If the collection is from your warehouse using the Vision software suite, they will be able to print the carrier label on your behalf using the data submitted in your electronic order file. Various changes required to Vision Commerce to allow this to work, some initial configuration is required by yourselves to get this working. Summary of the main changes included here: - Fragile product flag - Order screen now includes new options relating to the parcel carrier and parcel carrier consignment information plus delivery status tracker - Submission to carrier via the Vision Live Parcel Carrier Gateway during order allocation - Consignment cancellation in delivery orders when 'unallocating' | Yes | Yes | ||
| VC-1019 | Report | BI Enquiry 3_1_3 Stock Turn Last x Days (Product Summary) | Summarised to provide one line by product. | No | No | ||
| VC-1018 | Report | BI Enquiry 3_14 Total Product Stock | Total product stock enquiry, no matter where the stock this will show the total per product. | No | No | ||
| VC-1017 | Report | PO Left - Extra | New Report has been added with modified product details providing the second product description line to be used to provide instructions to the supplier for things like capsule, closure, label instructions. | No | No | ||
| VC-922 | Report | Report - Sales analysis by customer type | In conjunction with VC-921, a new sales analysis report will be created utilising the 'Customer Type' analysis code from the sales order screen. | No | No | ||
| VC-694 | Report | BI - 5 1 1 SO Lines | 2.4.2 | This report is titled Sales, Outstanding, SO lines but is shows complete orders | No | No |
Version 2.10.0 (03/01/2017)
| Issue key | Summary | Issue Type | Affects Version/s | Description | Configuration Needed | FusionUID | Licensed Module |
| VC907 | New Sales Order Entry | New Feature | When adding a new sales order, prior to the order form place a new form which will allow the quicker searching of customers. The form should allow the search of Customer Code (first field) Customer Name Postcode Telephone Number Contact Name It should then quickly present the possible matches, the user then selects and the usual form opens with the customer loaded. If the customer types the customer code and it single matched when they hit ENTER after entry of this first field and there is an exact single match it should just open the customer on the sales order form. | No | No | ||
| VC346 | New Price list format - 'Costs Plus %' | New Feature | On Price List maintenance there are 3 price formats at present. (range Price, Range % Price and Range Price Discount). Enhancement to add another which would be Cost Plus %. This would take the cost of the product from the product file, add the storage/rent, freight, estimated transport charges and add a set % to this to calculate the price to sell at. This could still be done by quantity eg 1-6 units Cost price plus 20% 7-12 units Cost price plus 19% 13+ units Cost price plus 18% | No | No | ||
| VC967 | Order Entry | Issue | 2.6.0 | When searching for a product for an order customers need to know what stock there is of the product otherwise you have to guess which one to pick. Whilst we removed the general search from the navigation this is needed for order entry, or we need the ability to filter and search which will list the product. In addition the results need to show SS, SPC, Vintage- Currently SPC is missing. | No | No | |
| VC968 | VBI reports | Issue | A full refresh from the master DB will take place. ** Please check permissions after this has been implemented, it is likely you will have to reset permissions. | No | No | ||
| VC955 | Delisting Flag | Issue | 2.6.1 | When trying to delist or un-delist a product the box change be changed (either can be ticked or un ticked) but saving does not necessarily commit the change on the first save | No | VSUP-412 | No |
| VC951 | Reserve Stock Order - Minimum value | Issue | 2.8.0 | The minimum sales price which a reserve customer wants for the sales of their stock is not being checked during the validation of the sales order. A warning will be shown if you try to sell below stating what the minimum is. WARNING only you can still proceed. | No | No | |
| VC889 | Issues with various BI Enquiries | Issue | 2.6.0 | A few issues have been found whilst testing the new BI module in VC. Refers to 3_1_2 and 3_3 | No | No | |
| VC865 | Price list screen improvements | Improvement | The screen is not so user friendly for the following price formats: Range % Discount Range Price Discount + the new 'Cost Plus %' from VC-346 There are also some issues with these formats in the screen, here we will address all of these and make some other user friendliness improvements. | No | No | ||
| VC856 | API - View LOG table | Improvement | 2.5.3 | The API log will be added within the API interface screen. This has been added to allow the API user to discuss issues with the external senders without support needing to get involved. | No | No | |
| VC637 | Stock Transfers - Generate PO | Improvement | Stock Transfer orders should create a purchase order which should be receipted against, allowing users to enter information especially when transferring to rotation warehouses. | No | No | ||
| VC2 | Mailing - Marketing extract / audit trail | Improvement | Dynamic mailing list creation, to allow better lists to be generate for the likes of mail chimp Mailchimp file format guidelines: http://kb.mailchimp.com/lists/growth/format-guidelines-for-your-import-file | ||||
| VC971 | EP SO - PO link | Bug | The PO link is sometimes showing the order line allocated to a PO when it isn't actually allocated to it. | No | No | ||
| VC970 | Invoice Line Totals | Bug | 2.6.1 | Under certain conditions it is possible for an invoice line total to show differently to the sales order line totals Sales Order has 3 lines. - Two of the lines have a line total of zero. - One lines has a line total of 0.01 The Sales Order is correct. The invoice raised against this order is showing two lines with a line total of 8.59 and one line of 0.01 which is not correct. This is because the single price is missing from the pricing tables for the product, so it is taking the case price and putting it on the invoice after calcuating the bottle price and ignoring the fact it is actually to be 0 | No | VSUP-604 | No |
| VC965 | International Bank Details | Bug | 2.6.1 | The international bank details are not showing on the standard invoice. A new invoice layout with these has been added. | No | VSUP-484 | No |
| VC954 | Surcharge record in SOP documents | Bug | 2.8.0 | If you add a surcharge on an order and use the pre invoice function a surcharge invoice is left behind in the 'Pending Invoices' tab until the order is delivered. | No | No | |
| VC953 | Liv-ex 'Find Matches' error. | Bug | When clicking 'Find Matches' and no result is retrieved the program errors. It does this when LWIN is wrong or there are no values to report | No | No | ||
| VC948 | EX PO - Opening | Bug | When you try and open a EX PO from POP documents you get an error. | No | No | ||
| VC947 | Financial Credits - Reason is empty | Bug | 2.4.3 | When choosing Financial and Credit Note on a Stock and En Primeur Sales Orders the Credit Note Reason field shows no values to choose from. | No | VSUP-354 | No |
| VC946 | Amending Sales Orders | Bug | 2.6.1 | Prices and Line Totals are not updating correctly when changes are made on Sales Order Lines. Line Total only updating when Quantities changed. When Quantity changes the Unit and Singles Price reverts to Selling Price in Product Maintenance. | No | VSUP-344 | No |
| VC937 | Financial Invoices - Surcharges | Bug | 2.6.1 | Sales Orders are showing in Pending Invoices and Historical where they were Financial Invoices and have Surcharges, but have actually been invoiced. | No | VSUP-285 | No |
| VC924 | Archiving Analysis Codes | Bug | When archiving Analysis codes there is a problem in that if you archive the first analysis code on the (usually Account Manager/Sales Rep) it will display the archived message for any order that you try to open. | No | LFN-878-90899 | No | |
| VC916 | EP order split | Bug | Customer has created an EP order and part allocated it in 2 halves, the first part of the order was allocated as a Underbond Transfer order and sent to the warehouse, the rest of the order was allocated as a Duty Paid Home order. When the orders were pick confirmed and updated back into Vision Commerce, Duty and VAT invoices were generated for the Duty Paid order correctly, however a DVAT invoice was also generated for the Underbond Transfer. | No | VSK-693-10676 | No | |
| VC888 | Web Extract - missing lines | Bug | 2.3.4 | Product not showing on Daily Extract when remaining quantity less than Singles Per Case value When running the Daily Web Extracts - Product Extract, if a product has less bottles in stock than the number of Singles Per Case on product then the Daily Web Extract will not include the product. | No | XBM-532-79866 | No |
Version 2.9.1 (estimated 12/11/2016)
Has been changed to v2.10.0
Version 2.9.0 (20/10/2016) - Specifically for one customer so not generally made available.
VC945 - Grouping of PDF invoices going to the same customer and providing a summary and total of the charges.
Version 2.8.0 (07/10/2016) - Specifically for one customer so not generally made available
VC944 - Ability to invoice a sales order in full and post to sage prior to allocation / confirmed delivery.
Version 2.7.0 (01/10/2016) - Specifically for one customer so not Generally made available
VC925 - Trading Reserve Improvements - now with the ability to pick specific rotations which a customer wishes to sell and set a minimum price they want to obtain from the sale.
VC943 - Secure Connections to Mail Server - implemented for google mail
VC936 - New BI Report added 5/4/3/7
VC923 - (BUG) VAT is being included on underbond PO
Version 2.6.1 (20/08/2016)
VC913 - A bug existed where the users were unable to open purchase orders with visible data from the navigation search
Version 2.6.0 (02/08/2016)
-- NOTES --
A license is required for the business intelligence module, there are two parts to this module the reporting and the designer. Existing customers will be provided a reporting license free of charge. If you want the designer module then there is a charge for this module, please contact customer services for this.
The same warehouse customer code and warehouse site code can not exist against more than 1 warehouse prior to the upgrade
New shipping invoice feature requires a Sage Acconts code setup against the shipper with a valida VAT code, currency and nominal for posting to sage.
| Issue key | Summary | Issue Type | Affects Version/s | Release Notes | Fusion Reference |
|---|---|---|---|---|---|
| VC894 | Error opening EXC orders | Bug | When opening EXC orders following error was shown : " INSERT failed because the following SET options have incorrect settings:‘QUOTED_IDENTIFIER’. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations". | ||
| VC892 | Client application login version check | Improvement | When logging in to the application, it compares it's version number to the server version, if they do not match then the user is not allowed to log in. Version numbers are currently: x.y.z x - Incremented on a major release y - Incremented on an improvement release z - Incremented on a bug fix release With this change, version numbers will be changed to also allow the following format: x.y.z.s x - Incremented on a major release y - Incremented on an improvement release z - Incremented on a bug fix release s - Incremented on a bug fix release, where an application release is not necessary, and only simple changes to the server side are necessary. This will allow us more flexibility in issuing some server side fixes more quickly to customer systems, meaning that the customer does not always have to update their local / terminal server installations. | ||
| VC884 | Goods Received BBD field is too short | Bug | 2.5.3 | BBD field in VC only allows 8 characters - it should allow 10. This causes an error during the Goods Received file import process. | ZKE-734-50528 |
| VC872 | Error - System Verification for Sage Invoices | Bug | Customer has reported an issue when trying to use the System verification of the Verify - Sage Invoices. Error received is shown in !TVL Out of range error.PNG|thumbnail! | QXV-144-23423 | |
| VC855 | API - not passing product descriptions | Bug | 2.5.3 | When (Product Codes) ItemNames are coming in with an ' in them they are failing with the an unclosed quotation mark errpr message. | |
| VC825 | Business Intelligence (BI) | New Feature | The new Vision Business Intelligence v1.0.2 is now available in Vision Commerce, which now includes reports and a report designer. | ||
| VC819 | Encryption of Credit Card Information | Issue | The fields on the order form are not PCI compliant and we need to meet the requirements. When the order is entered the fields are shown, but upon close and re-open the order or any future opening of the order the fields should not be fully shown. Credit Number should only show the last 4 digits the rest should be ***** Card Security No should only show as **** Within the database the credit card number should be encrypted as should the card security number. | ||
| VC818 | Navigation Search - Product - Speed Improvement | Issue | Speed up the Product search on the navigation panel. This is also used for order product search so check it does not hinder you too much for order processing. Oct20,2016 - We have made a change for v2.9.1 which will return this feature in a more controlled way to allow it to be used for order searching again, the previous F11/F12 search was too vague and causing numerous speed issues. Short term use Stock Enquiry - Report 13 which will show you what you need for order entry. | ||
| VC816 | Deliver Order Form | Issue | On the left hand side of the form add in the Order Date and Allocation date to the right og the delivery cost. Adjust the default opening to ensure the fields can be seen. Add a filter in the top for allocation date "up to" | ||
| VC755 | Document Management - sort order | Improvement | 2.4.3 | Sort EDI Report lists in Document Management screen by Received Date descending.The list currently appears in no order (which leaves customers thinking the most recent files have not been imported). | |
| VC754 | Customer Reserve field length | Improvement | Stock Exception report import needs to allow up to 12 characters for customer Reserve field Error thrown during import of Stock Exception report into VC if the Reserve (customer code) field is longer than 8 characters. This field length was increased to 12 characters in VW and needs increasing here. | ZZW-267-57553 | |
| VC709 | Historical Sales Order Information | New Feature | Adding Historical Sales Order Database to the system. This is to allow customers who take on Vision Commerce to load their old sales order information which can then be viewed in VC in the future. Vision Commerce will store sales order header and details from legacy systems and to be able to output this information both within Vision Commerce and through the Web API or Live Views. | ||
| VC703 | Delivery Point Maintenance | Improvement | 2.4.2 | You cannot open the Delivery point maintenance screen from the navigation search results | |
| VC697 | BI - GRN Accruals | Improvement | 1. Add the currency for the order 2. Remove time from date fields | ||
| VC696 | BI - Sales Margin Summary EP Campaign | Improvement | 2.4.2 | The date fields all have times in them, but this appears to always be 00:00 so can the time be removed | |
| VC685 | Stock Cost Adjustment - product code validation | Improvement | If you enter the product code before the warehouse, you get an error message, if you click ok the product code shows in the product code column, but when you select the warehouse nothing is brought back | ||
| VC684 | Stock Adjustment - warning if new rotation | Improvement | 2.4.2 | You can stock adjust onto a rotation that does not exist in the system. It may be that this is correct, but a warning message to state that this rotation does not exist and would you like to create it would be helpful, so the user does not create incorrect rotations | |
| VC683 | Report - Stock Movement Postings Report | Improvement | 2.4.2 | When opening the report, the navigation panel on the left hand side is showing the pkmovementtype rather than giving it the movement type name | |
| VC679 | User Maintenance - archive function | Improvement | 2.4.1 | A user should not be able to be archived and left as active. If we archive then the user is set as inactive | |
| VC646 | VC - SOP Credit is inconsistent | Improvement | 2.3.4 | The process when you credit a sales order is not clear and sometimes illogical. The SOP screen should be SOP Returns with the detail screen being the credit authorisation. This is what it does but it is worded incorrectly. We want to allow multiple reasons to be entered for one line, so you can Send 5 to a customer, and they return 3, 2 because they are damaged and 1 because it was destroyed (so not coming back into stock) There also needs to be the reason decision on each line, and depending on the reason used the system will determine whether the goods need to be returned to stock and whether the warehouse you selected for the return needs a rotation. You will then not be able to change those after you process and you will not be able to change anything once it is processed. But you will be able to enter the information. Also the logic of having to remember to hit save all the time is being resolved and opening the credit screen will now save and each line you process will save as you hit the process button. | JAY-160-76125 |
| VC629 | Add date landed to stock enquiry | Improvement | 2.4.2 | On the stock enquiry screen (from Enquiry menu) add a column on the right showing the date the stock was received (date received from tblstock) | |
| VC401 | Posting Shipping Invoices | New Feature | ** Current Process ** When stock is landed onto the system we store the freight and insurance charges for this based on the charges setup in the country or the region tables, and a default standard cost is used for the purposes of working out margins. These costs are stored in the tblStock table. ** NEW Business Process ** To provide more accurate reports we will record freight invoices and register these in a new table, and it will contain the FreightCostsperUnit We need to have a new screen designed which will allow the entry of a freight invoice, the user will then select --The purchase orders to which this freight invoice is for --The lines on the selected purchase order to which this invoice should apply. We will record this information in a, as this needs to be posted into Sage we also need to store --VAT Code --Invoice Number --Nominal Code --Invoice Date We will apportion the freight costs between all the stocks relating to the freight invoice, and we will post in the Stock Cost table an entry for each Rotation Stock line to which we are referencing for this invoice. As invoices can be in multiple currencies its important that we allow multi currency entries with the exchange rate shown (and adjustable) from the curency tables, and when we post we need to post this in GBP onto the VC tables and in the shipper currency for the Sage posting. This does mean that the shipper table needs to have a currency field, and Sage Account code field adding to it, entry should only be possible of a freight invoice is both fields have been setup, and once setup they can not be changed at all EVER. There also needs to be a new configuration option, available to the customers on their Admin screen. This option should be called "Use Actual Freight Costs for Stock Movement Postings" If this is true then when the tblStockMvoement record is created for stocks leaving instead of us using the region/country default cost per case we should look to see if exists an entry in the tblStockCost and then use this for the freight costs on the tblStockmovement entry. At the point of purchase order entry, the user should be allowed to specify the shipper and will need the ability to store an expected cost for the purchase, if this is used then this becomes the cost which is used for shipping rather than taking it from the country/region and this again will be over wrote by the invoice being posted against the puchase order. |
Version 2.5.3 (01/04/2016)
| Key | Summary | Issue Type | Affects Version/s | Fix Version/s | FusionUID | Apply License | System Config | Release Notes |
|---|---|---|---|---|---|---|---|---|
| VC827 | Analysis code grouping | Issue | 2.5.3 | No | No | Whilst investigating VC-704 we found that the analysis code grouping had some issues and this needed tidying up. Access to the system analysis groups was removed to ensure reporting integrity | ||
| VC822 | Currency Rate | Bug | 2.5.0, 2.5.1, 2.5.2, 2.5.3 | 2.5.3 | DTH-304-68897 | No | No | This appears to have happened since the ISO code was added in 2.5.0 , customers were unable to change the rates |
| VC821 | Emailing of Reserve Stock Report | Bug | 2.5.3 | QJX-657-88711 | No | No | Customer is able to load the reserve stock report, however when clicking the Email button to send it out an 'Object reference not set to an instance of an object' error is thrown to the screen. | |
| VC820 | Customer Delivery Service | Bug | 2.5.3 | 2.5.3 | VHH-135-76746 | No | No | If you set up a delivery service against a customer, it should then use this delivery service as a default when placing an order, but this does not happen |
| VC817 | SOP Documents - Preview not working | Bug | 2.4.4 | 2.5.3 | VMM-583-22776 | No | No | When previewing an invoice in pending invoices, it does not show any product lines, only the delivery charge. |
| VC815 | Customer Maintenance | Bug | 2.5.3 | 2.5.3 | No | No | Error when saving a new customer. Unable to insert a new customer (via the <Customer Maintenance screen). | |
| VC812 | SO Lines Issue when using unpaid reserves | Bug | 2.4.4, 2.5.3 | 2.5.3 | BGJ-320-26214 | No | No | Customer noticed an issue where when using stock that was in unpaid reserves, once the order was allocated the stock would go into negative quantities, this was on VC 2.4.4 This caused the customer issues when the order was submitted to the warehouse as it caused the files to be rejected, this only looks to happen when the entire quantity of that particular stock is used. |
| VC811 | API - postcode not passing through from XML | Issue | 2.5.1 | 2.5.3 | No | No | Internal Issue | |
| VC809 | BI reports - error due to volume of data | Issue | 2.5.3 | No | No | 3x BI reports are reporting an error "ERROR GETTING BI REPORT" when the customer has a large volume of data: 2 1 1 2 1 2 2 1 3 | ||
| VC807 | Mixed cases being sent to the warehouse incorrectly | Bug | 2.5.3 | No | No | If there's a mixed case with 3 component products, and we order 5 cases of it, the quantities in the output file are wrong (5 singles / 10 singles / 10 singles). | ||
| VC799 | Customer Reserves - once depleted | Issue | 2.5.3 | EEV-345-93978 | No | No | If a customer has reserve stock and then the stock is moved to another warehouse, the original record is still showing in customer maintenance as 0 qty as well as a new record for where the stock is now held | |
| VC798 | Error opening up API customer in VC | Issue | 2.5.1 | 2.5.3 | UKX-663-33209 | No | No | As description |
| VC796 | API, external order ID not being populated in VC | Issue | 2.5.1 | 2.5.3 | No | No | The <orderID> from the Xml file should populate to the Customer Ref in VC. The <OrderNumber> from the XML file should popluate to the notes field. Neither of these are being populated so the user has no idea what the details are from the external sender. Please reference https://visionsoftware.atlassian.net/wiki/pages/viewpage.action?pageId=14843908 for further details under the WEB API for Inbound Customers / Orders section. | |
| VC787 | Double Quotes in Tasting Notes do not process on Web Extract correctly. | Issue | 2.3.4, 2.5.0 | 2.5.3 | TAU-535-60710 | No | No | Convert any Double Quotes to the correct escape sequence for the Web Extract. |
| VC784 | Order can be allocated on Hold, this does not generate the SO Submission | Bug | 2.3.4, 2.5.0 | 2.5.3 | YLK-235-18661 | No | No | Orders can be placed on hold and can then be allocated . Customer had an order that was placed on hold and was then allocated while on hold. This can cause the SO Submission to not generate which can cause orders that are meant to go to the warehouse to be missed. |
| VC783 | Pro-Forma Layout | Bug | 2.5.3 | No | No | There are no bank accounts appearing on the pro-forma invoice. | ||
| VC782 | Customer Bank Account | Bug | 2.5.3 | No | No | This is showing the account name and not the short code. The short code is used to identify the account wheras the names could all be the same so we need to display the short code on the customer setup. | ||
| VC780 | Removal of VIC objects | Issue | 2.5.3 | No | No | As VIC hasn't been supported for some time, now we will remove the last left over VIC components. | ||
| VC778 | Non existent customer code | Bug | 2.5.3 | No | No | If you enter a customer code for one which does not exist the system gives a "there is no row at position 0" error message. The message should be in english and say "No such codes code exists" | ||
| VC775 | Product Codes file generation issues | Bug | 2.5.0 | 2.5.2, 2.5.3 | No | No | A few issues have been noticed when generating Product Code files for submission to the Warehouse, information on the files is being pulled from the wrong locations. The file is only being generated once, it should be generating for all the warehouse sites. Attached file is an example of the Product Code files generated. | |
| VC774 | PO files sending over incorrect information to warehouse | Bug | 2.5.0 | 2.5.3 | No | No | A PO was created and the file generated but the file that was sent to the warehouse is incorrect (customer code & site code). | |
| VC773 | "Surchages" label should read "Surcharges" | Issue | 2.5.0 | 2.5.3 | No | No | in EP Order\Invoicing tab\Total section, "Surchages" should read "Surcharges" | |
| VC769 | Ampersand '&' in Goods Received XML is not handled correctly | Bug | 2.5.0 | 2.5.3 | No | No | If there are ampersands in the XML file from VW/VEDI, the file is not processed correctly in VC. This may affect all of the XML files received into VC, so please check the processing for all types. | |
| VC768 | Warehouse Submissions Orders Awaiting Submission Results - Column typo | Issue | 2.5.0 | 2.5.3 | No | No | Bttles column should be named 'Bottles' | |
| VC766 | AWRS Requirements | HMRC | 2.5.3 | No | No | Alcohol Wholesaler Registration Scheme – displaying AWRS Unique Registration Numbers - this will be on the invoice as per requirement HMRC is implementing the Alcohol Wholesaler Registration Scheme (AWRS), to tackle alcohol duty fraud. The scheme was announced in the Chancellor’s Autumn Statement 2013 and legislation has been introduced in the Finance Act 2015. We will begin to accept registration applications for the scheme from 1 January 2016 until 31 March 2016. As part of wider changes taking place to tackle alcohol fraud the new scheme will introduce the requirement for all wholesalers to display their HMRC AWRS Unique Registration Number (URN) on all sales invoices, with effect from 1 April 2017. The number can be positioned anywhere on the invoice and there is no requirement to include the AWRS URN on any other documentation. Displaying a valid AWRS URN will ensure alcohol retailers and other trade buyers can be confident that they are buying from legitimate, HMRC registered, wholesalers. The format for the Unique Reference Number (URN) is: XXAW00000123456 Character Position Format Character 1 X Alpha Character – Always “X” Character 2 X Alpha Character Characters 3 to 4 AW Always "AW" Characters 5 to 9 00000 00000 (always zeros) Characters 10 to 15 123456 Numeric Industry bodies have welcomed the registration scheme as a key weapon in the fight against the illicit alcohol trade. | ||
| VC764 | Stock Availability for Components | Bug | 2.5.3 | No | No | Stock reports are showing the total singles of the components rather than the total packs. | ||
| VC762 | Unable to create a manufacturing Product | Bug | 2.5.0 | 2.5.3 | No | No | When creating a manufacturing product you have to set the singles per unit to equal the number of component products, this should not be mandatory for manufacturing products | |
| VC761 | Available Stock incorrect on Allocating Order | Bug | 2.5.0 | 2.5.3 | No | No | Upon allocating an order the available stock qty in product maintenance is incorrect | |
| VC760 | Stock Levels incorrect on Product Maintenance | Bug | 2.5.0 | 2.5.3 | No | No | When placing an order for a product that has component parts, the stock levels iagainst the component products within Product Maintenance is incorrect upon saving the order | |
| VC758 | Pre-mixed Product with components SO XML file quantities incorrect | Bug | 2.3.4, 2.5.0 | 2.5.3 | ZBM-288-29141 | No | No | A pre-mixed sales order once the XML is generated, the quantities inside the file have been multiplied by the actual line number |
| VC757 | BI 5_6 General Sales Report Issues | Bug | 2.5.0 | 2.5.2, 2.5.3 | PRM-645-26043 | No | No | There are several issues with this report: 1. The Customer Analysis codes (& names) 1, 2 & 3 displayed on the report are incorrect - CA 1 should be Account Manager (currently 'Type' is shown), CA 2 should be 'Type' (currently 'Classification' is shown) & CA 3 should be 'Outlet' (currently 'Type' is being shown again). 2. Now that the report will show just the 'Fixed' analysis codes, could we show the actual names for the Code & Name fields ? eg show 'A/C Manager Code' as the column header instead of 'CustAnalysisCode'1 & 'A/C Manager Name' as the column header instead of 'CustAnalysisName1' 3. There are spelling mistakes in the column headers for Product Analysis codes/names - could we do the same as for point 2 above ? 4. No product analysis codes are being displayed. This is being raised as a result of investigating PRM-645-26043. |
| VC756 | Goods Received XML file spec RotnNotes field length not long enough | Bug | 2.4.3 | 2.5.2, 2.5.3 | No | No | An error is thrown during file import process if the RotationNotes are greater than 30 characters on the Goods Received file. | |
| VC751 | Interfaces SO file upload | Bug | 2.5.3 | No | No | Uploaded SO file data is not being saved to the database. | ||
| VC748 | Update purchase cost option | Issue | 2.5.3 | PSU-749-32395 | No | No | When using the update purchase cost option, it updates both the Underbond Purchase cost and the Duty Paid purchase cost field with the same last invoiced price. The calculation needs to be correct | |
| VC747 | Incorrect currency on reserve PO | Bug | 2.5.3 | SCH-461-10497 | No | No | When creating a transfer to reserve customer and the customer is non GBP currency the auto generated PO is not showing in the currency of the customer. The value is correct but shows in £ This also shows in stock enquiry as £ but the non GBP figure | |
| VC746 | POP VAT Analysis screen, Net value not updating when Goods Value or VAT Value is modified | Issue | 2.5.3 | ICD-355-63411 | No | No | Customer noticed when testing VC 2.4.2 that on the POP VAT Analysis screen when updating the VAT Value or the Goods Value the Net Value field is not updating, the posting has the correct updated values but the POP VAT screen Net field does not update. | |
| VC745 | Replicating a product does not copy over the Duty Paid Purchase cost | Issue | 2.4.2, 2.4.3 | 2.5.3 | ICD-355-63411 | No | No | Customer noticed when testing 2.4.2 that when replicating a product the Duty Paid Purchase cost columns are not transferring over. |
| VC742 | Non vintage LWINs being converted to 9999 instead of 1000 | Issue | 2.5.3 | No | No | Non vintage LWIN18s are being calculated with 9999 as the vintage part, and this should be 1000 instead. | ||
| VC740 | Stock Record Card reading start date | Issue | 2.4.3 | 2.5.3 | No | No | The stock Record Card is using report start date but the window title does not say so, there is also an unnecessary column at the end. | |
| VC705 | Site code used for PO and Product XMLs does not match that for SOs | Issue | 2.4.2 | 2.5.3 | No | No | PO and Pre advice XMLs take the site code from one table and SO XMLs from another | |
| VC704 | BI Sales By Product | Issue | 2.4.2 | 2.5.3 | No | No | In BI report - Sales by Product 1) Columns 1 & 2 are calculating incorrectly and not showing the correct period start and end dates 2) Columns Monthnontradetotalsales & monthtradetotalsales are incorrect | |
| VC701 | Sundry Charge can be added to completed/invoiced sales order | Bug | 2.5.3 | YFB-575-80777 | No | No | Issue noticed on customer system where a Surcharge can be entered on a completed and invoiced Sales Order, however this surcharge entry will not be invoiced as the order has already been invoiced and completed. This can cause an imbalance between the order value and the invoice/sage posting. | |
| VC699 | BI - Negative Underbond Price | Issue | 2.4.2 | 2.5.3 | No | No | On some reports the Underbond price per case and price per bottle are showing a negative figure Reports affected Valuation by Product Valuation by rotation Valuation simplified This was caused by the product price being set to the value of duty or less | |
| VC691 | Underbond Delivery Address - Saved with no Data | Issue | 2.4.2 | 2.5.3 | No | No | If you save a new underbond delivery address, but only enter the code, it will save, but not show up in the search. If you then try to add it again, it tells you it already exists | |
| VC690 | Price List - start date in the past | Issue | 2.4.2 | 2.5.3 | No | No | When creating a price list, you can set the start date prior to today's date | |
| VC688 | Warehouse Submissions - Sales Order - Resubmit | Issue | 2.4.2 | 2.5.3 | No | No | In warehouse submissions - sales Orders, the orders submitted and resubmit (editable) tabs now appear to be the same | |
| VC686 | Rotation Maintenance - duplicate rotations | Issue | 2.4.2 | 2.5.3 | No | No | When rotation maintenance is used, the users have ability to enter a rotation that already exists against that product and this causes duplicate rotations in the database Although users have been told not to do this, and it is stated in the wiki, there is still the possibility they will use a rotation that already exists. This in turn affects their stock records and gives incorrect information on their stock levels When using rotation maintenance, a validation should be done to ensure the rotation does not already exist, and either give a warning message or stop them actually being able to create the record | |
| VC673 | Sales Order Processing | Issue | 2.4.2 | 2.5.3 | No | No | Improve the form to help the flow work more efficiently, this can be achieved by forcing input before continuing because : If you input the warehouse group and line items before the customer code, it write protects the customer code field and you cannot then process the order If you input line items before warehouse group, it produces an error message, but write protects the warehouse group field Added validation so you cannot input line items until both the customer code and warehouse group have been input | |
| VC672 | EP Allocate order - Only show live campaigns | Issue | 2.4.2 | 2.5.3 | No | No | Exhausted inactive campaigns should no longer show in the allocate EP orders screen | |
| VC662 | Navigation Screen - Product Search | Issue | 2.4.1 | 2.5.3 | No | No | Search Panel:- Product Description - Have an automatic wildcard search Producer Code - Add Producer Name - Drop down Vintage - make sure it works Single Size - dynamic list Unit Size - Remove Price per bottle1 -Remove Price per bottle 2 - Remove Delisted - Default to False Campaign - remove Country Name - dynamic create drop down Product Type Code - Remove not in results Colour - Remove not in results Region Code - dyanmically create drop down list Region Name - Remove Commodity Code - Remove not in results Duty Rate Code - Remove Group Code - Remove Group Description - Remove Main Supplier Name Remove Warehouse Group Code - Remove Results Grid:- Put column names in the same order as the search columns Only show columns in the results that you can search on | |
| VC658 | Navigation Screen - Customer Search | Issue | 2.4.1 | 2.5.3 | No | No | Search Panel:- Address Line 2 - Remove does not show in results Town - show in results County - Remove Group Account - show in results Reserve Warehouse - show in results Sales Rep Drop down of all sales reps Cust Type - Drop down of all customer types Outlet - Drop down of all outlets Area - Does not work - Remove Status - Default to Live Results Grid Put column names in the same order as the search column Ensure column names match those in the search panel and only show the columns that are in the search panel | |
| VC657 | Navigation Screen - SO Search | Issue | 2.4.1 | 2.5.3 | No | No | Search Panel Order Date - it is not clear what date format the user needs to use - show format required e.g. dd/mm/yyyy (date picker preferred (defaulted to empty however)) so the user knows how to enter the date Order Type - Not clear what the user needs to input, so drop down of the order types Order status - Not clear what the user needs to input, ability to pick multiple statuses, code and description to be shown Order on hold - default to false Proforma Orders - default to false Account - Change to 'Customer' the same as on the order screen Account Name - Add this into the search with an automatic wildcard search and call it 'Customer Name' same as on the order screen Results grid:- Put column name in same order as search columns Only show columns that you can search by Status - show full name not just the code | |
| VC655 | Navigation Screen - PO search | Issue | 2.4.1 | 2.5.3 | No | No | Search Panel:- Order date - not clear of the correct date format add dd/mm/yyyy calendar style picker (defaulted to empty however) so user knows which format to use Order Type - not clear exactly what user needs to input - have a drop down selection list Order Status - not clear exactly what user needs to input - would like a multi selection here Supplier Name:- Add this to field after the Supplier Account and have an automatic wildcard search Results grid:- Put column names in the same order as the search columns Ensure column names match those of the search columns ie Account/Supplier Account which match the PO screen | |
| VC634 | On UB Orders duty is being taken off for the price list price in GBP even when price list is not GBP | Bug | 2.3.4, 2.4.1, 2.4.2 | 2.5.3 | No | No | When an order is placed underbond (Stock or Ex Cellar) and a price is pulled from a price list the duty is taken off the price list price. This works fine when the price list is in GBP. However, when the price list is NOT in GBP the duty is still taken off as the GBP figure which makes the price on the SO incorrect. |
Version 2.5 (01/12/2015)
** There are some new features PLEASE READ THESE NOTES CAREFULLY **
| Key | Summary | Issue Type | Affects Version/s | Fix Version/s | FusionUID | Apply License | System Config | Release Notes |
|---|---|---|---|---|---|---|---|---|
| VC-772 | VC Web API mapping fields corrections | Improvement | 2.5.0 | No | No | Datatype Issues for some fields which were stopping the API working correctly have now been addressed | ||
| VC-771 | Paid Reserve Rotation Stock Report 3/11 | Improvement | 2.5.0 | No | No | New Report Added 3 -11 | ||
| VC-770 | Rotation Stock Report 3/10 | Improvement | 2.5.0 | No | No | New Report Added 3 - 10 | ||
| VC-763 | Add ISO field to the Currency Maintenance screen | Improvement | 2.5.0 | 2.5.0 | No | No | Add a field for the ISO code to the Currency Maintenance screen. This is required for VC-413 implementation | |
| VC-708 | Paid Reserve Storage Invoicing | New Feature | 2.5.0 | Yes | Yes | The current "Paid reserve storage invoicing" needs to work so that the Paid Reserve Storage Invoices can be produced and sent to the user running the routine (not the customers directly) and a file produced which the user can upload to Sage for the postings. Customers wishing to use this module should request the module activation as it also requires Invoice customisation. | ||
| VC-707 | Sales Order - Customer Analysis | Improvement | 2.5.0 | No | No | *** THIS ITEM STANDARDISES DATA *** Following the standardization of the Customer analysis codes the first two fields of the analysis codes should be Sales Rep -> Account Manager Cust. Type -> Type Then Outlet Area Source Division Classification On the Sales Order form we only showed the Sales Rep (Account Manager) however we will be adding the Sales Type to the form as well and both will be able to be adjusted. All BI reports will then work as per their name and as expected. Many customers have this standard field structure already the changes effect only 10% of customers where the fields need to be moved. ** IT IS VERY IMPORTANT FOR CUSTOMER TO CHECK THIS BEFORE THEY SIGN OFF FOR GO LIVE ** | ||
| VC-680 | Brokerage Charges | Improvement | 2.4.2 | 2.5.0 | No | No | There is a new requirement for a client that the brokerage rate for trading customer reserves to be able to be set as a percentage at order level rather than customer level. What is changing: The brokerage is stored against the customer should be the defaults and we will be allowing each order to be adjusted to the agreement for the order. So on a sales order there needs to be a way to adjust and store the % rate entered which will then be applied to the order value to calculate the brokerage rate for the deal. Conclusion : The rate should be set up on the customer as a default and be changeable at sales order level. The Customer Reserve trading report output needs to be adjusted to show the order level % and admin charges. As there is a possibility of manipulation of these figures we will not be posting this directly to Sage so when the report is run a further option at the bottom will generate a Sage50 export file in CSV format for the user, this will generate transaction type SC for the import file which will generate a credit note against the customer who sold the stocks. | |
| VC-612 | Web API for Customers and Orders | New Feature | 2.5.0 | Yes | Yes | Create a web API This is to replace the old "CSV" order file system which the system had in existance, this is in addition to the CSV output and the Live view. Allow new customers and sales orders to be received through the API Load the customers and orders and add forms in VC to be able to see those customers and orders. Prior to posting them into the main system. Add some API variable namely - Default customer account for orders - Qty or "Qty/SubQty" in use - Default order type for orders. Allow processing of customers - allocate a new customer code and open the customer setup screen prefilling the information from the API. - normal form process would then be maintained at the save point. Allow processing of orders - allocate a customer code if needed and an order type - open the order form pre-filling all the information from the API db's - normal order process would be maintained at the save point. | ||
| VC-603 | Stock navigation results to show the cost of stock | Improvement | 2.5.0 | KIR-348-68911 | No | No | On the Stock Navigation results panel could we show the cost of the stock as a column | |
| VC-528 | Fixed analysis captions | Improvement | 2.5.0 | QMZ-416-82622 | No | No | The main customer analysis code captions should not changeable, these should be fixed (non changeable) in order for BI reports to work correctly. Customers and Products have codes, we have system analysis codes and user analysis codes, only the user analysis codes can be modified by Vision customers. There are other optional analysis codes which can be changeable In order to sort the issue all clients setup will have to have a unique script written to move the codes to their new positions which will allow reports to work correctly. SEE ALSO VC-707 *** IMPORTANT *** | |
| VC-519 | Enhancement to allow users to remove orders from SO Submissions | Improvement | 2.5.0 | KBY-979-18696 | No | No | Request for an enhancement to allow users to remove orders from the SO submission screen if they were allocated in error. | |
| VC-487 | Sage Line 50 2015 & 2016 Integration | Improvement | 2.5.0 | No | No | Integrate VC with the new Sage Line 50 2015 & 2016 objects to allow customers with this version to use it with VC. | ||
| VC-478 | VC- Link customer to specific bank account | New Feature | 2.5.0 | IMN-357-75383 | No | No | The bank account information was not working for some customers as some have multiple accounts as well as invoice financing. We have added the ability to link each customer to a specific bank account or UPTO three accounts (Primary, Secondary, Tertiary) All of which will appear on the customers invoice if set against the customer. It will still require the "show bank account" option to be switched on in the report manager. ** PLEASE CHECK YOUR LAYOUTS ** Set your bank account details and remember that the bank account is not linked to the invoice currency, you can therefor invoice in EURO and have them pay it into a USD account. | |
| VC-458 | Multiple users submitting SO files causing duplicate files | Improvement | 2.5.0 | XEG-256-12159 | No | No | 2 users can submit the same order for processing to their Warehouse. If 2 users have the SO submission screen open and do not refresh the data, then the same order can be submitted to the warehouse multiple times. This has the potential for the warehouse to process the order multiple times. Added lock tothis screen so that only 1 user can create submissions files. | |
| VC-449 | Interface Product Exports | Improvement | 2.5.0 | No | No | Add the following additional fields to the exports In the currency of the price list, send the last purchase supplier case price and the last purchase date. | ||
| VC-413 | Multiple bank accounts to be able to be used on invoices of diff currencies | New Feature | 2.5.0 | JWS-799-79932 | Yes | No | ** SEE VC-478 ** Business Requirement To be able to show different bank accounts on the invoice The invoice templates need to be adjusted and the Report Manager options need to be redefined. Add a new table called tblCurrencyBank which will hold the following fields - Account Name (30) - Bank Name (30) - Bank Address (30) - Bank Town (30) - Bank Postcode (10) - Bank Country (2) - Account Number (12) - SortCode (8) - Swift BIC (15) although restrict on form to 11 - IBAN (40) although on form restrict to 34 A new form is required which will allow bank details to be added to any currency in existence on tblCurrency. Modify the report layouts to use the new bank details |
Version 2.4.3 (08/09/2015)
| Key | Summary | Issue Type | Affects Version/s | Fix Version/s | Release Notes | FusionUID | Apply License | System Config |
|---|---|---|---|---|---|---|---|---|
| VC739 | Stock Transfer Orders not showing in Product Maintenance > Sales Orders | Bug | 2.3.4, 2.4.3 | 2.4.3 | Noticed on system had 2/9 of stock on an order, however this order was not showing on the Product Maintenance > Sales Orders tab. It can be seen that the 2/9 quantity of this product was placed on a stock transfer order, however as mentioned this order is not being displayed anywhere on the Sales Order list for the Product. | EYX-153-75315 | No | No |
| VC717 | Regeneration of PO XML does not remove it from the Resubmit tab | Bug | 2.4.3 | 2.4.3 | if you try to regenerate a PO from the <Submissions><Pre-Advices><Resubmit>, the PO does not disappear from the screen (even if you hit refresh). This could lead to users resubmitting a PO multiple times. Also, please check that no cancelled PO's appear on this screen, too. | No | No | |
| VC715 | Values incorrect on Stock Exception Report | Bug | 2.4.3 | Issue noted when importing Stock Snapshot XML files. The Stock Exception report being generated will display the same value for the Physical Stock and Whse Available, the report does not look to be pulling through the correct values for the report. . | No | No | ||
| VC710 | Availability figures | Bug | 2.4.3 | Odd figures have been spotted in the VC 3 8 BI report 'Total Stock Available' and also in the Product Maintenance 'Warehouse Stock Levels'. This seems to be when a warehouse does not use rotation numbers. | No | No | ||
| VC706 | Pre Advice XML extract Brand should be name not code | Bug | 2.4.2 | 2.4.3 | The XML produced for the Pre Advice should have the brand set to the Product producer Name not the product producer account code. | SMY-974-66332 | No | No |
| VC695 | BI - Sales Margin Summary EP Campaign | Bug | 2.4.2 | 2.4.3 | The report shows [E] but also works on the start date | No | No | |
| VC676 | EP Cost of Sales Acc report (532) unbalanced reversals | Bug | 2.4.1 | 2.4.3 | The Cost of Sales Accruals report for EP is incorrectly showing orders which are status X and C. See https://visionsoftware.atlassian.net/wiki/pages/viewpage.action?pageId=34144328 for details of what should show on this report. | SYG-973-41143 | No | No |
| VC675 | User maintenance - password not visible when trying to amend | Bug | 2.4.2 | 2.4.3 | In user maintenance, if amending password, you cannot see what the current password is, as it only shows asterix, yet it shows them to you in plain text when the focus is not on the field. All fields should be *** | No | No | |
| VC674 | Unable to Create new user group | Bug | 2.4.2 | 2.4.3 | Unable to create a new User Group | No | No | |
| VC670 | Auditing of "current" duty rates | Issue | 2.4.3 | The duty rate maintenance screen allows you to modify the "current" duty rate which provides no audit of previous values, this change will log changes to an audit location to aid the support team in any queries raised relating to these changes. | No | No | ||
| VC668 | Dynamic Product Code - Singles per case not pulled through | Bug | 2.4.2 | 2.4.3 | When creating a dynamic product code, the singles per case does not pull through onto product maintenance | No | No | |
| VC659 | General Sales Report showing D&V invoice records | Bug | 2.3.4, 2.4.2 | 2.4.3 | Duty and VAT entries show on the General Sales Report, but as these are not sales and make no difference to the margin these should not be shown. Also the report is showing multiple lines per order line, if for example the order has been part despatched, but again, part despatches are irrelevant to this report, it should be grouping by the order line. | WDH-473-35952 | No | No |
| VC654 | EP Partial Delivery Invoice issues where Singles Price does not equal Unit Price/SPC | Bug | 2.3.4, 2.4.2 | 2.4.3 | Partial Delivery of EP Orders (where Cases are broken down into singles) and the Singles Price does not equal the Unit Price / SPC, does not calculate Duty and VAT invoices correcty. Also, there's an issue with already invoiced lines appearing again on invoices. | OUB-702-66686 | No | No |
Version 2.4.2 (01/07/2015)
| Summary | Issue Type | Affects Version/s | Fix Version/s | FusionUID | Apply License | Config Option | Release Notes |
|---|---|---|---|---|---|---|---|
| BI General Sales Report (5 6) - Title says S/E but report does not use End Date | Bug | 2.3.4, 2.4.2 | 2.4.2 | DMF-165-99397 | No | No | BI General Sales Report export to .xls and .csv when customer looks at historical data because the result set returned is too large. Regardless of the the End Date set the report always pulls back all data up to the current date. Customer cannot view data just for 2011 for example. |
| Incoming Files not being removed from Awaiting Processing screen after processing has occurred. | Bug | 2.4.2 | No | No | When incoming files have been processed (whether successfully or with exceptions) they are not being removed from the Awaiting Processing Tab of the Document management screen | ||
| Delivery Times | Bug | 2.4.2 | No | No | The minimum required warehouse delivery windows should be based on a warehouse group, at present this defaults insisting on a 2 hour window for all deliveries not matter where supplied from. We will adjust the order form to ensure that this is checked and we will on the warehouse groups display the minimum delivery window as read only and store it against the warehouse group. The system will still allow customer and delivery points to have any times selected as defaults but we will validate upon ordering. The window length will be in minutes and the minimum will be zero although this will not work for warehouses who operate route planning automation. | ||
| Product Maintenance In Stock qty incorrect | Bug | 2.4.1 | 2.4.2 | No | No | If you have stock on a PO but not landed the In stock qty is showing double the amount that is in stock | |
| Reprocess button on Historical Delivery Notes doesn't do anything | Bug | 2.4.1, 2.4.2 | 2.4.2 | No | No | Clicking Reprocess button in SOP Documents\Historical Delivery Notes doesn't do anything (No email sent to either Customer A/C default address or Delivery Note address in Report Manager). | |
| The archive and failed folders are not being found in the DOc Mgt files inward processing | Bug | 2.4.2 | No | No | In the document management files inward processing from VC 591 when the files are processed they should move to archive folder but there is an error and they keep reprocessing. If a file does not processes there is not message about the Failed folder but it likewise does not move out of the inwards folder. | ||
| Stock Snapshot report shows Unknown WH Code error on every product | Bug | 2.4.2 | No | No | Has been resolved | ||
| Transfers out of a non bonded warehouse | Issue | 2.4.2 | No | No | When transferring stock out of a non bonded warehouse, the SO screen gives us an error when using the F11 search and double clicking on a product result. | ||
| Zero'ing a line on a Ex Cellar Sales order does not remove it from PO | Bug | 2.3.1, 2.4.1, 2.4.2 | 2.4.2 | No | No | When zero'ing a line on Ex-Cellar Sales order the line is removed from the SO, however the line was still left on the corresponding PO. | |
| Updating the product 'Brand' when using Livex data | Improvement | 2.4.2 | No | No | When we attach a product to a Livex LWIN, we ask the user if they want to use the Livex description as the product description, we need to change this process slightly. 1. First of all, change the question that we ask the user to: "Do you want to use the L-WIN data to update your product description and producer?" 2. If they click yes, we already update the product description. However, we currently use the 'Wine' field for this, change this to use the 'Label' field instead 3. Then, check if the 'Producer' returned exists in VC, if it does not, create it 4. Finally, set the Producer field to the value retrieved | ||
| Error on product search in SO entry when only one row returned | Bug | 2.3.4, 2.4.1 | 2.4.2 | VDY-514-42572 | No | No | At user site they get an error message during SO entry when they type in a product with a * and hit F11 when the product is the only one found – I.e. if there are more than 1 row returned by the search its fine but when 1 row is returned it gives an error as shown in screenshot 1. If they click OK to the first error and then click on the single returned row it does add the product to the order. |
| Cannot find warehouse information error on SO entry | Bug | 2.4.1, 2.4.2 | 2.4.2 | No | No | When entering Sales orders of more than one line there is an intermittent error when adding products via F11 that you cannot find warehouse information and the product code is blanked out. Then if you save the SO you get a DB null error but the order saves and when you go back into it the lines have saved correctly. | |
| Generate Delivery Notes from Allocate SOs prints number of copies as per lines on order | Bug | 2.3.4, 2.4.0, 2.4.1 | 2.4.2 | CFN-403-11433 | No | No | When in the allocate sales order screen and the user ticks Generate Delivery Notes there is a pop up which asks if they want email or print. Email works fine and generates correct number of delivery notes. Sending to printer brings up a pop up to specify the printer and the number of copies. However the number of copies is ignored and the number of delivery notes printed depends on the number of lines on the sales order. |
| Pickups not working in SO Allocation screen | Bug | 2.3.4, 2.4.1, 2.4.2 | 2.4.2 | No | No | If an order has a return to stock credit note created and has LCB to pickup ticked then it appears in the SO allocation screen under the pickup section. However, when you select it, pickup selected and commit nothing happens. This should generate a file to be sent to the warehouse under the pre advices submission tab. Once the credit note is ticked as processed and the order re-saved it does not appear here and the WIKI documentation will need to reflect this so I will do this once it is fixed. | |
| EP cost of sale credit reversal posting is not using the correct value, the reversal does not match the invoice value | Bug | 2.4.2 | No | No | When you raise an EP credit note, it is not using the price from the EPPO it is using the current product price To replicate this do the following 1. Create a product and add to an EP campaign and set the standard UB price to £150 2. Create the EPPO and receipt the stock at £150 3. Create the EPSO and invoice - check tblEnPrimeurSalesMovement and you will see it has correctly picked up the price of £150 4. Change the standard UB price in product maintenance to £250 5. Process a credit note, check tblEnPrimeurSalesMovement and you will see it has incorrectly picked up the price of £250, the current product price rather than the EPPO price | ||
| Unable to change rotation number whilst partially allocating an EPSO if the original rotation number has zero stock | Bug | 2.4.2 | No | No | Has been fixed, To replicate : 1. Create a new EP Product 2. Enter an EPPO for 20/0 of your new product 3. Land 10/0 and note the rotation number 4. Enter an EPSO for 20/0 of the new product 5. Allocate the EPSO using the rotation number from (3) 6. Check the EPSO - there will now be 2 lines (for 10/0 on each) & both lines will be referencing the rotation number from (3) 7. Deliver the 10/0 8. Land the outstanding 10/0 on a different rotation number. 9. Try to allocate the outstanding 10/0 - I am unable to save a different rotation number in the details sub-screen and therefore, cannot allocate any more of the order. This does not seem to happen if there is still stock on the original rotation - you can change the rotation and save it whilst allocating without any problems. | ||
| Credit note qty incorrect when crediting same product and qty on one order at the same time | Bug | 2.4.2 | No | No | Credit note showing incorrect qty When there are 2 lines on an order that are for the same product and qty and both lines are credited at the same time for the same qty on each line. Only 1 line shows on the credit note and the qtys are not added together | ||
| VC - Problem with removing supplier from main supplier pricing | Bug | 2.4.2 | JDZ-766-14900 | No | No | If you have added a main supplier in the pricing and purchase section of product maintenance, you cannot then remove it You can change the supplier, but if you blank out the main supplier and click save, it will just repopulate the original details. | |
| LWIN18 calculation incorrect | Bug | 2.4.1 | 2.4.2 | No | No | From VC-578 - The LWIN18 calculation is incorrect. As an example: look at product ABRESBEA01 in test & get the LIVEX Code. The one that was calculated was: 103018120111275000 it should be: 103018120111200750 - the difference being the single size in ml (the product has a single size of 75cl = 750ml). | |
| EP Cost of Sale Report and Stock Movement Posting Report showing Non-GBP value as GBP for PO's for foreign currency purchases created before VC 2.3.4 (VC-479 fix) | Issue | 2.3.4, 2.4.1 | 2.4.2 | BUR-921-30807 | No | No | This issue is related to VC-479 The EP Cost of Sale Report (5 3 1) and the Stock Movement Postings Report is showing the EP PO non-GBP value (where the supplier is non-GBP) instead of showing the [non-GBP value] / [EP PO Header exchange rate] where the EP PO Line Detail Exchange Rate = 0. This is affecting any EPPO where the Supplier is non-GBP AND the EPPO Line details are showing zero for Exchange Rate AND the EPSO Invoice has been generated after the upgrade to 2.3.4. Changes made in VC-479 are working for any EPPOs created since the upgrade but the changes do not take into account that many EPPOS created before the upgrade that have a PO Line Detail Exchange Rate of zero where the products are then invoiced on an EPSO. Any EPPOs created after 2.3.4 are copying the EPPO Header Exchange Rate to the EPPO Line Detail exchange Rate when the EPPO is created so this does not affect EPPOs created after the updated. |
| Qtys incorrect on credit notes when processing multiple credit notes for a single order at one time | Bug | 2.4.2 | GCZ-193-37672 | No | No | If multiple credit notes are processed on the same order, and you then try and print the credits notes from historical invoices at the same time, all the lines show on each credit note and the qtys multiply by the number of credit notes selected. This was previously raised under VC-233 for invoices but credit notes were not amended. | |
| Valuation reports by product and rotation are not using EP link (341 & 342) | Bug | 2.4.0, 2.4.1 | 2.4.2 | No | No | On the Stock Valuation by Rotation (3 4 2) report there is an issue in the 'En Primeur Stock' and 'En Primeur Value' columns. The problem is that regardless of the EP PO's that the EP SO's are linked to, the two columns above are populated for every rotation line. The lines are showing what is owed on invoiced EPSOs regardless of whether they are the right rotations for it. | |
| EP order being picked from a mixture of DP and UB rotations causes invoicing issues. | Bug | 2.4.2 | AON-184-72032 | No | No | Issue noticed on customer's live system. When an EP order has a line picked across a DP and UB rotation at the warehouse, VC has issues calculating the Duty And VAT. Have been able to replicate as follows : 1 - EP PO and EP SO keyed in VC for 15/0 cases. 2 - Stock is landed on a Pre-Advice in VW, Goods Received report is then send into VC which updates with the rotation and also updates the EPPO to show the stock is now available. (15/0) 3 - On VW some of the stock was sent out on an order (3/0) and was then returned back into the warehouse as DUTY PAID stock. 4 - VC customer then allocates the stock to the order and sends the SO over to the warehouse. (15/0) 5 - Warehouse then picks the stock, however due to step 3 some of the stock on the line is DUTY PAID. (12/0 UB, 3/0 DP) 6 - Order Picking Confirmation is the produced by warehouse and is imported into VC, this updates the Order to show that the stock has been delivered (15/0) 7 - Checking pick records it can be seen that there is 2 entries for the line 1 record for 12/0 which has correct VAT information and is appropriately being charged VAT, the second record for 3/0 has no VAT information. 8 - Trying to preview the invoices in VC throws an error: Failed to generate invoices Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. | |
| Zero value BuyingPrice causing report to return incorrect values. | Bug | 2.4.2 | YSB-785-61724 | No | No | Customer noticed issue with BI report 4 1 3, (also affects 4 1 2, as they use the same function) On both of these reports the last field output is the GBPNetValue, this field is being calculated as 0.005 for every product, despite the other product values that are present. This field should display the NetValue of the product minus any Discounts etc and showing this in the GBP value. Depending on if the Product has UnitORSingle = 1 it should either be taking the BuyingPricePerSingle or BuyingPricePerUnit into the calculation, to workout and display the correct amount. It also looks to be affecting the Net Value field itself as there are multiple records with a 0 value against NetValue. | |
| Data Cleaning function should be reflected in Margin Reports | Issue | 2.4.0 | 2.4.2 | No | No | During testing of Data Cleaning it became apparent this function does not reflect in the margin reports. It does write to a table tbldatacleaning. However, nothing then looks at this table. The values in stock movement and on the SO are not changed, which is correct. None of the margin reports look at the data cleaning table and none of them change when there is a record in this table (there are now several records in TEST but none of them affect the margin report). All the reports on the Menu 5 4 3 (Sales Margin reports) should reflect the data in this table, this is reports 5431, 5432, 5433, 5434, 5435, 5436 and 5437 Also, change the column headings in 'Data Cleaning' to: Sales -> Sales/Unit Cost -> Prod Cost Total New Sales -> New Sales/Unit New Cost -> New Prod Cost Total |
Version 2.4.1 (05/03/2015)
| Key | Summary | Issue Type | Affects Version/s | Fix Version/s | FusionUID | Apply License | System Config | Release Notes |
|---|---|---|---|---|---|---|---|---|
| VC580 | VC - BI Sales\Outstanding\SO Lines by Customer and SO Lines by Product showing completed Order Lines | Bug | 2.3.4, 2.4.1 | 2.4.1 | CIT-519-64051 | No | No | VC BI Sales\Outstanding\ 5 1 2 (Lines by Customer) and 5 1 3 (Lines by Product) both show all lines on any order that has a Header Status = (Outstanding) regardless of whether the Detail lines are status 1 or 2. Only outstanding Detail lines should show on these reports. |
| VC578 | Problem when Livex value copied back into product record | Issue | 2.4.0 | 2.4.1 | No | No | When searching for a Livex code on a product if you blank out search criteria such as vintage, bottle size, pack size etc... and then search and select a record from the list the LWIN code is only populated with the 'product' part of the code. However we know the pack size, vintage etc.. from the product record so the whole long code should be worked out and put into the LWIN code field, even if these values were not used in the search we still know them. | |
| VC577 | Reserve Stock and Reserve Stock Values reports not showing all paid reserves | Bug | 2.4.0 | 2.4.1 | No | No | On a customer in the reserve tab when the livex module is running there are two reports - reserve stock and reserve stock values. These should show ALL the customers Paid reserve stock, not just ones with a livex value (ie it can show the bought value etc.. | |
| VC576 | EP despatch movements posting duplicate journals to Sage | Bug | 1.7.28, 2.4.0 | 2.4.1 | WGY-117-18891 | No | No | Customer noticed that duplicate journal entries were posting through to Sage for EP despatch movements |
| VC575 | Warehouse -> Documents menu not visible | Issue | 2.4.1 | No | No | It is noted that 'Warehouse' -> 'Documents' menu is not visible when some settings were set to on in the configuration, it should always appear. | ||
| VC574 | When adding products to an SO from previous orders you get an unhandled error | Bug | 2.3.4 | 2.4.1 | No | No | Create a new SO for a customer Click on Previous Orders Select any line and hit Update order You get an unhandled exception error saying Failed to Find Warehouse Details | |
| VC573 | Wording wrong on Livex message returning no prices | Issue | 2.3.4 | 2.4.1 | No | No | On a product request Livex values (hit the get Lives Values button on the cloud tab of the product) - if none are found the message says "No data found. Unfortunately we don't have received any prices for this wine vintage combination yet" This should say something like: "Either the LWIN is incorrect or we have simply not received any prices yet for this LWIN" | |
| VC571 | Changes for VLIVE-7 to pass the users full name to livex when sending the LWIN request email | Improvement | 2.4.1 | No | No | as description | ||
| VC566 | Order showing negative qtys ordered after user uses the screen in a very specific way | Bug | 2.4.1 | OJC-737-97517 | No | No | Order is showing as negative figures in the items ordered column, upon investing it appears that this may have been caused by the rotation number on one of the lines being changed before allocating the order, and leaving the other lines without a rotation. Here are the steps taken to replicate this issue Create a sales order Input 3 lines of stock, but do not at this point input any rotation numbers Go back to line 1 and F11 in the rotation number. Select a rotation Then clear that rotation number, and F11 again, chose a different rotation Save the order Allocate the order as normal Go back into the the order, and you will see that the original line with the rotation number is now showing with negative stock ordered There is also a new line for the same product with different stock amounts, and all but this new line are at status C. | |
| VC565 | PI Postings not going to Sage | Bug | 2.4.1 | PMV-884-57474 | No | No | This bug relates to VC-218. A customer asked for their stock movement postings to be turned off. When this was done the PO posting started to fail to post | |
| VC556 | Customer cannot return stock on PO when rotations are not in use. | Bug | 2.3.4, 2.4.0 | 2.4.1 | NBQ-799-91808 | No | No | Warehouse group is set-up to not use rotations and the user tries to return stock on a PO they receive an error about insufficient stock to return. |
| VC553 | Component products not having correct qtys sent to the warehouse for a 'Mixed Case' when ordering more than 1 case on a SO | Bug | 2.4.1 | EFP-828-32691 | No | No | Customer Created a Sales Order in VC using a Productset up with 3 Child (component) products (each child product had a qty of 1). The parent Product had a quantity of 83. The SO EDI file created by VC (2.3.4) was for an Order with just the child items on it (with a qty of 1) for each. The file has created an order at the Warehouse for 3 lines (the component products) with a quantity of 1 for each line. | |
| VC552 | Error when saving mixed case build | Bug | 2.4.0 | 2.4.1 | No | No | When attempting a mixed case build where there is stock of every item it appears to work correctly. However when the save button is pressed an error occurs and the mixed case will not save. The error message does not explain why this will not save and therefore needs clarification and possibly fixing. | |
| VC541 | Errors running BI Report 3 2 Stock Record Card | Bug | 2.4.0, 2.4.1 | FRD-897-82744 | No | No | Customer is trying to run the BI report 3_2 Stock Record Card, however the report errors after a few minutes with 'Error getting BI report detail' clicking OK on this report gives a further error 'Object reference not set to an instance of an object'. | |
| VC524 | Detail Margin report title needs [E] removed. | Issue | 2.3.4, 2.4.0 | 2.4.1 | QDB-688-38207 | No | No | Report Detail Margin 5 4 4. The title on the report has both [S] and [E]. However it does not look to be including the End date in the calculation. |
Version 2.4.0 (10/01/2015)
Please note from Version 2.4 onwards Stock Movement postings are only supported in summary format as this is the recommended method of posting stock movement transactions.
| UID | Summary | Issue Type | Affects Version/s | Fix Version/s | FusionUID | Apply License | System Config | Release Notes |
|---|---|---|---|---|---|---|---|---|
| VC563 | Remove the ‘There is a charge for this service*’ text label in the Product Maintenance screen | Improvement | 2.3.4 | 2.4.0 | No | No | There is a text label as below in the Product Maintenance screen's 'Cloud' tab which needs to be removed. ‘There is a charge for this service*’ | |
| VC561 | Livex integration improvement to show the producer at the top of product maintenance | Improvement | 2.4.0 | No | No | Product Maintenance > Purchasing & Pricing > 'Producer' Moved to the top section of the form, above the tabs na beneath the second product description fields. Space out the checkboxes on the right and make 'Available from' and all the checkboxes in line with the controls on the left. 'Available from' would be in line with the 'Producer' fields. Ensure tab index is correct afterwards. The purpose of this change is to ensure the user can still see the producer even when they're in other tabs, like the cloud tab, when searching for LWINs. | ||
| VC544 | EPSO over allocated due to pack size change | Bug | 2.3.4, 2.4.0 | 2.4.0 | AHY-581-13576 | No | No | Issue noticed when amending pack size using EP Maintenance for customer. When using EP maintenance and entering the new product code, and clicking save, then clicking yes on the message that comes up the EPPO that is chosen is updated as are any linked EPPO's, however any other linked EPPO's are also updated, however this is not made clear in the message. If a user does not notice this they may proceed to update other EPPO's for this product despite these already having been updated, this causes line quantity duplication on there EPSO's. We should ensure that only the selected PO only and all associated SOs are updated, as per VC-85 the original issue where we did this work. |
| VC542 | Placing an SO using stock from unpaid reserves incorrectly changes unit qty on order line when ordering less than the unpaid reserve quantity | Bug | 2.4.0 | 2.4.0 | No | No | Example of Recreation : Product code CUI0306F06 has 10 units in stock in OFFICE Place all 10 into unpaid reserves for PLATT01 Place a stock order for customer RHTEST for this product Set units to 1 on the line and tab to next field Pop Up asks if user wants to use unpaid reserves or put order on hold – this is correct Click on use unpaid reserves – by which user wants to take the 1 unit they are ordering out of the 10 units in unpaid reserves Unit quantity on order changes to 10 (i.e. the full amount of the unpaid reserves) If user doesn't notice this it would be easy to then save the order and have the wrong quantity. The order quantity should not change, the 1 unit should be taken out of the unpaid reserves. | |
| VC541 | Errors running BI Report 3 2 Stock Record Card | Bug | 2.4.0, 2.4.1 | FRD-897-82744 | No | No | Customer is trying to run the BI report 3_2 Stock Record Card, however the report errors after a few minutes with 'Error getting BI report detail' clicking OK on this report gives a further error 'Object reference not set to an instance of an object'. | |
| VC540 | BI report 5 4 3 1 has column 'Year Start' which does not appear to change when report dates change nor does it seem to relate to the rest of the data shown in the row | Bug | 2.3.4, 2.4.0 | 2.4.0 | No | No | When running the report Sales Margin Summary (5431) with the report dates set to 1/10/14 to 31/1/0/14 the Year Start shows as 2013. When running with report dates set to 1/10/2012 to 31/10/2012 the year start still shows as 2013. This can be seen by running the report in TEST on waterloo. | |
| VC539 | Replicating a product does not copy the 'Product Style' or 'Product Type' analysis codes despite the other 3 analysis codes being copied fine | Bug | 2.4.0 | EKS-269-84198 | No | No | When replicating a product, it does not bring through the product style or the product type from the original product | |
| VC535 | Missing shipper contact details on PO Ack when not all shipper address fields filled in | Bug | 2.3.4, 2.4.0 | 2.4.0 | No | No | When using a shipper on a PO if any of the fields in the address are left blank the shipper contact on the PO Ack is blank. It should use the fields which are entered and ignore the blank ones. | |
| VC534 | Further tweaks to the Livex integration following the user group session | Improvement | 2.4.0 | No | No | Customer Maintenance - Market value, high / low / last traded? this column Mkt Single Val (Low) and show 'Currency' column to the right of 'Mkt Val (Low)' - Make sure the 'Bought' value is the 'Single' value and NOT case - As of date, rename this column to 'Retrieved' as there is no 'valued' date Product Maintenance - Livex Values grid, similar as above, column headings need to be refined - change 'Date' to 'Retrieved' and Value to 'Mkt Single Val (Low)' as above. Also put the 'Currency' column to the right and make sure there are no scroll bars in the grid, all columns should be made a bit narrower to fit this in - Immediately asking 'Do you want to use the livex product description', it's annoying, need to move this somewhere else where it's not such a pain. - remove this question, when the user clicks 'Save' but only after the user has 'Found Matches' and clicked a result? --put an option in the Admin System Configuration Options 'Use Livex Product Descriptions?' and only if this is enabled (defaulted to true) ask the question. - Get Livex Value should not require the product record to be saved first prior to pressing the button | ||
| VC532 | Orders are being created without an underbond type, it should be type 1 as default or changes cannot be saved | Bug | 2.3.4 | 2.4.0 | No | No | The customer reported that they were unable to update the delivery underbond type on EP sales orders, it was found that the underbond type field was null. When this was corrected the orders could be changed to the correct type. Thought this was old data, but there were two newer orders also with the same issue, but unable to determine whether they were replicated and the issue carried forward. Unable to establish how this was happening, originally thought it was old orders and initially was thinking a script can fix it but there were newer records. I know previously we allowed orders to be stored with nothing in this field if they were duty paid, but as this stops the ability to edit in the EP SO allocation it means that we need to resolve the issue. However - If the under bond type against the EP order is NULL the user should still be able to change the under bond type in the EP allocation screen. | |
| VC531 | Issue with Pro Forma or Duty Pre Payment Invoices on Pro Forma SO | Bug | 2.4.0 | 2.4.0 | No | No | When an order has no product lines or lines with 0 quantity and you tick pro forma and then click on the pro forma button the order saves but when you choose either Pro Forma or Duty pre payment in the pop up then you get a BMC error. The user should get a warning message saying 'The order must have lines and quantities before you can use this function' | |
| VC529 | Cost Price on PO not being updated when DP flag is ticked | Bug | 2.3.4, 2.4.0 | 2.4.0 | FQO-819-39636 | No | No | Issue noticed on customer's VC 2.3.4 When entering a PO if the product has an Underbond and a Duty Paid cost price on it, ticking the Duty Paid flag isn't triggering the screen to update the price to the Duty Paid price, resulting in PO's being saved in to the DB with the Underbond Price Customer has been given a workaround, if the DP flag is checked before the Product Information is added onto the line then it will pull through the correct DP price. |
| VC525 | Slow product search made quicker | Improvement | 2.4.0 | No | No | Re-wrote the stock availability calculations | ||
| VC523 | VC - Issues with EP Order Transfers to Reserve Accounts. | Bug | 2.3.4, 2.4.0 | 2.4.0 | GKX-225-62300 | No | No | When allocating an EP order using 'Customer Reserves' allocation type, the address details in the EDI file are wrong. This is similar to VC-493 where this issue was fixed for Stock Orders. |
| VC522 | On SO entry, the warehouse stock levels do not display the correct value for Unpaid Reserves | Bug | 2.4.0 | 2.4.0 | No | No | This is a follow-on from VC-491. Has been worked through and rechecked. | |
| VC515 | Price list maintenance - multiple price lines not showing and unable to delete price lines either | Bug | 2.4.0 | KLO-819-79602 | No | No | 1)When adding lines to the price list maintenance screen, it is not showing the previous lines, they disappear from the screen. But when you click save they reappear and you can see all the lines To replicate: create 2 lines on a price list, but when I tab to create the 2nd line, the 1st line disappears, then on saving you can see all the lines 2) When in price list maintenance, when you try and delete a line from the product price section, and then save you get an error message - deleted row information cannot be accessed through the row, therefore you are unable to delete any lines in this screen | |
| VC513 | Order screen not picking up correct price list price | Bug | 2.4.0 | WRL-984-53585 | No | No | If a product is attached to a price list it does not appear to be picking up the correct price. There are 2 issues in relation to price lists 1) In price list maintenance, under product prices, if there is only 1 line, when placing a sales order, it does not pick up this price, it picks up the standard price, if you copy this line exactly it will then bring through the correct price 2) If there are multiple lines in product maintenance, under product prices, it is only picking up the last price This means when placing a sales order the incorrect price is being picked up | |
| VC509 | VC - EPSO Credits do not reduce stock allocated | Bug | 2.3.4 | 2.4.0 | UYD-259-15886 | No | No | EPSO credits do not reduce stock allocated. Customer is unable to allocate credited stock to another EPSO. |
| VC508 | UB Per/Single value is not always being calculated correctly | Bug | 2.3.4, 2.4.0 | 2.4.0 | RQZ-205-40797 | No | No | Noticed on customer's system that when a product is first set up when entering the UB Per/Unit price on either the Standard Cost Price GBP and the Main Supplier Pricing, the UB Per/Single is not always being calculated properly. The calculation was modified under VC-330 and looked to be working correctly then? |
| VC507 | VC - Verify Invoices not Working | Bug | 2.4.0 | JME-855-13479 | No | No | When verifying invoices if the only invoices left in the date selected are 0 invoice number, then the date does not move on. For example date range 4/8/14 - 11/8/14 - verify invoices is selected and all the genuine invoices are verified and flag updated to correct status, there are some invoices left that have an invoice number of 0, so they will not have the flag updated. | |
| VC505 | Credit note problem on EP orders if customer on hold in sage | Bug | 2.4.0 | BDE-768-57009 | No | No | When a credit note is processed on an order, it does not need to do a credit check against the customer in sage as it does not matter what the credit status of the customer is | |
| VC503 | Report 3 5 Stock Summary by Region has hard coded values in the function | Bug | 2.3.4 | 2.4.0 | VMO-962-79308 | No | No | The stock summary by region report does not agree with the stock valuation report. In the function VCR-StockSummary (which is used by this report) the region descriptions are hard coded. User can change or add region descriptions so this was rewritten not to be hard coded and ideally so that the values for the stock for each region agree to the value for the stock on the stock valuation report as this gives the correct data. |
| VC499 | Price not showing to 2 dec places on Duty and VAT invoices | Bug | 2.4.0 | PNJ-647-21626 | No | No | Duty and VAT invoices from Ep sales there are no decimal points showing or currency on the ib price | |
| VC496 | EP Stock Not Landed Report (5 2 2) does not show put a value in NotSoldValue column | Bug | 2.3.4 | 2.4.0 | No | No | The Stock Not Landed Report (5 2 2) does not populate the NotSoldValue Column with any values. This can be seen at several client sites running VC2.3.4 and also in TEST. | |
| VC494 | No stock shows in product 'Warehouse stock levels' when ordered is greater than in stock, and there are also SO qty discrepancies on this screen | Bug | 2.3.4 | 2.4.0 | LRK-238-74410 | No | No | Summary: 1) On the warehouse stock level part of the General tab on Product Maintenance the line disappears if more stock is on sales orders than is available. But this is warehouse stock level MINUS the stock being on sales orders does not mean it is not in the warehouse so it should still show. 2) On the Stock info tab of product maintenance and also Stock Enquiry function stock on SOs does not show in the On SO column. This all makes it very difficult for users to correctly know what they do and don't have in stock at the warehouse and on sales orders. |
| VC493 | POs created from Type R SOs have the wrong warehouse defaulted in the 'Receipting' tab | Bug | 2.3.4 | 2.4.0 | No | No | Reported by a customer and replicated in test as below. When a PO is created by the system for a type R order the warehouse group and warehouse on the main PO screen are correctly set to the reserve warehouse as specified on the SO. In the receipting tab on the PO (example 1026) the warehouse incorrectly shows the non reserve warehouse that the stock came out of. If you click to receipt all an error message shows 'Please enter warehouse for receipting' - however this field looks as if it has a value. If you click into the field it blanks out and in the drop down only the reserve warehouse is shown (as it should be). Once this is selected everything is fine to receipt. The reserve warehouse should correctly default into this field on the receipting tab as per the front screen on the PO, not showing an incorrect warehouse which isn't in the drop down list. | |
| VC491 | The Order Lines > Unavailable stock window is not showing 'Quantity in Stock' correctly when a quantity is held in an unpaid reserve | Bug | 2.4.0 | No | No | If you take a product which has never had any stock records, then adjust 50 cases in, then put 25 in an unpaid reserve for customer A, then try to order 50 cases for customer B, the unpaid stock window appears, and at the top it's showing 'Quantity in Stock' as 25 when it should be 50. | ||
| VC490 | Underbond warehouse details require all 5 address fields to be input. | Bug | 2.3.4 | 2.4.0 | No | No | On the Order screen > 'Warehouse options' tab in VC, when the UnderBond Receiving Warehouse details need to be input out all 7 address lines are mandatory. However we only set the defaults in the system to show Name Address Line 1 Address Line 2 Town County Postcode. Address line 3 and 4 (tblVisionSalesOrderHeader.UBWarehouseDeliveryAddress3 & UBWarehouseDeliveryAddress4) should not be mandatory in order to be able to save the order. | |
| VC489 | Can't put anything in the units column on the order form when using reserve stock | Bug | 2.3.4 | 2.4.0 | WNG-742-61362 | No | No | Resolved as per description |
| VC488 | Underbond Type R order can not be amended once it has been created. | Bug | 2.3.4 | 2.4.0 | No | No | Once a type R order has been created the system is correctly creating a PO. If you go back into the order to make any amendments and try to save. The following error message comes up Failed to save sales order Cannot insert the value NULL into column 'PurchaseOrderNumber', table 'VisionCommerce.dbo.tblVisionPurchaseOrderHeader'; column does not allow nulls. INSERT fails. The statement has been terminated. | |
| VC486 | In Verify Invoices - Sage zero value invoices should be excluded or ignored | Improvement | 2.3.4 | 2.4.0 | No | No | When using Verify Invoices - Sage zero value invoices return a not found result. They are not listed, it just returns an error message saying 'invoices not found'. Zero value invoices will not post to Sage so this is correct but in high volume clients this creates a lot of work to identify which invoices are the problem. Please amend the functionality to allow the customer to select "ignore zero value" invoices where we ignore them in the check assuming that they are correct as they will never be sent to Sage. | |
| VC485 | VC -Incorrect invoice displayed when printing 2 EPSO Duty and VAT Invoices | Bug | 2.2.7, 2.4.0 | 2.4.0 | HEO-708-15012 | No | No | If customer clicks 'Print Selected' with 2 EPSO Duty and VAT invoices selected at the same time, the document is wrong. - One of the invoices in the document is correct (Says "Duty and Vat Invoice" and calculates correctly). - One of the invoices in the document says "Sales Invoice" instead of "Duty and VAT Invoice" + says "Excise Duty" under Product column header and does not total the Duty and VAT correctly. [See Attachment EPInvoiceTest7.oxps] - Both the invoices in this document should look like the ones in EPInvoiceTest5 and EPInvoiceTest6. - The invoices are posted to Sage correctly. - Historical invoices does show both invoices correctly. The only place it is wrong is in the Crystal Reports Viewer window where the customer emails the document to their customer. To recreate this issue:- - Create EPPO. - Create 2 x EPSO and POLink to PO. - Invoice 2 x EPSO (Invoices value of goods without Duty or VAT). - Land Stock on EPPO. - Allocate and Deliver stock on both EPSOs. - Highlight both orders in SOP Documents and print invoices. |
| VC483 | VC - Amount appear to be doubled on SO submission | Bug | 2.4.0 | UQA-206-41169 | No | No | If a product is used on a PO on more than one line, the SO submission screen is showing the incorrect amount in the cases field. This can happen if a product is part allocated or if a product is used twice on a PO but against different rotations. The actual SO file that is created, is correct as it breaks it down by line, and so picks up the correct amounts. | |
| VC475 | VC - Spelling Mistake: Warehouse File Imports Screen: "Selcect File to be Processed" | Improvement | 1.7.28, 2.3.2 | 2.4.0 | No | No | Minor issue: Spelling mistake on Warehouse File Imports Screen "Selcect File to be Processed" should be "Select File to be Processed". | |
| VC462 | Price List Maintenance | New Feature | 2.4.0 | Yes | No | Add the ability to review prices on either the Product List or the Price Lists with the ability to update and save a new price only updating those which have had a new price entered. Customer should choose whether to maintain a price list or the product prices. Should show the following fields --Product info-- (these fields do not scroll in this section horizontally) Product Code / Description / SPC / SS / Vintage --purchase prices-- Last Landed Price GBP Cs / Last Landed Date Last ExCellar Price GBP Cs / Last ExCellar Date Product UB Cost GBP Cs --sales pricing -- Qty Breaks- only used for price lists DP Sales Price - from prduct or price list - Cs Suggested DP Price @ Margin (defaults from the configuration table) Suggested ExCellar Sales Price @ Margin (as DP Price but do not take into account freight, insurance, RHD, Rent, CCT or Duty) --- user entry and can then update product or price list --- New Sales Price ---- analysis-- Duty per unit / CCT per unit based on COO / RHD / Rent / Freight / Insurance Single should be Cs / SPC Ability to initiate function Update Product Cost from Last Purchase price (existing function) from the screen. | ||
| VC461 | Price List Output | New Feature | 2.4.0 | Yes | No | We are going to produce 2 styles of price list...... 1) Price List - which will be either PRoduct prices or you pick a price list and produces the prices from the price list. 2) Customer Price List will show a list of ALL product and their price for this customer whether specific, price list or product, but will only include those where a new flag on product group does not say "Exclude from Customer Price Lists" No delisted products to be shown. Output must be PDF and should be emailled to the user who will then send the price list on to the customer. Options on the output - Show Single Prices Yes or No - Prices shown as IB or DP (whilst our price list shows everything as DP we would have to remove the duty element) It would use the customer logo which we do for delivery notes. There would be : header page - as shown and see below Index page - can this be created dynamically in the PDF ???? About us page - we need to add this in for the Price list document, it should be part of the system configuration screen in the Admin section.We need to store this along with the contacts information. Wine Listings - A new page should begin for each Region. Terms and conditions - similar to one on the report manager screen we should use the same and if available should be attached to the email, (config in system config) different file name to the delivery notes one though. | ||
| VC460 | Proforma - Ability to raise but only request the duty | New Feature | 2.4.0 | No | No | If proforma is selected at order entry the user upon saving is provided with a screen showing a Proforma Invoice. Would like to add a new option that upon save the user is asked the question - Proforma - Duty Pre-Payment If they select proforma then nothing changes. If they select duty pre-payment we send a revised document with the label "Duty Pre-Payment" In the section on the document which shows the Delivery Address, remove this section and replace this with a new section. The new section will show the calculated duty amount for the ordered quantities based on VC duty information. It will then show in this new section as "This is a request to pay the duty for this order in advance, as such the duty for this order is calculated as :- <VALUE> This should be 24 pt and BOLD Please make payment in order to release your order. When your invoice is sent for payment you should deduct the above pre-paid duty amount from the invoice payment." | ||
| VC447 | Report 3-9 Stock List / 2-1 All Reports - add fields | Improvement | 2.4.0 | No | No | For 3-9 Report Stock List Add the following fields onto the report Producer Name Last Stock Movement Date (MAX tblStockMovement.MovementDate) Last Stock Receipt Date for the Product Total Singles Moved in Last 90 Days Total Single Moved in Last 180 Days Total Singles Moved in Last 260 days. List the Price lists that the product appears on in one field. For All reports in 2-1-X Add the Producer NAme Add the Last Stock movement date Add the last stock receipt date | ||
| VC434 | Further Livex LWIN service integration to offer: Basic license - use of their product descriptions, Enhanced license - Many reserve customer improvements to reserve stock values (bought / market value / current market bids) and an additional new report | New Feature | 2.4.0 | Yes | No | We want to be able to offer 'Basic Livex Integration' and 'Enhanced Livex Integration' by means of a license in VC. If the customer holds a valid license for this, they will have the FULL Vision - Livex integration, otherwise they will have the basic integration only. 1) BASIC INTEGRATION a. The product maintenance form to - Lookup LWIN - Ask for LWIN - Retrieve LWIN value b. New change, use Livex's description (more information below) 2) ENHANCED INTEGRATION a. Show 'last known value', 'valuation date', 'bid value' on the Customer Maintenance > Reserve Stock tab, plus line level button to update values from Livex b. Create a stock sheet PDF report which can be launched from this tab, with the options of with or without values. Use Livex's Description --------------------------------------------- Is available for basic integration Customer Maintenance > Reserve stock ------------------------------------------------------------------------------------------ - System MUST have the 'Enhanced Livex Integration' to have these new changes - New columns: - Bought: Product cost per unit - Market value: The most recently received value in tblProductLivexValue - As of: The date the market value was retrieved (allow proper date sorting in the grid) - Bid: Result from the 'Update Bid' button click - Update Market Value: Calls the same functionality that we have in Product Maintenance > Cloud tab and simply gets the value from Livex, updates tblProductLivexValue table, refreshes the data shown on screen - Update Bid: Calls a new web service (see VLIVE-6) which we'll implement in Vision Live. The values will not be stored however, and only shown in the grid. - New buttons at the bottom: - Update Market Values: existing functionality to get the values and update table and refresh screen. User should be shown waiting animation and message during this process. - Update Bids: existing functionality to update the bid - Stock report: A new report with customers logo (just like on the invoices), title 'Vision Reserve Stock Report', 'Stock records for customer <customer name> (<customer code>) as of: <current date dd/mm/yyyy> at <current time hh:mm>', showing columns: Product ([<ProductCode>] <ProductDescription>), Producer, Rotation, Vintage, Size (SinglesPerUnitxSingleSize - to 2 decimal places), Stock C/S (<Cases>/<Singles>) - Stock values report: Uses the same report as above but also shows the following additional columns: Bought (ProductCostPerUnit), Market value, Variance, Stock value, Valued (see attached) | ||
| VC426 | Once an order allocated you should not be able to make it proforma | Improvement | 2.3.1 | 2.4.0 | No | No | If an order has been allocated you should not be able to change the flag on the order to pro proforma. | |
| VC406 | Stock Turn Report (3_1_2) using old analysis option should be changed to use new mandatory product type analysis field | Improvement | 2.4.0 | No | No | The 3 1 2 report should be using the product own product type field rather than analysis caption 9. | ||
| VC388 | Fine tune BI Reports | Improvement | 2.4.0 | No | No | Below BI (VCR) Views needs to be fine tuned for performance as they are taking long time to run. vwVCR_3_1_1_StockAuditTrail vwVCR_3_2_StockRecordCard vwVCR_5_9_SalesmanReport | ||
| VC387 | Expand the Top 30 Products and Top 10 Customer reports 5 5 1 and 5 5 2 | Improvement | 2.2.7 | 2.4.0 | No | No | In BI The reports for Top 30 Products 5 5 1 and Top 10 Customer 5 5 2 should be expanded. Make these the TOP Products and TOP Customers Remove the (30) and (50) | |
| VC386 | New Report based on Margin Summary 5 4 3 1 to group by account & remove order type | New Feature | 2.2.7 | 2.4.0 | No | No | Create a new report based on the Margin Summary Report 5 4 3 1 Remove the order type from this and summarise by the account name. To be called Margin Summary by Account Report | |
| VC381 | Create new report based on Stock Valuation in BI 3 4 1 | New Feature | 2.2.7 | 2.4.0 | No | No | Create a new report based on the Stock Valuation Report in BI (3 4 1) which shows the rotation and does not group at product level. It will be called Stock Valuation by Rotation and the existing will be renamed to 'Stock Valuation by Product' | |
| VC378 | BI 3 1 2 Allow Stock Turn 190 Days to be customised | Improvement | 2.2.7 | 2.4.0 | No | No | Allow the BI Report 3 1 2 Stock Turn 180 days to be customised to a date range or a number of days other than 180. | |
| VC375 | VC-Set S as default VAT code when creating a new Product | Improvement | 2.4.0 | PPJ-588-26430 | No | No | When a new product is added have the system default the VAT code to the standard one This is identified as systblVATCode.IsStandard = TRUE | |
| VC354 | VCR report objects should not retrieving data from the custom analysis fields | Improvement | 2.4.0 | No | No | Tidy up of database objects . Internal only | ||
| VC345 | Per Line Margin on Sales Order Entry | New Feature | 2.4.0 | No | No | New feature to have an extra column on the 'lines' tab of sales order entry which shows the margin for that line at the price entered, allowing for the cost of the product in 'real' terms ie including the freight, storage etc.. and this margin per line value should change when the sale price on the line changes. Margin is based on the sales price - cost price and should be based on the rotation number specified or in the event nothing is supplied it should use the OLDEST rotation with available stock as this is likely to be the one used on a standard FIFO operation. Call the column "Margin" with a tooltip saying "If rotation specified then cost price of the rotation has been used, otherwise we take the oldest rotation with stock which would be used on a standard FIFO. This is only to provide an indication of margin" Show the field at all times but allow for the field to be controlled through a user group control function, so only if enable will it be filled. | ||
| VC328 | Improvements to the 'warehouse account code' field | Improvement | 2.4.0 | No | No | tblWarehouse.WarehouseOperatorSiteCode 1) Field length increased to 8 2) Field name is misleading. Should read tblWarehouse.WarehouseOperatorAccountCode | ||
| VC327 | Cannot view Stock Frozen Reason anywhere after it is entered during the freezing of stock | Improvement | 2.4.0 | SLY-649-43866 | No | No | When you freeze stock in VC you are asked for a reason. This is saved on tblstockfrozen as field 'reason'. However it is then never displayed in VC, not when you list the frozen stock you have via the navigation pane nor when you then double click on the frozen stock to open the frozen stock record. You can unfreeze it but it does not show you why it was frozen. Modify the search results to show the reason after the frozen by column in the results form. On the frozen form you then open when you select it should also show the user and reason on the right side of the row, and make the form bigger to display this. | |
| VC320 | PO Invoice Number field expansion | Improvement | 2.4.0 | No | No | The current field is limited to 8 characters, however sage does not have this limitation any more and we should expand the field to the sage maximum size (30) on vision form, db and on the sage posting. | ||
| VC293 | Create Delivery Service Screen needs to be clarified | Improvement | 2.4.0 | No | No | Display text to provide customer clarification for the use of this saying. "The Delivery Service should be based on the delivery options offered by your warehouse. Please contact your warehouse for further details." Change made to clarify .......as per https://visionsoftware.atlassian.net/wiki/display/VC/Delivery+Service in the WIKI. | ||
| VC275 | VC - EAN Code Warning | Improvement | 2.4.0 | IDC-449-21367 | No | No | Can we have a warning when a duplicate EAN or UPC code is added in Product Maintenance screen. When entering values into below fields check to see if the same code already exists. If code already exists then warn the user. Warning options are to accept it or try again which will remove the value entered from the field to start again. | |
| VC274 | VC - Auto Archive Products | Improvement | 2.4.0 | YTD-415-52864 | No | No | Add an option to the Maintenance Menu which will allow a procedure to be run which marks Products as Archive . The routine will update products to be marked as archived. The basis of the process is when the product has no stock, no SOP, no POP and where the last movement date was before X (where the user can define what X is to then obtain a list and select the products which match and then they can archive them in one go. | |
| VC261 | Web Extract - ftp option | Improvement | 2.4.0 | No | No | Currently the web extract now creates and automatically FTP's the files to the remote server. On the VC form, where this is run manually the user should have the ability to deselect this option so that the files can be run and dropped to the output directory. | ||
| VC225 | Update to Delivery Note - additional fields added. | Improvement | 2.4.0 | FJZ-250-75878 | No | No | Modify the existing note to contain the following Add the following fields - Delivery times - Contact Name - Contact telephone number - Page numbering - Qty total at end of note to the existing delivery note | |
| VC219 | Purchase Order - DP flag on each line not the header | Improvement | 2.3.0, 2.4.0 | No | No | When entering a Purchase Order we default the IsExcisedutyPaid in the UK flag based on the header of the purchase order (its based on the supplier country) We may however be purchasing items which are both duty paid and underbond in the order, so we need to add this flag to the purchase order lines to enable the users if required to change the flag when needed. When stocks are receipted also on the automated receipting we should automatically tick the IsexciseDutyPaid if the rotation matches ??/D?????? The flag can not be changed once the goods have been received. The PO lines screen needs to show this field. The PO default note should display this field against each line ONLY if there are lines on the order which are both marked as true and false. e.g. If all lines are FALSE the layout need not show it. | ||
| VC207 | Product maintenance form changes for Livex LWIN service integration into VC | Improvement | 2.4.0 | No | No | Livex functionality has been added | ||
| VC199 | Stock Movement Enquiry - additional filters | Improvement | 2.4.0 | No | No | Please add the following other filters Rotation Number (with lookup) Movement Type (drop down) Posted Batch No Posted Batch Date (already exists) Also make the screen wider to reduce horizontal scroll | ||
| VC194 | Delivery note modifications and changes to the output options | Improvement | 2.4.0 | No | No | Problem : All SOP documents are operated from a single flag controlling what should happen. In Customer-> Analysis Tab Remove the word Delv Notes from the text as these will not use these options. The delivery note would NOT go to the customer so when it runs the options should be to print OR to email the pdf to the user running the job. Modify the Delivery Notes - swap the delivery and invoice addresses around as a delivery note should predominantly have the delivery address at the top of the page not hidden at the bottom. Ensure - delivery note should NOT be getting sent to the customer it should be printed or all emailed to the user who is running the job. Also 2 copies of Delivery Notes are needed by default when you use the PRINT ALL / PRINT SELECTED options in SOP Docs. However If you pick an individual note and PREVIEW then print it should continue as it does currently where the user can set it. | ||
| VC193 | Incoming / Outgoing XML Files | Improvement | 2.4.0 | No | No | Outgoing files to warehouse - Product Codes / Pre-Advices | ||
| VC186 | Warehouse - store delivery times to be used on transfer orders for default | Improvement | 2.4.0 | No | No | Within the warehouse table can we store open/close times for the warehouse. Allow these to be editable on the warehouse maintenance. When creating a STOCK transfer order can we then default the times on the SO to the times held in the warehouse file, we would use the receiving warehouse times. 2 sets of fields as per standard sales order are required. Earliest from and to Latest from and to. This is generally used when moving stock from the warehouse to the local office. | ||
| VC184 | So on hold - ability to get sage financial data | Improvement | 2.4.0 | No | No | On so on hold form add the ability to get sage data which then populates two additional fields. Credit limit Balance As each SO for a customer is shown seperately then each line would have this information populated, but the system should be able to work out that a query to customer record on sage is only required once if the customer has multiple orders on hold. Also Provide link to customer record from form | ||
| VC182 | SO Template -rename and define no of days | Improvement | 2.4.0 | No | No | On so form change name -template - to - Prev. Orders- Also store as a variable the no of days to run the start date of the query from, show this on the configurable options form and change the procedure to use this Also DELISTED products should still appear on this Add the delisted flag to the form as well. | ||
| VC177 | Analysis codes - mark as archive to stop them appearing | Improvement | 2.4.0 | No | No | Mark analysis code as archive provide option. Any archive marked will not show in the options on customer, prod, sales order etc. Any form using these fields, if archived will not appear. | ||
| VC175 | SOP Docs - store extra auditing data, who sent to, date time and show on the form | Improvement | 2.4.0 | No | No | To aid auditing on the SOP Documents On the SOP Documents form we want to be able to view the audit information on documents which have been sent, to this end add a link to the Audit on each line showing the audit trail for each item, the audit trail should open a small form showing : 1) the date/time of the last sending in descending order 2) VC user who sent it 3) Who it was sent to 4) The bit flags for printed / emailled. If nothing exists then say "no audit information exists" | ||
| VC173 | Financial credit note - ability to associate with original sales order for audit purposes | Improvement | 2.4.0 | No | No | Provide association of credit note financial with sales order to aid auditing. Add a new field into the SOP Header table which is called Associated PKID, which will only be visible for Financial SO and will allow entry of any numerics which check to ensure the PKID exists. On the stock movement table also show this AssociatedPKID inthe table. For any other order, default the contents of this new field to be the same as the PKID. | ||
| VC83 | Stock movement enquiry improvements for stock adjustments (new reference field) | Improvement | 2.4.0 | VMV-576-33236 | Stock movement enquiry already has a reference field, but for adjustments this is blank. Add a new column into the stock adjustment screen 'customer notes' which allows users to enter a varchar (255) reference/note for the movement which is displayed on the enquiry form (by showing an (i) roundel which when pointed at will display the note (only shown if there is a note) and database in a new field. Also allow the searching by Movement Dates Batch posting Reference (Included in VC-199) nominal account (search debit or credit) The ability to display the information grouped into batches with the ability to drill into each batch to provide the current level of granularity. This would involve having an option to group by batch and provide a + on the left to allow the batch to be expanded. | |||
| VC81 | Purchase Order Results Pane - Enhancements | Improvement | 2.4.0 | 1. The required Date is currently in the incorrect format, it current shows as "yyyy/mm/dd" but it should be "dd/mm/yyyy", please see attached for reference. 2. Can the Supplier Ref be added to the results pane and also can this field be added to the Filter Options for purchase orders as this will be required to filter results. | ||||
| VC42 | SO Entry Template Enhancements | Improvement | 1.7.27 | 2.4.0 | Adding NEW SO Template facility Business Requirement - When a restaurant offers wine they have a thing such as a wine list, usually with numbers and in a set order, that restaurant tend to order just from that list. We are going to store that list in the DB, one for each customer account, a new table tblVisionCustomerSOTemplate should be created to store this. The SO Form will then have a new button called "Template" which will require a new table to be created. (dont confuse this with the existing one which is renamed in VC-182) When opened this will display a form taken from the data in the tblVisionCustomerSOTemplate table. which is to speed up ordering for restaurants, the idea is that the restaurants standard wine list can be loaded into the template and the order processor can then open the template retrieve the listing of the wines, see the availability and the last order qty and date. We need the ability to export the list to the operator by email, this email will show Customer Name Product Code - Product Description - Producer - Vintage - SS - SPC - ListOrder The template should be editable and any products can be removed with no audit. On the SO form add a new button which opens the template "Template" and this will open the items from this table and present them to the user, the following fields should be shown Item, Product Code, Last Ordered (which is a date), Last Qty, Order Avail Cases Bottles 1 ABC1234 12/12/11 3/0 60/4 __ __ The user can then update the cases and bottles fields and then ADD them to the order, this then adds those items with quantities to the order. | |||
| VC40 | Purchase Order - Supplier Terms visible on input - TBB-916936 | New Feature | 1.7.27 | 2.4.0 | Upon creation of a new purchase order, when the supplier is entered, populate the "supplier default terms" to the purchase order terms box from the supplier account This will allow the user to modify them, so just ensure that the print report layout uses the terms from the po header and not the supplier table | |||
| VC1 | Analysis Code Cleanup | Improvement | 2.4.0 | A new level of analysis was added to VC for the VCR project (Analysis Code Groups). 1) Against Customers / Products / Suppliers / Delivery Addresses (each of their respective maintenance screens), we should now show in a read only text field next to each of the analysis codes, to show the 'Analysis Code Group' against the selected analysis code. So for example, customer analysis option 'Sales Rep' has analysis group 'Rep Group'. Joe Wagner is in rep group 'Fine Wine', in customer maintenance, if a customer has 'Joe Wagner' selected as their sales rep, 'Fine Wine' will show in a read only text field adjacent to the analysis code combo box. Added for potential future use. |
Version 2.3.4 (06/08/2014)
VC-479 was released which is a fix to users of the previous release, this fixes a bug in the EP Cost of sales accrual where a purchase in foreign currency was being accrued at the foreign currency rate and not taking into account the exchange rate. This only applies to the accrual (where you will accrue too much) and only for those customers posting stock movements.
Version 2.3.3 (01/08/2014)
| Key | Summary | Issue Type | Affects Version/s | Fix Version/s | Apply License | System Config | FusionUID | Release Notes |
| VC474 | Error when using Direct Collect when allocating EP orders | Bug | 2.2.7, 2.3.3 | 2.3.3 | No | No | OGM-983-35008 | When allocating EP Sales Orders. On the Allocated EP Orders screen, if the Direct Collect box is checked and then the stock is allocated. Upon clicking the Commit button and error is received saying "Invalid column name 'DirectCollect'" |
| VC473 | SalesLeft Invoice Layout | Improvement | 2.3.3 | No | No | Modified to pull the qty and value fields back to the top line. | ||
| VC471 | EP Order Allocation of Type R causes overwriting of TOWN field in delivery address with lengthy information | Bug | 2.3.2 | 2.3.3 | No | No | Old method for type R orders had not been removed, addressing section now as per EDI specifications | |
| VC470 | Incorrect Supplier Price showing on Report 2 2 | Bug | 1.7.28, 2.3.2 | 2.3.3 | No | No | PLW-657-71996 | As description |
| VC466 | Product Search returns Object reference not set to an instance of an object error | Bug | 2.3.3 | 2.3.3 | No | No | Error message fixed | |
| VC464 | IsCustomerPickUp field in SO Submission XML is passing wrong value | Bug | 2.3.3 | No | No | Fixed SO submissions | ||
| VC463 | Product Maintenance Screen > Sales Orders showing multiple lines for order when picked from multiple locations | Bug | 2.3.3 | No | No | GCN-519-64644 | Now resolved | |
| VC455 | VCR Functions - Not passing PKCustomer but a 1 | Bug | 2.3.3 | No | No | Now resolved | ||
| VC454 | UnPaid Reserves - Order Processing | Improvement | 2.3.3 | No | No | Product Screen - This shows the order available correctly but does not highlight that there is a potential issue when Unpaid Reserves > 0 Colour code the Product screen - Stock section so that when the Available for Order Stock is shown, if Unpaid Reserves > 0 then the background colour of the Available for Order and the Unpaid Reserves are shown in YELLOW (light) Please also adjust the Order Available to take into account the UnPaid reserves when you show the Order available figure. Additionally in ordering, if there is something on unpaid reserve the ordering screen will basically state "not enough available" when you try to order into the reserve and now will not allow this to happen. The idea of the Unpaid Reserves was to keep some back, but its unpaid and like most companies they want the ability to sell things. For example I have a hotel which wants me to keep some stock for them but unpaid, thats fine because I know I have more coming in, so I allow my available stock to be sold but not modifying the reserve. So where the order is placed and the order available is lower than the requested quantity but adding the unpaid reserves onto this then means there is available stock then ALLOW the order to be entered, a new button which says "Accept - Use UnPd Reserves" should display when this is possible allowing the user to force the order through. | ||
| VC453 | PO Acknowledgement - inconsistency in Underbond Message | Bug | 2.3.3 | No | No | There are three distinct messages Duty Paid - where all lines are DP Underbond - where all lines are Underbond and where there is a mix then it should state "UB if possible else DP" | ||
| VC452 | GRN Accruals reports returning stocks already landed incorrectly | Bug | 2.3.3 | No | No | GRN Accruals report was returning already landed stocks, made changes to Accruals to fix this | ||
| VC450 | Credit Note allows user to enter the same rotation for different products | Bug | 2.2.7, 2.3.3 | 2.3.3 | No | No | ZEX-846-75861 | When entering rotations for a return to stock credit reason, the customer is allowed to enter the same rotation for multiple credits on different products which is not allowed |
| VC446 | Error when saving PO due to supplier discount | Bug | 2.3.2, 2.3.3 | 2.3.3 | No | No | GWA-643-27307 | When saving a PO when the supplier has a discount set up of 12.00%, the error the customer is getting is shown below: Failed to save purchase order.System.Data.SqlClient.SqlException: Arithmetic overflow error converting numeric to data type numeric. The statement has been terminated. If the discount is removed from the supplier it saves |
| VC445 | VC - Request to be able to manually verify 1 invoice | Bug | 2.3.3 | No | No | SCE-939-74834 | When you system verify invoices for the week, if there is 1 invoice that is not in sage, it returns all invoices after this one, even though they are in sage. We would like to be able to manually verify just this one invoice, and then system verify the rest of the invoices that are in sage, rather than having to manually verify all the invoices. | |
| VC444 | VC - Replicate sales order is not updating the order date | Bug | 2.3.3 | No | No | UJP-940-95827 | Use Replicate SO function the order date does not update to today's date but stays the same. | |
| VC436 | BI - PO Reports not showing if description 2 is not used. | Bug | 2.3.3 | No | No | As this is no longer a used field its been removed from the report requirements. | ||
| VC432 | VC - verify invoices shows invoice number of 0 | Bug | 2.3.3 | No | No | NMQ-938-67688 | When a financial credit note order is placed, with 0 as the invoice number and £0 value. This is correct as a record needs to be recorded in this table. The issue is this invoice is showing in the verify invoices screen, which is should not as it not an invoice and therefore will not be sage. The relating credit note invoice is showing correctly in this screen with the credit note invoice number. The invoices that show in the verify invoices screen should not show these 0 number invoice records as they will not be in sage and therefore cannot be verified. | |
| VC431 | Remove FKReceivingCustomer from SO Submission file | Bug | 2.3.3 | No | No | Field not required | ||
| VC429 | Rotation Maintenance Not working for long product codes | Bug | 2.3.1, 2.3.2 | 2.3.3 | No | No | ZFB-215-96249 | Rotation Maintenance does not work for LIVEX length codes (18) |
| VC428 | VC - Manually partially receipted lines on POs receipted for full qty when GdsRcvd fileprocessed | Bug | 2.2.7, 2.3.2 | 2.3.3 | No | No | WLZ-618-63194 | PO raised in VC. PA raised in VW and receipted. PO in VC partially manually receipted. (a new line for outstanding quantity is created). GoodsReceived file processed in VC. The outstanding line is receipted for the full amount received on the PA in VW. Result: Excess stock has been landed and it has created a pkStock record with a duplicate rotation number. The qty received on the outstanding line should be less the qty already received. This was NOT a bug but the customer interfering with an automated process which has now been locked down |
| VC425 | VC- Rotation incorrectly req for return to stock credit note to non rotation warehouse | Bug | 2.3.3 | No | No | HWR-367-16103 | • Return to stock credit note • Sales order was in a Rotation warehouse group • Stock coming back to non-Rotation warehouse group • A rotation number is still required and the credit note will not process without one. You should be able to do a return to stock credit note to a non rotation warehouse without needed a rotation number. | |
| VC423 | VC-BI Report 5-1-2 not displaying net values correctly for all ordes | Bug | 2.3.3 | No | No | GMH-845-96421 | A fix in the old VCR was not carried to the new version, now done | |
| VC420 | VC- Testing Issue Cannot Create Pro Forma | Bug | 2.3.1 | 2.3.3 | No | No | DYN-367-86492 | Logo left template was erroring |
| VC415 | SO allocations not always going to submissions | Bug | 2.3.2 | 2.3.3 | No | No | WUJ-508-70148 | Relation to VC-241, even if an order is allocated with the inv-only option ticked it should still create an SOsubmissions record, but the "should be sent" flag should be set to false. |
Version 2.3.2 (14/05/2014)
| Key | Summary | Issue Type | Affects Version/s | Fix Version/s | Apply License | System Config | FusionUID | Release Notes |
| VC411 | VC- widen product code on invoice layouts | Improvement | 2.3.2 | No | No | TAA-700-29459 | Customers adopting the LIVEX code as their main code reported that invoice layouts were not wide enough to accommodate. Invoice layouts (3 main ones) were increased, the layout with columns can not be increased due to space limitations | |
| VC410 | Report Manager - Layout - Fax Number | Improvement | 2.3.2 | No | No | YSL-648-30628 | Add Fax number into the report manager to stop it appearing when the Vision customer does not have a fax | |
| VC409 | Stock Turn Report - 3.1.2 - incorrect reference to analysis caption 9 | Bug | 2.3.1 | 2.3.2 | No | No | If customer is not using analysis codes leaving them blank some reports were not working. This has been corrected on the Stock Turn report. | |
| VC408 | Amend Customer Reserve Trading Report to give more information | Improvement | 2.3.2 | No | No | The customer reserve trading report needs to be amended as it does not show the commission or admin charge which can be found on the Web/reserve tab of customer maintenance. We should show the sales price the paying price and then the admin charge at the bottom, t The aim is to allow the user to work out the amount they owe to the reserve stock owner when they trade reserve stock (i.e. the sales value minus the commission and admin charge). |
Version 2.3.1 (18/04/2014)
| Key | Summary | Issue Type | Affects Version/s | Fix Version/s | Apply License | System Config | FusionUID | Release Notes |
| VC405 | Unhandled error if user selects 'Mailing List' before adding a new contact | Bug | 2.3.1 | 2.3.1 | No | No | Select the contacts tab on the Customer Maintenance screen (for any customer). If the user wants to add a new contact and hits what will be the 'Mailing List' box (which will be blank as you haven't added the new contact yet), you will get an Unhandled exception error - Index ... has no value'. You can 'space bar' out of it and enter + save a contact as normal. You have to add a new contact (& save it) before you can edit the mailing list, so rather than the Unhandled exception, it would be better to display a helpful message, such as 'Before you can access the mailing list please enter the new contact details first' | |
| VC404 | Stock valuation function logic for returning non reserve customer stock | Bug | 2.3.1 | No | No | Change the logic in the stock valuation function for BI report 3_4_1, (tblStock.FKVisionCustomer IS NULL OR reserve customer code = WhseCustomerCode) This will now display stocks owned by the VC customer which are in the reserves and not using a reserve customer code (of course this is inconcistent with the warehouse use) | ||
| VC403 | VC - Rotation Maintenance view only displays a single rotation when filtered | Bug | 2.2.7, 2.3.0 | 2.3.1 | No | No | JWW-699-35680 | Rotation Maintenance view only shows a single row when filtered by a rotation that has duplicates. This means The Customer can create duplicates but not rectify them afterwards. |
| VC399 | Product Screen Warehouse Stock Levels issue | Bug | 2.3.1 | No | No | The warehouse stock levels are supposed to show what is available in the warehouse, these have now been updated. EP SO and EPPO have been seperated to the right side and now form part of the available stock figure which is shown on the right. | ||
| VC397 | Product Form - field lengths | Improvement | 2.3.1 | No | No | Product lengths increased to 20 characters in line with customers using LIVEX | ||
| VC391 | EP Stock available Info | Improvement | 2.3.1 | No | No | New report added to the system. | ||
| VC390 | Product Maintenance Form | Improvement | 2.3.1 | No | No | superceded by VC399 | ||
| VC385 | Detail Margin Report 5 4 4 does not show S and E | Bug | 2.2.7 | 2.3.1 | No | No | Done | |
| VC384 | Correct E and S on Accruals Reports 5 3 2 and 5 3 1 | Bug | 2.3.1 | No | No | Done | ||
| VC383 | Add Cost Price on EP Reports 5212 and 5211 in BI | Improvement | 2.2.7 | 2.3.1 | No | No | Done | |
| VC380 | Add customer code for reserve stock on Stock Valuation Report in BI 3 4 1 | Improvement | 2.2.7 | 2.3.1 | No | No | Not done, cancelled this customer request as a stock valuation report will not show reserve stocks in the first place as the stock does not have a value in relation to a Stock Valuation as this report is predominantly used by customers to check their Sage Balance sheet, it should not show stocks NOT OWNED by the VC customer | |
| VC379 | Show Warehouse on BI Report 3 8 Total Stock Available | Improvement | 2.3.1 | No | No | Done | ||
| VC377 | BI report 1 2 1 is not the same as it was in VCR | Improvement | 2.2.7 | 2.3.1 | No | No | Modified | |
| VC374 | Unhandled Exception when trying to Create Duty Rates | Bug | 2.2.7, 2.3.0 | 2.3.1 | No | No | ZKA-211-36186 | When trying to create a new Duty Rate via Maintenance > Create > Create Duty Rates an unhandled exception error comes up. The message is detailed below Object cannot be cast from DBNull to other types. See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.InvalidCastException: Object cannot be cast from DBNull to other types............ |
| VC373 | Stock Valuation using start date | Improvement | 2.2.7 | 2.3.1 | No | No | The stock valuation report appears to be using a start date (It has an S showing when you run it) but is should not be as it should be a valuation as at the end date of all the stock a client has at that date regardless of when it was put onto the system. This is not the same as closed issue VC-352 | |
| VC372 | GRN Accrual report 5 3 2 missing Date Arrived | Improvement | 2.2.7 | 2.3.1 | No | No | GRN Accrual report 5 3 2 need the column added for Date arrived as this will allow users to sort by this and will provide further useful information. | |
| VC370 | VC - Broking Credit Notes not following through to SAGE | Bug | 1.7.28, 2.3.0 | 2.3.1 | No | No | PNM-281-77961 | Customer have a credit note reason ‘Broking Credit Notes’ set-up to use a base nominal of 5095, they have this Nominal Code set-up in Sage. When they raise a Financial Only Credit Note Sales Order, SalesOrderHeader shows the CreditNominalCode correctly as 5095, however when the Message is generated to go over to Sage is gives it a Base Nominal of 4050. It doesn’t mention the Credit Nominal at all, so is not going into the correct nominal account. |
| VC369 | Reports - SalesMan report 5_9 - not using dates | Bug | 2.3.1 | No | No | The above report takes forever to run as it is not taking into account the START date specified nor the end date. This report has been modified to used both to reduce the overall time it is taking. | ||
| VC368 | EP Stock Not Landed Report - no output when no product analysis | Improvement | 2.3.1 | No | No | This was not working when customers had no product analysis setup, it now works. | ||
| VC367 | Report Stock Turn 3 1 2 - no analysis codes | Bug | 2.3.1 | No | No | This was not working when customers had no product analysis setup, it now works. | ||
| VC366 | Adding a contact gets a constraints error | Bug | 2.3.1 | No | No | SOP Docs flags on customer contacts were causing an error when adding a new contact into the system, the default for the SOP Docs was not set. | ||
| VC350 | tblWarehouse.WarehouseOperatorSiteCode - Name Change and Column length update | Bug | 2.2.6 | 2.3.1 | No | No | More logical naming for the warehouse information | |
| VC330 | Incorrect processing when updating UB price/case on a product | Bug | 2.2.6 | 2.3.1 | No | No | Product Form - Purchasing and Pricing Tab When you amend an existing product and change the UB price/case the duty paid price/case AND the duty paid price/single both update but the UB Single per case does not. This needs to also be recalculated if the UB per/Unit is modified. |
Version 2.3.0 (01/04/2014)
This version will disable all use of the VIC access on the Vision database, since v2 release VIC was not supported and results could be wrong as many changes to the structure took place. From v2.3 this will not longer be active and you will have no connection to the data from VIC.
| Key | Summary | Issue Type | Affects Version/s | Fix Version/s | Description | Apply License | System Config | FusionUID | Release Notes |
|---|---|---|---|---|---|---|---|---|---|
| vc 394 | General Sales Report bringing back extra data | Bug | 2.2.7 | 2.3.0 | No | No | PYT-196-51445 | Reports bringing back extra data.Getting three entries for each product, the first is just the product code, the second has JOE on the end and the third has WAGNER. This has been amended | |
| vc 393 | Ex Cellar order entry - error message on Purchase Order tab | Bug | 2.3.0 | No | No | Without entering any data on the Ex Cellar Sales Order screen, select the Purchase Order tab. This produces the following error: 'Cannot bind to the property or column DutyPaid on the dataSource. Parameter name dataMember.' On further investigation, it has been found that this error also appears if you try to access an existing ex cellar order - meaning that the users are unable to amend any Ex-Cellar orders. This was caused by the PO DP line flag on excellar orders not setting, now based on the SO type | |||
| vc 392 | Unable to allocate EP Sales Orders | Bug | 2.3.0 | No | No | Enter an EP Sales order and then go to the appropriate campaign allocation screen. Enter a bond type and try to allocate your order. this error (for all bond types I tried to use): 'BMC Internal Application error... Unable to create purchase order' Close the screen (either opting to save or not) and re-open, my order has disappeared from the allocation screen. | |||
| vc 389 | SO Submission file RotationLineNo format not correct | Bug | 2.3.0 | No | No | Found an output on an SO Submission file and it has a problem which would stop the XML from working. The RotationLineNo format is wrong. The format of the field is either 'YY/D123456' or 'YY/D123456/nnnn' The nnnn can be 1 to 4 digits. Currently picking up from the first '/' and not the second one. | |||
| vc 376 | Upload Product Prices Issue | Bug | 2.3.0 | No | No | There is an issue with customers uploading the price lists into the system The file is uploading and not failing or pushing the entries to validation failure but updating nothing. | |||
| vc 363 | No VAT on Product Invoice showing VAT | Bug | 2.3.0 | No | No | KWA-308-12493 | The VAT logic on invoice creation was not looking at the product lines to see whether VAT should be charged and was basing it on the header, however the sage extract was checking the line. The calculation has been centralised | ||
| vc 361 | Further BI Improvements | Improvement | 2.3.0 | No | No | 1) Speed improvements 2) Date ranges not being used correctly 3) previously hidden columns removed 4) Timeouts on reports requiring re-writes of the process 5) Resize columns to sensible sizing when report opens, do not try to squash all into the open window 6) IFiltering on decimals has been sorted to allow entry of more than 2 where needed | |||
| vc 360 | Layout/Formatting issues with Invoices | Bug | 2.2.6, 2.2.7, 2.3.0 | 2.3.0 | No | No | GCP-888-60714 | This was specific to a customer layout and has been resolved. Issue where on certain pieces of paperwork the lines are being printed twice however the second copy of the line on has quantity, price, value and VAT. - SO Acknowledgement – Line printed twice - Delivery Note – Line is only printed once - Pending Invoice (Preview) – Line printed twice - Actual Invoice – Line printed twice | |
| vc 359 | Sage Line 50 v2014 | Improvement | 2.3.0 | No | No | Make Vision to Sage service compatible with the latest version of Sage 50 | |||
| vc 358 | VC - No warehouse choices on STOCK TRANSFERS | Bug | 2.2.7 | 2.3.0 | No | No | OCO-417-37936 | We removed the restriction which was only showing reserve warehouses which was added in error. Any real warehouses will be shown. | |
| vc 357 | BI Review | Improvement | 2.3.0 | No | No | 1) When selecting the report some take a while to run, but the screen freezes whilst this is running, it should on all reports come up with a box on the screen which is animated in some way saying "Report is being generated, depending on the volume of data requested this may take a little time" 2) No report seems to have a drop to excel function on them, this would be required on all the reports. 3) Each Report needs to have its reference number against it e.g. Stock Valuation is 3 4 1 4) Identification of each reports use of the "Set Report Dates" e.g. 5_7 Credit Card Orders [S][E] 5_11 Sales by Product [E] | |||
| vc 356 | EP Accruals query is filtering by start date | Bug | 2.3.0 | No | No | In VCR-23 we changed the report to filter by start date to speed up the function, and although it achieved that, it means the users are getting inaccurate results in the stock valuation as the start date entered is ahead of the EP dates. The start date check needs to be removed. | |||
| vc 355 | Ensure VC 2.3 is compatible with Sage 2014 | Improvement | 2.3.0 | No | No | Ensure SAge 2014 and VC 2.3.0 are compatible | |||
| vc 351 | Re-instate the Bank details | Improvement | 2.3.0 | No | No | In the report manager we have two options which need renaming and the reports need altering. Bank Details - change the text to read "Show GBP Bank on non GBP Invoice" Internations details - change the text to read "Show nonGBP Bank on GBP Invoice" Modify the reports to use the flags as above. on GBP invoice only GBPBank details to show unless the International details flag is yes. - this currently works.......... on non GBP invoice - show only the international details unless the "show GBP bank on non GBP invoice" is true when both should be shown. Currently this does not work as above and always shows the GBP details. | |||
| vc 347 | SO Export - Tweaks to some fields | Bug | 2.3.0 | No | No | Some of the fields being sent in the SO submission file are wrong - DPAccountRef - This should be the tblVisionCustomer.Account and for Transfer orders it should be tblWarehouse.WarehouseCode. - Sales Price is supposed to be truncated or rounded to be 8.2 it should not be sending 5 decimals. Also the LD section is sending in FKProductOrder in reality it should be in PODLineNumber Order. | |||
| vc 305 | Bring reports across from VCR into the main VC application | New Feature | 2.3.0 | No | No | Remove VCR requirements, move everything to new BI option in Vision Commerce. Remove VIC compatibility and access to the db. | |||
| vc 228 | Update Purchase Price - automatic update after input of invoice | Improvement | 2.3.0 | No | No | Add a customer controlled option ( In Admin -> System Configuration options) and when its enable when a preadvice is save FOLLOWING invoice entry that we update the product price with the price from the invoice. At present this can only be run manually, we want this to be available as an automatic option. | |||
| vc 219 | Purchase Order - DP flag on each line not the header | Improvement | 2.3.0, 2.4.0 | No | No | When entering a Purchase Order we default the IsExcisedutyPaid in the UK flag based on the header of the purchase order (its based on the supplier country) We may however be purchasing items which are both duty paid and underbond in the order, so we need to add this flag to the purchase order lines to enable the users if required to change the flag when needed. When stocks are receipted also on the automated receipting we should automatically tick the IsexciseDutyPaid if the rotation matches ??/D?????? The flag can not be changed once the goods have been received. The PO lines screen needs to show this field. The PO default note should display this field against each line ONLY if there are lines on the order which are both marked as true and false. e.g. If all lines are FALSE the layout need not show it. |
Version 2.2.7 (10/02/2014)
| UID | Summary | Issue Type | Affects Version/s | Fix Version/s | Apply License | System Config | FusionUID | Release Notes |
| VC 348 | Product maintenance errors when timing out retrieving product details | Bug | 2.2.7 | No | No | When opening products on our test server we occasionally get this error: " BMC Unknown internal application error Unable to retrieve product details" There was an issue in the procedure relating to server security which has now been resolved. | ||
| VC 343 | Cannot process any return to stock credit notes | Bug | 2.2.6 | 2.2.7 | No | No | The error is when - Create a sales order in warehouse which uses rotation numbers. then Allocate, commit, deliver stock, invoice. Attempt to add a credit note, pick a return to stock credit note reason, tick the processed box, click on close and save and get error message 'Mandatory Rotation number is missing' There is now a credit note record with no rotation number as it has not been saved so it cannot be processed as it is not in SOP documents but the rotation number now cannot be entered. | |
| VC 341 | Doubled lines on Sales Order | Bug | 1.7.28, 2.2.6 | 2.2.7 | No | No | ENP-429-86158 | A sales order 29450 that was placed with 4 lines each for 3 singles, however the invoicing tab is showing the same 4 lines but with 6 singles each. This was replicated in our test and was caused by the same order being marked as delivered by two different users at the same time. |
| VC 340 | After increasing the EPPO qty users are unable to add further sales | Bug | 2.2.7 | No | No | EP: PO for 10 cases SO for 10 cases Update PO for 20 cases instead of 10 Another SO for another 10 The 'Link PO' button (previously 'Allocate to EPPO') does not allow us to link for the additional cases. | ||
| VC 339 | Button to link EP SO to EP PO | Improvement | 2.2.7 | No | No | Rename the button AND the window to 'PO Link' from 'Allocate EPPO' | ||
| VC 338 | SOP Allocation Failure when EPSO uses Stock adjusted | Bug | 2.2.7 | No | No | When we wrote the initial EP allocation module we assumed all customers were following a standard method for dealing with receiving different size cases on EP purchases. It turns out some customers were not using this and were receipting the stocks and then adjusting them out and adjusting a different stock in but these would never be allocated to the EPSO...... so sending stock out was made impossible. We have relaxed the requirements to allow this to happen. | ||
| VC 337 | Saving a Sales Order twice causes UnderBondType to be Null'ed and changes DutyPaid flag | Bug | 2.2.5, 2.2.6 | 2.2.7 | No | No | LRG-246-48234 | Updating an order after initial saving was causing the duty paid box to reset itself. |
| VC 336 | Selling prices wrong background on product purchasing and pricing tab | Bug | 2.2.6 | 2.2.7 | No | No | Modified background | |
| VC 335 | Stock availability issue allowing more stock to be ordered than available | Bug | 2.2.7 | No | No | Under some conditions the system when adding the same product again on another order the system was not re-checking the availability. | ||
| VC 334 | Allocation Screen showing incorrect document and message | Bug | 2.2.6 | 2.2.7 | No | No | JBH-938-26805 | Modified the text |
| VC 333 | Credit note asking for warehouse Code on non return to stock credit notes | Bug | 2.2.6 | 2.2.7 | No | No | NCW-803-35898 | Similar to VC-343 but this time for items with no rotation required for receiving warehouse. |
| VC 332 | Error when updating the quantity ordered once the EPPO link has been created. | Bug | 2.2.7 | No | No | UTO-355-72960 | When updating the quantity of a line on an EP order, if you update the line total and the new amount is more than the available it won't allow you to save it. It is not taking into account the amount already allocated. Example. PO has 20 units Create an SO for 10 units and allocate it against the EP. Save the order Re-open the order and update the line to 20 units - you will get an error ''not enough stock for this line to allocate'' Delete the line and add the full 20 units - allocate EP and it saves fine. |
Version 2.2.6 (15/01/2014)
| UID | Summary | Issue Type | Affects Version/s | Fix Version/s | Apply License | System Config | FusionUID | Release Notes |
| VC 325 | Allocation of EPPOs for an EPSO is incorrect | Bug | 2.2.6 | 2.2.6 | No | No | From testing | To re-create : Add 3 EPPO's for the same product, with quantites 5/0 (EP553), 10/0 (EP555) & 7/0 (EP556). Receipt them all. Enter an EPSO for 14/0 (EP3876). Allocate EP553 & EP555. This writes 2 rows correctlyEPSalesOrderAllocation (ie EP553 allocates 5/0 & EP555 allocates 9/0). Enter a new EPSO for the remaining 8/0 The allocate PO's screen is selected and it says: EP553 - EP PO Qty (Singles) - 60 - EP PO Price - 0 - EP SOs Linked - 1 - EP SO Unallocated Qty - 0 EP555 120 singles 1 EPSO linked Unalloc qty 12 - EP PO Qty (Singles) - 120 - EP PO Price - 0 - EP SOs Linked - 1 - EP SO Unallocated Qty - 12 **There is a tick against this line** EP556 84 singles 0 EPSP linked Unalloc qty 0 - EP PO Qty (Singles) - 84 - EP PO Price - 0 - EP SOs Linked - 0 - EP SO Unallocated Qty - 0 ISSUE 1: I would expect there to be 2 ticks for the allocation rather than just the tick by EP555. ISSUE 2: Also, it should say Unalloc qty = 84 against EP556. I, then, ticked the box by EP555 & EP556 (making the 8/0), which saves fine. ISSUE 3: However, checking the database now, EPSalesOrderAllocation has incorrect data - rather than adding 2 new rows as expected, only one row has been added, using EP555 for the whole 8/0 cases. I would have expected to see 2 rows: EP555 allocating 1/0 & EP556 allocating 7/0. This would presumably cause issues for the users further down the line when they add more EPPOs for the same product. The Stock enquiry screen reports (at each stage) the correct information. |
| VC 317 | Unable to Add Analysis Captions | Bug | 2.2.4, 2.2.5 | 2.2.6 | No | No | KBN-144-78519 | In Analysis Code Maintenance there is an option to Add/Edit Analysis Captions. This works fine to edit them but if you try to add one it will not save and eventually gives an unhandled error if you try enough times. Go to Analysis Code Maintenance Select Analysis type Product Hit Add/Edit Analysis Captions This should allow 7 Max Captions (as per the number on screen) and there are only 2 so you should be able to enter more Type a new caption in Hit Save Nothing happens Try this again but hit the enter key after typing and all the captions disappear from the screen If you then type in a new code and hit save nothing still happens I cannot get a new caption to save no matter what order I do things in. Captions should be able to be added in up to a maximum of 7. |
| VC 316 | Spelling mistake in Customer Maintenance > Customer Details | Bug | 2.2.6 | No | No | XEZ-862-91866 | Telephone is spelt telelphone. | |
| VC 309 | Customer Unpaid Reserves not showing via Stock -> Unpaid Reserves, but showing via Navigation | Bug | 2.0.1, 2.2.6 | 2.2.6 | No | No | UYD-633-81980 | Issue where they have a product that is showing as no stock available, as they have 40 cases showing in Unpaid Reserves, they have gone to Stock > Unpaid Reserves to try and remove the stock from reserves but it is not showing that there is any stock that is reserved. If you go to the Unpaid Reserves screen via Stock > Unpaid Reserves, it does not show up with any stock that has been reserved, however if you via the navigation pane, and search for the Unpaid Reserves that way it shows up, with the Stock that has been reserved and lets you make adjustments to it from there. |
| VC 308 | Credit note not appearing in pending invoices | Bug | 2.2.5 | 2.2.6 | No | No | When you credit a a line on an EP SO the credit note does not appear in pending invoices if line total becomes zero. Example sales order has 1 line. The line has 10 cases. 10 cases are credited and processed. Sales order takes the 10 cases from the line total. Credit note shows against the line with N/A as the credit note number. Credit never appears in pending invoices, but shows correctly in tblsalesorderinvoice. If you re-open the sales order and try to save you get an error that not all lines are allocated. This is because the data in EPSalesOrderAllocation has the figure of the line before the line was credited. This means if 1 line is credited and there are others that still need to be completed the user can never do this. | |
| VC 307 | SO Submissions screen is not displaying allocated SO's that contain manufactured cases. | Bug | 2.2.6 | 2.2.6 | No | No | From Testing | 1. create a sales order using manufactured product codes 2. Allocate the order(s) - this works OK 3. However, the orders do not then appear on the SO Submission screen |
| VC 302 | When creating new customers/suppliers the default printer is left blank and there is no prompt that this is a required field, which cases problems later | Bug | 2.2.6 | No | No | TSP-831-75857 | Customer Maintenance & Supplier Maintenance, when creating a new customer, set the 'Default Printer Name' to 'Specify at time of printing' as this is what's used 99% of the time. A data script which will update customers and suppliers which do not have this populated when this update is installed | |
| VC 298 | Delivery address 4 not showing on delivery address | Improvement | 2.2.5 | 2.2.6 | No | No | XTX-440-52945 | On an order you are able to input 4 address lines as well as the town, county and postcode. The customer set up is only set as Name Address1/2/3 Town Postcode These additional fields need to be removed from both the SOP forms and the delivery address entry form. |
| VC 297 | Unable to create 'manufactured'' cases | Bug | 2.2.5 | 2.2.6 | No | No | XKK-670-47786 | If you enter a product with components that is type 'manufacturing', VC does not recognise that there is any stock when you try to put it on a sales order (even though there is stock for the components) 'Manufactured' should act in the same way that a 'Mixed' case does, ie all you need to do is set up the product on 'Product Maintenance', add the components, and save as 'manufactured'. You should then be able to add the product to a sales order (as long as there is sufficient stock for each component part). |
| VC 296 | Error whilst allocating stock transfer with 'Generate Delivery Note' ticked | Bug | 2.2.6 | 2.2.6 | No | No | From Testing | Following the steps below results in an error: 1. Enter a stock transfer. 2. Go to the 'Sales Order Allocation' screen. Allocate the stock transfer ensuring that the 'Generate Delivery Note' field is ticked. 3. You get the error: 'Following error occurred while Printing\Emailing: Report Type: Delivery Note Account: Error: There is no row at position 0' A delivery note is NOT printed out, but the transfer is allocated successfully. |
| VC 295 | EPPO allocation on EPSOs resulting in negative stock levels on the Stock Enquiry | Bug | 2.2.6 | 2.2.6 | No | No | From testing | To replicate : entered 3 EPPO's for a new product (EPTESTVC252D) for 5/0, 10/0 & 7/0 respectively. Then I added 3 EPSOs: EP3847 - for 9/0 - alloc EP528 (leaving one available) EP3848 - for 12/0 - alloc EP527 & EP529 (used up both of these EPPOs) EP3849 - for 1/0 - the system defaulted to EP527 for allocating, even though there was 0 stock unallocated. I changed the check to EP528 (which correctly said there was 1/0 left) and saved. All looked fine. I then allocated all 3 EPSO's on the EP Sales Alloc Screen - all processed OK. However, when I run the Stock Enquiry report for the above product, one rotation is listed as having negative availability. As there was enough EPSO's to allocate all of the product, the report shouldn't show this negative stock level. |
| VC 294 | Sales Invoice Currency code is getting truncated. | Improvement | 2.2.6 | 2.2.6 | No | No | Background: On the Currency table , the field CurrencySign should be set as the 3-letter ISO code. Many customers use this incorrectly and set the £ sign so this issue rarely happens but when the ISO value is used and the value amount is more than 4 digits it truncates the ISO Code. The template was adjusted to not truncate. | |
| VC 292 | Stock Transfer Orders not creating an SO submission record | Bug | 2.2.5, 2.2.6 | 2.2.6 | No | No | OHO-784-41144 | Create a stock transfer order Allocate the Order / Commit and at this point the message ''Sales Order submission record created'' No record is create in tblSOSubmissionHeader so the xml can never be sent. This can be replicated on our test environment |
| VC 290 | Product Maintenance - Stock Available for Ordering | Improvement | 2.2.6 | No | No | The general tab in product maintenance shows the warehouse stock levels, but some customers have mentioned that this does not include EP stocks on Purchase orders. The reason they are not included in the available stock is that the figure is used to show what is available at the warehouse. So we are going to add a new column after the "Available" with a small gap between the two to highlight the difference and in a light blue background we will add a column "Order Available" which will take into account what an be ordered based on EPPO. This will also use the same calculation which is used when orders are placed.So this column will agree to the sales order processing. | ||
| VC 289 | Error when using the Mixed Cases Build screen | Bug | 2.2.5 | 2.2.6 | No | No | The error : 'String or binary data would be truncated. appears on the 'Mixed Cases Build' screen when trying to build a pre-mixed case. I have entered a valid souce/destination warehouse, then the product code and hit <return> on the product field. The error above then pops up. This seems to happen for any newly set-up case entered | |
| VC 287 | VC - Crystal Report Error when trying to load proforma invoices | Bug | 2.2.5 | 2.2.6 | No | No | ANS-182-58001 | In the latest version of VC, when producing a proforma invoice from Stock Sales Order it throws up an error message from Crystal Reports as it tries to grab the data (see attachment). This was replicated on the test system as well. |
| VC 285 | Supplier screen asking for a VAT code when you amend supplier | Bug | 2.2.4 | 2.2.6 | No | No | JQP-713-23758 | When you open up the supplier tab and make any amendments it asked you to enter a VAT code even though one exists. If the VAT code exists it shouldn't validate it again. |
| VC 284 | Excise Duty rate displaying the wrong effective date rate in product maintenance | Bug | 2.2.4 | 2.2.6 | No | No | In Product maintenance screen the Excise duty rate is being displayed as the first effective date and not the latest. | |
| VC 282 | Problems caused when symbols are used in the Customer Price List Name | Bug | 2.2.6 | No | No | PNK-733-62827 | Need to ensure the customer price list name can only use characters and not invalid symbols such as apostrophe To replicate Enter price list called "Ruth's List" Enter the Customer admin screen, goto the Customer Contract tab and press F11 to list This produces a SQL error with an unhandled exception. For this to be fixed - SQL should be corrected to allow apostrophe's to not cause the unhandled expception | |
| VC 267 | Postings for reserve customer warehouses | Bug | 1.7.28, 2.2.4 | 2.2.6 | No | No | CAE-688-59089 | When any of the following are made a posting should NOT be made to sage if the stock is from a reserve warehouse: 1) Stock cost adjustment 2) Price variance 3) Stock movements |
| VC 266 | Get Sage details on Supplier tab returns an error when connecting to sage data object18 | Bug | Sage Version 18 | 2.2.6 | No | No | GOQ-195-83799 | When Vision to Sage services 2.2.1 tries to retrieve the supplier transactions from sage the below error is returned. Unable to retrieve supplier details for currency check from sage ---> System.Exception: Failed to retrieve data: System.Exception: Failed to retrieve data: System.Data.Odbc.OdbcException: ERROR [42S02] Table not found at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) This error only occurs with customers who run Sage version 18. |
| VC 264 | Product Form - Stock Summary | Improvement | 2.2.6 | No | No | This is using the warehouse address field to summarise stock, it should be showing the warehouse CODE in the field and not the name or address. | ||
| VC 262 | Sales Invoice not showing the Euro sign on the line item | Bug | 2.2.4 | 2.2.6 | No | No | HJX-943-84092 | Sales Invoice line item showing the £ sign when it should be showing the € sign. |
| VC 252 | Allocate EP PO button against EP SO Lines not retrieving all applicable POs | Bug | 2.2.6 | No | No | 1) Change the process to retrieve FKPODetail statuses 1-5 2) Add a parameter to the procedure and ensure the screen populates it, so we can retrieve only PO's with the same EP campaign as the SO. | ||
| VC 249 | VC - Printing multiple delivery notes. | Bug | 2.2.0 | 2.2.6 | No | No | SNN-651-53691 | In SOP Documents > Pending Delivery Notes • If you select a line and use button “Print Selected” button, increase the copy count to 2, it will only print 1 copy, regardless of the printer selected. • If you click “delivery note” the same note is displayed in a crystal reports viewer, click print report and select 2 copies – both are printed. Anything else on the server in any other program prints 2 copies when asked. |
| VC 160 | International Bank Details not showing on Sales Invocie | Bug | 1.7.28 | 2.2.6 | Even though there are international bank details in the db they are not showing on the sales invoice when the show international bank details box is ticked. Non sterling invoices are not showing bank details, even though the show international bank details box is ticked. I have tested on our test server and created a US dollar invoice, and ensured show bank details and international bank details were ticked. The invoice has created without any bank details showing. |
Version 2.2.5 - Bug Fixes
Note : VC-271 attempted replication of this issue but was unable to do so and the customer who reported it can not replicate this either in their current system, the issues related to stocks received pre April prior to the version the customer is running, The customer reporting this will be going to this version but we will monitor their system to see if there are re-occurrences of this issue. The issue relates to the ability to receipt multiple lines with the same rotation on a stock transfer
| UID | Summary | Issue Type | Affects Version/s | Fix Version/s | Apply License | System Config Option | FusionUID | Release Notes |
| VC 280 | Different price showing on sales order | Bug | 2.2.4 | 2.2.5 | No | No | LRB-271-57155\ QBD-388-43259 | Customers are having an issue where, when adding items to a previously saved Sales Order, Items added after the initial save, such as below on the second line do not have the price showing up at the correct amount. Validation on the form has been changed. |
| VC 277 | Incorrect VAT Rates picking up for Credit Notes | Bug | 2.2.4 | 2.2.5 | No | No | On VC a credit note is somehow picking up an old VAT rate. When looking at the data for the credit note it appears to show the correct amount in data tables, however when the credit notes are generated from the invoicing screen they show incorrectly. Screen modified to use database value and not the system defined default vat code | |
| VC 272 | Changes required to some tables to allow longer product codes | Bug | 2.2.5 | No | No | data take on upload tables modified to allow 20 character codes | ||
| VC 270 | SO Adjustments - increases when rotation exists | Bug | 2.2.5 | No | No | System modified to increase existing stock recorded when a adjustment is made to increase stocks where the rotation exists. Currently it was creating a new stock record causing issues with customers making huge volumes of stock adjustments. | ||
| VC 269 | SO Returns - Validation of Rotation existence | Bug | 2.2.5 | No | No | When entering a return the final stage of returning this to stock is allowing the rotation number to be entered for the return. Current form was allowing the use of a rotation which already exists on the tblStock for the same warehouse This should not be allowed in any circumstances, if the rotation number already exists for that warehouse then we should be telling the customer "You can not return stock into this warehouse as the rotation number given already exists in this warehouse for other stocks" Additionally we need to be able on the return form to specify which warehouse location this stock is being sent to, defaulting to the warehouse code of the warehouse it left from but allowing it to be changed to another warehouse code. | ||
| VC 263 | Stock Adjustment of Existing Rotation | Bug | 2.2.5 | No | No | When making a stock adjustment of an existing rotation Changed the process so that when a stock adjustment increase is posted we check the existence of the rotation number (whether blank or filled) and the existence of this rotation number for this stock and increment the existing record by the quantity. | ||
| VC 260 | For EP orders move the validation of the UB Warehouse/Haulier fields to the order allocation stage, currently it's validating that these fields are populated whenever the order is saved which is wrong | Bug | 2.2.5 | No | No | When an EP order is entered the system assumes it is underbond, this is not an issue however we should not be checking the warehouse/haulier for these EP orders until stock allocation time. Prior to this stage, any changes or updates (including the original order being first saved) should not check that these fields on the warehouse options tab are validated. | ||
| VC 254 | Error on viewing/allocating stock transfers | Bug | 2.2.2 | 2.2.5 | No | No | XOB-752-43556 | Enter a stock transfer (with 0.00 prices) and save it. When you try to look at the stock transfer, you get an error (before the screen opens): 'Failed to calculate order total. Object cannot be cast from DBNull to other types. at System.DBNull.System.IConvertible.ToDecimal(IFormatProvider provider) at System.Convert.ToDecimal(Object value) at Baccus.Client.frmVSalesOrder.CalculateOrderTotals()' The screen then opens OK and you can view all the tabs with no problems. If you then try to save again, you get the above error and cannot save. Then, when you try to allocate the order, you get the same error when you hit commit. |
| VC 251 | No VAT on financial credit notes | Bug | 2.2.5 | No | No | PQM-607-93623 | Financial credit notes are not showing any VAT when raised, however if you do the 'Preview' before raising the credit note, the preview shows the VAT correctly. The posting to Sage however is correct. We need to ensure the problem is fixed, but also so that the customers can correctly generate the historical credit note's which have also been processed which do not show the VAT. | |
| VC 248 | Show the customers VAT registration number on all invoice layouts | Bug | 2.2.5 | No | No | EWJ-998-10758 | VAT Number now shown on the invoice. | |
| VC 196 | ePOS Manager Update | Improvement | 2.2.5 | No | No | Modification required to update the ePOS Manager so that it will work with the latest versions of Sage/Vision Commerce. |
Release v2.2.3 & v2.2.4
** This must be installed with v2.2.
v.2.2.4 are just script changes to update the Product PO filter.
| Issue ID | Summary | Issue Type | Affects Version/s | Fix Version/s | Apply License | System Config Option | FusionUID | Release Notes | |||||
| VC-256 | VC - unable to alter sales orders | Bug | 2.2.3 | No | No | GNH-279-91627 | Upon editing an existing order the system did not notice the DP flag and assumed the DP order was type U and made the customer apply delivery information which was not needed. | ||||||
| VC-255 | Credit notes not posting to Sage | Bug |
| 2.2.3 | No | No | DMA-726-76217 | Modified the sage queuing for credit notes to post to Sage. There were circumstances where this was not happening. | |||||
| VC-253 | VC displaying VAT on EP sales orders | Bug |
| 2.2.3 | No | No | UHI-846-82625 | The header upon SO entry was showing a VAT amount even for EP orders, although this was not effecting data it was unnerving for customers to see this. | |||||
| VC-246 | Unallocating lines of stock in deliver orders does not update stock level & adding stock to an SO does not show in product stock tab or stock enquiry | Bug |
| 2.2.3 | No | No | The stock availability was calculating incorrectly, this is not a data issue but was the methodology of the calculation being used for available stock, this effected Product, ordering and stock reconciliation | ||||||
| VC-243 | Invoice template not showing international bank details | Bug |
| 2.2.3 | No | No | CIR-122-57282 | Updated to show internation bank details on the form | |||||
| VC-242 | Sales Order Duty Deferred | Bug | 2.2.3 | No | No | The system stored your detault duty account which will populate automatically on a sales order unless the customer has their own code. In the past this used to be blank but the warehouse must be supplied with the duty payers parameter, so this field can not be left blank. Previously if left blank and a SPACE was added the system would assume an entry and thus decide it was Duty deferred and prices would adjust accordingly. We now check whether the code agrees to the default code, if different then it is a deferred order. | |||||||
| VC-241 | SO Allocations not always going to submissions - user errors | Bug | 2.2.3 | No | No | All SO will be sent to submissions, and marked whether they need to goto the warehouse. Then when a customer claims to have made an error it’s a simple task of changing the marker rather than trying to find the details. | |||||||
| VC-240 | VC - Credit Note VAT not showing when original invoice showed VAT | Bug |
| 2.2.2 | No | No | LHX-637-23620 | This related to old orders where the VAT marker has moved from the header to the detail line, if this was not marked correctly originally then VAT was not showing correctly although the original invoice was uneffected and data/sage element was fine. This only effected reprints. | |||||
| VC-236 | Cannot edit Date Received when receipting PO in VC Test | Bug | 2.2.3 | No | No | Can now be edited | |||||||
| VC-235 | In the SO Submission screen changing the Show Orders Up to Date does not show orders with future release date | Bug | 2.2.3 | No | No | Now working | |||||||
| VC-233 | Qtys doubled on invoices | Bug |
| 2.2.3 | No | No | CQW-507-53364 | This relates to delivering orders line by line which was creating multiple entries for invoice, however as each entry had the same sales order number the system was invoicing the lines for each time the deliver order was run. | |||||
| VC-232 | Template sensitivity | Bug |
| 2.2.3 | No | No | WVV-153-52481 | Adjusted the price list templates to remove horizontal scrolling and increase the spacing to stop accidents happening when ticking the boxes. | |||||
| VC-231 | Freight cost is not being calculated for imported stocks | Bug | 2.2.3 | No | No | Error in the forumla for working out whether a charge is applicable for receipt. |
Release v2.2.1 & v2.2.2
| Issue ID | Summary | Issue Type | Affects Version/s | Fix Version/s | Apply License | System Config Option | FusionUID | Release Notes |
| VC-223 | POP VAT Analysis screen VAT inconsistencies | Bug | 2.2.1 | 2.2.1 | No | No | When invoicing a PO, you get the POP Vat screen. The VAT amounts match as soon as you enter this screen. However, when you hit the 'process' button, you get an error stating that the values do not match (because one of the values has in fact changed when you press the 'process' button). You can amend the 'changed' VAT amount, but you shouldn't need to do this. This happens each time you save an invoiced PO. | |
| VC-216 | Vision to Sage Manager service is not starting when Server restarted | Bug | 2.2.1 | No | No | When SQL server is not installed as the default server the service was not starting as it was looking for the default instance. Now resolved | ||
| VC-212 | Create Mailing List | Bug | 2.2.1 | No | No | Option for user to add a new mailing list category has been added | ||
| VC-211 | VC XML SO Extract - mapping new field to XML format | Improvement | 2.2.1 | No | No | New Sales Order XML format to work with Vision Warehousing/EDI | ||
| VC-210 | Cannot view stock movements for product codes over 15 characters | Bug | 2.2.1 | No | No | TLA-358-65294 | Modified to allow longer codes | |
| VC-209 | Details not showing or Credit Note | Bug | 2.2.1 | No | No | EGH-458-59053 | Lines missing from credit note in some circumstances. Very difficult to test this one. | |
| VC-208 | Cost of sales postings incorrect for SO credit note stock movement | Bug | 2.2.1 | No | No | JHO-765-27307 | Postings to Sage have been updated to resolve this issue. It effected credit notes when stock movement postings were taking place and it was crediting freight and duty which was wrong. | |
| VC-206 | PO Acknowledgement file format | Bug | 2.2.0 | 2.2.1 | No | No | The PO acknowledgement file that is being produced has formatting issues - some fields are missing / cut-off. Please see the attached file for reference. The fields need to appear on the file clearly. | |
| VC-202 | Customer Reserve Account field length - can now be 8 | Bug | 2.2.1 | No | No | Field increased | ||
| VC-200 | Overnight file reports - make product code bigger to suit customers with long product codes | Bug | 2.2.1 | No | No | Stock check Goods received Orders processed all modified | ||
| VC-190 | SOP Docs - warning message if date is changed more than 14 days - requires confirmation before using | Improvement | 2.2.1 | No | No | Modification required to SOP Docs in order to show a warning message asking for confirmation if the date is changed more than 14 days. | ||
| VC-86 | XML SO Files for Warehouse | Improvement | 2.2.1 & 2.2.2 | Modification required to implement a new Sales Order XML process and automation of the allocation of orders, in order to allow direct sending of emails to LCB. | ||||
| VC-38 | Send Emails to Multiple Addresses - CXT-893158 | New Feature | 2.2.1 | Modification required to allow the ability to send email to multiple Addresses for Invoices, Delivery Notes and Acknowledgements. New flag added for - SO Invoices - SO Delivery Notes - SO Acknowledgements For each of the above documents when sending them out you will check the contact table and find the addresess they need to be sent to. Also in the customer form left the existing email address box, and if filled also send to that address. This is to allow the Vision customers to add their internal addresses so they can copy themselves without becoming a contact | ||||
| VC-17 | Automatically update the product prices after each PO has been invoiced | Improvement | 2.2.1 | Modification required in order for Product Prices to automatically be updated after each PO has been invoiced. |
Release v2.2.0
**Bugs
Project | Fix Version/s | IssueID | FusionUID | Summary | Release Notes/Link |
Vision Commerce | 2.2.0 | International Bank Details not showing on Sales Invoice | |||
Vision Commerce | 2.2.0 | Stock allocation can create negative stock on one line leaving positive on another line when rotations are not in use | |||
Vision Commerce | 2.2.0 | Need the ability to leave Delivery Service blank and ensure the default is blank |
** Improvement
Project | Fix Version/s | IssueID | FusionUID | Summary | Release Notes |
Vision Commerce | 2.2.0 | VAT rates stored against the Sales Order Header, Details and Stock Pick Detail | Modification to stop VAT rates from being stored against the Sales Oder Header, Details and Stock Pick Detail. Instead apply the current VAT rate at the time the order is invoiced. | ||
Vision Commerce | 2.2.0 | XML Sales Order Files for Warehouse | Modification to implement a new Sales Order XML process and automation of the allocation of orders, in order to allow direct sending of emails to the integrated warehouse. See Sales Order Submissions for full details. | ||
Vision Commerce | 2.2.0 | Ability to have same rotation under different warehouse location/site | Modification to add the ability to have the same Rotation Number stored under different Warehouse Locations/Sites. | ||
Vision Commerce | 2.2.0 | Sage Line 50 v 2013 Integration | Modificationsto Integrate VC with Sage v2013. | ||
Vision Commerce | 2.2.0 | Allow multiple addresses for sales invoice address | Modification in order to allow multiple addresses to be recorded for the Sales Invoice Address. | ||
Vision Commerce | 2.2.0 | Purchase Order Supplier Emails - allow multiple addresses to be specified | Modification required to add ability to store multiple addresses for the Purchase Order Supplier Emails. | ||
Vision Commerce | 2.2.0 | Product form -Sales Order & Purchase Order tabs, add option in bottom right hand of form to show all or just outstanding orders. | |||
Vision Commerce | 2.2.0 | Sales Order allocation - amend fields booked/ required date | Modification to allow the ability to edit the Booked and Required Dates on the Sales Order Allocation screen. | ||
Vision Commerce | 2.2.0 | Sales Order Header order of fields changed faster keyboard entry | Modifications to change to order of 'Tabs' on the Sales Order entry screen in order to improve the input speed. | ||
Vision Commerce | 2.2.0 | Within Customer Form set the optio for "SO acknowledgement on SOP" to default field | Modification to add a new field to the Customer screen with the option "Default to Sending SO Acknowledgment". | ||
Vision Commerce | 2.2.0 | Enquiry stock movement - ability to link to transfers | Modification to the Stock Movement Enquiry in order to add the ability to link to transfers. | ||
Vision Commerce | 2.2.0 | Enquiry filter option - allow customer / supplier to be specified | Modification the Enquiry filter in order to allow Customer/Supplier to be specified as an option. | ||
Vision Commerce | 2.2.0 | Help menu. - link to wiki for product/general info/ help desk | Modification to the Help Menu in order to allow it to link directly to the Wiki site for Product/General/Helpdesk information. | ||
Vision Commerce | 2.2.0 | SOP Docs - warning message if invoice date is changed more than 14 days - requires confirmation before using | Modification required to SOP Docs in order to show a warning message asking for confirmation if the invoice date is changed more than 14 days. | ||
Vision Commerce | 2.2.0 | ePOS Manager Update for SAGE & VC | Modification to update the ePOS Manager so that it will work with the latest versions of Sage/Vision Commerce. |
Release 2.1.0
** Bug
Project | Fix Version/s | IssueID | FusionUID | Summary | Release Notes/Links |
Vision Commerce | 2.1.0 | On Purchasing Tab of Product Form the correct currency should be shown (i.e Euro, £, $ etc..) rather than just 'currency'. | |||
Vision Commerce | 2.1.0 | Correct table schema changes | Database Change only. | ||
Vision Commerce | 2.1.0 | EP Orders should only pick the Duty Paid Lines for the Duty and VAT invoice. | |||
Vision Commerce | 2.1.0 | Spelling corrections in Report Manager | See also VC-161 | ||
Vision Commerce | 2.1.0 | If a Purchase Order is manually partially receipted (creating a second line) the goods received report should take this into account correctly. | |||
Vision Commerce | 2.1.0 | Change to ensure Ex Cellar Purchase Orders only print as Duty Paid if this is the case. | |||
Vision Commerce | 2.1.0 | Fix to allow Bond Type to be selected in the EP order allocation screen | |||
Vision Commerce | 2.1.0 | Make sure Create and Maintain Price List options working correctly. | |||
Vision Commerce | 2.1.0 | Fixed selection of Products in Mixed Case Build | |||
Vision Commerce | 2.1.0 | Mailing list button to appear on Create and Maintain Customer Contact Tab | |||
Vision Commerce | 2.1.0 | When a credit note is entered for an EP Order, if the goods are delivered and the invoice raised then the user should get a message saying "Please check the stock status flags before generating the credit note". | |||
Vision Commerce | 2.1.0 | Product Details > Purchasing & Pricing tab does not save when you update it, now resolved. | |||
Vision Commerce | 2.1.0 | On the Customer screen, although the ADDRESS fields allow you to enter 50 characters, the maximum for orders is 40 characters, correct this to 50 | |||
Vision Commerce | 2.1.0 | Could not add tasting notes - now resolved | |||
Vision Commerce | 2.1.0 | Allocate Stock on EP Orders was not working, now resolved. | |||
Vision Commerce | 2.1.0 | Check VAT calculations for Sage postings are correct on Invoices. |
** Improvement
Project | Fix Version/s | IssueID | FusionUID | Summary | Release Notes/Links |
Vision Commerce | 2.1.0 | Ability to mark a delivery address as archived | Modification to add the ability for users to mark a Customer Delivery Address as archived. Delivery Address Details | ||
Vision Commerce | 2.1.0 | Sales Order Form Modifications | Modifications to the Sales Order Entry, adding the new fields as required in header and detail. There are several new fields, see the IssueID log for greater detail. | ||
Vision Commerce | 2.1.0 | Stop users accidentally crediting Duty and VAT Invoices | Moditfications made for a warning message to appear when raising credits notes, in order to avoid Duty and VAT Invoices being credited accidently. | ||
Vision Commerce | 2.1.0 | Line Discounts not clear when order line is selected | Modification required to make 'Line Discounts' on the Sales Order Detail tab clearer when the order line is selected. | ||
Vision Commerce | 2.1.0 | SO Allocation Extract failure | Modification required to show a message screen informing users that 'No Sales Order Extract Files were Generated' in the instances where users do not have access to the server share. | ||
Vision Commerce | 2.1.0 | Held Order information | Modification required to store and show which user has 'Held' or 'Unheld' an order, along with the date and time on the Order Enquiry form. | ||
Vision Commerce | 2.1.0 | VC-140: Purchase Order Warehouse should be stored at line level, not against the header | Modification required in order to allow users to select the 'Warehouse' that stock should be receipted into when completing the PO receipt. | ||
Vision Commerce | 2.1.0 | SOP Stock Allocation - new screens | Modification to add new screens to SOP Stock Allocation. This will add additional fields, widen the form and add the ability to modify the delivery method at time of allocation. Allocate Sales Orders | ||
Vision Commerce | 2.1.0 | Report Option - Show Pick Group on Delivery note | Modification to be made to the Report Manager. Add a new option for the Delivery Note to show the Pick Group at the top of the note. |
** New Feature
Project | Fix Version/s | IssueID | FusionUID | Summary | Release Notes |
Vision Commerce | 2.1.0 | Release Unpaid Reserve when cancelling SO | Modifications made to allow the release of Unpaid Reserve Stock at the same time as when the Pro-Forma Order is cancelled. | ||
Vision Commerce | 2.0.0, 2.1.0 | Product Setup Enhancements | Modifications made to make the process of creating a Product quicker. | ||
Vision Commerce | 2.1.0 | Produce Invoice and Delivery Note at time of allocation | Modifications made to add the ability to produce an Invoice and Delivery Note at the time of allocation, in the allocate orders screen. | ||
Vision Commerce | 2.1.0 | Add a Sales Left layout with columns (where product details are not concatenated) | Modification to add a Sales Left layout with columns. This will be applied where the Product Details are not concatenated. |
Release 2.0.1
** Bug
* [VC-127] - Web Extract - Price Lists
* [VC-135] - Unable to create DP sales order with Duty Deferred to another account
* [VC-138] - Templates - Need to show all sales even those of no value
* [VC-140] - System allows update of warehouse group and warehouse fields on the purchase order screen after receipting.
* [VC-141] - EP Credits posting the wrong product cost value to the cost of sales accrual in Sage
* [VC-142] - Vision Commerce Stock Import procedure calculating wrong movement product cost
* [VC-143] - When creating a new product unable to tab off UB per/unit box
* [VC-144] - Orders processed pdf 'Bottles Ordered' on first row is suppressed
* [VC-145] - Allow 'Stock Cost Adjustment' postings to Sage to be switched off by a flag in 'tblCustomer' - Also 'Price Variance' postings for PIs should be able to be disabled
* [VC-146] - PO Acknowledgement - Increase cases field width
** Improvement
* [VC-34] - EP Sales Order - Allocating lines to an EP Purchase Order
* [VC-85] - EP Order Improvements - To resolve pack size issue and EPSalesMovement Product Cost issue
* [VC-107] - User ID Against Orders
* [VC-139] - Adjust Stock - Warning if close without saving
Release 2.0.0
** Bug
* [VC-103] - If a component product is picked across multiple rotations, VC fails to process the orders processed file
* [VC-113] - EP Allocation screen - Issues when allocating SO with underbond type 'T' and 'R'
* [VC-134] - Purchase orders not crediting correctly
** Improvement
* [VC-6] - Report Manager Improvements
* [VC-16] - Allow product pack size change prior to receipting the PO which also amends the outstanding sales orders for the stock
* [VC-33] - Adding products to PO - calculating cost prices with an exchange rate
* [VC-106] - Email PO Acknowledgements
* [VC-117] - SOP documents, SO Acknowledgements Tab
* [VC-133] - Product Component Manufacturing
* [VC-136] - Report Manager and Email attachment
* [VC-137] - Remove - 'Our Excise Number' on Purchase Order Acknowledgement
** New Feature
* [VC-53] - Product Setup Enhancements
* [VC-60] - Report Manager Enhancement - Email Outgoing
* [VC-61] - Product Sales Analysis
* [VC-62] - Report Manager - Pro Forma Message
Release 1.8.2
** Bug
* [VC-93] - Vision ePOS - Logging users out intermittently
* [VC-111] - ON PO report it does not show the singles price
* [VC-119] - Financial SO's affecting the Stock Availability Check
* [VC-120] - Z Read screen showing the incorrect last Z Read date
* [VC-121] - Sales Order Numbers in results pane have additional zero's to the order numbers at the begining of the number
* [VC-124] - Delivery Orders - part line confirmation not apportioning delivery cost correctly
* [VC-125] - Unable to add new Duty Rates in VC Duty Rates Maintenance screen
* [VC-126] - Users able to delete Surcharges after they have been invoiced.
* [VC-128] - Error while saving order - Due to PO Header Check
* [VC-129] - Customer maintenance - Contract Price List tab shows nothing when the customer is setup for a contract price list
* [VC-130] - Excise Duty for LOA calculations is incorrect
* [VC-131] - Acknowledgement reports - Qty field is not big enough
** Improvement
* [VC-6] - Report Manager Improvements
* [VC-132] - Sales Invoice posting to Sage - Use product level analysis grouping
* [VC-133] - Product Component Manufacturing
Release 1.8.1
** Bug
* [VC-94] - Stock Exception report not taking into account reserve Customer Accounts
* [VC-99] - Adding a contact, requires the user to tick and untick the 'archived' box otherwise record cannot be saved
* [VC-103] - If a component product is picked across multiple rotations, VC fails to process the orders processed file
* [VC-105] - Component products not displaying correctly in the deliver orders screen
* [VC-110] - Template Sensitivity
* [VC-112] - Record locks when user loads order from allocate order screen.
* [VC-113] - EP Allocation screen - Issues when allocating SO with underbond type 'T' and 'R'
* [VC-115] - Error when changing quantity's in epos
* [VC-122] - Component Products: Allocating more stock when picked from more than one location.
Release 1.8.0
** Improvement
* [VC-3] - Sage Line 50 2012 Integration
* [VC-5] - Sales Order Line Total Function
* [VC-20] - Invoice Report changes for Case Size field
* [VC-55] - X2 and Z2 Reports to show the total on the reports
* [VC-64] - ePOS Case Price Use
** New Feature
* [VC-54] - Product Code Auto Population
Release 1.7.28
** Bug
* [VC-35] - Replicating EP Sales Orders - Problems with VAT Code and Duty Paid Flag
* [VC-43] - Minus Stock Adjustment Insufficient stock error
* [VC-46] - Vision is allocating batch numbers to stock movement records that are not being posted to Sage
* [VC-47] - Purchase Invoice TAB calculating wrong VAT
* [VC-49] - Users are able to amend sales orders that are being allocated
* [VC-50] - Error when user clicks 'Receipt All' to receipt all lines on a PO
* [VC-51] - Underbond Sales Prices being entered on Duty Paid Sales Orders
* [VC-52] - Unable to email Reports from VC
* [VC-57] - Unable to return stock on PO when stock is receipted into non rotation warehouse group
* [VC-58] - When creating a Mixed case product code the search results are not being retained when adding the components
* [VC-65] - Error when creating Country
* [VC-66] - Nominal Code is Mandatory when creating Credit Note Reason
* [VC-68] - SO Detail lines being saved with NULL FKWarehouse
* [VC-69] - Issue with EP SO Allocation for Underbond Type R orders
* [VC-70] - Stock adjustment calculate duty on the product cost when duty paid tickbox ticked
* [VC-71] - EP PO Duty Paid flag is set incorrectly
* [VC-72] - Duty calculation for LOA products
* [VC-76] - Error while saving sales order due to DeliveryAddressLine1
* [VC-77] - Error while trying to Print order items - EPOS
* [VC-78] - Cancelled SO's appearing on the Customer Sales Analysis
* [VC-79] - BankReceipts / Payment Postings not being created when Sage service is stopped
* [VC-80] - Automated credit note issue
* [VC-82] - When EP SO allocated as Bond type 'Customer Paid Reserve' the PO is using the wrong prices
* [VC-89] - Prevent orders being saved with the same product and rotation number on multiple lines
* [VC-90] - Booked date in warehouse extract less than current / order date & Other VW integration issues
* [VC-95] - Order screen is rounding unit / singles price to 2 decimal places
* [VC-96] - ePOS - Item Price Calculations
* [VC-97] - Penny Issue between Sage Posting and Sales Invoice
* [VC-98] - ePOS Credit Note issue when processing the credits in VC
* [VC-100] - ePOS Rounding Issues when Discounts Applied in Percentages
* [VC-101] - Error while opening PO Acknowledgements - Error found while testing v1.7.28
* [VC-102] - Mixed product allocation 1) does not allow stock to be allocated 2) sends wrong quantity to LCB
** Improvement
* [VC-84] - Make the posting of credit notes from EPOS to Sage easier for users to reconcile
Release 1.7.27
** Bug
* [VC-8] - When Sales Invoices are being posted to Sage the detail message is not always being shown.
* [VC-10] - Stk Adjustment is adjusting the stock into the wrong location if you have minus record in tblStockLocation
* [VC-11] - Stk Transfer Order - In movements going to wrong warehouse
* [VC-12] - Replicating a sales order with different VAT rate retains the old rate on the new order, instead it should get the current rate at the point of replication
* [VC-18] - Stock Movements are posting to Sage with the wrong date
* [VC-19] - Outgoing email mail server authentication
* [VC-22] - Stock Movements not being posted to Sage for PO - Consignment Orders
* [VC-23] - Mixed Case Products reporting that there is insufficient stock on the Sales Order screen
* [VC-24] - Issues with the Mixed Case Build Screen when calculating the Available stock
* [VC-26] - Stock Movement Posting When Group By Movement Date
* [VC-27] - Stock Adjustment Product Cost Issue
* [VC-28] - Error while trying to create a Price List
* [VC-29] - ExCellar PO changing to Duty Paid 'True' when user saves
* [VC-30] - ePOS - Z Read posting different Payment value to the Sales Invoice Value
* [VC-36] - VAT Code data binding issue on the SO form
* [VC-39] - Purchase Order - additional items after saving UPE-540750
* [VC-45] - Update Purchase Cost function updating Product Costs with NULL and 0.00
** Improvement
* [VC-31] - EPOS Product Search Screen – Cursor
Release 1.7.26
** Bug
* [VC-44] - Penny Difference on Invoice Posting to Sage when line discounts are used
** Improvement
* [VC-25] - Web extract changes
Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.