Sage 100

 View Only
  • 1.  MAS v4.4.10 - Trying to do a VI to BOM header. Ke

    Posted 11-26-2013 19:46
    MAS v4.4.10 - Trying to do a VI to BOM header. Keep getting error message that the item code exceeds 15 characters. it doesn't. But what seems to be happening is that the VI doesn't recognize that I am using a tab delimited file to import from. So I switch to a CSV comma delimited which it doesn't recognize either. Has anyone else encountered this issue?


  • 2.  RE: MAS v4.4.10 - Trying to do a VI to BOM header. Ke

    Posted 11-26-2013 19:52
    how do you have the file type and delimiter options set?


  • 3.  RE: MAS v4.4.10 - Trying to do a VI to BOM header. Ke

    Posted 11-26-2013 20:12
    I've often used the ~ (tilde) delimiter without quote marks on BoM imports when I've run into issues like this. If you are sourcing from Access on the export, make sure you select tilde and then select 'none' as the text qualifier.


  • 4.  RE: MAS v4.4.10 - Trying to do a VI to BOM header. Ke

    Posted 11-26-2013 20:21
    As I normally do. In v4.5 and v2013, I click on the ASCII check box, then fill in the box with 009 (tab)., then I move onto tab two. When I come back to tab one, the check box is deselected. I run the test import and it fails because the field is greater than 15 characters. When I do the same process in v4.5 and v2013, the check selection holds. I've tried it on two separate systems with the same result. The source file is an Excel file saved as tab delimited. Way odd. Wish I had access to the KB to search....


  • 5.  RE: MAS v4.4.10 - Trying to do a VI to BOM header. Ke

    Posted 11-26-2013 20:42
    I really like tab delimited too. Easy to save an excel to it and is better than csv for sure.