In the Reports / Reseller Report part create a new report called Azure billing report.

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.