Statistical Value in MEIS for INTRASTAT reporting

10-11  Source: Network gathering  Views:6 

Advertisement
Hello,
From reveiwing related posts I understand that the statistical value on the INTRASTAT report comes from a system default exchange rate that uses the average exchange rate from the border crossing rate (GRWR condition on the PO) and the exchange rate on the invoice.
What is the exact calculation that is being used to determine the statistical value on the MEIS report?
Thanks,
Thanks very much for the link.
We do have the GRWR conditions set up, and the statistical value is populating correctly on the PO. 
The issue I'm having is that I can't properly explain how the reported statistical value (VEIAV- GRENZEWEAK) is calculated.
For example:
VEIAV - GRENZWEAK is 5,405.86 SEK
GRWR on PO   572.03 EUR   5,299.22 SEK    (Ex rate: 9.26389)Goods Receipt  504.79 EUR   4,681.78 SEK    (Ex rate: 9.27470)
Freight               40.00 EUR       370.99 SEK   (Ex rate: 9.27470)Invoice              503.00 EUR   4,770.43 SEK    (Ex rate: 9.48395)
Do you know how SAP arrives at 5,405.86 SEK with these inputs?
Thanks,
Related articles
  • Statistical Value in MEIS for INTRASTAT reporting 10-11

    Hello, From reveiwing related posts I understand that the statistical value on the INTRASTAT report comes from a system default exchange rate that uses the average exchange rate from the border crossing rate (GRWR condition on the PO) and the exchang

  • PO Creation of free goods for intrastat reporting 10-11

    All, Due to intrastat reporting restrictions, when we are creating a PO with a free good we need to mark the item as "Free Good" on the item overview, and set the "Business Transaction type" to 41 on the "Origin / Destination / Bu

  • Import Data in Purchase Order for Intrastat Reporting 10-11

    Dear Gurus, Technical Scenario: Extended Classic SRM Server: 5.5 Backend:R/3:  4.6C For PO created for cross border purchasing, ( vendor country different from receiving plant country ) the PO when replicated to backend system, DOES NOT HAVE IMPORT T

  • TDS Amount on Vendor Advance Shows positive value in *QUERY* for TDS Report 10-11

    Hi Everybody, I have made a query for List of TDS Report with Vendor informations as required by my client. In which the value of TDS on Vendor Advance Payment appears as positive value instaead of negative value. Please suggest how to rectify. Thank

  • About passing multiple values in parameter for oracle report 11-30

    https://docs.google.com/file/d/0B0dx7wf68mD0QzdpbWU4UGNURTQ/edit Hi all, i want to pass multiple value using , to separate them 1,2,3.... here is my query SELECT DISTINCT oh.header_id ,oh.org_id ,to_char(oh.ordered_date,'DD-MON-YYYY') d_date ,to_char

  • Intrastat Report for Switzerland 11-30

    Hi My Client has asked for Intrastat report for Switzerland I am trying to configure Intrastat report for Switzerland But the system is not allowing me to do so Let me know why this is so As well if anyone have done this before send me the documents

  • Intrastat reporting- Incorrect PO picked 10-11

    Hi Gurus, I need to find out why and how a particular PO is being picked by the MEIS report? I was always in the belief that once the import procedure is maintained at the PO item level, if any GR/ IR takes place, then these would be reported. But I

  • How to hide dynamic parameters values in the URL with Reports 6i 10-11

    Hi, I want to know a way of hiding the parameters values when asking for a report through the web. Now I'm using the Reports 3.0.5.8 with a Cartridge defined in the Oracle Web Application Server 3.0.1.0.1. When you ask for a report with the parameter

  • How to add statiscal value in intrastat report for free of charge Pur Order 10-11

    Hi Experts, In Purchase Order if 'free of charge' check box is ticked then it wont allow us to have condition tab ( as there should not be any pricing for FOC) - SAP Standard functionality. But since I want to report this purchase order in Intrastat

  • Intrastat reporting for STO 10-11

    Hi All, We have a plant abroad located in Hungary to which we despatch goods through STO from UK. Please let me know if we are supposed to report this transaction in the intrastat arrival for Hungary and despatch for UK. If yes, please let me know ex

  • Intrastat - The statistical value of the document is zero - how to update? 10-11

    Dear gurus, I have a problem in Intrastat and maybe you can help me. When running VE01, I have incomplete billing documents with the message EIP020 'The statistical value of the document item is zero'. How can I update these billing documents? How ca

  • Intrastat report duplicating receipts for corrections 11-30

    Hi,  The situation is that,GR (movt.type-101)was done and then a reversal (movt type-102)was done and again GR was done.Now in Intrastat report only GR is getting displayed but not the Reversal.I mean to say that there are two entries for GR but ther

  • Stock report with value and qauntity for given date not month wise 10-11

    Hi gems, can any body give me the standard report for Stock value and qauntity for given date not month wise at storage location levelHi check the report S_P00_07000139 with the option inventory and raw material report- detail and selection date (fro

  • Not able to change exportfolders value in MBeans for FRConfig.cmd for Hyperion Financial reporting 11.1.2 version. 10-11

    I am not able to change exportfolders value in MBeans for FRConfig.cmd for Hyperion 11.1.2 Financial reporting . When I enter the value , it just vanishes. Am I missing something here.? I need to set export path for PDF generation in Hyperion financi

  • Error 7 occurred at Get LV Class Default Value.vi only in my executable for Print Report - LV 2010 SP1 10-11

    I have a program written which uses the print report function. Everything works fine in the uncompiled code, my report prints just fine. I can compile my project all the way to a full installer. When I run the executable I get the error: Error 7 occu

  • San Marino to be included for Italy Intrastat reporting 10-11

    Hello All, We have to include San Marino in EU Country Members for Italy Intrastat Reporting. San Marino should be visible in folder "INtrastat" under folder "EU Countries" after executiing transaction "ENGR". TX "ENGR&q

  • INTRASTAT reporting rules for France french (receipt) 10-11

    Hello experts, I would like to know the rules for selection and inclusion of the data for the INTRASTAT report for import. My country is FRANCE. I know that the logic depends on the country. I've not found a thread explaining France. My SAP is 4.7. T

  • Values are not matching for inventory report 10-11

    Hi all, we are running the report stock over view, in that there is a key figure total stock which is having the non cumulative option inflow and outflow data has been loaded correctly but when we are executing the report it is giving the values cumu

  • Intrastat Report in ECC 6 for Inter Company Billing 10-11

    Hi Experts, Need your input. In business case, Company code A raise intercompany invoice on Company B for Goods deliverd by Co A directly to End customer of Co B. Since there is no actual Physical goods receipt by Company B, the intrastat report is n

  • Defining default value for financial reports display in the workspace (9.3) 10-11

    Hi I need to change the default value for financial reports workspace preview mode, for every workspace user. It is actually set on html, and I would like to have pdf instead. This option can be changed when logged on the workspace, in file->preferen