Previous VI Release Notes
- Alan Gilchrist
- Joe Wagner
- Andrew Stacey
Owned by Alan Gilchrist
See bellow details of bug fixes, improvements and new features that have been implemented in order to enhance the way that Vision Invoicing works within previous releases.
Where a new feature has been added, you will be able to link directly to the user manual page giving details of how the new feature works and what it does.
| Version | 4.5.2 |
|---|---|
| Release Date | 31/05/2018 |
| Other Application Requirements | |
| Warnings or Notices |
| UID | Summary | Issue Type | Affects Version/s | Description | Requires Config | Requires License |
|---|---|---|---|---|---|---|
| VINVOICING-482 | Customer specific invoice - cutting off postcode | Bug | 4.5.1 | VINVOICING-475 Clone Modification to another setting changed the layout | No | No |
| VINVOICING-479 | Storage invoicing - customer specific summary layout issue | Bug | 4.5.1 | A specific customer's summary storage invoice layout is not populating the 'Min Chg' field in the 'Additional charges from previous invoice period' section. | No | No |
| VINVOICING-478 | Storage invoicing - Time out | Bug | 4.5.1 | Timing out when checking for backdated pro rata storage charges. | No | No |
| VINVOICING-477 | Historical Invoices: Charges are not showing correctly | Bug | 4.5.1 | When loading Historical Invoices > Stock Transactions > Goods Inwards charge value are being shown incorrectly. | No | No |
| VINVOICING-476 | Stock Charge Invoices - Decimals | Bug | 4.5.1 | The 'Rate' and 'Charge' values are not showing any decimals, it appears to be rounding to the nearest whole number which should not be happening. However the sub total, total VAT & grand total appear to be correct. In addition the column 'Datetime raised' should be changed to 'Raised'. Finally it looks like the addition of this column has pushed the other columns to the right of the page, this also needs to be corrected. | No | No |
| VINVOICING-475 | Customer specific invoice - cutting off postcode | Bug | 4.5.1 | We have noticed that on various types of invoices no postcode is showing in the customer address area. The name & address info only seems to be able to show 5 lines if a customer has 6 lines it is missing the last line which is the postcode. | No | No |
Release 4.5.1 (21/05/18)
| UID | Summary | Issue Type | Affects Version/s | Description | Linked to |
|---|---|---|---|---|---|
| VINVOICING-482 | Customer specific - ALL - cutting off postcode | Bug | 4.5.1 | Customer Specific Layout has been updated | |
| VINVOICING-479 | Customer Specific - Storage - summary layout | Bug | 4.5.1 | A specific customer's summary storage invoice layout is not populating the 'Min Chg' field in the 'Additional charges from previous invoice period' section. | |
| VINVOICING-478 | Storage invoicing - Time out | Bug | 4.5.1 | Timing out when checking for backdated pro rata storage charges. | |
| VINVOICING-477 | Customer Specific - ALL - Historical Invoices | Bug | 4.5.1 | When loading Historical Invoices > Stock Transactions > Goods Inwards charge values are being displayed incorrectly | VSUP-5684 |
| VINVOICING-476 | Stock Charge Invoices - Decimals | Bug | 4.5.1 | The 'Rate' and 'Charge' values are not showing any decimals, it appears to be rounding to the nearest whole number which should not be happening. However the sub total, total VAT & grand total appear to be correct. In addition the column 'Datetime raised' should be changed to 'Raised'. Finally it looks like the addition of this column has pushed the other columns to the right of the page, this also needs to be corrected. | VSUP-5612 |
Release 4.5.0 (20/09/2017)
This release is specifically for VW v5 and will only work with that version of Warehousing and nothing earlier.
in addition the following has also been resolved
| Issue ID | Summary |
|---|---|
| VI-455 | New Indexes added to speed up the invoice run |
| VI-458 | Storage Invoice data type error |
| VI-460 | Imports were slow from warehousing |
Release 4.4.1 (10/04/2017)
Bugs only listed below.
| Issue ID | Summary |
|---|---|
| VINVOICING-454 | Navigation - Can't Access New Customers |
| VINVOICING-452 | Stock import from VW - Non bonded customers - issues when brand field is not being completed |
| VINVOICING-450 | Stock Storage CSV file taking a very long time to generate |
| VINVOICING-447 | Goods in by line charges re-invoiced |
| VINVOICING-446 | Goods out - pallets and case picked charges |
| VINVOICING-445 | Amend data - Time out retrieving stock storage data |
| VINVOICING-444 | Rent import speed |
| VINVOICING-442 | Opening an invoice throws an error if Pro rata additional weeks exceeds 255 |
Release 4.4.0 (08/12/2016)
Requires VW v4.4.0+ & VCIS v3.3.4+
| UID | Summary | Issue Type | Affects Version/s | Description | Linked Issue |
|---|---|---|---|---|---|
| VINVOICING-428 | Transport Charges Invoice | Report | Customer Specific Note Change Change the logo Move the Doc Ref back to the same line and wrap Change back to a single line wrap delivery name if required | RFC-69 | |
| VINVOICING-235 | Stock Charge - Generic charge for multiple uses | New Feature | 'Stock Charge' will be made into a generic charge by removing references to 'Condition Reporting' and allow the import of 'Condition Report' and 'Valuation Report' charges against this invoice type. This will also allow us to use it for other things in the future as well. | ||
| VINVOICING-402 | Amend invoice screen - Goods in load vs line charging | Issue | Users can currently change the load charge against a line charging pre advice, and vice versa. This should not be permitted. The load charge field will be locked against line charge pre advices, and the line charge field will be locked against load charge pre advices. The amend screen will also be made slightly bigger, removing horizontal scroll bars and longer so more rows fit in by default. | ||
| VINVOICING-436 | Invoice Template changes | Improvement | Changes to customer specific invoice templates | RFC-39 | |
| VINVOICING-394 | Storage Invoice - Speed | Improvement | Creation of database index to speed up allocation of storage invoice number allocation | ||
| VINVOICING-375 | Add rent date to amend data screen | Improvement | The 'Rent Date' column will be added as a read only column to the Amend Data > Stock Storage screen / tab. | ||
| VINVOICING-438 | Customer specific invoices | Bug | 4.3.6 | Customer specific invoices - stock storage summary won't load A login box is appearing when trying to load a specific customer's stock storage summary invoice. | VSUP-796 |
| VINVOICING-437 | Send Invoice - Odd email addresses | Bug | The specified string is not in the format required for an email error is thrown each week for a couple of invoices when the email address format looks to be valid. The code has been changed to ignore this. | VSUP-758 | |
| VINVOICING-435 | Stock Storage Invoice - not 50% | Bug | Issue noticed where a customer had a Stock Storage rate with a discount that did not equal 50%. When this rate is being applied it is not applying the discount percentage to the charge, but is taking discount percentage and using that as the charge quantity. | VSUP-687 | |
| VINVOICING-434 | GI Invoice - rate to display when not 50% | Bug | Customer noticed that the rate on their Goods In invoice is showing incorrectly, when they have a Reduced Rate Discount % that is not 50% Instead of showing the discounted amount as the rate, it is showing the actual discount amount as the rate. | VSUP-682 | |
| VINVOICING-432 | Customer specific invoices | Bug | 4.2.3 | On specific customers invoice layouts it's showing the wrong registered office details. | VSUP-491 |
| VINVOICING-430 | Goods In - Invoice Minimum | Bug | Customer has set up accounts with a minimum Goods In Invoice total. however when running off the invoice it does not look to take into account this minimum Goods In Invoice total. | VSUP-420 | |
| VINVOICING-427 | Grouping of Movements | Bug | Linking orders / movements to grouped goods out charges A small issue was found linking orders / movements to grouped goods out invoice charges which has now been resolved. |
Release 4.3.6 (10/08/2016)
Bug Release Only - if you have v4.3 you should upgrade direct to live as soon as possible to remove these issues.
| UID | Description | Fusion ID |
|---|---|---|
| VI-406 | Remove Zero Charges is removing all outstanding charges | FZH-906-36308 |
| VI-404 | Transport invoicing is ignoring the "to" date when invoicing | TBY-760-20872 |
| VI-403 | Bespoke Storage Invoice Layout Issue | PQA-607-11690 |
Release 4.3.5 (30/06/2016)
Bug Release Only - if you have v4.3 you should upgrade direct to live as soon as possible to remove these issues.
| UID | Description |
|---|---|
| VI-396 | Sage Extract for Stock Storage Invoices is pulling through Goods In Invoices |
| VI-395 | Duplicate key error when loading transport invoices |
| VI-385 | Transport Invoice create operation freezes when stock holding customer is different to invoice to customer |
Release 4.3.4 (29/04/2016)
| Key | Summary | Issue Type | Affects Version/s | Fix Version/s | FusionUID | Apply License | System Config | Release Notes |
|---|---|---|---|---|---|---|---|---|
| VI384 | Pro rata rent duplication | Bug | 4.3.4 | No | No | Pro rata rent records are having their quantities doubled when the stock is receipted and a location move done on the same day. This relates to change VW-2359, and this issue handles the changes required on the VI side. | ||
| VI382 | Simplify the nominal code setup in VI | Issue | 4.3.4 | No | No | After investigation of VINVOICING-354 it was deemed necessary to log these changes to be made to simplify the nominal code setup in VI. Previously all customers would set up nominals against every stock storage and goods out invoice type, now it will only be necessary to set up one storage nominal and one goods out nominal. Later, VW-2311 will be implemented to remove nominals from the warehousing system. | ||
| VI380 | VI Updates - Pallet charging | Improvement | 4.3.4 | No | No | Updates required to the Vision Invoicing import (from Warehousing) utility in relation to the changes made in VW under reference: VW-1978 for the new pallet usage feature. | ||
| VI376 | Making and saving some changes (Unchecking Bottle Picking Charges) causes an error | Bug | 4.3.4 | GVG-736-30695 | No | No | Error thrown when customer tried to remove Bottle Picking Charges from by unchecking the Invoice Selected and Include VAT fields and clicking Save. !Capture.PNG|thumbnail! | |
| VI371 | Allocation of invoice numbers speed up | Issue | 4.3.4 | No | No | The allocation of invoice numbers could do with speeding up, a missing index has been identified. | ||
| VI370 | Trying to open Invoice number results in APP crash (after a delay) | Bug | 4.3.4 | OPC-750-45781 | No | No | Opening this single invoice (originally created as part of a batch along with other invoices that open fine), results in an App crash (no reason given) after a long delay. | |
| VI369 | Storage invoicing slowness | Issue | 4.3.4 | No | No | Since the changes a couple of years back, which massively improved the stock storage performance, a couple of customers have commented that the speed has started to deteriorate. We've found this to be caused by the date / flag update which takes place, to say that the invoicing for a certain invoice type / storage period has been completed. This process will be recoded to be much quicker. If you select ALL then updates will be quick, if you are selective in invoicing then this will be much slower | ||
| VI368 | Merged charges not showing on transport invoice | Bug | 4.3.2 | 4.3.4 | PEA-502-75022 | No | No | Merged charges not showing on transport invoice when exported to customer, exported or printed, but shows in the load details of the historical invoicing |
| VI366 | Storage showing to be invoiced in amend invoices but not pulling through to the invoicing screen | Bug | 4.3.4 | No | No | Some records are showing in 'Amend Invoices' but when loading up 'Raise Invoices' screen they are not pulling through. | ||
| VI365 | Storage invoice cannot be displayed when specific fields contain longer than usual data | Bug | 4.3.4 | No | No | When the StorageChargePeriodDescription or StorageChargeDescription contain data longer than 30 characters (up to a maximum of 50) the storage invoices fail to open. | ||
| VI359 | Data field length - consistency across Vision suite | Issue | 4.3.4 | No | No | We need to expand some fields to make the entire system consistent with field lengths available. Delivery to Invoice OrderRef -> 30 Order Header DeliveryName -> 50 | ||
| VI354 | SUN extract file issue for goods out invoice with sundry charge | Bug | 4.3.4 | TBK-768-91583 | No | No | The goods out SUN extract file appears to be duplicating the lines for some invoices and giving random nominal codes | |
| VI353 | errors when searching historical Invoices | Bug | 4.3.2 | 4.3.4 | EAS-814-50101 | No | No | Timeouts and unhandled exception errors intermittently appear when searching for historical invoices. |
| VI351 | Some Stock Storage Invoices repeatedly sending email | Bug | 4.3.4 | LIL-125-51852 | No | No | Some Stock Storage Invoices are repeatedly resending the email. |
Release 4.3.3 (28/01/2016)
Small changes to a couple of layouts were released
VI-349 - Logo change for customer
VI-348 - Storage invoice to show line number
Release 4.3.2 (13/01/2016)
| Key | Summary | Issue Type | Affects Version/s | Fix Version/s | FusionUID | Apply License | System Config Option | Description |
|---|---|---|---|---|---|---|---|---|
| VI346 | Cannot raise Transport invoices when customer code and invoice customer code are different | Bug | 4.3.2 | 4.3.2 | MWS-451-32945 | No | No | Customer ran off their transport invoices, however there are several that have been left behind. Checking these deliveries it can be seen that the customer code and Invoice to customer code are different Codes |
| VI345 | Customer specific invoice change | Improvement | 4.3.2 | AMU-586-11541 | No | No | Change the logo on customer specific invoice layouts. | |
| VI344 | Corrections to customer specific invoice layout | Bug | 4.3.2 | YBW-200-58202 | No | No | The page numbering is 1 number short, it doesn't seem to be including the last page, and in addition the word 'Pro Rata' appears to be showing in the 'Invoice Period' field if the invoice minimum charge has been applied. | |
| VI341 | Not showing zero value deliveries on invoices | Bug | 4.3.0 | 4.3.2 | No | No | If a customer is not set to include VAT on transport invoices, then any zero VAT deliveries will no show on the the transport invoice |
Release 4.3.1 (06/01/2016)
| Key | Summary | Issue Type | Affects Version/s | Fix Version/s | FusionUID | Apply License | System Config Option | Description |
|---|---|---|---|---|---|---|---|---|
| VI343 | Error setting up new customers | Bug | 4.3.1 | VSI-711-11174 | No | No | Since 4.3.0 an error is appearing when setting up new customers. | |
| VI342 | Brand for v4.3.0 | Issue | 4.3.1 | No | No | The brand was needed in VI for the v4.3.0 changes and was missed. |
Release 4.3.0 (31/12/2015)
| Key | Summary | Issue Type | Affects Version/s | Fix Version/s | FusionUID | Apply License | System Config Option | Description |
|---|---|---|---|---|---|---|---|---|
| VI-340 | Transport invoices missing deliveries for other customers | Bug | 4.2.3 | 4.3.0 | TTM-939-83188 | No | No | Transport Invoices not showing all charges even though the Totals are correct. |
| VI-338 | Transport invoices are missing some deliveries in the CSV/PDF | Bug | 4.2.0 | 4.3.0 | TTM-939-83188 | No | No | If you sum the charges on the PDF and the CSV on some invoices, the value is less than the total due to missing deliveries with a different customer account to the invoice account. |
| VI-336 | Changes to customer specific invoice layouts | Improvement | 4.3.0 | No | No | Changes to customer specific invoice layouts to use a new customisation table which allows for greater customisation of the layouts. | ||
| VI-334 | VAT discrepancy on transport invoices | Bug | 4.3.0 | No | No | Since the VINVOICING-259 change, deliveries can have zero VAT. This means that during the invoice run, deliveries have their VAT calculated (although not shown) delivery by delivery, this value is rounded, and so the user sees the invoice total at the bottom, but the VAT does not equal InvoiceTotal x VATRate. With this change, deliveries with different VAT rates will be split on to different invoices, keeping all deliveries with the same vat rate on any invoice, which is how it should be anyway as the invoice footer shows the same VAT rate for all deliveries so there should not be a mix. | ||
| VI-315 | Customer delivery type discounts for goods in | Bug | 4.3.0 | No | No | VW calculates a 'Calculated Charge' and an 'Actual Charge' on by line charged pre advices. When a customer has their own delivery type adjustment set up in VW Customer Maintenance, VW sets the 'Actual Charge' according to the customer delivery type discount. So for example, if a customer has a 50% reduced rate discount on the 'PURCHASED GOODS' delivery type, VW will set the 'Actual Charge' to 50% of the 'Calculated Charge'. When this goes across to invoicing, and the invoice is produced, VI is further discounting the charged rate by 50% incorrectly. | ||
| VI-309 | Goods in invoices without VAT | Bug | 4.3.0 | OGX-594-87359 | No | No | Goods in invoices are intermittently having no VAT applied despite the customer 'Goods In - Invoice VAT' box being checked. | |
| VI-308 | Increase the length of the VAT number field | Issue | 4.3.0 | No | No | The current length of the VAT number field is 10 characters, this will be increased to 20 characters which will cover all countries. | ||
| VI-307 | Issues when running goods in invoices | Issue | 4.3.0 | ANC-408-87914 | No | No | Customer had an issue when running Goods In monthly invoices, since the VInv 4.2.3 upgrade customer has had large delays when running Goods In invoices. | |
| VI-303 | Sundry charges are not invoiced if the pre advice has already been invoiced | Issue | 4.3.0 | No | No | When a pre advice has had it's line / load charges invoiced, and a user adds a sundry charge to the pre advice, it imports to invoicing but is never picked up to be invoiced. | ||
| VI-298 | Changes to customer specific invoice layouts | Improvement | 4.3.0 | No | No | A customer has requested changes to their own invoice layouts. | ||
| VI-296 | Customer specific new storage invoice layout with valuations | New Feature | 4.3.0 | No | No | Add a new layout in line with the addition of the Livex values to provide an annual invoice including all values where known of wine held in store. This requires a number of new template fields and a new template It also requires import routine for the values and a store for them as they will need to be kept in case the invoice is to be reproduced. | ||
| VI-275 | Database indexes for goods out | Improvement | 4.3.0 | No | No | A couple of useful indexes were identified on slow running queries, and have been added into the system to speed some queries up related to goods out nightly imports. | ||
| VI-268 | New column in the Amend Invoice screen | Improvement | 4.3.0 | DBF-955-51601 | No | No | Application : Vision Invoicing Menu : Processing / Amend Non Invoiced Data Form Tab : Transport To display the following read only fields "Order Date" "DeliveryConfirmationDate" on the form. | |
| VI-233 | Maximising the Invoice customer screen | Improvement | 4.3.0 | No | No | Maximising the invoice customer screen and the grids within it, now the grids will expand vertically as well as horizontally. | ||
| VI-226 | Stock Charge - Take the 'Per case Charge' from the 'Amend Invoices' screen instead of customer maintenance | Improvement | 4.3.0 | No | No | Customers have a 'Per case charge' setting for condition reports invoices, this field is also available in the amend invoices screen but the invoicing run currently ignores this and overrides it with the customer value. |
Release 4.2.3 (18/11/2015)
| Key | Summary | Issue Type | Affects Version/s | Fix Version/s | FusionUID | Apply License | System Config | Release Notes |
|---|---|---|---|---|---|---|---|---|
| VI306 | Consolidated deliveries not being added into the invoice total | Issue | 4.2.2 | 4.2.3 | No | No | On a transport invoice with consolidated deliveries, the value of the consolidated deliveries is not being included in the invoice total. | |
| VI302 | Accounts extract outputting previously output invoice records | Bug | 4.2.1, 4.2.2 | 4.2.3 | No | No | When invoicing outstanding charges, even if no invoices are raised, an accounts extract is getting raised with records which were previously already output. Once the records are output, they should not be output again, unless the user is regeneraing them manually. | |
| VI301 | Transport invoice not showing correct currency | Bug | 4.2.1 | 4.2.3 | No | No | Customer specific transport invoice template is showing currency against each line rather than the ISO currency code This was discovered whilst investigating a different issue on our test database | |
| VI300 | Goods in invoicing ignoring 'Include VAT' customer flag | Bug | 4.2.3 | No | No | Against the customer setup there is an 'Include VAT' flag against each of the invoice types, for goods in, it appears to be ignoring this and always charging VAT. | ||
| VI299 | Transport invoice not showing correct currency on customer specific layout. | Issue | 4.2.1 | 4.2.3 | OFX-165-16306 | No | No | Transport invoice template is not showing £ against the VAT column on the current customer specific template |
| VI297 | SUN accounts extract files / Account code | Issue | 4.2.3 | No | No | We were previously advised that the account codes in the SUN accounts extract file needed a 'D' prefix, however it transpires that this is actually included within the account code so the prefix isn't necessary. |
Release 4.2.2 (22/09/2015)
| Key | Summary | Issue Type | Affects Version/s | Fix Version/s | FusionUID | Apply License | System Config Option | Description |
|---|---|---|---|---|---|---|---|---|
| VI291 | Window title appearance | Issue | 4.2.2 | No | No | During the implementation of the ribbon bar the window title bar appearance changed and the text became bold, when VW ribbon bar was implemented it was done correctly but VI requires the same correction to make them consistent. | ||
| VI290 | Customer specific invoice issue | Bug | 4.2.2 | No | No | The email address on some new customer invoice notes is hard coded and should be reading from the site settings. | ||
| VI289 | Currency history | Issue | 4.2.2 | No | No | The currency history table in VI is growing too large, it's having records inserted when it's unnecessary. |
Release 4.2.1 (13/08/2015)
| Key | Summary | Issue Type | Affects Version/s | Fix Version/s | FusionUID | Apply License | System Config | Release Notes |
|---|---|---|---|---|---|---|---|---|
| VI288 | Output VAT analysis code for the SUN file format | Issue | 4.2.1 | No | No | An additional analysis code is required for the SUN system file format, in position T6. Column T6 needs populating with OS (Standard VAT) or OZ (Zero VAT) against the SALES and VAT lines in the file, but NOT the debtor line (top one). | ||
| VI286 | SUN extract format | Improvement | 4.2.1 | No | No | 1) When we output an invoice line, it gets spread over up to 3 lines, the first line is the invoice line, second is the sales line, third is the VAT. At the end of the 18 digit amount field is a D or a C, the invoice line is correctly showing a D afterwards, but the sales line and the VAT line should be showing a C instead. 2) In column T4, BAR should be shown for the Sales line 3) In column T6, OS should be shown for the Sales line AND the VAT line. | ||
| VI285 | Customer specific template additions | Improvement | 4.2.1 | No | No | New customer layouts included in the release | ||
| VI284 | Raising goods in invoices with long customer addresses | Bug | 4.2.1 | No | No | If raising an invoice with a customer address longer than 30 characters, the system errors. | ||
| VI281 | Customer maintenance 'Default Charge' tab showing rates for other customer sites | Bug | 4.2.1 | No | No | If you have the same customer code in many sites, the 'Default Charge' tab in VI Customer Maintenance shows you the charges for all customers with the same code across all sites, not only for the customer / site that you've opened. The screen is ignoring the site code and it should be checking it. | ||
| VI277 | Invoice navigation wildcard searching | Bug | 4.2.1 | No | No | Wildcard searching does not work on the 'Invoice' navigation pane search for any of the search fields. For example, I cannot search customer code 'J*' to retrieve all invoices for customer codes beginning with J. | ||
| VI272 | Audit report not showing storage records deleted from amend invoices | Bug | 4.2.1 | No | No | Rent records deleted in 'Amend Invoices' were not shown on the audit report | ||
| VI271 | New customer setup issues | Bug | 4.2.1 | No | No | When completing a new customer set up in VW and finishing off the setup in VI: # HO being ticked for Doc charges, even after unticking and saving it remains. (Open customer which hasn't been set up, input all of the nominals, Invoice admin, tick Document Charges and the tickboxes adjacent, hit enter, go to the next tab where you set up the band charges, click Document Charges, tick all of the invoice types, enter a one line charge band and click save, then reopen the customer, notice that the selected order types are no longer selected). # If you don't save after entering nominals first, and tick transport VAT before saving, it says that a nominal isn't set up even though it is. # Automatic numbering in grids has issues if you put wrong figure in the 'From' column, you can't amend | ||
| VI267 | Placement of the currency in the invoice search results | Issue | 4.2.1 | No | No | It should be next to the invoice total and not at the end of all of the existing columns | ||
| VI264 | Storage Charge Invoice 'Charge' Column incorrect when discount applied | Bug | 3.4.1, 4.2.0 | 4.2.1 | QRR-487-25512 | No | No | The 'Charge' column is not displaying the correct value when a discount has been applied. |
Release 4.2.0 (13/03/2015)
| UID | Summary | Issue Type | Affects Version/s | Fix Version/s | FusionUID | Apply License | System Config | Release Notes |
|---|---|---|---|---|---|---|---|---|
| VI--263 | Password Length Consistency | Improvement | 4.2.0 | No | No | Expand password field length to allow users with long passwords to have the same password across all application in the Vision Suite | ||
| VI--262 | Error Message when running invoices | Bug | 4.1.0 | 4.2.0 | No | No | When sending storage invoices by email an error appears on the screen : 'Following error occurred while emailing invoice number Axxxxx. Invalid column name 'Customer_Code', Invalid column name 'Site_Code'' This only happens when the 'UseVisionInvoicingOutputService' constant is TRUE, on 'Raise Invoices' | |
| VI--260 | Sun Accounts Extract - Improvement | Improvement | 4.2.0 | No | No | Modified the output of the extract. 1) Transaction / Journal Type - when no vat then SIZ otherwise SI 2) Journal Source = VISION 3) Split out the VAT line to a seperate entry with the same headers 4) We were told that the first column of the file is the customer A/C (our 'SageAccountCode') however just found out that this is a 10 character field which is supposed to be 'D' + SageAccountCode. | ||
| VI--259 | Allow for multi currency deliveries in VI | Improvement | 4.2.0 | No | No | This is required to finish off the work for VDIST-356: 1) Added a currency table 2) Added a currency history table 3) Update the currency history when the currency is updated 4) ADD Currency to - tblTempDeliveryToInvoice - tblDeliveryToInvoice - tblInvoice 5) When receiving the transactions from Distribution check and match the currency signs. 6) Update the Distribution import for the new fields 7) Change the delivery invoicing process - to batch deliveries of the same currency on to the same invoice. So if we have 5x GBP deliveries and 2x EUR deliveries they will go on to two separate invoices - to set the invocie currency 8) Make sure all existing transactions are set to use base currency 9) VAT process for non base country are required 10) all historical data to set all records to the Base Currency 11) Ensure the currency is output where necessary in the accounts extracts - Sage Line 50: Set the 'Exchange Rate' column (after 'Tax Amount') "The exchange rate used, relative to the base currency, for a foreign transaction, rounded up to six decimal places.Use numeric entry up to eight digits plus six decimal places" - Sage Line 200: Set the 'DocumentToBaseCurrencyRate' (after 'SalControlValueInBaseCurrency'). - SUN: See point 16 below. 12) Show the CurrencyISO on the relevant screens - Amend Data > Transport after the 'Total Charge' column show heading 'Currency'. This should appear populated using CurrencyISO. Allow the user to change it by using a combo box - Customer Maintenance > Historical Invoices > Transport, in top grid show Currency as the final column,- Customer Maintenance > Outstanding Invoices > Transport, in the grid show 'Currency' at the end and show the CurrencyISO value. - Outstanding by Site report - Transport column will need to convert any values to the Base Currency (don't hard code GBP) Do the same for Outstanding by Customer. - Invoice navigation search results needs the Currency column too showing CurrencyISO value. 16) SUN extracts file for non GBP invoices. When it's a non GBP invoice line, we need to: - Show 'Amount' column as the GBP value - ConversionCode - Other Amount (Foreign currency value to 3 decimal places, blank for GBP invoices) - Other Amount Decimal Places should show hardcoded 2 for non GBP invoices |
Release 4.1.1 (17/02/2015)
This release fixes a problem with the new menu ribbon on older servers.
Release 4.1.0 (10/02/2015)
| UID | Summary | Issue Type | Affects Version/s | Fix Version/s | FusionUID | Apply License | System Option | Release Notes |
| VI-258 | Changes to allow the system to reproduce an invoice with the original customer and address information as they were at the time the invoice was produced | Issue | 4.1.0 | No | No | Some information on invoices was being taken at the run time, this meant that a historical invoice being reproduced could have incorrect information shown on it, namely the customers invoice address. It is a requirement under the finance act to store the original invoice address, this is now being done | ||
| VI-257 | Upgrade Vision Invoicing to the latest version of the .NET framework | Improvement | 4.1.0 | No | No | Update to internal core | ||
| VI-254 | Addition of a new accounts file extract format for the Sun Accounts system | New Feature | 4.1.0 | No | No | New accounts extract format for Sun accounts | ||
| VI-231 | Goods Out - When goods out invoicing had finished it tells the user that all 'weekly' invoices had been invoiced, some customers do not raise these weekly | Improvement | 4.1.0 | No | No | Updated the messages to make more sense. | ||
| VI-209 | Invoicing Outstanding - Make the invoicing of zero values consistent | Improvement | 4.1.0 | No | No | To make the invoicing of zero values consistent, the following need to be changed: Transport – No change Goods out – Invoice numbers are not allocated to 0 charges and they should be. - Invoice output is also filtering anything which is 0 charge so it won’t be shown on the invoice, this needs to be changed Goods In - Goods in sundry charges are not allocated invoice numbers if charge = 0. This needs to be changed Stock charge – No change Storage – No change On ALL of the above, check the following. Zero charges should only be allocated an invoice number when there will be other charges on the invoice, ie, there cannot be an invoice raised with total value of 0. It's imperative that the invoice number sequence is also maintained and not broken. It seems that the 'Stock Charge' invoice is doing this correctly as it is newer. |
Release 4.0.0 (11/12/2014)
| UID | Summary | Issue Type | Affects Version/s | Fix Version/s | FusionUID | Apply License | System Config | Release Notes |
| VI255 | Issues raised from Internal Testing of v4.0.0 | Bug | 4.0.0 | 4.0.0 | No | No | Whilst speeding up the sending of emails for this version in test it was noted that the mail server then gave a RATE control error that we were sending too many at the same time. This has been adjusted as when this limit comes in on your mail server further emails are not sent. | |
| VI251 | Warning message when clicking 'Remove Zero Charges' in 'Amend Invoices' suggests to the user that it will only remove one charge, when in fact it will remove all | Improvement | 4.0.0 | Yes | No | The warning message reads: "You are about to delete this charge, if this has any dependencies (ie line charges, sundry charges) they will also be deleted, are you sure you want to continue?" Change it to: "You are about to delete data, if this data has any dependencies (ie line charges, sundry charges) those charges will also be deleted, are you sure you want to continue?" | ||
| VI249 | The application is not returning all errors received from the email server transmission making it appear that invoices have been successfully sent when they have not | Bug | 4.0.0 | OOW-956-10593 | No | No | Noticed after going live with VI 3.4.2 , when 'SMTPAuthentication' = TRUE emails appear to go out fine but in fact they don't. Internal ErrorLog VI show nothing, nor the Event Viewer on the machine. All errors in the email transmission need to be fed back to the user so they are aware if there's an issue, with the full mail server details of the error. | |
| VI248 | The invoice total is short when there are multiple goods in sundry charges against a single pre advice on an invoice | Bug | 3.4.2 | 4.0.0 | OHZ-125-52670 | No | No | After going live with version 3.4.2 an issue with sundry charges on goods in invoices, that the invoice total would be short if there were multiple sundry charges against any pre advice on the invoice. Basically it was only considering one of the charges. |
| VI244 | Customer not showing as available to invoice when a sundry charge is imported with line charges = 0 and then had zeros removed | Bug | 4.0.0 | VEQ-988-51715 | No | No | If a customer has a sundry charge in the VI table waiting to be invoiced, but for that pre advice the lines had 0 charge and were removed using the 'remove zeros' functionality in 'Amend Invoices', the customer doesn't show as waiting to be invoiced. Now resolved | |
| VI242 | Site non invoiced has horizontal scroll and column width / naming issues | Improvement | 4.0.0 | No | No | 1) Allow the screen to be maximised 2) if possible increase the default screen width 3) improve this grid, for example we have many columns showing 'Storage XYZ', can we put a column group above all of the storage columns so we can remove the word 'Storage' from each of the individual column headings? | ||
| VI241 | CPU usage does not return to idle after emailing | Improvement | 4.0.0 | No | No | modification of the process to ensure that the processor returns to normal after emailling. | ||
| VI239 | Remove SundryChargeValue field from the tblGoodInHeader | Improvement | 3.4.3 | 4.0.0 | No | No | As the Invoicing details are moved on to the new table there is no need of this field in the GoodInHeader table. . | |
| VI232 | £ sign not showing against invoice sub total and VAT values on 'Stock Charge' and 'Goods Out' invoices | Bug | 3.4.2 | 4.0.0 | No | No | On 'Stock Charge' and 'Goods Out' invoices, before v3.4.2 they used to show a £ symbol before the value, but now they do not. The invoice grand total does however. | |
| VI230 | Goods out exception report taking too long to run and timing out | Bug | 4.0.0 | No | No | It's taking 40seconds+ to run as such it's timing out and not producing any data: Report has been optimised | ||
| VI224 | Invoice setup report showing the VW storage charge check as 'goods in storage charge profile check' - The words 'goods in' need to be removed | Improvement | 4.0.0 | Yes | No | as description | ||
| VI223 | Stock charges do not appear on the outstanding invoice report | Improvement | 4.0.0 | Yes | No | Show the stock charges outstanding on the outstanding invoice report, should be the last column before 'Sub Total' | ||
| VI222 | VI - Transport invoices showing ## not digits | Bug | 4.0.0 | DER-743-41049 | No | No | On the transport invoices if the amount is more than 3 digits the amount does display instead a '####' appears on the line. This occurs only when looking at it on screen, the PDF generated seems fine (see two attachments). | |
| VI221 | Vision Invoicing Output Service does not check for customers without their own customised report layouts | Bug | 4.0.0 | No | No | The Vision Invoicing Output Service only works when the customers have their own reports in the ReportFolderPath. This causes the Vision Invoicing Output service to log the following in the event log and means that the invoices don't get printed / emailed: Message: Load report failed. Trace: at VisionInvoicingOutputService.ServiceManager.SendReportToPrinter(DataSet dsInvoice, Int32 fKStockStorageReportType, String printername, String reportPath) The Vision Invoicing Output Service should work in the same way as the VI program does, and first check, do the customers own reports exist, and if not, fallback to the standard VI reports. | ||
| VI220 | Exporting the Line 50 format Sage extract fails with error for all invoice types | Bug | 3.4.2 | 4.0.0 | KKZ-935-41067 | No | No | When generating a Sage extract for any of the invoice types, when constant SageVersion200 is FALSE, we get an error: Unknown Error Column 'InvoiceValue' does nto belong to table tblSAGEExtract |
| VI219 | Goods in invoice 'Total Charge' does not take into consideration 'load charges' as such if a pre advice is by load charge the 'Total charge' always shows as 0 even though the invoice total is correct | Bug | 4.0.0 | KKZ-935-41067 | No | No | Goods in invoice 'Total Charge' does not take into consideration 'load charges' as such if a pre advice is by load charge the 'Total charge' always shows as 0 even though the invoice total is correct. The reason is because tblGoodsInDetail.LineTotal is not populated by VW any more for 'By Load' receipts, which is correct because a line cannot have a 'Line Total' for a by line receipt. | |
| VI218 | VI - Goods Out Invoice: Detailed CSV showing double the bottle qty for bottle picks when using the progressive charging method | Bug | 3.4.1 | 4.0.0 | XGI-669-95599 | No | No | Goods Out Invoice and the Goods Out Detailed CSV is showing different values for the number of bottles picked. The issue looks to be that the detailed CSV had a created an EDI true and EDI false line for every order line on the days where movements occurred on a mixture of EDI orders and non-EDI orders, regardless of the IsEDIOrder flag on tblOrderHeader |
| VI217 | Store customer created date time | Improvement | 4.0.0 | No | No | internal db update | ||
| VI213 | Improvements to the 'Invoice Setup Report' to cover requirements of previous requests and allow users to easily use this report to identify which customers have not been correctly set up for invoicing | Improvement | 4.0.0 | Yes | Yes | This issue replaces VINVOICING-72 and VINVOICING-73, the changes in those issues will NOT be implemented and we will implement this one instead to cover the requirements of both. Create an 'Data Setup Integrity' check button, this will be positioned on the Ribbon Bar to the right of the existing 'Invoice Setup' report 2) Move the following 'checks' from the 'Invoice Setup' report - Product storage charge profile check - Product goods in charge profile check - Multiple default storage charge check 3) On the 'Invoice Setup' report, allow customer to choose a filter option before running the report 'Check customers created after:' with a calendar control. | ||
| VI211 | Invoice Setup Report | Improvement | 4.0.0 | Yes | Yes | Nominal Code Check - The system should ensure that the invoice type has a positive selection before it checks whether the nominals are missing, at present it appears for goods out invoice nominals even although the customer is set to never use them. | ||
| VI210 | Amend invoice screen > Removing single records (& Remove Zero Charges) results in the charges coming back in after the next goods out invoice run | Bug | 4.0.0 | No | No | Amend Invoices screen > Stock Transaction > Goods Out The user can currently: - Press DEL key on keyboard to remove a line - Click 'Remove Zero Charges' button which removes all zero charges When records are removed, a process is noticing they are missing and bringing them all back again and has now been changed to do this correctly. | ||
| VI206 | VI - Print box not showing for invoices | Bug | 3.4.2, 4.0.0 | TVQ-594-49194 | No | No | **************************************** Customer issue logged "When I have completed running the transport invoices a print box used to come up for me to print the invoices that are not emailed this has not come up since the upgrade?" **************************************** Resolution It's related to the constant check to use the 'Vision Invoicing Output Service', however, this service is only used for storage and not transport, so the transport invoice print prompt should still appear. | |
| VI202 | Outstanding invoice report is showing a high/incorrect RHD figure | Bug | 3.4.0 | 3.4.0, 4.0.0 | No | No | The report needs to only include the goods in header when it's a by load charge. It should only include the goods in detail when it's a by line charge. | |
| VI199 | When installing VI on a PC with an older version already installed, the VI installer removes the existing version, it should allow multiple to be installed | Improvement | 4.0.0 | No | No | corrected | ||
| VI198 | Tidy up the invoice report output queries | Improvement | 4.0.0 | No | No | DB process enhancements to speed up and re look at the logic in the process when producing any invoice. | ||
| VI188 | Amend invoice data screen is allowing users to amend already invoiced data | Improvement | 4.0.0 | No | No | Users have found a flaw in the Amend Invoice screen in that, they can open the screen and load data, then invoice the data, and without refreshing the amend invoice screen they can amend the already invoiced data. This causes inconsistencies on the invoice report, sage extract, csv, cis etc. Stop used from being able to do this. | ||
| VI185 | Update the VI menu to bring it up to date by changing it to a new Windows 8 style ribbon bar | Improvement | 4.0.0 | No | No | New menu design used | ||
| VI183 | VW > VI Customer import job needs to be source controlled | Improvement | 4.0.0 | No | No | Database object now within the source control | ||
| VI182 | Mail server connection - additional settings to allow secure connections | Improvement | 4.0.0 | No | Yes | We have already implemented VINVOICING-44 to allow authentication, however we need to take this one step further to allow secure connections to a mail server. | ||
| VI174 | Clear down the new consolidation tables for goods out | Improvement | 4.0.0 | No | Yes | **Note this will show the individual data for the consolidated good out invoice, the original data is maintained. Added ability to remove old data for the two new tables to stop them getting too large: the default for these tables is 6 years. | ||
| VI169 | Move Transport to use the new centralised invoicing table to aid quicker searching and simplified searches | Improvement | 4.0.0 | No | No | Centralised function implemented in the DB to improve performance | ||
| VI143 | Storage invoice charge description field for customer specific invoice a little too short | Improvement | 4.0.0 | No | No | size increased | ||
| VI142 | Stock movement table needs a direct link to order table to ensure 100% correct output on the detailed CSV for goods out invoices | Improvement | 4.0.0 | No | No | Added the direct link | ||
| VI141 | Remove unused DB objects | Improvement | 4.0.0 | No | No | DB clean up | ||
| VI73 | Invoice Customer - Ability to set the default flag for Invoicing. | Improvement | 4.0.0 | No | Yes | Modifications required to change the default flag to be YES for invoicing when a new customer is added. | ||
| VI72 | Default Setup Template - to reduce setup time and eliminate errors | New Feature | 4.0.0 | Yes | Yes | Modification to add a default template within VI so that whenever a new customer is added to VW, the system will use the default template to automatically fill in many of the fields. |
Release 3.4.2 (11/04/2014)
| UID | Summary | Issue Type | Affects Version/s | Fix Version/s | Apply License | System Config | FusionUID | Release Notes |
| VI-208 | Invoice setup report misses records when the charge exists against the product profile but not the customer profile | Bug | 3.4.2 | No | No | It should be checking that the charge exists against the product profile AND the customer profile, currently it's only checking that the charge exists against the product profile. | ||
| VI-207 | VI - Error in calculation on Goods Out invoices. | Bug | 3.4.2 | No | No | WSS-294-65637 | "The order was for 24 bottles picked but only charging the rate for 12, checked the data which states 24 bottles picked, and using range 1-12, but multiple ranges set up for this customer in VI including a range for 13-24 which this invoice should have picked up. - The total 24 singles picked is correct after checking the VI and VW records. - Checked audit tables and no changes have been made to the records for this invoice - The customer was set up as accumulative and not changed. - Additionally the invoices for that customer on that movement date were rolled back and rerun to see if the same ranges were picked up, and they were, so there is an issue with the routine which populates data. The reason the same incorrect rate was picked up when we retried, is that if you look at the individual movements, they’re all for no more than 6 bottles so it’s setting that as the range charge whereas actually it should be grouping by order and summing the bottles. This needs to be amended so that the total picked bottles on the order are summed and the ranges are corrected identified. | |
| VI-206 | VI - Print box not showing for invoices | Bug | 3.4.2, 4.0.0 | No | No | TVQ-594-49194 | After completed running of the transport invoices a print box used to come up for me to print the invoices that are not emailed this has not come up since the upgrade? This has been resolved |
Release 3.4.1
| Key | Summary | Issue Type | Affects Version/s | Fix Version/s | Apply License | System Config Option | FusionUID | Release Notes |
| VINV 204 | The grouping of the stock storage summary invoice has changed and it is no longer grouping how it used to | Bug | 3.4.0 | 3.4.1 | No | No | ZKC-288-36909 | System was not grouping the different case sizes into one figure for a week, this has been resolved, its back to pre v3.4 output |
| VINV 203 | Users unable to amend fields relating to the total charge in the amend invoice screen | Bug | 3.4.0 | 3.4.1 | No | No | Unable to amend the following fields in the 'Amend Invoicing' screen: Stock Transaction > Goods In - Load Charge (Top grid) - Charge (Bottom grid) Stock Transaction > Goods Out - Total Charge - Carton Charge Sundry Charges > Goods In - Line Total Sundry Charges > Goods Out - Charge Stock Storage - Total Charge Stock Charges - Charge Transport - Total Charge You double click into them and cannot edit them, nor does anything happen if you click into them and try to overwrite what's in them. In the meantime, we are extracting the data for the customers using the procedures below, which they are editing and sending back to us to upload in: prc_GetConditionReportInvoiceDetailsForAmending prc_GetGoodsInInvoiceDetailsForAmending prc_GetGoodsInSundryDetailsForAmending prc_GetGoodsOutInvoiceDetailsForAmending prc_GetGoodsOutSundryDetailsForAmending prc_GetStockStorageInvoiceDetailsForAmending prc_GetTransportInvoiceDetailsForAmending |
Release 3.4.0
* This release must also have VDistribution v1.8.0 installed. * (see notes for VINV-176)
| Key | Summary | Issue Type | Affects Version/s | Fix Version/s | Apply License | System Config Option | FusionUID | Release Notes |
| VINV_197 | Two emails are being sent for storage invoices | Bug | 3.4.0 | No | No | We've noticed that two seperate emails are being sent out for the storage invoices | ||
| VINV_196 | VAT details are taken from the VW site details but VI should allow users to overwrite certain site details such as the VAT number | Improvement | 3.4.0 | No | No | To take any details from the local VI table if they exist, otherwise fall back to the VW table. | ||
| VINV_192 | Condition report mismatches between first invoice and historical and the invoice totals stored in the database | Bug | 3.4.0 | No | No | All invoices should be taking the subtotal, VAT and grand total from data table, the stock charge invoice is not currently doing this, so correct this, and check all others at the same time. Relating to an Invoice PDF email included record 11605 but not 11670 When we load the historical invoice on SQL can see both however when another use does the same he cannot. We found this to be the default printer, when XPS Document Writer is selected, it seems to be using 'Letter' size and we can see the missing lines, when using a physical printer, it uses 'A4' and we cannot see the line. Later version of crystal runtime will resolve this, there was no data issues | ||
| VINV_191 | Stock charge invoices ignoring the customer setup 'Include VAT' | Bug | 3.3.2, 3.4.0 | 3.4.0 | No | No | INZ-777-65546 | Customer has an issue where they were creating stock charge invoices to not include VAT, however when the report was printing it kept including the VAT. The system was not properly checking the next customer record to see if the invoice required VAT, this was fixed |
| VINV_190 | Customer specific note updates | Improvement | 3.4.0 | No | No | Customer rebranding | ||
| VINV_186 | Grouping is incorrect for the storage invoice output, when a rotation exists on an invoice twice each against different warehouses, the charge is not summed | Bug | 3.4.0 | No | No | CDG-895-17896 | See summary | |
| VINV_184 | Daily goods out import from VW to VI fails when there are sundry charges in VW | Bug | 3.4.0 | No | No | Modified output to accept any sundry charges | ||
| VINV_181 | Unable to run the VInvoicing import jobs | Bug | 3.4.0 | 3.4.0 | No | No | If you try to run the VI import jobs (any of them - daily, weekly, annually, etc) you get the following error: Error occurred while importing Goods Out data: Column 'GoodsOutOrderChargeMinimumPerOrderApplied' does not belong to table tblOrderHeader. This can not be tested. | |
| VINV_180 | Blank 'Goods In' invoices appearing when generating Stock storage invoices | Bug | 3.4.0 | 3.4.0 | No | No | On our internal test system, went to the 'Outstanding invoices' on Customer Maintenance. I generated a stock storage invoice and created ref A91208. Then, if you go to 'Historical Invoices' > Stock Storage and view A91208 - looks fine (figures are correct). However, now go to Historical Invoices > Stock Trans > Goods In and there is also an entry here for invoice ref A91208. If you select 'Show invoice' for this one, all you get is a blank invoice template appearing. The form was picking up additional records in error. | |
| VINV_179 | Users cannot load outstanding transport invoices as the system tells them that there are no matching customer records (yet there are) | Bug | 3.4.0 | No | No | This is resolved. | ||
| VINV_178 | Unable to save changes on the Customer Maintenance Screen | Bug | 3.4.0 | 3.4.0 | No | No | When adding a new nominal code on the Nominal Codes section of 'Customer Maintenance' for example, and hit save, I get the following error: 'Unhandled exception has occurred in your application ... Index was out of range. Must be non-negative and less than the size of the collection'. | |
| VINV_177 | If a pre advice has no lines in VI but does have a sundry charge the invoice appears blank | Bug | 3.4.0 | No | No | Table join now changed | ||
| VINV_176 | Changes to the transport invoice data import and invoice layout to show merged delivery charges more clearly to the customers | Improvement | 3.4.0 | No | No | Changes to the transport invoice data import and invoice layout to show merged delivery charges more clearly to the customers, work to be done alongside VDIST-223 changes. Change the transport invoice layout to show: a. If no merging has happened, show the delivery. b. If the delivery has been merged, only the parent delivery should show. For merged deliveries, show a subreport, which shows the details of the child deliveries underneath. *** YOU MUST HAVE VDIST v1.8 or later for this to work *** *** IF YOU USE MERGE YOU MUST ALSO UPDATE YOUR REPORT LAYOUTS OTHERWISE THIS WILL NOT SHOW *** | ||
| VINV_175 | Storage minimum charge is not being applied to the weekly rate for pro rata rental records | Bug | 3.4.0 | No | No | In VI v3 the minimum charge calculation remained the same however the way we import pro rata records changed for weekly rent to match the way we calculate it for quarterly / annual customers. For example, if a weekly customer had stock received 10 weeks ago but it's only landed on the system today, previously 10 rent records would be imported, however now, we only import 1 and set the 'ProRataAdditionalWeeks' to 9. This presents a problem, in that the minimum charge checks that the total rent > minimum charge, otherwise the minimum is applied. Previously, each weekly record would be less than the minimum, so the £0.20 would be applied. However now, all 10 weeks = £1.00, therefore > £0.20 so the minimum is not applied to the weekly rent figure. | ||
| VINV_172 | VDIST-210: Extend the rotation line no field | Improvement | 3.4.0 | No | No | as description | ||
| VINV_171 | Unable to view invoices via 'Show Invoices' | Bug | 3.3.0 | 3.4.0 | No | No | WBS-461-43289 | When searching the customer code > Historical invoices > Stock Transaction then Goods Outwards and clicking 'show invoice' nothing happens. Also when searching the navigation pane for and search for invoice, and select the order charge as type and search, only IDI order charge orders come up and you cant open them either. |
| VINV_170 | Condition Reports Sage Extract using wrong nominal code | Bug | 3.4.0 | No | No | UBB-223-18273 | When condition reports are invoiced the nominal code is not being picked from the nominal code set up on the customer in VI. | |
| VINV_168 | Outstanding invoice report data for storage recalculating figures and ignoring invoice amendments | Bug | 3.4.0 | No | No | Every time we're loading the report we're recalculating the figures using the function, we should be directly taking the figures from tblStockStorage | ||
| VINV_167 | Logic for applying invoice minimum charge on storage invoices | Improvement | 3.4.0 | No | No | PTH-187-94804 | ...when inserting into the database we check if the InvoiceValue < StockStorageMinCharge then apply minimum charge. We need to change this This will be set by the user, basically, when they click 'Invoice Outstanding' for storage charges (in Outstanding Invoices OR Customer maintenance screen), we will ask them in a WARNING window "Do you wish to apply minimum charges to these invoices if the total does not exceed the invoice minimum charge setup against the customer?" | |
| VINV_166 | Stock storage invoices are timing out when it generates the sage extract. | Bug | 3.4.0 | No | No | CWZ-151-42151 | When the users run the stock storage invoices they are getting a time out error. This happens when it comes to the generate sage extract part. Imodified the logic and ensuring it runs without database locks | |
| VINV_165 | Ability to regenerate sage extracts as a batch | Improvement | 3.4.0 | No | No | New screen 'Regenerate Sage Extract', radio button showing each of the 5 invoice categories, and a 'Invoice date from' and 'Invoice date to' fields, with a button 'Export' which will produce the save dialog window allowing them to save the extract. | ||
| VINV_163 | Banded storage rates are not being picked up correctly, although the extract from VW is correct, VI is linking the records up to the wrong rates | Bug | 3.4.0 | No | No | NCS-549-61254 | Any non banded storage rates are absolutely fine. However, banded rates are intermittently not being linked to the correct StockStorageCharge in Vision Invoicing. where VI matches the rent records up to the StockStorageCharging record, the join was missing the check on the 'Rate'! | |
| VINV_161 | Pro rata invoice layout changes for all customers | Improvement | 3.4.0 | No | No | For ALL storage reports (including Detailed & Summary - for ALL customers), make the following changes... 1) Change the rate being output to the invoice as the base rate. 2) To the right of the Rate column on the invoice, add a new field which is the number of weeks the charge applied 3) On the CSV, add a new column to show the same | ||
| VINV_160 | Determining the invoice report to load from the search result | Improvement | 3.4.0 | No | No | Changed the invoice search result to load the invoices based on FKInvoiceCategory, as each one of these directly reflect the correct invoice to load. | ||
| VINV_158 | Standardise the 'Invoice Customers' tabs screen layout to avoid confusion when switching between invoicing different invoice types and reorder the tabs | Improvement | 3.4.0 | No | No | Each of the tabs in 'Invoice Customers' has a different layout and it's confusing for users when switching between raising each of the different invoice types. The screens have been made consistent Also, change the order of the tabs to: - Goods In - Stock Storage - Stock Charge - Goods Out - Transport | ||
| VINV_157 | VI - Screens within modules too small and unable to increase | Improvement | 3.4.0 | No | No | ETV-952-21186 | The screens within the modules are very small and there is no option to expand these or drag the borders out to make them larger and easier to work with. Continually have to scroll to side or decrease column size. | |
| VINV_150 | Improvement to the way we log / show errors to users so that the logging system always works even for customers using locked down servers | Improvement | 3.4.0 | No | No | Frequently get the following error message in various places on the system: "Application attempted to pereform an operation not allowed by the security policy. To grant this application the required permissions, contact your system administrator, or use the Microsoft .NET Framework Configuration Tool. ...... The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security" It means the app is trying to write to the application event log but can’t because it’s using a ‘source’ that hasn’t been used before. This is a MS security issue, but have stopped writing to their logs. | ||
| VINV_138 | Move Goods In to use the new centralised invoicing table to aid quicker searching and simplified searches | Improvement | 3.4.0 | No | No | Centralised Goods in logic ... all others using centralised process | ||
| VINV_136 | A few enhancements to VINVOICING-110 storage invoicing rewrite | Improvement | 3.4.0 | No | No | After testing VINVOICING-110 1) Need to be able to use the invoice search for the following fields 'Emailed', 'Printed', 'Sage extract generated' 2) I asked for users to be able to set the printer in VI for the Vision Output Service, a new admin screen will need to be created for this called 'Output Service Configuration' 3) Give the users the ability to view the Output Service log, it should show in the navigation pane as 'Logs' > 'Error' like it does in VEDI client 4) While the storage invoicing is running, we now have a new 'Messages' section at the bottom, is it possible to only show the most recent entries in the progress window? Ie, for the window to auto scroll to the bottom as new entries are added? | ||
| VINV_135 | When clicking on the 'Historical' tabs in the customer record it's very slow / times out on customers with a lot of invoice history | Improvement | 3.4.0 | No | No | this is because we are getting the 'details' as well as the invoice headers. | ||
| VINV_126 | Split out pro rata storage charges in the 'Outstanding Invoice Report' to enable users to check that pro rata charges are importing correctly | Improvement | 3.4.0 | No | No | In the 'Outstanding Invoice Report' 'Pro Rata' storage charges are all included in Storage Monthly / Weekly / Daily etc columns. We should split this out into a seperate column, to allow users to check that pro rata charges are importing. | ||
| VINV_118 | Rename the sage extract procedures in the back end to tidy up the db objects | Improvement | 3.4.0 | No | No | Modifications to rename the Sage Extract procedures to make them easier to find in the DB. | ||
| VINV_114 | Ability to Clear Down Zero Charges | Improvement | 3.4.0 | No | No | INE-834-91523 | Add the ability to remove any data within the 'Amend Invoice Tab' which has a calculated charge of £0.00. This should be applied to any type of invoice. | |
| VINV_90 | Transport invoice report layout modification for existing customer | Improvement | 3.4.0 | PHR-444-11824 | Request for Transport Invoices to always show Cs(s) in the qty column, and never show Plt(s). | |||
| VINV_87 | Goods out invoice > Show 'Lines' and also 'No of Orders' should not be showing a decimal value for the MAN line | Improvement | 3.4.0 | Modification required for the Goods Out Invoice to show new column 'Lines' and the 'No of Orders' should not be showing a decimal value for the MAN line. | ||||
| VINV_75 | Audit change information not detailed enough | Improvement | 3.4.0 | Add the ability to at least see Customer/Product in the Audit Change information screen and some kind of identification column for example Extract Date for Rent/Pre-Advice ID for Goods In/Order ID for Goods Out. | ||||
| VINV_53 | Program not selecting any database as a default. | Improvement | 3.4.0 | Modification required as default database is not being set when the programme is loaded. | ||||
| VINV_50 | Invoice Output Options | Improvement | 3.4.0 | Add the ability to specify both PRINT and EMAIL for each customer and also modify existing radio buttons to be check boxes. | ||||
| VINV_44 | Mail server authentication | Improvement | 3.4.0 | Make improvements to the Mail Server Authentication to Ensure the program uses the 3 new constants any time it attempts to relay mail through the mail server. |
Release 3.3.2
*** This bug release requires ALL outstanding Goods Outwards charges to be fully invoiced before the upgrade can be implemented ***
| Issue ID | Summary | Issue Type | Affects Version/s | Fix Version/s | Apply License | System Config Option | FusionUID | Release Notes |
| VINVOICING-159 | Annual invoice level minimum charges are not being applied for the annual invoice | Bug | 3.3.2 | No | No | If invoice value is less than customer minimum it is now being applied. | ||
| VINVOICING-156 | Amend Invoices > Stock Storage: The screen is not showing the correct fields to allow editing of the rates which carry through to the invoice | Bug | 3.3.2 | No | No | In VI 3.3.0 we changed the way the system works, among many other changes, we changed the system to calculate the final rent charge at the time the data is imported and NOT when the invoice is raised. Previously the user could edit the fields that are used to calculate the rate, now we need to allow them to change the calculated fields instead. | ||
| VINVOICING-149 | Error message when trying to Amend invoices - Stock Storage | Bug | 3.3.1 | 3.3.2 | No | No | When the user tries to amend the 'Charge' values in Stock Storage tab in the Amend Invoices Screen after saving they are receiving error message | |
| VINVOICING-147 | VINVOICING-123: Replacement issue. "Goods out invoice penny difference between invoice and sage posting" | Bug | 3.3.2 | No | No | There are penny differences occurring between the invoice and the posting to sage. | ||
| VINVOICING-145 | Add a missing index to speed up the retrieval of customer export detail data (goods out) | Improvement | 3.3.2 | No | No | |||
| VINVOICING-144 | Rogue field appears on customer specific goods out invoice | Bug | 3.3.2 | No | No | layout amended | ||
| VINVOICING-140 | Goods in charges were split across two invoices | Bug | 3.3.2 | No | No | Now combined, only one invoice per customer per run. | ||
| VINVOICING-139 | When there are outstanding goods out charges ranged by 'Bottles Per Case' the correct outstanding figure is not brought through to the outstanding report | Bug | 3.3.2 | No | No | |||
| VINVOICING-137 | Historical invoices date format | Bug | 3.3.2 | No | No | All dates changed to dd/mm/yyyy | ||
| VINVOICING-134 | Document charges not showing on goods out 'Detailed' csv | Bug | 3.3.2 | No | No | Now showing | ||
| VINVOICING-133 | Goods out charges grouping daily for minimum charges and should be charging the minimum per order | Improvement | 3.3.2 | No | No | The customer initially wanted the minimum charge to be applied per order for Order Line charges, during development they added that they also wanted Order charges done the same way, and also bottle picking. Afterwards, they added that the carton charges were not charging correctly, that it should be a carton per each order's bottles and not carton per days bottles. | ||
| VINVOICING-132 | Centralise the goods out grouping logic so that we can use it for the detail CSV extract | Improvement | 3.3.2 | No | No | To ensure the data sent out on invoices is always correct all charging has been centralise | ||
| VINVOICING-131 | Rewrite goods out routines which populate invoice data to cut down the code into a core query used for the calculations which will help ensure the integrity of the data being pulled through to invoice | Bug | 3.3.2 | No | No | Speeding up of invoicing | ||
| VINVOICING-130 | When the import daily routine fails at any point, the goods out charges are not calculated | Bug | 3.3.2 | No | No | Modified processes to ensure that this is dealt with in a structured manner if failure occurs. | ||
| VINVOICING-128 | Goods out tables are using a text field for joining and should be using an integer foreign key | Bug | 3.3.2 | No | No | Improve speed | ||
| VINVOICING-127 | Goods out bottle picking invoice not showing rotations with line numbers. | Bug | 3.3.2 | No | No | FHE-652-55109 | If an order uses a rotation number and then the same rotation but with a line number this is not showing up on the detailed CSV report. This means the PDF invoice shows more lines than the detailed CSV. Now resolved | |
| VINVOICING-125 | Opening AND saving in the customer maintenance screen sometimes timing out | Bug | 3.3.2 | No | No | Resolved | ||
| VINVOICING-124 | Goods out invoice and detailed CSV conflict, CSV showing a bottle picking charge when there was no bottle picking charge for that day | Bug | 3.3.2 | No | No | Resolved | ||
| VINVOICING-122 | VI - Condition reports invoice search brings back list with invoice values from one invoice line not invoice total | Bug | 3.3.2 | No | No | |||
| VINVOICING-121 | Unable to view Bottles charged invoice | Bug | 3.2.2 | 3.3.2 | No | No | now able to view | |
| VINVOICING-117 | Invoicing CSV files - all text fields need to have a " around the text to ensure it is opened in Excel without excel thinking its a numeric | Bug | 3.3.2 | No | No | Added | ||
| VINVOICING-115 | Customer specific invoice is not resetting the totals when printing multiple invoices | Bug | 3.3.2 | No | No | Customer layout altered | ||
| VINVOICING-113 | Summary rent invoice, when multiplying the qty with the rate or minimum charge it does not equal the calculated final charge | Bug | 3.3.2 | No | No | Resolved by the centralised charging mechanism | ||
| VINVOICING-111 | Invoice period date 'invoiced' flag is getting updated incorrectly / too early which prevents invoices from being raised | Bug | 3.3.2 | No | No | |||
| VINVOICING-107 | Payment Date on All Invoices | Improvement | 3.3.2 | No | No | AWP-714-46594 | Modification required for the Due Date Calculation in the Sage Extract. It is currently start of the following month plus one and should be 30 days from date of invoice. | |
| VINVOICING-106 | Customer specific invoices ALL have address hard coded in footer line | Bug | 3.3.2 | No | No | now looks at system for footer | ||
| VINVOICING-105 | Good out invoice - Carton charges showing on invoice but not CSV file | Bug | 3.2.1 | 3.3.2 | No | No | Now on csv |
Release 3.3.1
| Issue ID | Summary | Issue Type | Affects Version/s | Licensed | System Config Option | FusionUID | Release Notes |
| VINVOICING-116 | Modify the SP [prc_CustomersWithOutstandingTransportInvoices] to view the PKDelivery along with error msg if any error occurs | Improvement | 3.2.3 | No | No | Where customers were setup on multiple sites and the charge to was modified the site code of who to charge was not populated as such invoices were not created. Instead of error a message will appear to allow for debugging | |
| VINVOICING-115 | Customer specific invoice is not resetting the totals when printing multiple invoices | Bug | No | No | multiple printed invoices, the total values were being carried through all the printed version instead of changing each invoice number. This has been resolved | ||
| VINVOICING-106 | Customer specific invoices ALL have address hard coded in footer line | Bug | No | No | Now taking footer line data direct from the database instead of hard coded in the invoice. | ||
Release 3.3.0
**Bugs
Project | Fix Version/s | IssueID | FusionUID | Summary | Release Notes |
Vision Invoicing | 3.2.3, 3.3.0 | Stock storage sage extract is very slow | |||
Vision Invoicing | 3.3.0 | New VI Goods In PDF invoice correct but changes not showing on csv format | |||
Vision Invoicing | 3.3.0 | Good out invoice - Carton charges showing on invoice but not CSV file | |||
Vision Invoicing | 3.3.0 | Customer specific invoices ALL have address hard coded in footer line | |||
Vision Invoicing | 3.3.0 | Blank Stock Storage invoices created. | |||
Vision Invoicing | 3.3.0 | Storage invoicing routine is far too slow to run and needs to be speeded up | |||
Vision Invoicing | 3.3.0 | Invoice period date 'invoiced' flag is getting updated incorrectly / too early which prevents invoices from being raised | |||
Vision Invoicing | 3.3.0 | MUN-224-74499 | Postcode not Showing on Invoice | ||
Vision Invoicing | 3.3.0 | Summary rent invoice, when multiplying the qty with the rate or minimum charge it does not equal the calculated final charge | |||
Vision Invoicing | 3.3.0 | Customer specific invoice is not resetting the totals when printing multiple invoices |
**Improvement
Project | Fix Version/s | IssueID | FusionUID | Summary | Release Notes |
Vision Invoicing | 3.3.0 | Modify the SP [prc_CustomersWithOutstandingTransportInvoices] to view the PKDelivery along with error msg if any error occurs |
Release 3.2.4
**Bug
Project | Fix Version/s | IssueID | FusionUID | Summary | Release Notes |
Vision Invoicing | 3.2.3, 3.2.4 | Stock storage sage extract is very slow | |||
Vision Invoicing | 3.2.4 | Summary rent invoice, when multiplying the qty with the rate or minimum charge it does not equal the calculated final charge | |||
Vision Invoicing | 3.2.4 | MUN-224-74499 | Postcode not Showing on Invoice | ||
Vision Invoicing | 3.2.4 | Customer specific invoice is not resetting the totals when printing multiple invoices | |||
Vision Invoicing | 3.2.4 | Invoice period date 'invoiced' flag is getting updated incorrectly / too early which prevents invoices from being raised | |||
Vision Invoicing | 3.2.4 | Blank Stock Storage invoices created. | |||
Vision Invoicing | 3.2.4 | Customer specific invoices ALL have address hard coded in footer line | |||
Vision Invoicing | 3.2.4 | Good out invoice - Carton charges showing on invoice but not CSV file | |||
Vision Invoicing | 3.2.4 | New VI Goods In PDF invoice correct but changes not showing on csv format | |||
Vision Invoicing | 3.2.4 | Storage invoicing routine is far too slow to run and needs to be speeded up |
**Improvement
Project | Fix Version/s | IssueID | FusionUID | Summary | Release Notes |
Vision Invoicing | 3.2.4 | Modify the SP [prc_CustomersWithOutstandingTransportInvoices] to view the PKDelivery along with error msg if any error occurs |
Release 3.2.3
** Bug
Project | Fix Version/s | IssueID | FusionUID | Summary | Release Notes |
Vision Invoicing | 3.2.3 | Customer specific stock storage summary invoice report has an incorrect reference | |||
Vision Invoicing | 3.2.3 | Goods in invoices not loading if product code is greater than 30 characters in length OR RateName longer than 30 characters | |||
Vision Invoicing | 3.2.3 | Outstanding invoice report temporary file | |||
Vision Invoicing | 3.2.3 | PRoduct Code field on TBLTempInvoiceDetails needs to be varchar 50, 30 not long enough causes invoices to fail to open | |||
Vision Invoicing | 3.2.3 | Space before the account field on Sage L200 extract | |||
Vision Invoicing | 3.2.3 | Sage 200 extract file - additional spaces and SI marker to be removed | |||
Vision Invoicing | 3.2.3 | Invoice Adding Rent Charge Twice | |||
Vision Invoicing | 3.2.3, 3.2.4 | Stock storage sage extract is very slow | |||
Vision Invoicing | 3.2.3 | Invoice navigation search does not search the condition report table | |||
Vision Invoicing | 3.2.3 | Timeouts hardcoded into the import routine program | |||
Vision Invoicing | 3.2.3 | Rate displayed on the storage invoice is halved twice when a 50% discount is applied |
Release 3.2.2
** Bug
* [VINVOICING-77] - Unable to Search and recall Customer
* [VINVOICING-92] - Transport Invoicing - Not invoicing everything which should be invoiced
* [VINVOICING-98] - Invoice sent to customer showing incorrect figures
* [VINVOICING-100] - Goods in table field sizes are too small compared to VW and results in goods in invoices failing to import
Release 3.2.1
** Bug
* [VINVOICING-78] - Charges column not wide enough
* [VINVOICING-79] - Annual Customer Extract
* [VINVOICING-80] - If customer has only goods in sundry charge outstanding (With no pre advice lines) they do not appear as outstanding for invoicing
* [VINVOICING-81] - GoodsInSundry table 'LineTotal' does not allow NULLs which means the sundry charges are not imported
* [VINVOICING-82] - Procedures have DB names hard coded in them
* [VINVOICING-84] - Tables should have a primary key defined to prevent issues with duplications being inserted
* [VINVOICING-86] - Order charge is not calculated when the customer is setup for an order charge with bands by 'lines'
** Improvement
* [VINVOICING-85] - tblCustomerExportDetail fields need increasing in size
Release 3.2.0
** Bug
* [VINVOICING-65] - Emailed transport invoices sending wrong CSV file
* [VINVOICING-66] - Transport Invoices showing incorrect PostCode for Company
* [VINVOICING-68] - Missing Stock Storage monthly invoices.
* [VINVOICING-69] - Invoice queries for storage detailed output wrong when pallets calculated
* [VINVOICING-71] - Issue with Transport Sage Extract - Calculating the wrong Invoice Value
* [VINVOICING-74] - Secure VI new features to be controlled by license string
** Improvement
* [VINVOICING-24] - Invoices - Change to layout
* [VINVOICING-64] - Pre-invoice report
* [VINVOICING-67] - Customer specific transport invoice layout change
* [VINVOICING-70] - Customer specific goods in invoice layout change
* [VINVOICING-76] - CERT Report Names
** New Feature
* [VINVOICING-30] - VDist-26 - Fuel Surcharge
* [VINVOICING-51] - Vision Invoicing Goods Out CSV
Release 3.1.2
** Bug
* [VINVOICING-56] - Timeout when searching for Invoices via the Invoice search in Navigation
* [VINVOICING-57] - Storage Detailed Invoice shows rate halved twice when a discount is applied
* [VINVOICING-58] - Storage - If discount percentage = 0 then total charge is calculated at £0.00 when it should charge 100%
* [VINVOICING-59] - Invoice Crystal Error
* [VINVOICING-60] - Pro-Rata additional months calculation
* [VINVOICING-61] - Rent Invoice is showing 'rate' column with a double discount incorrectly
** Improvement
* [VINVOICING-42] - VI Import - Check for timeouts when updating data
* [VINVOICING-52] - Doc Ref Field Expansion - (8 - 15tbc)
* [VINVOICING-62] - UOM Project - Invoice Descriptions enhancement
Release 3.1.1
** Bug
* [VINVOICING-54] - Not looking for customer specific report correctly
* [VINVOICING-55] - Error logged when running storage invoices
Release 3.1.0
** Bug
* [VINVOICING-49] - fncGetFinancialYearNextStartDate() calculating wrong
** New Feature
* [VINVOICING-37] - VI7 - Invoice Exceptions Report (C)
* [VINVOICING-38] - VI8 - Manipulation of Invoices Prior to Printing (C)
Release 3.0.1
** Bug
* [VINVOICING-31] - Goods in invoice, Sub-Total + VAT does not equal the Grand Total (penny difference - rounding issue)
* [VINVOICING-32] - When a batch of email and print invoices are sent out, if a customer specific invoice report exists it is only used for the print invoices
* [VINVOICING-34] - Missing features required - Minimum Charges
* [VINVOICING-35] - Stock Rent Summary Report - Rounding Issue
* [VINVOICING-39] - Outstanding invoice report does not load in the new version
* [VINVOICING-40] - Error opening customer maintenance, value was either too large or too small for Int16
* [VINVOICING-41] - Print transport invoices are duplicating lines even though the data is correct and when loading the invoice on it's own it's fine
* [VINVOICING-43] - If goods in header / details have zero charge but there is a sundry charge, it is never picked up for invoicing
* [VINVOICING-45] - Transport Invoicing - Table column definition mismatches with VD
* [VINVOICING-46] - Error when generating Sage Extract
* [VINVOICING-47] - Rental minimums per rotations have invalid logic
** Improvement
* [VINVOICING-36] - VI Import Program - Pro rata 'extract date' used in tblStockRent
* [VINVOICING-48] - Remove unnecessary reports from reports directory plus other report changes
Release 3.0.0
** Bug
* [VINVOICING-18] - Timeout Error when opening Customer Records
* [VINVOICING-21] - Annual Invoice Issues - Discounts not taking into account the Storage Type
* [VINVOICING-23] - Sage CSV Extract calculating Goods In charges for FOC receipts
* [VINVOICING-25] - Historical Transport Invoices appearing under the wrong customer account
* [VINVOICING-26] - Timeout error when processing outstanding Storage Invoices
* [VINVOICING-28] - MMS CSV Sage Extract (Spaces / Transaction Date / 'STOCK STORAGE (PERIOD)' reference too long)
* [VINVOICING-29] - Sage Extract for Goods Out Weekly charges - lines duplicated for different charge types
* [VINVOICING-33] - PDF & CSV not matching for Rent and RHD invoices
** Improvement
* [VINVOICING-1] - Show delivery date in customer outstanding transport invoices section
* [VINVOICING-2] - Last Invoice Date - Outstanding Storage is incorrect at customer level
* [VINVOICING-3] - Login to multiple DBs, show DB name in app title, keep config file on uninstall, auto open single search result
* [VINVOICING-8] - Script for reduced rate to be applied for one customer who has stock in two different warehouses
* [VINVOICING-17] - Condition report charge by enhancements
* [VINVOICING-27] - Changes to the rent invoicing (Decimals & rounding, vintage / pack information)
** New Feature
* [VINVOICING-5] - Invoice Number Search
* [VINVOICING-6] - Stock Charging (Condition Reports)
* [VINVOICING-7] - Goods Outwards Charging Additions & Enhancement
Release 2.1.6
** Bug
* [VINVOICING-14] - When emailing the OS Invoice Report it doesn't create the temp file in a correct location
* [VINVOICING-15] - Changes to Sage Extract files generated from Vision Invoicing
* [VINVOICING-16] - Goods Out invoice not calculating correct qty's on the detail lines
* [VINVOICING-19] - Goods In Invoice 'Line Total' not matching the CSV for RR charges
* [VINVOICING-20] - Pro Rata Rent Invoicing
Release 2.1.5
** Bug
* [VINVOICING-4] - Quotes ( " ) within Sage CSV Import file causing Sage Import to fail
* [VINVOICING-10] - fncCalculateChargeStorage taking too long to run
* [VINVOICING-13] - Goods In Invoice not rounding the charge qty up
** Improvement
* [VINVOICING-9] - Procedures are using VAT Rate from systblVisionInvoicingConstants
* [VINVOICING-11] - Sage extract generated with 'LCB' in the filename
* [VINVOICING-12] - Free receipts are showing as charged on the invoice
Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.