Sage 100

 View Only
  • 1.  I am trying to import cost codes into Job cost mai

    Posted 02-07-2018 13:22
    I am trying to import cost codes into Job cost maintenance. I want to assign existing cost codes (Set up previously) to a new job. I also want to assign revised units or costs to those cost codes. I cannot get the VI job to bring in any units or costs. Has anyone done this before? TIA


  • 2.  RE: I am trying to import cost codes into Job cost mai

    Posted 02-07-2018 13:26
    I've done it. Are you getting errors, or just nothing importing?


  • 3.  RE: I am trying to import cost codes into Job cost mai

    Posted 02-07-2018 13:35
      |   view attached
    I'm assuming you are importing it into JC2? that table has headers and detail lines. chances are your import has assigned the header record already. You will need to do a second import where you set the record type to Detail Record to bring in the units and the costs.


  • 4.  RE: I am trying to import cost codes into Job cost mai

    Posted 02-07-2018 13:47
    Nothing is importing OR I am getting an extra cost code record that causes an error when I try to open it


  • 5.  RE: I am trying to import cost codes into Job cost mai

    Posted 02-07-2018 13:55
    It's a good possibility it's the danged Div and Vendor fields. The Div defaults to 00 because it is a Z type instead of S. I think I have to modify the data dictionary for those imports and change that to an S so it can import a BLANK.


  • 6.  RE: I am trying to import cost codes into Job cost mai

    Posted 02-07-2018 14:05
    Thanks for the leads @BethBowers and @DavidOverholt . I will check and let you know