In the Reports / Reseller Report part create a new report called Azure billing report.
In the Reports / Reseller Report part create a new report called Azure billing report.In the file attached we indicate the information we need (the light blue columns are the columns that you have already sent us and the light green columns are the columns that we need you to add).
Released new columns in Azure usage report - Product ID, Sku ID, Sku Name + columns to do with price configuration. They are given in Billing Currency and they can be calculated to Pricing Currency using the Pricing to Billing Exchange Rate.
These unit price columns can be enabled by checking the box under Pricing Info.
About Price Adjustment - this info is not added, because the way you would like it to have is not possible within this report, as Microsoft does not give this info for daily usage.
Yes, we would like to have a report containing the monthly exchange rate applied by Microsoft on Azure resources, and regarding MSPRICE ADJUSTMENT we would like to have a column with the type of discount Microsoft applies to Azure resources, like PEC and others. See attached image.
Hi, Could you please clarify regarding mentioned above 2 columns:
2)Confirm you want to include Exchange rate from Microsoft billing files (taking into account that it's not always the case that Microsoft shows the same exchange rate in the unbilled azure usage data as in the billed invoice lines. they should)?
3)MSPrice Adjustment - in essence it is under PEC - 15% or 0%. Is this sufficient? Or you want it to have by day, tags, etc., it might not be possible to get it due to in the daily usage that we use for the report it is not given the same way as in the billed invoice lines, which I think is their source. Please confirm what if the first option is fine? Or how you want to proceed with the MS Price Adjustments column?
Hi, could you please comment on points 2) and 3) what would be preferable from your side on the 2 columns? So that a timeline can be established for adding additional columns to the Azure usage report.
1) Can be included as information is available in the platform
2)ok - as long as Microsoft shows the same exchange rate in the unbilled azure usage data as in the billed invoice lines. they should, but it's not always the case
3)Microsoft is a bit bad about this one. In the daily usage that we use for the report it is not given the same way as in the billed invoice lines, which I think is their source. Basically - if we want to have usage by day, tags, etc., then we might not be able to have this.
3)MSPriceAdjustment - in essence it is under PEC - 15% or 0%. Is this sufficient? Or please provide an example what you would want to see in this report?
Released new columns in Azure usage report - Product ID, Sku ID, Sku Name + columns to do with price configuration. They are given in Billing Currency and they can be calculated to Pricing Currency using the Pricing to Billing Exchange Rate.
These unit price columns can be enabled by checking the box under Pricing Info.
About Price Adjustment - this info is not added, because the way you would like it to have is not possible within this report, as Microsoft does not give this info for daily usage.
Hi Arta,
Yes, we would like to have a report containing the monthly exchange rate applied by Microsoft on Azure resources, and regarding MSPRICE ADJUSTMENT we would like to have a column with the type of discount Microsoft applies to Azure resources, like PEC and others. See attached image.
Hi, Could you please clarify regarding mentioned above 2 columns:
2)Confirm you want to include Exchange rate from Microsoft billing files (taking into account that it's not always the case that Microsoft shows the same exchange rate in the unbilled azure usage data as in the billed invoice lines. they should)?
3)MSPrice Adjustment - in essence it is under PEC - 15% or 0%. Is this sufficient? Or you want it to have by day, tags, etc., it might not be possible to get it due to in the daily usage that we use for the report it is not given the same way as in the billed invoice lines, which I think is their source. Please confirm what if the first option is fine? Or how you want to proceed with the MS Price Adjustments column?
Hi, could you please comment on points 2) and 3) what would be preferable from your side on the 2 columns? So that a timeline can be established for adding additional columns to the Azure usage report.
Hi,
1) Can be included as information is available in the platform
2)ok - as long as Microsoft shows the same exchange rate in the unbilled azure usage data as in the billed invoice lines. they should, but it's not always the case
3)Microsoft is a bit bad about this one. In the daily usage that we use for the report it is not given the same way as in the billed invoice lines, which I think is their source. Basically - if we want to have usage by day, tags, etc., then we might not be able to have this.
Hi, i answer your questions
1) SAP ID it is informed in the basic details information of the customer. The field is called ERPID
2 & 3) Exchange Rate and MSPrice Adjustment are in the billing files from Microsoft
Hi, could you please clarify some questions
1) Where do you store SAP ID?
2)ExchangeRate = billing/pricing currency exchange rate?
3)MSPriceAdjustment - in essence it is under PEC - 15% or 0%. Is this sufficient? Or please provide an example what you would want to see in this report?
Other green columns seem fine.