VC v2020.0.2

Release Date

20/06/2020

Other Application Requirements

as per v2020

Warnings or Notices

Issue key

Summary

Issue Type

Fix versions

Description

Linked to

VC-2354

API SO - Price length

Bug

2020.0.2

When submitting an order (from Insight for example) with case/single price having length > (6,5) an arithmetic error throws ''Arithmetic overflow converting nvarchar to datatype numeric''.   The field should be 18.5

VSUP-13826
VC-2357

VC-2394

API Interface - Validate product price 

Bug

2020.0.2

When click on validate product price throws an error for ''SQL Error occured while searching for Interface Rejections.

• > Unable to retrieve Interface Rejection records.

• > Invalid object name 'VisionCommerce.dbo.tblInterfaceRejection'.''

VSUP-14110

VC-2392

LWIN Interface - SS > 100cl not supported

Bug

2020.0.2

When adding LWIN product only allow The single size(cl) field lower or equal to 100cl. The single size(cl) field automatically change down to 100cl when we give more than 100 and press tab/move on next field

VSUP-14116

VC-2378

Accounts posting - credit note with surcharge

Bug

2020.0.1

Credit Note postings to the accounts system are failing when there are surcharges included within the credit, these are not being taking into account within the Document totals. 

VSUP-13947

VC-2377

Stock snapshot - reserve customer exception

Bug

2020.0.1

In Vision Warehousing, stock in a reserve account not marked as belonging to a specific reserve customer shares the same reserve customer code as the main account code.  These are being marked as exceptions in the stock exception report.

VC-2375

PO auto receipting - line no

Bug

2020.0.1

The PO line number will be stored and sent to the warehouse with the POs submitted, to improve the reliability of the automatic receipt processing.

VC-2341

Report - Detail Margin 604 components

Bug

2020.0.1

The Detailed Margin Report (604) does not show the Sales Value against any transaction using a component product

VSUP-13777

VC-2317

Whse re-submission- Pre advice 

Bug

2020.0.1

Warehouse submission- No records listed in Pre advice resubmission tab. 

VSUP-13845

VC-2390

Product searching

Improvement

2020.0.2

Product search navigation, addition of a 'Producer Name' free text field to search by (including the drop down box field) in case users wish to search for part of the producer name / perform a wildcard search.

The fields returned in the navigation search results have also been tidied and improved to give more information such as the free text product analysis fields.

VC-2379

Excellar SO - Exchange Rate rounded off

Issue

2020.0.1

Exchange rate on Ex cellar SO is the rate on PO tab which rounded up to 4 decimal places.

VSUP-14104
VSUP-13999

VC-2342

Finance link - FX rate / stock 

Issue

2020.0.2

When a customer's system is configured to not do stock movement postings, a journal posting is incorrectly being made when the exchange rate is changed on a PO between invoice and receipt.

VSUP-13750

VC-2312

Customer Account - Validate Email Address

Issue

2020.0.1

Within the customer Maintenance form ensure that the email address is valid. If this is invalid will cause Xero to reject any customer updates.  

VSUP-13628

VC-2304

Finance link - missing / archived customers

Issue

2020.0.2

When we have a customer using Xero, they can archive a contact, then amendments to the customer record fail to post & billing documents also.

For any accounts system, when we open Customer Maintenance and click 'Get Accounts Data', the user cannot tell if nothing was returned because VC makes it seem like something was returned and all values were 0.

The customer maintenance 'Get Accounts Data' button will be changed to inform the user better if there's no information found for the customer / if it's archived.

VC-2389

BI Report

Report

2020.0.2

New Report Added

Stock Purchase Cost (avail stock)

Will show the recorded stock record purchase price for the rotation or batch of stock

VC-2383

PO Left Template Updates

Report

2020.0.2

Now suitable for 23 characters