Purchase Order XML  Report

10-11  Source: Network gathering  Views:0 

Advertisement
Hi Experts,
I am customizing the Purchase Order detail Report .Here I need to add total tax details .
I found tax details are in po_distribution_all table.Here tax amount is caluculated for each and every line.
in po_distribution table we have recoverabl and nonrecovera0ble tax
i am following this
tax amount per line =recoveralbe tax + non recoverable tax
tax amount per header= sum(tax amount per line)
total amount = sum(linetotal per header) + sum(tax amount per header)
Please tell me breifly how many forumla colums or summary colums we have to take to get the output.
and
Another requirement is
while creating purchase order template
if there are so many lines per one header
then in second page i need to display the lines data with line headings also(eg:ref num, item,item description,need by date).
so for eg if there are 100 lines per one header
then
header details are displayed on first page (ship to , bill to , supplier)
line details are also displayed on first page(ref num,item, item description,need by date,amount,qty,uom)
suppose in first page first 10 lines are displayed
from second page remaing 90 lines are displayed with line hedadings(ref num,item, item description,need by date,amount,qty,uom)
and in the last page we will get footer(terms and conditions,buyer,email)
Could you please tell me how we will solve them..
Thanks
Ashok
Edited by: 886640 on Oct 27, 2011 12:16 AM
Hi Experts,
I am customizing the Purchase Order detail Report .Here I need to add total tax details .
I found tax details are in po_distribution_all table.Here tax amount is caluculated for each and every line.
in po_distribution table we have recoverabl and nonrecovera0ble tax
i am following this
tax amount per line =recoveralbe tax + non recoverable tax
tax amount per header= sum(tax amount per line)
total amount = sum(linetotal per header) + sum(tax amount per header)
Please tell me breifly how many forumla colums or summary colums we have to take to get the output.
and
Another requirement is
while creating purchase order template
if there are so many lines per one header
then in second page i need to display the lines data with line headings also(eg:ref num, item,item description,need by date).
so for eg if there are 100 lines per one header
then
header details are displayed on first page (ship to , bill to , supplier)
line details are also displayed on first page(ref num,item, item description,need by date,amount,qty,uom)
suppose in first page first 10 lines are displayed
from second page remaing 90 lines are displayed with line hedadings(ref num,item, item description,need by date,amount,qty,uom)
and in the last page we will get footer(terms and conditions,buyer,email)
Could you please tell me how we will solve them..
Thanks
Ashok
Edited by: 886640 on Oct 27, 2011 12:16 AM
Related articles
  • Purchase Order XML  Report 10-11

    Hi Experts, I am customizing the Purchase Order detail Report .Here I need to add total tax details . I found tax details are in po_distribution_all table.Here tax amount is caluculated for each and every line. in po_distribution table we have recove

  • Problem with the hierarchial fields in a Purchase order xml report 10-11

    Hi, I am having a problem with the hierarchy problem. We are populating attribute 15 of a PO header. some times it can be null. FYI, we are using 11.5.10 instance where oracle supports direct PO template rather than having a rdf file. And now in the

  • R12 - How to customize the seeded Purchase Order PDF report 10-11

    Hi, We need to customize the layout AND the data of the seeded Purchase Order pdf report that is generated in PO Summary form when user picks drop-down menu Inquire->View Document. I know how to set up the Document Type with a customized layout but I

  • Purchase Order Committments report 10-11

    Hi All Can anyone advise as to what reports i can run that will show me what Purchase orders have no goods delivered against it and goods partly delivered or over delivery against it. A sort of outstanding Purchase Order/Deliveries report VishnuUSe t

  • With reference to contract Purchase Order Analysis report. 10-11

    Hi, I need SAP Standard " With reference to contract Purchase Order Analysis report" Regards, Priya.Hi, there is no standard report to get the PO list wrf to contracts, but you can get through SE16 from the table EKPO, where you have to pass the

  • Can we create purchase order through report programming? 10-11

    hi experts..... can we create purchase order through report programming?If yes plz give me the thread details?Hi, Use this code in a program by using a BAPI function module Anothe rway is using classical/ALV report using call transaction from a repor

  • Purchase Order Print Report Compilation Error 10-11

    Hi, While compiling the report in Reports Builder Purchase Order Print Report , we get the following error: identifier GET_PRECISION must be declared. Where as this is a seeded function inbuild in the Program Units. Also while compiling on server we

  • Customizing Printed Purchase Order (XML) in R12 10-11

    Hi, I need to customize the Printed Purchase Order (which is sent to Supplier). I see the existing report (Executable: XDODTEXE Method: Java Concurrent Program) , I tried to download the template with data definition code=POXPRPOL_XML but i dont see

  • Purchase order status report 10-11

    hi, can any one give an idea regarding to generate a report for purchase order status this report gives a list of purchase orders that are against given sales order item this report also gives the delayed status of purchase orders. 1. user will give

  • Purchase Order Release Report 10-11

    Hi, Is there a report that I can run that will give me the following information with regards to Purchase Orders released: PO number, Date Entered, Username, Release Code, Release Date and Released By? Thank-you in advance. Regards, TracyHi, I think

  • Purchase Order Condition Report 10-11

    Dear all Can we get report for changes in Purchase Order Tax change (i.e. after saving PO initially, users modify the tax code) I want this report to check the user awareness. Pl help If I could get the report on basis of user id basis. ManojHi Manoj

  • Purchase Order Standard Report 10-11

    Dear Experts, I am new to MM module. I want a standard report which can display purchase order report. Please help me. Its important.Hi Charan, This is a forum about certificaiton. So please start a new question in the application forum, I assuem in

  • Purchase Order Pending Report 10-11

    Hi Experts, I am creating a report regarding Purchase Order Pending Details. I want to display only the pending order detail where as report display all the order detail. Please help me out how to get this report. Regards RakeshHAi Please take report

  • Purchase order text report 10-11

    Hi All,   I want to take report of "Purchase order text" which is stored in material master. Any Idea pls let me know.... Thanks HariDear Hari, You can use BAPI_PO_GETDETAIL1 or BAPI_PO_GETDETAIL to retrieve the data in your program.Enter the PO

  • Purchase Order Crystal Report Layout Error 10-11

    The stock Crystal Report Layout for Purchase Orders is giving me the following error: A subscript must be between 1 and the size of the array. Details: errorKind Error in File POR20002 {b89f97ad-bf1f-447b-8bb4-b3d2e5219269} {3C375C81-7D37-475D-9BCB-1

  • How to find import and local  purchase order for report 10-11

    Dear Friends,               Please help me in coding this report, =below is the functional requirement. 1. To find the list of Import or Local Purchase Orders(purchase orders to be procured from another country). 2.Once the import purchase order is s

  • Displaying Purchase order in report 10-11

    Hi Expert I am modifing a report for Mangement , They want to display purchase order in the report .....So I did the following modification but when I run the report all the fields are displaying and purchase order is showing empty, though I have add

  • Purchase Order History Reports 10-11

    Is there any standard SAP report to mass query Purchase Order History on several POs. I can go to ME23N and see the PO history one-by-one, but trying to see if there is a report out there. I am basically looking for follwoing three things from a give

  • Link Sales Order & Purchase Order in Reports 10-11

    Hi All, We create all our Purchase Order's back-to-back to our Sales Orders. When we look at Row Details in a Sales Order we can see the linked Purchase Order, and vice versa. Is it possible to run a Query that will show the list of Sales Orders (all

  • Purchase order aging report 10-11

    Dear All, Is there any report avl which gives PO aging means that the PO has been completed within these days in which GR and IR completed or not. RegardsHi, Hope Purchasing documents by material report with transaction code ME2M and Mandatory input