RE: Browser Calcalation

["Robert Russell" <Robert.Russell@xxxxxxxxxx>]

This would be a couple of  steps, try a subset on the reqs based on OPC etc.  
Use mass change to shift the qty to the right (1,2,or 3 decimals).  Use mass 
change to return the qty back same decimals.
 
Another would be to use mass change to change a user field and have the user 
exit modify the qty.  User exit could also blank out user field before actual 
record is updated.

        -----Original Message----- 
        From: mandis-inc@xxxxxxx [mailto:mandis-inc@xxxxxxx] 
        Sent: Fri 8/13/2004 8:26 AM 
        To: MAPICS ERP System Discussion 
        Cc: 
        Subject: RE: Browser Calcalation
        
        

        The specific issue is the quantity on the purchase requistion 
calculated in the MAPICS re-order function. MAPICS is calculating a re-order 
quantity of with a decimal of .001 because MAPICS ROP does not allow for 
re-reordering up to a FOQ of zero.  For example, on an item, the OPC=C and the 
FOQ=.001, when inventory is zero and an allocation drives the available to -2  
MAPICS re-order will calculate a re-order quantity of 2.001. The order quantity 
should be 2 not 2.001.  If the OPC=C and the FOQ=.001 and the Mult=1, the 
reorder quantity will be 3. The order quantity should be 2 not 3. 
        
        So, we are looking for a way to change the requisition quantity, in the 
requisition file, from the calculated 2.001 to 2.000.
        
        Hope this help is understanding what we are trying to do.
        
        
        --
        Best regards,
        
        Mike Dreimiller
        Mandis Inc.
        410-526-5996
        Mandis-Inc@xxxxxxx
        
        
        -------------- Original message from "Robert Russell" : --------------
        
        > Mike,
        >
        > You can change the number of decimal positions that are used in the 
presentation
        > of the data (rounding will occur). You would do this in the Card or 
View
        > defininition that is displaying the data. If you have Integrator you 
can change
        > it on the attribute in the business object. Using Integrator would 
address all
        > places the data is presented unless specifically set at a Card or 
View. This
        > only affects the presentation of the data. Data would not be altered 
in the
        > database.
        >
        > Do you want the field to be updated in the database? If so, can you 
be more
        > specifc about what field(s) in what object(s). Maybe user exits for 
the objects
        > can be used.
        >
        > Hope this helps.
        > Robert Russell
        > Paragon SI
        >
        > -----Original Message-----
        > From: Michael J. Dreimiller [mailto:mandis-inc@xxxxxxx]
        > Sent: Fri 8/13/2004 7:01 AM
        > To: MAPICS-L@xxxxxxxxxxxx
        > Cc:
        > Subject: Browser Calcalation
        >
        >
        >
        > Using Brower, is there a way to perform a calculation on a field. For
        > example, take a value of 5.001 and make it 5.000. Exporting to a
        > spreadsheet is not an option.
        >
        > In advance, thanks
        >
        > Mike Dreimiller
        > Mandis Inc.
        > 410-526-5996
        > mandis-inc@xxxxxxx
        > _______________________________________________
        > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
        > To post a message email: MAPICS-L@xxxxxxxxxxxx
        > To subscribe, unsubscribe, or change list options,
        > visit: http://lists.midrange.com/mailman/listinfo/mapics-l
        > or email: MAPICS-L-request@xxxxxxxxxxxx
        > Before posting, please take a moment to review the archives
        > at http://archive.midrange.com/mapics-l.
        >
        >
        >
        >
        > _______________________________________________
        > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
        > To post a message email: MAPICS-L@xxxxxxxxxxxx
        > To subscribe, unsubscribe, or change list options,
        > visit: http://lists.midrange.com/mailman/listinfo/mapics-l
        > or email: MAPICS-L-request@xxxxxxxxxxxx
        > Before posting, please take a moment to review the archives
        > at http://archive.midrange.com/mapics-l.
        >
        _______________________________________________
        This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
        To post a message email: MAPICS-L@xxxxxxxxxxxx
        To subscribe, unsubscribe, or change list options,
        visit: http://lists.midrange.com/mailman/listinfo/mapics-l
        or email: MAPICS-L-request@xxxxxxxxxxxx
        Before posting, please take a moment to review the archives
        at http://archive.midrange.com/mapics-l.