IV90745: WHEN A DISTRIBUTED LINE IS REVISED, IN MATRECTRANS TABLE THE POCOST RECORDS POINT TO WRONG PO REVISION

APAR status

• Closed as program error.

Error description

• Steps to replicate the issue in Maxdemo database:
  
  1) Go to Item Master application
  
  2) Create a new Item as the following and save:
  Item = any valid Item number
  Order Unit = EACH
  Issue Unit = EACH
  
  3) Change Item Status to ACTIVE, selecting the option "Roll New
  Status to Organizations and Inventory?"
  
  4) Select Action > Add Items to Storeroom
  
  5) From Add Items to Storeroom dialog, enter:
  BEDFORD Site
  CENTRAL Storeroom
  Unit Cost = 100.00
  Current Balance = zero
  
  6) Click OK, save Item and take note of its number
  
  7) Go to Purchase Orders application
  
  8) Create a new PO against any valid Vendor with just 01 PO Line
  as the following:
  Line Type = ITEM
  Item = the Item created above
  Quantity = 5.00
  Unit Cost = 100.00
  No Tax Code
  Charge To > GL Debit Account = 6000-200-000
  
  9) Save PO
  
  10) Click on Distribute Costs button
  
  11) From Distribute Costs dialog, distribute the costs as the
  following and click OK:
  (in this scenario, we can use the same GL Account while
  distributing the costs)
  
  Line Cost = 200.00
  GL Debit Account = 6000-200-000
  
  Line Cost = 300.00
  GL Debit Account = 6000-200-000
  
  12) Approve PO and take note of its number
  
  13) Go to Receiving application
  
  14) Receive the PO
  
  15) Go to Purchase Orders application
  
  16) Bring up the PO and revise it (in this scenario, while
  revising the PO just change the PO Description)
  
  17) Approve the revised PO
  
  18) Go to Receiving application
  
  19) Bring up that PO, click on Select Items for Return button
  and return the total quantity
  
  20) Using a SQL tool, run the query below considering the PONUM
  in question:
  
  select ponum, itemnum, polinenum, porevisionnum, issuetype,
  quantity, gldebitacct, linecost, loadedcost from matrectrans
  where ponum = 'XXXX' order by
  to_char(transdate,'DD-MON-YYYHH24:MM:SS');
  
  From the query results, note that the issue is:
  
  When a Distributed Line is Revised, the Returns in MATRECTRANS
  records inherit the correct PO Revision being Returned only for
  the RECEIPT record and not for the POCOST records. For the
  POCOST records, always refer to the current PO Revision and not
  to the PO Revision of the Return transaction.
  

Local fix

• No workaround has been found.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users who return a receipt with distributed (POCOST)         *
  * records.                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * "POREVISIONNUM" on the MATRECTRANS with POCOST type are      *
  * incorrect when user returned a receipt with distributed      *
  * records.  This happened after user revised the purchase      *
  * order before using the Select Items for Returns              *
  * functionality in the Receiving app.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * none                                                         *
  ****************************************************************
  

Problem conclusion

• This is fixed in code.
  
  The fix for this APAR is contained in the following maintenance
  package:
  	 | release\fix pack | Interim Fix for Release 7.6.0.8 Product
  

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

• R760 PSY

     UP