my issue is actually with the FedEx new integration tool they are attempting to setup.  It gets this error and then in the FedEx log file is also shows an error on the field attributes and fails.

Run the type of test I show above and make sure it works, to confirm basic ODBC functionality.  If ODBC is OK, and the FedEx tool doesn't work, perhaps try setting up a SQL Express with linked server as a bridge to Providex data.

I Have problems with odbc mas 90 when i add new record PO1_PurchaseOrderEntryHeader all filed are fill correct before to FOB but when put information on that field and WareHouseCode first character warehousecode is put in FOB

Insert into PO1_PurchaseOrderEntryHeader (
PurchaseOrderNumber ,
PurchaseOrderDate ,
OrderType ,
Division ,
MasterRepeatingPOOrSO ,
VendorNumber ,
VendorName ,
VendorAddress1 ,
VendorAddress2 ,
VendorCity ,
VendorState ,
VendorZipCode ,
POShipToCodeIfDropShip ,
ShipToName ,
ShipToAddress1 ,
ShipToAddress2 ,
ShipToCity ,
ShipToState ,
ShipToZipCode ,
OrderStatus ,
RequiredExpireDate ,
APPurchaseAddressCode ,
UseTax ,
PrintPO  ,
OnHold  ,
BatchFax ,
ShipVia ,
FOB ,
WarehouseCode ,
ConfirmTo ,
Comment ,
_1099Form ,
_1099Box ,
LastReceiptIssuePONumber ,
PrepaidCheckNumber ,
VendorAddress3  ,
VendorCountryCode  ,
FaxNumber  ,
ShipToAddress3  ,
ShipToCountryCode ,
UserID ,
TaxSchedule  ,
LinkToFirstDetailRecord ,
PrepaidAmount  ,
TaxableAmount ,
NonTaxableAmount  ,
SalesTaxAmount  ,
FreightAmount  ,
AmountInvoiced  ,
AmountReceived  ,
AmountFreigtAndSalesTaxInv  ,
BackOrderLostAmount  ,
PrepaidFreight  ) 
Values (
'0000013' ,
{d'2024-07-06'} ,
'S' ,
'00' ,
'' ,
'ADVCOL ' ,
'Advanced Color Coatings       ' ,
'865 South Coast Highway       ' ,
'                              ' ,
'Oceanside           ' ,
'CA' ,
'92054     ' ,
'0000' ,
'XXXXX                          ' ,
'58078 Van Allen Way            ' ,
'                              ' ,
'Carlsbad            ' ,
'CA' ,
'92008     ' ,
'' ,
{d'1899-12-30'} ,
'' ,
'N' ,
'S' ,
'N' ,
'S' ,
'' ,
'' ,
'000' ,
'' ,
'' ,
'N' ,
'  ' ,
'' ,
'' ,
'                              ' ,
'',
'' ,
'                              ' ,
'USA' ,
'' ,
'SANDIEGO ' ,
0 ,
0 ,
0 ,
279.95 ,
0 ,
0 ,
0 ,
0 ,
0 ,
0 ,
0 )

Sage 100 ODBC is read only.  The generally accepted rule is to never add records via ODBC (using your own RW driver obtained elsewhere). You skip all business rules / data validation that way.

Use BOI or VI to import data.

Sage 100 ODBC is read only.  The generally accepted rule is to never add records via ODBC (using your own RW driver obtained elsewhere). You skip all business rules / data validation that way.

Use BOI or VI to import data.