MIDRANGE dot COM Mailing List Archive



Home » MAPICS-L » August 2004

RE: Browser Calcalation



fixed

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. 
> 





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact