|
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. >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.