The Cost Code is required mesage when editing UDF's on Estimate Lines

SUGGESTED

Hello!

Hopefully someone can help with this. We have a client who wants to use Estimates in the Job Cost module. We have created some UDF's on the Estimate Detail table to allow them to add in needed informaiton that they will be prinitng on their paperwork. In doing some testing with adding some information, they are receiving the message stating that "The Cost Code is required. The Cost Type is required. the Item Code is required. The Line Type is required". It appears its when I go back and edit information that is in the UDF's that are on this table. Highlighted in yellow in the screen shot are the UDF's I have added. In this case I went back to change the text in the "Room Name" UDf on the second line and when I went to add another line after making those edits it gave me this error. In order to get out of this error I have to close the Estimate which doesnt save any changes.

I have talked to Sage and they said because its a UDF they won't help, we confirmed that it works fine if I remove UDF's from the table. Customer really needs these UDF's in order to use Estimates so hoping someone can assist! They are on Sage 100 Standard, Version 7.00.2.0

Parents Reply
  • 0 in reply to Prestonw

    I have verified with Sage how this happens and duplicated this with them remoted in so they could see it. There is no custom scripting or enhancements, this is all NATIVE Sage 100 code and they will still not do anything about it. I have also confirmed that this happens on different versions so this appears to have been in the code for sometime. Frustrating to say the least especialy given this client cannot use the estimating feature without these UDF's.

Children
  • 0 in reply to Prestonw

    Have you tried dragging the UDF's to the lower grid to see if that helps?

  • 0 in reply to Kevin M
    SUGGESTED

    @Prestnow

    Couple of questions:

    * Do these UDF's have any other attributes?  Like Required fields or have any default values?

    * Does this error message only occur when editing the last row?

    Just want to double check the steps to duplicate this.

    1. Enter estimate lines including values in the RoomName field as new lines.  (Sounds like you are able to add values when adding new lines, right?)

    2. After entering a room name value, go back to a line and change the room name (then you get the error message?)

    I have been trying this here and the only way I get the error messages is if I add values to the UDF's on the blank row (which indeed does have all those fields missing).  I think this is what is occurring, that it thinks it's on the blank row with no values.

  • 0 in reply to jepritch

    I've seen line scripts where the detail object and the UI / data entry grid get out of synch (if the script doesn't SetKey back to the original line).

  • 0 in reply to jepritch
    SUGGESTED

    This is exactly what happens, it only happens on the last row. I have a worked around where I am having them import data from an csv file with a VI job to import all of the detail rows. Once these rows are imported they can make changes to rows if needed, appears to only be with new rows. Not a great solution but its doable, still disappointed in Sage's not taking more ownership in their program logic. Thanks for everyones help on this!!