First don't use the Test feature in VI. It does not work with Sage 2014 as it will not produce true results. You should have a test company and run the imports as normal to see what will happen. Also if you could, post the import job.

I gave up on the Test feature and am just it normal.

In what format would you like to see the import job?

Here is the job:

----------------------

Import Job Definition                                            ()

Configuration Information

Job       POS      Table     PO_PurchaseOrderHeader          Compiled   VIWI00

Name:t F  ODBC Table SourName:                                     Name:

File T    ODBC

Next Job C

Data Elements                   Dat  Fie

Seq N  Column Name              TypeType Oper Col    Mask          Default Value

0001   H.PurchaseOrderNo        STR STD   REPL  67   Start: 1 Len:

0002   H.PurchaseOrderDate      STR DATE  REPL  35   YYYYMMDD

0003   H.OrderType              STR STD   ASSN   3   Start: 1 Len: S

0004   H.MasterRepeatingOrde    STR STD   ASSN   4   0000000

0005   H.RequiredExpireDate     STR DATE  REPL  86   YYYYMMDD

0006   H.APDivisionNo           STR STD   ASSN   6   00            00

0007   H.VendorNo               STR STD   REPL  38   Start: 1 Len: 0001100

0008   H.PurchaseName           STR STD   FILE   8   Start: 1 Len:

       File Assi    AP_Vendor:VendorName

0009   H.PurchaseAddress1       STR STD   FILE   9   Start: 1 Len:

       File Assi    AP_Vendor:AddressLine1

0010   H.PurchaseAddress2       STR STD   FILE  10   Start: 1 Len:

       File Assi    AP_Vendor:AddressLine2

0011   H.PurchaseAddress3       STR STD   FILE  11   Start: 1 Len:

       File Assi    AP_Vendor:AddressLine3

0012   H.PurchaseCity           STR STD   FILE  12   Start: 1 Len:

       File Assi    AP_Vendor:City

0013   H.PurchaseState          STR STD   FILE  13   Start: 1 Len:

       File Assi    AP_Vendor:State

0014   H.PurchaseZipCode        STR STD   FILE  14   Start: 1 Len:

       File Assi    AP_Vendor:ZipCode

0015   H.PurchaseCountryCode    STR STD   FILE  15   Start: 1 Len:

       File Assi    AP_Vendor:CountryCode

0016   H.PurchaseAddressCode    STR STD   FILE  16   Start: 1 Len:

       File Assi    AP_Vendor:PrimaryPurchaseAddressCode

0017   H.ShipToCode             STR STD   ASSN  17   Start: 1 Len: 0000

0018   H.ShipToName             STR STD   FILE  18   Start: 1 Len:

       File Assi    PO_ShipToAddress:ShipToName

0019   H.ShipToAddress1         STR STD   FILE  19   Start: 1 Len:

       File Assi    PO_ShipToAddress:ShipToAddress1

0020   H.ShipToAddress2         STR STD   FILE  20   Start: 1 Len:

       File Assi    PO_ShipToAddress:ShipToAddress2

0021   H.ShipToAddress3         STR STD   FILE  21   Start: 1 Len:

       File Assi    PO_ShipToAddress:ShipToAddress3

0022   H.ShipToCity             STR STD   FILE  22   Start: 1 Len:

       File Assi    PO_ShipToAddress:ShipToCity

0023   H.ShipToState            STR STD   FILE  23   Start: 1 Len:

       File Assi    PO_ShipToAddress:ShipToState

0024   H.ShipToZipCode          STR STD   FILE  24   Start: 1 Len:

       File Assi    PO_ShipToAddress:ShipToZipCode

0025   H.ShipToCountryCode      STR STD   FILE  25   Start: 1 Len:

       File Assi    PO_ShipToAddress:ShipToCountryCode

0026   H.OrderStatus            STR STD   ASSN  26   Start: 1 Len: O

0027   H.UseTax                 STR Y/N   ASSN  27   Start: 1 Len: N

0028   H.PrintPurchaseOrders    STR Y/N   ASSN  28   Start: 1 Len: Y

Run Dat 2/11/2015  11:39:03AM                                                  Page:1

Import Job Definition                                            ()

Data Elements                   Dat  Fie

Seq N  Column Name              TypeType Oper Col    Mask          Default Value

0029   H.OnHold                 STR Y/N   ASSN  29   Start: 1 Len: N

0030   H.BatchFax               STR Y/N   ASSN  30   Start: 1 Len: N

0031   H.CompletionDate         STR DATE  ASSN  31   M/D/Y

0032   H.ShipVia                STR STD   REPL  71   Start: 1 Len:

0033   H.FOB                    STR STD   REPL  69   Start: 1 Len:

0034   H.ConfirmTo              STR STD   REPL  94   Start: 1 Len:

0035   H.Comment                STR STD   REPL  95   Start: 1 Len:

0036   H.TermsCode              STR STD   FILE  39   00

       File Assi    AP_Vendor:TermsCode

