Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. armanps

    Report output exceeds printer width....

    Hi everyone, I was trying to export SO to a CSV file but this error pops-up: "Report output exceeds printer width or record length exceeded on file write operation." Can anyone explain why this is so and if there's a way this could be avoided? Thanks for the help!
  2. armanps

    Importing to IM.ITEMEXT via ODBC

    I was able to import it now successfully. I just specified the Header Record as the CommentText field and the Comment Record as the CommentSize field on the Records tab (#4). Sorry for the late response... just arrived from a short vacation. Thanks for the help! Truly appreciate it!
  3. armanps

    Importing to IM.ITEMEXT via ODBC

    Import Item's Extended Description CONFIGURATION INFORMATION ------------------------------------------------------------------------------------------------------------- FILE NAME: IM.ITEMEXT I/M Item Extended Description DATA SOURCE: SQL_MAS FILE TYPE: ODBC...
  4. armanps

    Importing to IM.ITEMEXT via ODBC

    Hi! I was trying to import records from MS SQL to MAS using Visual Integrator but the only fields imported are the ItemNumber and Sequence Number. The other fields, CommentSize and CommentText were not imported. I already tried to make a condition on Tab#4 (Records) that's always true. I need...
  5. armanps

    Importing to PO

    Thanks a lot Wayne! Your a big help!
  6. armanps

    Importing to PO

    Is this your referring to? CONFIGURATION INFORMATION ------------------------------------------------------------------------------------------------------------- FILE NAME: PO.ORDER P/O Purchase Order Entry File DATA SOURCE: SQL_MAS FILE TYPE: ODBC INSERT...
  7. armanps

    Importing to PO

    Hi! I'm trying to to use the Visual Integrator on importing data from an SQL table to MAS' PO.Order. The import was successful except for the Item_Number field of MAS, it doesn't receive any data. Is there a way I can assign data on that (Item_number) field? TIA, Arman
  8. armanps

    Error Inserting Data to MAS

    I tried to use brute force here. I run a scipt that will update the ProcureTypeBuyMakeSub field to 'B' but it seems my problem became worst. Instead of the field updated to 'B', some characters on my item description were inserted to that field. Are there restrictions/constraints on...
  9. armanps

    Error Inserting Data to MAS

    I'm trying to insert data from MSSQL to MAS using VB as interface. My code is: dbMAS.Execute "INSERT INTO IM1_InventoryMasterfile ( ItemNumber, ItemDescription, ProductLine, ProductType, Valuation, ProcureTypeBuyMakeSub) values ('" & Trim(mRS!cActualItem) & "','" &...

Part and Inventory Search

Back
Top