In the Dynamics GP metadata file shipping weight is an integer value. In TIBCO Scribe® Insight it displays as an int, so if you try to enter a shipping weight of 2.5 it drops the .5 and improperly adds shipping weight to the GP table.

Example. 

2.5 weight from TIBCO Scribe® Insight goes in as 200 (2.00 in GP) dropping the .5
250 from TIBCO Scribe® Insight goes into GP as 25000 (250.00 in GP)

The GP table specifies Shipping weight as Numeric(8,2) which means that it carries two decimal places. This is why 250 gets seen as 25000. 


The field is ITEMSHWT in IV00101

The resolution is to change the  ship weight to numeric(8,2) instead of int. This is from the GP metadata file


Once more run the following query on your company database where you ran the GP metadata scripts and then reconnect to your GP connection through TIBCO Scribe® Insight. 

IF EXISTS (SELECT id FROM sysobjects WHERE name='KSYNC_ITEM' AND xtype='V ') 
DROP VIEW dbo.KSYNC_ITEM 
GO 

CREATE VIEW dbo.KSYNC_ITEM 
AS 
SELECT I.*, CAST(I.ITEMSHWT/100 AS NUMERIC(8,2)) AS ShipWeight, 
CASE WHEN A1.ACTNUMST IS NULL THEN '' ELSE A1.ACTNUMST END AS IVIVACTNUMST, 
CASE WHEN A2.ACTNUMST IS NULL THEN '' ELSE A2.ACTNUMST END AS IVIVOFACTNUMST, 
CASE WHEN A3.ACTNUMST IS NULL THEN '' ELSE A3.ACTNUMST END AS IVCOGSACTNUMST, 
CASE WHEN A4.ACTNUMST IS NULL THEN '' ELSE A4.ACTNUMST END AS IVSLSACTNUMST, 
CASE WHEN A5.ACTNUMST IS NULL THEN '' ELSE A5.ACTNUMST END AS IVSLDSACTNUMST, 
CASE WHEN A6.ACTNUMST IS NULL THEN '' ELSE A6.ACTNUMST END AS IVSLRNACTNUMST, 
CASE WHEN A7.ACTNUMST IS NULL THEN '' ELSE A7.ACTNUMST END AS IVINUSACTNUMST, 
CASE WHEN A8.ACTNUMST IS NULL THEN '' ELSE A8.ACTNUMST END AS IVINSVACTNUMST, 
CASE WHEN A9.ACTNUMST IS NULL THEN '' ELSE A9.ACTNUMST END AS IVDMGACTNUMST, 
CASE WHEN A10.ACTNUMST IS NULL THEN '' ELSE A10.ACTNUMST END AS IVVARACTNUMST, 
CASE WHEN A11.ACTNUMST IS NULL THEN '' ELSE A11.ACTNUMST END AS DPSHPACTNUMST, 
CASE WHEN A12.ACTNUMST IS NULL THEN '' ELSE A12.ACTNUMST END AS PURPVACTNUMST, 
CASE WHEN A13.ACTNUMST IS NULL THEN '' ELSE A13.ACTNUMST END AS UPPVACTNUMST, 
CASE WHEN A14.ACTNUMST IS NULL THEN '' ELSE A14.ACTNUMST END AS IVRETACTNUMST, 
CASE WHEN A15.ACTNUMST IS NULL THEN '' ELSE A15.ACTNUMST END AS ASMVRACTNUMST 
FROM IV00101 I (NOLOCK) 
LEFT OUTER JOIN GL00105 A1 (NOLOCK) on A1.ACTINDX=I.IVIVINDX 
LEFT OUTER JOIN GL00105 A2 (NOLOCK) on A2.ACTINDX=I.IVIVOFIX 
LEFT OUTER JOIN GL00105 A3 (NOLOCK) on A3.ACTINDX=I.IVCOGSIX 
LEFT OUTER JOIN GL00105 A4 (NOLOCK) on A4.ACTINDX=I.IVSLSIDX 
LEFT OUTER JOIN GL00105 A5 (NOLOCK) on A5.ACTINDX=I.IVSLDSIX 
LEFT OUTER JOIN GL00105 A6 (NOLOCK) on A6.ACTINDX=I.IVSLRNIX 
LEFT OUTER JOIN GL00105 A7 (NOLOCK) on A7.ACTINDX=I.IVINUSIX 
LEFT OUTER JOIN GL00105 A8 (NOLOCK) on A8.ACTINDX=I.IVINSVIX 
LEFT OUTER JOIN GL00105 A9 (NOLOCK) on A9.ACTINDX=I.IVDMGIDX 
LEFT OUTER JOIN GL00105 A10 (NOLOCK) on A10.ACTINDX=I.IVVARIDX 
LEFT OUTER JOIN GL00105 A11 (NOLOCK) on A11.ACTINDX=I.DPSHPIDX 
LEFT OUTER JOIN GL00105 A12 (NOLOCK) on A12.ACTINDX=I.PURPVIDX 
LEFT OUTER JOIN GL00105 A13 (NOLOCK) on A13.ACTINDX=I.UPPVIDX 
LEFT OUTER JOIN GL00105 A14 (NOLOCK) on A14.ACTINDX=I.IVRETIDX 
LEFT OUTER JOIN GL00105 A15 (NOLOCK) on A15.ACTINDX=I.ASMVRIDX 
GO

Integer displays as an Int in TIBCO Scribe® Insight