Sage 100

 View Only
  • 1.  Sales orders with a type of ""Backorder"" seem to al

    Posted 04-22-2015 11:42
    Sales orders with a type of ""Backorder"" seem to allow the user to type in the ""Qty Shpped"" field. I expected that to be a field that is locked down and only updated from invoice update process. Is this just something that I never noticed? Is there a setting somewhere to disallow this? I have a new client that will be using sales orders with multiple ship dates, so almost every order will be a backorder status and they will be relying on the quantity shipped field to be correct based on what is invoiced. I don't want someone accidentally typing numbers in that field. has anyone run into this? I would like to lock the field but custom office does not allow me to lock fields in a grid, only allows me to hid them.


  • 2.  RE: Sales orders with a type of ""Backorder"" seem to al

    Posted 04-22-2015 11:46
    What version though I doubt that that matters. Create a panel mod for the Order entry folks that hide it from them. Maybe create a script that would prevent data entry in this field as well.


  • 3.  RE: Sales orders with a type of ""Backorder"" seem to al

    Posted 04-22-2015 12:29
    I've run into that and just had to hide it. Which was fine for my customer, but may not be for yours.


  • 4.  RE: Sales orders with a type of ""Backorder"" seem to al

    Posted 04-23-2015 06:45
    yes, I can't hide the field, they need to know the quantity shipped on each line. I'm jus concerned that they might type in that field. I had not thought of scripting yet. I'll have to look into that.


  • 5.  RE: Sales orders with a type of ""Backorder"" seem to al

    Posted 04-25-2015 12:57
    May not need a script - create a new UDF for Shipped View Qty and update from existing shipped qty source SO SalesJournal. Add to screens then Disable the UDF so you can see it but not change it and then hide the original shipped field.


  • 6.  RE: Sales orders with a type of ""Backorder"" seem to al

    Posted 04-25-2015 15:09
    I like that!!!


  • 7.  RE: Sales orders with a type of ""Backorder"" seem to al

    Posted 04-26-2015 05:57
    Great idea Moira!