Sage 100

 View Only

  • 1.  Using a SQL 2008 table to import into Sage 100 adv

    Posted 05-09-2013 08:05
    Using a SQL 2008 table to import into Sage 100 adv 4.5.5 with VI. The date fields in the SQL table are Day, month, year, century (an old ERP system) I have tried to substring the fields into a MAS date field mmddyy but it is failing. What am I missing? I seem to remember on a much older VI version that you had to use temp fields?


  • 2.  RE: Using a SQL 2008 table to import into Sage 100 adv

    Posted 05-09-2013 08:29
    Do your substring references give you a leading 0 on single digit days and months? Alternative approach: create a view in SQL that puts the date fields in a format VI likes.


  • 3.  RE: Using a SQL 2008 table to import into Sage 100 adv

    Posted 05-09-2013 08:37
    The SQL data is being created by a 3rd party and posted on a share point site, but I will see if that can be done. Thanks @PhilMcIntosh


Related Content