How to calculate actual amount on PO

10-11  Source: Network gathering  Views:1 

Advertisement
Hi,
I have to calculate tax and discount on Purchase order and have add that to ekpo-netwr to get the actual amount. Can you please tell me how to do that?
So far I have been taking the EKKO-KNUMV and going to KONV table and serach for records with that KNUMV. But here I am stuck.
I can not understand (I mean I can not find the field to distinguish) which of the records is actually being used in the PO and has an amount (non-zero) against it, which I see in ME23N in "Condition" at header label.
Reward Points Guaranteed.
Regards,
Anid
Hi,
In the PO , I hope yoy might be using the tax code at item level.
Take this tax code and go to the table A003 and get the KNUMH.
Pass this KNUMH to the KONP table to get the condition value.
Add the condition values to the net amount of the PO item. You will get the total amount.
Alaways find the conditions and taxes at thwew item level of the PO.
Regards,
Related articles
  • How to calculate actual amount on PO 10-11

    Hi, I have to calculate tax and discount on Purchase order and have add that to ekpo-netwr to get the actual amount. Can you please tell me how to do that? So far I have been taking the EKKO-KNUMV and going to KONV table and serach for records with t

  • How to calculate tax amount 10-11

    Hi, I am working in driver program of service sheet entry SF. i want calculate Tax Amount of every line item of service entry sheet number.   tax code, net value, total value  mention in line item but tax amount not. then How to calculate tax amount

  • How to calculate the amount of viewing the uploaded document in KM? 11-30

    hello      everyone       I  want to  calculate the amount of viewing the uploaded document in KM,like the iviews of topics in forum.      thanks in advance      lexianHi,    You can develop a hitcount repository services. Each time that you open a d

  • How to calculate actual activity price using cost center balance 11-30

    I have a problem,the case is that: i have two pro.order. orderA settlement to cost center M; orderB is a standard pro.ord,and the work center of orderB link to cost center M. when i calculate the actual activity revaluation.the activity price update

  • How to calculate the amount for cleared documents. 10-11

    Hi Experts, I am working on a program and here i need to display the amount for the cleared document. I have a scenario where there are two financial document related to a single cleared document. I can get the amount for financial document from BSAK

  • How to calculate line amount? 11-30

    I need help in calculating the amount column. Please advise and thank you in advanced!Hi, Try with the below function module. CALCULATE_TAX_FROM_NET_AMOUNT JshreeRead other 3 answers

  • How system calculate miro amount 11-30

    Hi Consultant, PO 2 unit at $12 During GR Dr inventory 24 Cr vendor 24 When in miro, 1) quantity i change to 3 unit and amount remained as 24 cr vendor 24 dr gr/ir      32 cr price diff 8 may i know why gr/ir debited 32 and with price difference? Whe

  • How to calculate ACTUAL QUANTITY for a given PM order 11-30

    hello all, i have  an ALV report requirement like below... (for given Pm order AUFK-AUFNR) i need to display material no       material desc     requirement quantity  Units of measure     Actual quantity these fields i have taken from RESB table (mat

  • How to calculate YTD credit amount and YTD Debit amount 11-30

    How to calculate credit amount and Debit amount for Year-To-Date type in GL Trial Balance Report?You may try the following options. 1. Run 'Expanded Trial Balance' report. 2. Run 'Trial Balance' report. 3. Create FSG report for trial balance based on

  • How to calculate HD space needed 10-11

    I need to videotape a ceremony on Friday and show it very quickly afterwards. I have a new Canon XL2 cam, and I played around with capturing direct into iMovie 5 using the FW cable. My plan was to capture it this way live; at the end of the 90 min sa

  • CFM /TR - how system calculate amount based on rate FX 60A 10-11

    Hi all, i need to know how system calculates amount based on rate entered upon creating a contract (t-code TX01). steps input:- 1. header - comp code, product type, trans type 2. partner 3. purchase curr & amount (eg. IDR 8,345,545,500) 4. sale curre

  • How to calculate tax / discount amount on PO 10-11

    Hi, I have to calculate tax and discount on Purchase order and have add that to ekpo-netwr to get the actual amount. Can you please tell me how to do that? So far I have been taking the EKKO-KNUMV and going to KONV table and serach for records with t

  • How can i subtract budget and actuals amount from gl_balances in discoverer 11-30

    I have a problem with a discoverer report. The table is GL_BALANCES (Financials), and i tried to subtract data of current year and last year, same month, or data from actuals and budgets amounts. Data from actuals have the "A" code in the ACTUAL

  • How to Calculate Opening balance 10-11

    Hi BW Gurus, How to calculate Opening balance for previous period using variables in Reports using debit and credit. Example: Opening balance is the balance for an account for the previous period. In other words, if the user is running a report for P

  • How to calculate optimized number of members of WLS cluster 10-11

    Hi everyone. I have a Oracle AS Portal 11g that run on a cluster with 2 managed servers. Each of managed server run with 8Gb heap (it is too much, I think so). My system has two node with 32G RAM each one (that run RHEL 4.x). While monitoring, I see

  • How to calculate Last year in BEx Report 11-30

    Hi Experts I have a requirement to create report in BEx --> report output will be Amount, Diff in percentage(Plan-Actual),Last year My question how we calculate the Last year and actual minus plan difference in percentageHi, Make use of % functions i

  • How to calculate no.of records for a specific company Code and Transaction 11-30

    Hi All, Could you please help me how to calculate or count no.of records, in a table which are having a specific Company Code and Transaction Code and populate  in an output table displaying that these many records are present for this company code a

  • How to calculate the % of time difference between different state 10-11

    Hi there, The below query returns the follwoign outptut. I need to calculate the % of time period that a specific state ( state ex: open or closed or all report )exists. I have to find the time difference between the 2 states . How could I do that ?

  • HOW TO CALCULATE OPENNING BALANCE 10-11

    HI Experts.. How to calculate Opening balance for previous period using variables in Reports using debit and credit. Example: Opening balance is the balance for an account for the previous period. In other words, if the user is running a report for P

  • How to calculate the unit for RATE? 10-11

    Hey All, I am not sure if there is something standard for this or not. I am calculating the 'Rate' by using 'Value/Amount' and 'Quantity' as follows - Rate == Value /  Quantity I need to calculate the unit for the rate as below - Rate unit == Value u