IV02352: PRORATE COST DOESN'T DIVIDE CORRECTLY.

APAR status

• Closed as program error.

Error description

• 1) Create a new item or make sure Item has zero current balance
  in
  Central storeroom.
  
  2) Create PO for item. Qty=2, Unit Cost = 35 for storeroom
  Central.
  
  3) Approve and Receive PO (current balance =2 in Central).
  
  4) In Inventory, Action Issue Current Item, enter GL Debit
  Account and
  issue 1 piece of item (new current balance is 1).
  
  5) Create Invoice enter PO in Invoice header. InvoiceLine - Copy
  POLine
  to Invoice for the first line.
  Create the second line - Standard service, FREIGHT, unit cost =
  200.63,
  with Check box Prorate service selected.
  
  6) Select Action Allocate Services allocate cost of standard
  service
  line into item line cost.
  
  7) Approve the Invoice.
  
  8) The Standard Service cost is divided in two halves.
     100.32 is loaded into Storeroom GL Control Account and 100.32
  is
  loaded into Storeroom variance account.
     The accounts are OK, but the costs are not correct.
     The cost of Service in Invoice is 200.63 but the allocated
  cost is
  200.64 (100.32+100.32).
     It brings 0.01 difference in accounts which is not
  acceptable.
  
  
  200.63 Prorate Cost doesn't divide
  correctly.
  MatRecTrans.proratecost = 100.32
  InvoiceTrans.linecost = 100.32 (for INVCEVAR type)
  MatRecTrans.proratecost (100.32) + InvoiceTrans.linecost
  (100.32) =
  Prorate Cost (200.63) + 0.01
  There is 0.01 difference.
  
  Here are examples in actual tables. MatRecTrans values are
  correct.
  select ponum, polinenum, itemnum, issuetype, linecost,
  loadedcost, tax1,
  proratecost from matrectrans where ponum='1105';
  
   ponum     polinenum     itemnum     issuetype     linecost
  loadedcost     tax1     proratecost
   --------        ------------  ----------  ------------
  -----------
  -------------  -------  --------------
   1105      1             ITEM1       RECEIPT       70
  70
  3.5      0
   1105      1             ITEM1       INVOICE       0
  100.32
  0        100.32
  
  select invoicenum, INVOICELINENUM, linecost, TRANSTYPE from
  INVOICETRANS
  where invoicenum='1073';
  
   invoicenum     INVOICELINENUM     linecost     TRANSTYPE
   -------------  -----------------  -----------  ------------
   1073           1                  3.5          TAX1
   1073           1                  100.32       INVCEVAR
   1073           (null)             274.13       TOTAL
  
  INVOICETRANS INVCEVAR (transtype) line cost should be
  Prorate Cost (200.63) - MatRecTrans.proratecost (100.32) =
  100.31
  
  MatRecTrans.proratecost (100.32) + InvoiceTrans.linecost
  (100.31) =
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: maximo                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: The remaining Prorate Cost in Invoice   *
  *                      Transaction is not correct              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  The remaining Prorate Cost in Invoice Transaction is not
  correct
  

Problem conclusion

• <This is fixed.>
  
  
  
  
  
  The fix for this APAR is contained in the following maintenance
  package:
  
    | release\fix pack | REL 7.1.1.9 - BS
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  PURCHASING

• Fixed component ID

  5724R46PU

Applicable component levels

• R711 PSY

     UP