Posted Wed, 15 May 2019 17:01:37 GMT by

Hi,

I have updated my version of viewpoint to 11.18.132 and am trying to use the excel add in with excel 365 version 16.0.11425.20200 32-bit

I have successfully created a scriptview and when i run it i get this data returned:

 

Focus Factory Item Number Lot Number Order Number Trn Typ Itm Cls Transaction Quantity Trans Date Total Material Total Labour Total VOH Totall FOH Total Cost
FF2 10017 19D099FHX 578618 PR F 1,250.00 10/05/2019 433.53 95.06 29.37 124.28 682.24
FF2 1180250456 19D079FHX 578550 PR F 10,650.00 29/04/2019 2,492.41 501.72 238.34 641.23 3,873.70

 

But when i call it using the viewpoint excel add in, i get this

Order Number Trn Typ Itm Cls Transaction Quantity Trans Date Total Material Total Labour Total VOH Totall FOH Total Cost
0     578618.00 PR 0 1250 20190510 433.53

95.06

 

It is not pulling in all the columns and the data that is in the columns is under the wrong header or is incorrect.

Do you know what could be causing this to happen and how can i correct it?

Regards

Paul

 

Posted Wed, 15 May 2019 20:51:07 GMT by

Hi Paul,

Were you adding the Scriptview to a new spreadsheet or an existing one?

What are the options you selected when first adding the Scriptview – can you send a screen shot, please?

 

Brandy Lulling

Sr. Support Analyst

brandy.lulling@helpsystems.com

Posted Wed, 15 May 2019 21:40:08 GMT by

Hi Brandy,

I have tried to add the scriptview to both a new spreadsheet and an existing one and gotten the same result with both.

 

screenshot attached with the settings 'viewpoint add in.jpg

Regards

Paul

 

You must be signed in to post in this forum.