Sage 100

 View Only
  • 1.  Troubleshooting what looks to be a basic import ro

    Posted 12-09-2015 11:34
      |   view attached
    Troubleshooting what looks to be a basic import routine to BOM production entry. My source file is a txt, problem is like items that follow each other with same quantity will not come in. Skip records is not selected on main tab either, select and record tabs are blank. Here is what sample text looks like Header/Date/item/ParentWhse/CompWhse/Qty ""H"",""12/8/2015"",""SCHDWESINGLE"",""HOU"",""HOU"",1 ""H"",""12/8/2015"",""LM8550-7BELT-1XLM895-1XLM893"",""HOU"",""HOU"",1 -IMPORTS ""H"",""12/8/2015"",""LM8550-7BELT-1XLM895-1XLM893"",""HOU"",""HOU"",1 -DOESN'T IMPORT ""H"",""12/8/2015"",""LM8165-7CHAIN-2XLM893"",""HOU"",""HOU"",1 -IMPORTS ""H"",""12/8/2015"",""LM8165-7CHAIN-2XLM893"",""HOU"",""HOU"",1 -DOESN'T IMPORT ""H"",""12/8/2015"",""LM8165-7CHAIN-2XLM893"",""HOU"",""HOU"",2 -IMPORTS


  • 2.  RE: Troubleshooting what looks to be a basic import ro

    Posted 12-09-2015 11:39
    Do you have the Allow Duplicates turned on in BM Options?


  • 3.  RE: Troubleshooting what looks to be a basic import ro

    Posted 12-09-2015 11:50
    Yes


  • 4.  RE: Troubleshooting what looks to be a basic import ro

    Posted 12-09-2015 12:15
    Had this same issue and had to add a unique identifier to each row and assign it to a udf so VI sees each row as unique and therefore imports all rows.


  • 5.  RE: Troubleshooting what looks to be a basic import ro

    Posted 12-09-2015 12:26
    Did you create the udf for BOM or Prod Entry and just didn't place it on the screen?