IV24770: WHEN CREATING INVOICES FROM PO,UNINVOICED COST DISPLAYS WRONGLY

APAR status

• Closed as program error.

Error description

• Problem :when creating invoices from PO,uninvoiced cost displays
  wrongly
  
  Env : 7118
  
  Steps to replicate
  
  Assume :  there is an active exchage rate between USD and
  VND1(vietnam)
  Exchange rate from USD to VND : 2087
  
  1. create a PO ( 1137 ) with USD currency
     Vendor : FSC
  
     In POLINE, add a line with SERVICE Line type
     Quantity : empty
     Line Cost : 3000
     Tax Code : empty
     GL Debit Account : 6000-200-200
     Approve that PO
  
  2. Go to Invoice - create a Invoice (1184).
     Put the po created in step 1.
     Change currency to VND1
  
     In Invoice line tab,  click "Copy PO Lines"
     In "Copy PO Lines" dialog box, you can see uninvoiced cost as
  3000
  
     Select that line
  
     Problem 1:  It is shown as USD in Linecost --> It makes user
  confused. user should change linecost as VND1.
     This is bug. When the PO line or Material line or Service is
  copied to the invoice line they should be converted to the
  invoice currency.
     If client wants to make invoice for 1437.47 USD of 3000 USD,
  Client  needs to change linecost as 3000000 VND1 ( = 1437.47 USD
  )
     Change linecost to 3000000 VND1
  
     Save
  
     Then 1437.47 USD of 3000 USD are invoiced.  In Invoice Tab,
  you can  see 'uninvoiced total' as 1562.53 USD
  
  3. Create a new Invoice for uninvoiced cost of that PO.
     Put the po created in step 1.
     Change currency to VND1
     Before saving that new invoice, if you see uninvoiced cost,
  uninvoiced cost is -2997000
     Problem 2:  WRONG! it should be shown as 1562.53 USD
     This is a bug. On changing the currency code this should be
  converted to the invoice currency.
  
     Go to invoice line tab
     Click 'Copy Po Lines'
     Problem 3:  In "Copy PO Lines" dialog box, you can see
  uninvoiced  cost as -29997000.
                 1562.53 USD should be shown.
     select that poline - OK
     Problem 3 :  linecost is set as -2997000.   --> WRONG !  It
  should be set  3261000.11 VND1. because
  3261000.11 VND1 (1562.53 USD  ) is uninvoiced.
  This is a bug. The Copy PO Line dialog should show the cost in
  PO or Receipt currency. Only when copying to the invoice line it
  should be converted to the invoice currency.
     user needs to change linecost to  3261000.11 VND1  .
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of PO and Invoice                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: when creating invoices from             *
  *                      PO,uninvoiced cost displays wrongly     *
  *                                                              *
  *                      Steps to replicate                      *
  *                                                              *
  *                      Assume :  there is an active exchage    *
  *                      rate between USD and VND1(vietnam)      *
  *                                                              *
  *                      Exchange rate from USD to VND : 2087    *
  *                                                              *
  *                      1. create a PO ( 1137 ) with USD        *
  *                      currency Vendor : FSC                   *
  *                                                              *
  *                      In POLINE, add a line with SERVICE Line *
  *                      type Quantity : empty                   *
  *                                                              *
  *                      Line Cost : 3000  Tax Code : empty  GL  *
  *                      Debit Account : 6000-200-200            *
  *                                                              *
  *                      Approve that PO                         *
  *                                                              *
  *                      2. Go to Invoice - create a Invoice     *
  *                      (1184).                                 *
  *                                                              *
  *                      Put the po created in step 1.           *
  *                                                              *
  *                      Change currency to VND1                 *
  *                                                              *
  *                      In Invoice line tab,  click "Copy PO    *
  *                      Lines"                                  *
  *                                                              *
  *                      In "Copy PO Lines" dialog box, you can  *
  *                      see uninvoiced cost as 3000             *
  *                                                              *
  *                      Select that line                        *
  *                                                              *
  *                      Problem 1:  It is shown as USD in       *
  *                      Linecost --> It makes user confused.    *
  *                      user should change linecost as VND1.    *
  *                                                              *
  *                      This is bug. When the PO line or        *
  *                      Material line or Service is copied to   *
  *                      the invoice line they should be         *
  *                      converted to the                        *
  *                                                              *
  *                      invoice currency.                       *
  *                                                              *
  *                      If the user wants to make invoice for   *
  *                      1437.47 USD of 3000 USD, the user needs *
  *                      to change linecost as 3000000 VND1 ( =  *
  *                      1437.47 USD )                           *
  *                                                              *
  *                      Change linecost to 3000000 VND1         *
  *                                                              *
  *                      Save                                    *
  *                                                              *
  *                      Then 1437.47 USD of 3000 USD are        *
  *                      invoiced.  In Invoice Tab, you can  see *
  *                      'uninvoiced total' as 1562.53 USD       *
  *                                                              *
  *                      3. Create a new Invoice for uninvoiced  *
  *                      cost of that PO.                        *
  *                                                              *
  *                      Put the po created in step 1.           *
  *                                                              *
  *                      Change currency to VND1                 *
  *                                                              *
  *                      Before saving that new invoice, if you  *
  *                      see uninvoiced cost, uninvoiced cost is *
  *                      -2997000                                *
  *                                                              *
  *                      Problem 2:  WRONG! it should be shown   *
  *                      as 1562.53 USD                          *
  *                                                              *
  *                      This is a bug. On changing the currency *
  *                      code this should be converted to the    *
  *                      invoice currency.                       *
  *                                                              *
  *                      Go to invoice line tab Click 'Copy Po   *
  *                      Lines'                                  *
  *                                                              *
  *                      Problem 3:  In "Copy PO Lines" dialog   *
  *                      box, you can see uninvoiced  cost as    *
  *                      -29997000.                              *
  *                                                              *
  *                      1562.53 USD should be shown.            *
  *                                                              *
  *                      select that poline - OK                 *
  *                                                              *
  *                      Problem 3 :  linecost is set as         *
  *                      -2997000.   --> WRONG !  It             *
  *                                                              *
  *                      should be set  3261000.11 VND1. because *
  *                      3261000.11 VND1 (1562.53 USD  ) is      *
  *                      uninvoiced.                             *
  *                                                              *
  *                      This is a bug. The Copy PO Line dialog  *
  *                      should show the cost in PO or Receipt   *
  *                      currency. Only when copying to the      *
  *                      invoice line it should be converted to  *
  *                      the invoice currency.                   *
  *                                                              *
  *                      .                                       *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  when creating invoices from PO,uninvoiced cost displays wrongly
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package:
  
    Release 7.1.1.12
  

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

  FINANCIAL

• Fixed component ID

  5724R46FI

Applicable component levels

• R711 PSY

     UP