[External][Cost Management] ListCost missing in Cost Management exports

🐛 Problem

Microsoft Cost Management does not include ListCost and ListUnitPrice in all exported cost data. There are 2 bugs with this:

1. ListCost and ListUnitPrice should always be specified.
2. If not available, ListCost and ListUnitPrice should be null and not 0.

This is documented in Ingest cost details data as a limitations for PayGPrice column in actual/amortized cost data. This limitation also applies to the ListCost and ListUnitPrice columns in FOCUS data.

👣 Repro steps

1. Export FOCUS cost data.
2. Filter rows where ListCost == 0 and ContractedCost > 0.

🤔 Expected

• All rows should have an accurate ListCost and ListUnitPrice values.
• The only records with a ListCost or ListUnitPrice of 0 should be free.
• If a value is not available, they should be null. (However, ListCost and ListUnitPrice should always be available.)

ℹ️ Additional context

This is a tracking bug only. The FinOps toolkit community is not responsible for this and cannot resolve the issue. Subscribe to this issue to be notified when the issue has been resolved.

We are tracking the following workarounds until this issue is resolved:

• #835
• #615

Related issues:

• #834
• #727

[!NOTE]
If you are facing this issue, you can file a support request with the Cost Management team to convey the importance of these columns for your needs; however, as a known issue, the support request will likely be closed. The intent of creating a support request is to raise awareness of your needs and increase the priority of the fix.

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Let us know if you see an opportunity to improve the experience from the toolkit.

Start by reviewing the Microsoft Cost Management export behavior described in the issue and reproduce the FOCUS-data filter where ListCost is 0 while ContractedCost is greater than 0. Compare the expected null and accurate-value behavior with the linked workarounds (#835 and #615); completion depends on a fix from the Cost Management team, not a toolkit change.