APAR status
Closed as program error.
Error description
Problem Description : Commited Cost/Amount received cost are calculated wrongly env : 7118 steps to replicate 1. Create VND1 for vietnam. 2. Set exchange rate from USD to VND1 = 2087 3.create a contract 1054 with 1 service contract line in Purchase Contract App. Type : BLANKET Company : FSC Currency : USD Maximum Amout : 25000 Line Type : Service Description : Test Change Quantity on Use? : Checked Change Price on Use? : Checked 4. Select Action / Authorize Site : Bedford - Approve that contract 5.Select Action/Create Release PO.( 1135 ) 6.Open 1135 PO in Purchase Order App. Make Sure that PO's currency is USD. In Poline, Change LineCost as 20000 TaxCode : TEST ( Which has 10% Tax Rate) --> Tax : 2000 LoadedCost will be 22000 USD Approve this PO. 7.Go to Receiving Application - Receive service. 8.Go to The Invoice Applicaiton - Create a new invoice for 1135 PO. PONUM : 1135 Change Currency from USD to VND1 In Invoice Line, Click 'Copy PO Lines' - In Poline Tab, Select line. Then, invoice line cost will be changed from 20000(USD) to 41740000(VND1) automatically. To make variance, change linecost to 41740001. Then, approve that invoice. Then, invoice variance will be entered into servrectrans (as INVOICE type and USD currency) 1 VND = 0.0004792 USD 41740001 VND = 41740001 VND * 0.0004792 = 20001.81 USD So, Variance between invoice linecost and actual receipt linecost is 200001.81 - 200000 = 1.81 (USD) If I check SERVRECTRANS table, 8. Go to the Purchase Contract Application. Open 1054. - Select View Release Costs. Committed Cost = sum (servrectrans) which include sum (invoice variance ) = 20000 + 1.81= 20001.81 USD --> That's the expected result. But, Committed Cost is shown as 23,777,13 which sum ( 20000 USD + 3777.13 VND ) --> WRONG !! Committed Cost should be calculated with the same currency. Ammout Received = sum ( servrectrans ) - sum(invoice variance) = 20001.81 - 1.81 But, Ammout received cost is shown as 23775.32 ( WRONG !!)
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: Users of Purchasing with different curencies * **************************************************************** * PROBLEM DESCRIPTION: Problem Description : Commited * * Cost/Amount received cost are * * calculated wrongly * * * * steps to replicate * * * * 1. Create VND1 for vietnam. * * * * 2. Set exchange rate from USD to VND1 = * * 2087 * * * * 3.create a contract 1054 with 1 service * * contract line in Purchase Contract App. * * * * Type : BLANKET * * * * Company : FSC * * * * Currency : USD * * * * Maximum Amout : 25000 * * * * Line Type : Service * * * * Description : Test * * * * Change Quantity on Use? : Checked * * * * Change Price on Use? : Checked * * * * 4. Select Action / Authorize Site : * * Bedford - Approve that contract * * * * 5.Select Action/Create Release PO.( * * 1135 ) * * * * 6.Open 1135 PO in Purchase Order App. * * Make Sure that PO's currency is USD. * * * * In Poline, Change LineCost as 20000 * * TaxCode : TEST ( Which has 10% Tax * * Rate) --> Tax : 2000 * * * * LoadedCost will be 22000 USD * * * * Approve this PO. * * * * 7.Go to Receiving Application - Receive * * service. * * * * 8.Go to The Invoice Applicaiton - * * Create a new invoice for 1135 PO. * * * * PONUM : 1135 * * * * Change Currency from USD to VND1 * * * * In Invoice Line, Click 'Copy PO Lines' * * - In Poline Tab, Select line. * * * * Then, invoice line cost will be changed * * from 20000(USD) to 41740000(VND1) * * automatically. * * * * To make variance, change linecost to * * 41740001. Then, approve that invoice. * * * * Then, invoice variance will be entered * * into servrectrans (as INVOICE type and * * USD currency) * * * * 1 VND = 0.0004792 USD * * * * 41740001 VND = 41740001 VND * * * 0.0004792 = 20001.81 USD * * * * So, Variance between invoice linecost * * and actual receipt linecost is * * 200001.81 - 200000 = 1.81 (USD) * * * * If I check SERVRECTRANS table, * * * * 8. Go to the Purchase Contract * * Application. Open 1054. - Select * * * * View Release Costs. * * * * Committed Cost = sum (servrectrans) * * which include sum (invoice variance ) * * * * = 20000 + 1.81= 20001.81 USD --> That's * * the expected result. * * * * But, Committed Cost is shown as * * 23,777,13 which sum ( * * * * 20000 USD + 3777.13 VND ) --> WRONG !! * * * * Committed Cost should be calculated * * with the same currency. * * * * Ammout Received = sum ( servrectrans ) * * - sum(invoicevariance) = 20001.81 - * * 1.81 * * * * But, Ammout received cost is shown as * * 23775.32 ( WRONG !!) * * * **************************************************************** * RECOMMENDATION: * * * * * * * **************************************************************** WHEN INVOICE AND PO CURRENCY ARE DIFFERENT, INVOICE COST SHOULD BE CONVERTED TO PO CURRENCY
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 number
IV24553
Reported component name
PURCHASING
Reported component ID
5724R46PU
Reported release
711
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-07-09
Closed date
2012-09-10
Last modified date
2012-09-10
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
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHPN3","label":"Purchase Requisitions"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"711","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
10 September 2012