0037   H.Box1099                STR STD   ASSN  41   Start: 1 Len:

0038   H.PrepaidCheckNo         STR STD   ASSN  42   Start: 1 Len:

0039   H.FaxNo                  STR STD   FILE  43   Start: 1 Len:

       File Assi    AP_Vendor:FaxNo

0040   H.TaxSchedule            STR STD   ASSN  44   Start: 1 Len: RESALE

0041   H.InvalidTaxCalc         STR Y/N   ASSN  45   Start: 1 Len:

0042   H.PrepaidAmt             NUM STD   ASSN  46   ###,###,###.00

0043   H.FreightAmt             NUM STD   ASSN  47   ##,###,###.00-

0044   H.PrepaidFreightAmt      NUM STD   ASSN  48   ##,###,###.00-

0045   H.InvoicedAmt            NUM STD   ASSN  49   ###,###,###.00

0046   H.ReceivedAmt            NUM STD   ASSN  50   ###,###,###.00

0047   H.FreightSalesTaxInvA    NUM STD   ASSN  51   ###,###,###.00

0048   H.BatchEmail             STR Y/N   ASSN  52   Start: 1 Len: N

0049   H.EmailAddress           STR STD   ASSN  53   Start: 1 Len:

0050   H.SalesOrderNo           STR STD   ASSN  54   Start: 1 Len:

0051   H.RequisitorName         STR STD   ASSN  55   Start: 1 Len:

0052   H.RequisitorDepartmen    STR STD   ASSN  56   Start: 1 Len:

0053   H.UDF_FORCE              STR STD   ASSN  57   Start: 1 Len:

0054   L.ItemCode               STR STD   REPL  15   Start: 1 Len:

0055   L.ItemCodeDesc           STR STD   REPL  29   Start: 1 Len:

0056   L.UseTax                 STR Y/N   ASSN  98   Start: 1 Len: N

0057   L.RequiredDate           STR DATE  REPL  99   YYYYMMDD

0058   L.PurchasesAcctKey       STR STD   REPL  30   Start: 1 Len:

0059   L.UnitOfMeasure          STR STD   ASSN 101   Start: 1 Len: EACH

0060   L.MasterLineKey          STR STD   ASSN 103   000000

0061   L.Reschedule             STR Y/N   ASSN 104   Start: 1 Len:

0062   L.JobNo                  STR STD   REPL  21   Start: 1 Len:

0063   L.CostCode               STR STD   FILE 106   Start: 1 Len: 010000000

       File Assi    JC_CostCode:CostCode

0064   L.CostType               STR STD   ASSN 107   Start: 1 Len: M

0065   L.AllocateLandedCost     STR Y/N   ASSN 113   Start: 1 Len: N

0066   L.TaxClass               STR STD   ASSN 115   Start: 1 Len: NT

0067   L.CommentText            STR STD   ASSN 116   Start: 1 Len:

0068   L.AssetAccount           STR Y/N   ASSN 117   Start: 1 Len: N

0069   L.AssetTemplate          STR STD   ASSN 118   Start: 1 Len:

0070   L.WeightReference        STR STD   ASSN 119   Start: 1 Len:

0071   L.SalesOrderNo           STR STD   ASSN 120   Start: 1 Len:

0072   L.CustomerPONo           STR STD   REPL  67   Start: 1 Len:

0073   L.Weight                 NUM STD   ASSN 122   #####.0000-

0074   L.QuantityOrdered        NUM STD   REPL   7   ##,###,###.000

0075   L.QuantityBackordered    NUM STD   REPL   8   ##,###,###.000

0076   L.MasterOriginalQty      NUM STD   ASSN 125   ##,###,###.000

0077   L.QuantityInvoiced       NUM STD   ASSN 126   ##,###,###.000

0078   L.UnitCost               NUM STD   REPL   9   ##,###,###.000

0079   L.ExtensionAmt           NUM STD   REPL  11   ###,###,###.00

0080   L.UDF_LABEL              STR STD   ASSN 129   Start: 1 Len:

Run Dat 2/11/2015  11:39:03AM                                                  Page:2

Import Job Definition                                            ()

Data Elements                   Dat  Fie

Seq N  Column Name              TypeType Oper Col    Mask          Default Value

0081   L.UDF_LINE_NUMBER        NUM STD   ASSN 130   #######

0082   L.UDF_LIST_PRICE         NUM STD   ASSN 131   #######.##-

0083   L.UDF_UNIT_NUMBER        NUM STD   ASSN 132   ###

ODBC Information

ODBC Data Source PO_Header

Name:

ODBC Data Source PO_Detail

Name:

SQL Statement

Run Dat 2/11/2015  11:39:03AM                                                  Page:3

Import Job Definition                                            ()

SQL Statement

SELECT  

PO_Detail.ID,  

PO_Detail.OrderNumber,  

PO_Detail.OrderLineNumber,  

PO_Detail.SourcingWarehouse,  

