Sage 100

 View Only
  • 1.  PO Fields marked as ReadOnly in the dictionary (V/I)

    Posted 08-07-2019 16:51
    ​​We have a client wanting to import into Purchase Order but there are certain fields that are not available for import, such as P/O Detail UnitOfMeasureConvFactor.  Can anyone recall the Sage design and functionality reason on not allowing these fields to be available for import? Was it an oversight or was there a valid reason on why they didn't allow them?

    Thank you in advance!

    ------------------------------
    Shannon Sadowsky
    RKL eSolutions, LLC
    ------------------------------


  • 2.  RE: PO Fields marked as ReadOnly in the dictionary (V/I)

    Posted 08-07-2019 17:07
    I don't think they are available to manually change, either, so it would be in keeping with that.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 3.  RE: PO Fields marked as ReadOnly in the dictionary (V/I)

    Posted 08-07-2019 17:18
    @Beth Bowers - Where might the ​unit of measure conversion maintenance under CI setup come into play here?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 4.  RE: PO Fields marked as ReadOnly in the dictionary (V/I)

    Posted 08-07-2019 17:43
    It will pull in the appropriate conversion, based either on the Purchase U of M or, if you're using the Unit of Measure Conversion file, the conversion factor there.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 5.  RE: PO Fields marked as ReadOnly in the dictionary (V/I)

    Posted 08-07-2019 17:23
    We can open up the field for them but the client specifically wants to know the reason behind it, especially because it is available in the Sales Order module.  I am reaching out to Sage Engineers, as well, but wanted to see if anyone can recall the logic or reasoning for this so I can pass the information back to the client.​

    ------------------------------
    Shannon Sadowsky
    RKL eSolutions, LLC
    ------------------------------



  • 6.  RE: PO Fields marked as ReadOnly in the dictionary (V/I)

    Posted 08-07-2019 17:32
    With a UoM project in the past I recall changing UoM after quantity is set will recalculate quantity and unit $'s (according to the conversion rate).  If you open up that field for editing, be sure of the quantities and $ amounts.
    We usually set up the conversion rates and let the business objects work normally.
    "Case" size can differ item by item so using a naming convention like "C12" = case of 12, "C24" = case of 24... allows UoM conversion maintenance settings to work for multiple items.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------