Comments

  • Sameh Soliman

    that one in specific

    https://www.youtube.com/watch?v=GrzJntNyVQI

  • Sameh Soliman

    yes through expression language personalization you will be able to hide the complete button for the users that are not assigned to supervisor role.

     

    here is the playlist will provide you videos on how to use the personalization on the cloud

    https://www.youtube.com/watch?v=fuEPyMRZEts&list=PLZjxln4kFCzdTkyleMVk6kjT3UYhnAF1T

     

  • Sameh Soliman
    Please go through the following document: Uploading VISA, MasterCard, and Diner's Club Corporate Card Transactions Files In Oracle Fusion Expenses. (Doc ID 2006166.1)
    
  • Sameh Soliman

    id like to know the answer to that too as we have a similar business case where each of 500 different code combinations range have different approvers

     

     

  • Sameh Soliman
    Hi Marc
    
    New AP invoice distribution workflow will be shipped in the second release of r13 so you can route your incomplete distribution scanned invoices using workflow.
    
    
  • Sameh Soliman

    Add GL job role and data access set to see the cost center desc.

     

    also this the formula you looking for

     

    SUBSTR('place your cost center column name here',INSTR('place your cost center column name here', '.', 1, 2)+1, INSTR('place your cost center column name here', '.', 1, 3)-1)

  • Sameh Soliman

    thank you so much for your valuable information Alexey

  • Sameh Soliman

    Could You please share it with us too :)

  • Sameh Soliman

    This should be very simply drill down report using the action link ( master detail ).

    on the summary report you will have only column for parent level companies.

     

    you need to use the GL balance real time subject area for that as it will help you indicate the level of parent you want to show on the respective column.

    on the drill down report you will show the parent company column in addition to the child company column and any further  columns you want to show that will help you on the analysis.

    both reports will be linked used the linked action link on the balance amount column.

     

    in order to do that you need to know how to build a drill down , please take a listen to this video it is related to HCM but it will help you to get the hang of it so you can use for GL too.

    https://www.youtube.com/watch?v=rCwO2T7Z-PA

     

     

    hope this answers your question

     

    Regards

    Sameh

     

     

  • Sameh Soliman

    Hi Armagin

     

    please find attached a file in which you will find info that i hope it will answer your question.

    regards

    sameh

  • Sameh Soliman

    here is what i have done so far

     

    i am still unable to finish it so it should combine project details as well as receipt and PO line description since we do not use inventory items.

    in oracle project SA there is receipt distribution ID but in receipt accounting SA there is receipt receipt number and distribution number , PO number but there is no PO number.

    where is what iam trying to achieve for receipts

     

    Project Number || Receipt Number || Receipt Distribution|| Receipt Amount|| PO Number || PO Line Desc

    <saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlVersion="201201160" xmlns:sawx="com.siebel.analytics.web/expression/v1.1">
       <saw:criteria xsi:type="saw:derivedCriteria">
          <saw:columns>
             <saw:column xsi:type="saw:derivedColumn" columnID="c11cd2ccb8cb4cd80">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Original Source References</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Transaction Source</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="c4aed226651a09d3a">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Original Source References</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Document</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="cc942b16f415367a3">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Project</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Project Number</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="c02553aa50468075f">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Project</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Project Manager</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="cb205d54a33178fef">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Project Type Attributes</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Project Type</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="c868a4974542667c0">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Project Classification</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Class Category Description</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="c44a91afb39e984c9">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Project Classification</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Class Code Description</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="cdf8b99018ea233c5">
                <saw:displayFormat>
                   <saw:formatSpec suppress="suppress" wrapText="true"/></saw:displayFormat>
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:displayFormat>
                      <saw:formatSpec/></saw:displayFormat>
                   <saw:caption fmt="text">
                      <saw:text>Invoice Number</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="c78f0eb401b910d9c">
                <saw:displayFormat>
                   <saw:formatSpec suppress="suppress" wrapText="true"/></saw:displayFormat>
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:displayFormat>
                      <saw:formatSpec/></saw:displayFormat>
                   <saw:caption fmt="text">
                      <saw:text>Invoice Line</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="cad4dfa56ad170110">
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption fmt="text">
                      <saw:text>Invoice Line Desc</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="cc32503c64b72a3cf">
                <saw:displayFormat>
                   <saw:formatSpec suppress="repeat" wrapText="true"/></saw:displayFormat>
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:displayFormat>
                      <saw:formatSpec/></saw:displayFormat>
                   <saw:caption fmt="text">
                      <saw:text>Line Amount</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="c0a7d87f5d337f0c3">
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption fmt="text">
                      <saw:text>Total Tax</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="ce54385f4b0f79c68">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Supplier</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Supplier</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column columnID="cc37df6c61ff65da9" xsi:type="saw:derivedColumn">
                <saw:displayFormat>
                   <saw:formatSpec suppress="suppress" wrapText="true"/></saw:displayFormat>
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>Receipt</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption fmt="text">
                      <saw:text>Receipt</saw:text></saw:caption>
                   <saw:displayFormat>
                      <saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>
             <saw:column columnID="cf304ae09f7ad134f" xsi:type="saw:derivedColumn">
                <saw:displayFormat>
                   <saw:formatSpec suppress="suppress" wrapText="true"/></saw:displayFormat>
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>Original Source References</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption fmt="text">
                      <saw:text>PO Number</saw:text></saw:caption>
                   <saw:displayFormat>
                      <saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>
             <saw:column columnID="c57c027f2972e0124" xsi:type="saw:derivedColumn">
                <saw:displayFormat>
                   <saw:formatSpec suppress="suppress" wrapText="true"/></saw:displayFormat>
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>Original Source References</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption fmt="text">
                      <saw:text>PO Line Number</saw:text></saw:caption>
                   <saw:displayFormat>
                      <saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>
             <saw:column columnID="c0af18b2d2cd5f797" xsi:type="saw:derivedColumn">
                <saw:displayFormat>
                   <saw:formatSpec suppress="suppress" wrapText="true"/></saw:displayFormat>
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>Original Source References</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption fmt="text">
                      <saw:text>PO Line</saw:text></saw:caption>
                   <saw:displayFormat>
                      <saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>
             <saw:column columnID="c34246e18b595fdef" xsi:type="saw:derivedColumn">
                <saw:displayFormat>
                   <saw:formatSpec suppress="suppress" wrapText="true"/></saw:displayFormat>
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>Receipt</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption fmt="text">
                      <saw:text>Receipt Distribution Amount</saw:text></saw:caption>
                   <saw:displayFormat>
                      <saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>
             <saw:column columnID="c5d7fd69e582214f5" xsi:type="saw:derivedColumn">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Expenditure Item</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Transaction Number</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column columnID="cab91af53a32d1421" xsi:type="saw:derivedColumn">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Original Source References</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Source Transaction Distribution Reference</saw:text></saw:caption></saw:columnHeading></saw:column></saw:columns>
          <saw:from>
             <saw:criteria xsi:type="saw:setCriteria" op="union">
                <saw:criteria xsi:type="saw:simpleCriteria" subjectArea="&quot;Project Costing - Actual Costs Real Time&quot;">
                   <saw:columns>
                      <saw:column xsi:type="saw:regularColumn" columnID="c6267de0d515e6fc2">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"Original Source References"."Transaction Source Name"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="cb3acc1cb067e49bd">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"Original Source References"."Document"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c3999388fe6971d24">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"Project"."Project Number"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c8a6c558392255d3a">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"Project"."Current Project Manager"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c257d5fb0bdd703c4">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"- Project Type Attributes"."Project Type Name"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c836c6939064630fa">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"- Project Classification"."Project Classification Category Description"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="cf6030de645b93760">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"- Project Classification"."Project Classification Description"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="ce9c350402aed8e51">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast ( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Invoice Number</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c6fe7837671721c75">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast ( null as int)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Invoice Line</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c355763fa35d00b5a">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast ( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Line Desc</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c6ec4e21c04870e23" aggRule="sum">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">case when "Original Source References"."Transaction Source Name" = 'Oracle Fusion Payables' then "- Expenditure Item and Cost Distribution Measures"."Cost" else null end</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Line Amount</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c0f61b4c237f7fa8b" aggRule="sum">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">Cast ( null as INT)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Line Tax</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c719b60c04c68b47f">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"Supplier"."Supplier Name"</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Supplier</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="ceb1f856e8b1fffde">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast ( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Receipt</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Receipt Number</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="cfb7f2d5e6627fcd2">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast ( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>PO</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>PO Number</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="caeeeb35d8e5e5464">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"Original Source References"."Expenditure Item Original Line Number"</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>PO</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>PO Line Number</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c1f59b9612548851f">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast ( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>PO</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>PO Description</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c47fd9ef51dd75500">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">case when "Original Source References"."Transaction Source Name" = 'Oracle Fusion Cost Management' then "- Expenditure Item and Cost Distribution Measures"."Cost" else null end</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>PO</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Line Amount</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="ca57e2c3867ca3810">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"Expenditure Item"."Expenditure Item"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c6aa2b8d757398004">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast ( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>PO</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>PO Distribution number</saw:text></saw:caption></saw:columnHeading></saw:column></saw:columns>
                   <saw:filter>
                      <sawx:expr xsi:type="sawx:logical" op="and">
                         <sawx:expr xsi:type="sawx:comparison" op="notEqual">
                            <sawx:expr xsi:type="sawx:sqlExpression">"Original Source References"."Document"</sawx:expr>
                            <sawx:expr xsi:type="xsd:string">Expense Report</sawx:expr></sawx:expr>
                         <sawx:expr xsi:type="sawx:list" op="in">
                            <sawx:expr xsi:type="sawx:sqlExpression">"Original Source References"."Transaction Source Name"</sawx:expr>
                            <sawx:expr xsi:type="xsd:string">Oracle Fusion Cost Management</sawx:expr>
                            <sawx:expr xsi:type="xsd:string">Oracle Fusion Payables</sawx:expr></sawx:expr></sawx:expr></saw:filter></saw:criteria>
                <saw:criteria xsi:type="saw:simpleCriteria" subjectArea="&quot;Payables Invoices - Transactions Real Time&quot;">
                   <saw:columns>
                      <saw:column xsi:type="saw:regularColumn" columnID="ca01bd5f134ecbd27">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">'Oracle Fusion Payables'</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c00fd4a87bd120317">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">'Supplier Invoice'</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c092629e0453d684e">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"- Invoice Line Details - Project Information"."Project Number"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="ce4772a2397557b46">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Project</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Project Type</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="cbce48a040b7c05ba">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Project</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Project Category</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="cbc6f585a1eb6bcad">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Project</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Project Class</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="cc8a0b47688ce4acf">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>

  • Sameh Soliman
    I agree,
    
    You need to include the tax amount too on your report if you have tax
    
    Iam working on something I will share later when I tune it up
    
    
  • Sameh Soliman

    I think You should have a column for expenditure ID and another column for invoice .

    by doing that you will have a single row for each expenditure ID

     

    right now on the screenshot you shared the grand and subtotal of your report will be doubled

     

  • Sameh Soliman

    Thanks Prasanna

     

    Transaction number in project is not the same as invoice number in AP

    could you please share screen shot of your sample data?

    in addition to that . do you know how to get the PO line desc for receipts coming from receipt costing?

  • Sameh Soliman

    thanks a lot Prasanna Reka

     

    did your query work with you? it did not give me any data. i think you are trying to join expenditure item number with invoice number that is why no data.

     

    I have done something similar but my challenge now is that i have few records showing as blank when the source is receipt.

    i noticed that the project actual cost subject area has more data than receipt accounting subject area when i filter both by project.

     

     

    <saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlVersion="201201160" xmlns:sawx="com.siebel.analytics.web/expression/v1.1">
       <saw:criteria xsi:type="saw:derivedCriteria">
          <saw:columns>
             <saw:column xsi:type="saw:derivedColumn" columnID="c11cd2ccb8cb4cd80">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Original Source References</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Transaction Source</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="c4aed226651a09d3a">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Original Source References</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Document</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="cc942b16f415367a3">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Project</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Project Number</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="c02553aa50468075f">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Project</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Project Manager</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="cb205d54a33178fef">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Project Type Attributes</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Project Type</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="c868a4974542667c0">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Project Classification</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Class Category Description</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="c44a91afb39e984c9">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Project Classification</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Class Code Description</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="cdf8b99018ea233c5">
                <saw:displayFormat>
                   <saw:formatSpec suppress="suppress" wrapText="true"/></saw:displayFormat>
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:displayFormat>
                      <saw:formatSpec/></saw:displayFormat>
                   <saw:caption fmt="text">
                      <saw:text>Invoice Number</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="c78f0eb401b910d9c">
                <saw:displayFormat>
                   <saw:formatSpec suppress="suppress" wrapText="true"/></saw:displayFormat>
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:displayFormat>
                      <saw:formatSpec/></saw:displayFormat>
                   <saw:caption fmt="text">
                      <saw:text>Invoice Line</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="cad4dfa56ad170110">
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption fmt="text">
                      <saw:text>Invoice Line Desc</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="cc32503c64b72a3cf">
                <saw:displayFormat>
                   <saw:formatSpec suppress="repeat" wrapText="true"/></saw:displayFormat>
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:displayFormat>
                      <saw:formatSpec/></saw:displayFormat>
                   <saw:caption fmt="text">
                      <saw:text>Line Amount</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="c0a7d87f5d337f0c3">
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption fmt="text">
                      <saw:text>Total Tax</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column xsi:type="saw:derivedColumn" columnID="ce54385f4b0f79c68">
                <saw:tableHeading>
                   <saw:caption>
                      <saw:text>Supplier</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption>
                      <saw:text>Supplier</saw:text></saw:caption></saw:columnHeading></saw:column>
             <saw:column columnID="cc37df6c61ff65da9" xsi:type="saw:derivedColumn">
                <saw:displayFormat>
                   <saw:formatSpec suppress="suppress" wrapText="true"/></saw:displayFormat>
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>Receipt</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption fmt="text">
                      <saw:text>Receipt</saw:text></saw:caption>
                   <saw:displayFormat>
                      <saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>
             <saw:column columnID="cf304ae09f7ad134f" xsi:type="saw:derivedColumn">
                <saw:displayFormat>
                   <saw:formatSpec suppress="suppress" wrapText="true"/></saw:displayFormat>
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>PO</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption fmt="text">
                      <saw:text>PO Number</saw:text></saw:caption>
                   <saw:displayFormat>
                      <saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>
             <saw:column columnID="c57c027f2972e0124" xsi:type="saw:derivedColumn">
                <saw:displayFormat>
                   <saw:formatSpec suppress="suppress" wrapText="true"/></saw:displayFormat>
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>PO</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption fmt="text">
                      <saw:text>PO Line Number</saw:text></saw:caption>
                   <saw:displayFormat>
                      <saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>
             <saw:column columnID="c0af18b2d2cd5f797" xsi:type="saw:derivedColumn">
                <saw:displayFormat>
                   <saw:formatSpec suppress="suppress" wrapText="true"/></saw:displayFormat>
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>PO</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption fmt="text">
                      <saw:text>PO Line</saw:text></saw:caption>
                   <saw:displayFormat>
                      <saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>
             <saw:column columnID="c34246e18b595fdef" xsi:type="saw:derivedColumn">
                <saw:displayFormat>
                   <saw:formatSpec suppress="suppress" wrapText="true"/></saw:displayFormat>
                <saw:tableHeading>
                   <saw:caption fmt="text">
                      <saw:text>PO</saw:text></saw:caption></saw:tableHeading>
                <saw:columnHeading>
                   <saw:caption fmt="text">
                      <saw:text>PO Line Amount</saw:text></saw:caption>
                   <saw:displayFormat>
                      <saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column></saw:columns>
          <saw:from>
             <saw:criteria xsi:type="saw:setCriteria" op="union">
                <saw:criteria xsi:type="saw:simpleCriteria" subjectArea="&quot;Project Costing - Actual Costs Real Time&quot;">
                   <saw:columns>
                      <saw:column xsi:type="saw:regularColumn" columnID="c6267de0d515e6fc2">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"Original Source References"."Transaction Source Name"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="cb3acc1cb067e49bd">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"Original Source References"."Document"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c3999388fe6971d24">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"Project"."Project Number"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c8a6c558392255d3a">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"Project"."Current Project Manager"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c257d5fb0bdd703c4">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"- Project Type Attributes"."Project Type Name"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c836c6939064630fa">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"- Project Classification"."Project Classification Category Description"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="cf6030de645b93760">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"- Project Classification"."Project Classification Description"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="ce9c350402aed8e51">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast ( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Invoice Number</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c6fe7837671721c75">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast ( null as int)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Invoice Line</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c355763fa35d00b5a">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast ( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Line Desc</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c6ec4e21c04870e23" aggRule="sum">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast ( null as INT)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Line Amount</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c0f61b4c237f7fa8b" aggRule="sum">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">Cast ( null as INT)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Line Tax</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c719b60c04c68b47f">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast(null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Invoice</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Supplier</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="ceb1f856e8b1fffde">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast ( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Receipt</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Receipt Number</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="cfb7f2d5e6627fcd2">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">Cast (null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>PO</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>PO Number</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="caeeeb35d8e5e5464">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast ( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>PO</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>PO Line Number</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c1f59b9612548851f">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast ( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>PO</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>PO Description</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c47fd9ef51dd75500">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">Cast ( null as int)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>PO</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Line Amount</saw:text></saw:caption></saw:columnHeading></saw:column></saw:columns>
                   <saw:filter>
                      <sawx:expr xsi:type="sawx:logical" op="and">
                         <sawx:expr xsi:type="sawx:list" op="in">
                            <sawx:expr xsi:type="sawx:sqlExpression">"Original Source References"."Transaction Source Name"</sawx:expr>
                            <sawx:expr xsi:type="xsd:string">Oracle Fusion Cost Management</sawx:expr>
                            <sawx:expr xsi:type="xsd:string">Oracle Fusion Payables</sawx:expr></sawx:expr>
                         <sawx:expr xsi:type="sawx:comparison" op="notEqual">
                            <sawx:expr xsi:type="sawx:sqlExpression">"Original Source References"."Document"</sawx:expr>
                            <sawx:expr xsi:type="xsd:string">Expense Report</sawx:expr></sawx:expr></sawx:expr></saw:filter></saw:criteria>
                <saw:criteria xsi:type="saw:simpleCriteria" subjectArea="&quot;Payables Invoices - Transactions Real Time&quot;">
                   <saw:columns>
                      <saw:column xsi:type="saw:regularColumn" columnID="ca01bd5f134ecbd27">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">'Oracle Fusion Payables'</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c00fd4a87bd120317">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">'Supplier Invoice'</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c092629e0453d684e">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"- Invoice Line Details - Project Information"."Project Number"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="ce4772a2397557b46">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Project</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Project Type</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="cbce48a040b7c05ba">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Project</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Project Category</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="cbc6f585a1eb6bcad">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Project</saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Project Class</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="cc8a0b47688ce4acf">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">cast( null as char)</sawx:expr></saw:columnFormula>
                         <saw:tableHeading>
                            <saw:caption fmt="text">
                               <saw:text>Project </saw:text></saw:caption></saw:tableHeading>
                         <saw:columnHeading>
                            <saw:caption fmt="text">
                               <saw:text>Project Manager</saw:text></saw:caption></saw:columnHeading></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="cbf08fd229256908e">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"- General Information"."Invoice Number"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c2be70a8f9e8c7d0c">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"- Invoice Line Details - General Information"."Line Number"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c704c7a0502976539">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"- Invoice Line Details - General Information"."Description"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="cbdbfc0b3d35e0d50">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"- Invoice Line Amounts"."Line Amount"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c23cf591f0890ff0e">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"- Invoice Amounts"."Total Tax Amount"</sawx:expr></saw:columnFormula></saw:column>
                      <saw:column xsi:type="saw:regularColumn" columnID="c6f2003c586093f6a">
                         <saw:columnFormula>
                            <sawx:expr xsi:type="sawx:sqlExpression">"Supplier"."Supplier Name"</sawx:expr></saw:columnFormula></saw:column>