Sage 100

 View Only

  • 1.  I need to modify all Average Unit Cost. I see the

    Posted 05-20-2014 22:46
    I need to modify all Average Unit Cost. I see the field in DFDM but I don't see it in VI. Can It be done? Am I missing something obvious?


  • 2.  RE: I need to modify all Average Unit Cost. I see the

    Posted 05-21-2014 04:34
    Here are the steps to make a read only field ""importable"" in the data dictionary. I have used this to import to the average cost field successfully. Props to Alnoor for sharing this. Description: Allowing Import to read only file in MAS Details: How to modify VI Data Dictionaries for 4.x framework 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 need to modify all Average Unit Cost. I see the

    Posted 05-21-2014 04:50
    Keep in mind that this won't adjust the GL balance and you will need to make a journal entry to correct the GL.


  • 4.  RE: I need to modify all Average Unit Cost. I see the

    Posted 05-21-2014 05:04
    Thank you


  • 5.  RE: I need to modify all Average Unit Cost. I see the

    Posted 05-21-2014 05:45
    The only way to modify average unit cost is to: 1. adjust existing quantities to 0 at the current average cost. 2. after updating step 1, adjust (add) the original quantities to inventory using the new unit cost.


  • 6.  RE: I need to modify all Average Unit Cost. I see the

    Posted 05-21-2014 15:26
    Going back to what @BernieLehman said, once you make that change you can also modify the panel in item maintenance to have the field unlocked then you can make changes right there.


  • 7.  RE: I need to modify all Average Unit Cost. I see the

    Posted 05-21-2014 16:18
    You can make the change in item maintenance but the are other tables affected such as IM_PeriodPostingHistory and IM_ItemWarehouse. If you only Change CI_Item you are asking for trouble... The next time you have a PO receipt and an SO Invoice update for the item, you will get an erroneous ave cost. Then you get to go in and (try to) fix it again.


  • 8.  RE: I need to modify all Average Unit Cost. I see the

    Posted 05-21-2014 20:04
    @DougHiggs agreed. I should have said you ""can"" but I would not recommend!


  • 9.  RE: I need to modify all Average Unit Cost. I see the

    Posted 05-21-2014 20:13
    Thank you all.


  • 10.  RE: I need to modify all Average Unit Cost. I see the

    Posted 05-22-2014 05:43
    We use an export that calculates the correct average cost and an import job to pull it back in. One of our clients has a vertical add on that regularly leaves negative average costs in the system. It would be nice if they just fixed it.............


Related Content