PO_Detail.PartNumber,  

PO_Detail.UOM,  

PO_Detail.OrderQuantity,  

PO_Detail.BackorderQuantity,  

PO_Detail.UnitPrice,  

PO_Detail.PricingUOM,  

PO_Detail.ExtendedPrice,  

PO_Detail.ItemDescription1,  

PO_Detail.CustomerDiscountAmount,  

PO_Detail.ItemDescription2,  

PO_Detail.CustomerPartNumber,  

PO_Detail.KitPartNumber,  

PO_Detail.ShippedVia,  

PO_Detail.OrderType,  

PO_Detail.LotNumber,  

PO_Detail.LotReservedQuantity,  

PO_Detail.JobNumber,  

PO_Detail.CustomerPurchaseOrderNumber,  

PO_Detail.CustomerPurchaseOrderLineNumber,  

PO_Detail.PromisedShipDate,  

PO_Detail.CustomerExpectedUnitPrice,  

PO_Detail.TotalDiscountAmount,  

PO_Detail.ExpectedReceiptDate,  

PO_Detail.BasePrice,  

PO_Detail.DetailedDescription,  

PO_Detail.MASGLAccount,  

PO_Detail.SOUnitPrice,  

PO_Detail.SOLineTotal,  

PO_Header.ID,  

PO_Header.OrderNumber,  

PO_Header.OrderDate,  

PO_Header.SellingCompanyName,  

PO_Header.SellingWarehouseName,  

PO_Header.SellingCompany,  

PO_Header.SellingWarehouse,  

PO_Header.CustomerNumber,  

PO_Header.ShipToCustomerNumber,  

PO_Header.JobName,  

PO_Header.SoldToCustomerName,  

PO_Header.ShipToCustomerName,  

PO_Header.SoldToCustomerAddress1,  

PO_Header.ShipToCustomerAddress1,  

PO_Header.SoldToCustomerAddress2,  

PO_Header.ShipToCustomerAddress2,  

PO_Header.SoldToCustomerCity,  

PO_Header.SoldToCustomerState,  

PO_Header.SoldToCustomerZ,  

PO_Header.ShipToCustomerCity,  

PO_Header.ShipToCustomerState,  

PO_Header.ShipToCustomerZip,  

PO_Header.SoldToCustomerAddress3,  

Run Dat 2/11/2015  11:39:03AM                                                  Page:4

Import Job Definition                                            ()

SQL Statement

PO_Header.ShipToCustomerAddress3,  

PO_Header.SoldToCustomerCountry,  

PO_Header.ShipToCustomerCountry,  

PO_Header.AcknowledgeToName,  

PO_Header.AcknowledgeToAddress1,  

PO_Header.AcknowledgeToAddress2,  

PO_Header.AcknowledgeToAddress3,  

PO_Header.AcknowledgeToCity,  

PO_Header.AcknowledgeToState,  

PO_Header.AcknowledgeToZip,  

PO_Header.AcknowledgeToCountry,  

PO_Header.CustomerPONumber,  

PO_Header.CustomerDiscountPercent,  

PO_Header.FOBDescription,  

PO_Header.ShippingTerms,

PO_Header.ShippedVia,  

PO_Header.OrderType,  

PO_Header.SalesPerson,  

PO_Header.AmountSubjectToCashDiscount,  

PO_Header.TotalSalesAmount,  

PO_Header.TaxAmount,  

PO_Header.PaymentTermsDueDays,  

PO_Header.TotalOrderAmount,  

PO_Header.CashDiscountPercent,  

PO_Header.CashDiscountDays,  

PO_Header.CashDiscountAmount,  

PO_Header.TotalNetAmount,  

PO_Header.OrderStatus,  

PO_Header.TotalDiscountAmount,  

PO_Header.StoreNumber,  

PO_Header.RequestedDockDate,  

PO_Header.TotalUnitsOrdered,  

PO_Header.ShipReasonCode,  

PO_Header.CustomerSalesContactName,  

PO_Header.CustomerCenterConfirmNumber,  

PO_Header.OrderCreatedBy,  

PO_Header.PrintVersion,  

PO_Header.SalesOrderReleaseNumber,  

PO_Header.MASConfirmTo,  

PO_Header.MASComment,  

PO_Header.OrphanRecord,  

PO_Header.SOCreateSO,  

PO_Header.SOOrderNumber,  

PO_Header.SOOrderDate,  

PO_Header.SOCustomerNumber  

FROM  

PO_Detail,  

PO_Header  

WHERE  

PO_Header.OrderNumber=PO_Detail.OrderNumber  

ORDER BY  

PO_Header.OrderNumber

Run Dat 2/11/2015  11:39:03AM                                                  Page:5

Woa that is way too much data in your source.  Here is a simple trick. Manually enter the date you are importing. Note the fields where you have to import the data and the order they are in. That is what you need in the source file and nothing else.

Bingo!  Waaaaay too many fields.  Started from scratch and it's happy now.  Thanks!