Sage 100

 View Only
  • 1.  I am trying to import into V2016.1 Purchase Order.

    Posted 06-20-2016 14:14
    I am trying to import into V2016.1 Purchase Order. There does not appear to be a line type and it rejects anything not in the CI_Item. I am trying to bring in Special Items. ""*


  • 2.  RE: I am trying to import into V2016.1 Purchase Order.

    Posted 06-20-2016 14:23
    This may help: How to modify VI Data Dictionaries for 4.x framework to enable import to fields otherwise defined as read only. USE CAUTION - MAKE A BACKUP DFDM MAS90\providex.ddf Lookup by name to find the VI entity to modify - get the key ID. DFDM MAS90\providex.dde Search by Key. Find the field record you want to modify Edit field 20 (15,1) a zero is importable. a 1 is read only.


  • 3.  RE: I am trying to import into V2016.1 Purchase Order.

    Posted 06-20-2016 14:23
    I'd expect to see a line type, too. Before calling Sage (should you need to go there), check that there is either a special item GL account in the PO options or that you're importing that; and that your * item is 15 characters or less, including the *.


  • 4.  RE: I am trying to import into V2016.1 Purchase Order.

    Posted 06-20-2016 14:25
    It just seams crazy the line type is not there any more. I guess the assumption is it is all now in the CI_Item table and no one considered special items. I tried /M and received the same issue that the item does not exist.


  • 5.  RE: I am trying to import into V2016.1 Purchase Order.

    Posted 06-20-2016 14:39
    Try setting a misc item with the * as the code.


  • 6.  RE: I am trying to import into V2016.1 Purchase Order.

    Posted 06-20-2016 14:41
    I actually want to do a few of them with *xxxxx with various codes.