Get (and Set) Billing and Payment info via Graph API

[luckman212]

related feedback (please vote!): https://feedbackportal.microsoft.com/feedback/idea/191d14b1-cd5b-ef11-a4e7-6045bdb238dc

I co-manage a handful of M365 tenants, and one thing that comes up fairly often is an expired credit card. I get an email as an admin that "Your credit card was declined" etc. But I always have to log in and wade through a long list of products to figure out which ones have the old/expired card and update them. It's very tedious and time consuming because you can't even see this status on the list view, you have to click each SKU, wait for the page to load to check which card is linked. Overall, to check and update a typical tenant with ~20 SKUs takes close to 30 minutes.

Being able to quickly connect to Graph API and use PowerShell to retreive for example, all active product SKUs that are linked to a certain card # would be amazingly helpful.

I imagine this could be added as an optional switch to the existing Get-MgSubscribedSku cmdlet, something like this:

PS> Get-MgSubscribedSku -IncludeBillingDetails:$true

Which could return additional properties such as Last4 of the card linked to that SKU, and whether the payment was successful or not (see last 3 fields below, which are hypothetical):

AccountId            : 3b54f482-84c2-4795-ab77-d407e49b5d99
AccountName          : reseller-account
AppliesTo            : User
CapabilityStatus     : Enabled
ConsumedUnits        : 75
Id                   : 3b54f482-84c2-4795-ab77-d407e49b5d99_475d2d3b-eaa9-442c-93ee-9e53caac9507
PrepaidUnits         : Microsoft.Graph.PowerShell.Models.MicrosoftGraphLicenseUnitsDetail
ServicePlans         : {M365_LIGHTHOUSE_CUSTOMER_PLAN1, BPOS_S_TODO_1, INTUNE_O365, EXCHANGE_S_ENTERPRISE}
SkuId                : 19ec0d23-8335-4cbd-94ac-6050e30712fa
SkuPartNumber        : EXCHANGEENTERPRISE
SubscriptionIds      : {7a07a31f-9fd9-48cc-9571-fa0ab395efcd}
AdditionalProperties : {}
BillingCardLast4     : 5505
BillingStatus        : Declined
BillingAccountId     : d3b04010-e6ee-4983-8153-57cb60e975cb

And then some additional tooling to also UPDATE the SKUs to use an already-stored billing profile, by referencing the Billing Account Guid or Last4 of the card, e.g.

PS> Get-MgBillingAccounts
 
Status:           Active
BillingCardLast4: 5505
BillingAccountId: d3b04010-e6ee-4983-8153-57cb60e975cb
 
Status:           Active
BillingCardLast4: 9876
BillingAccountId: 129ea005-7e9d-48d6-91d3-a298c65f4df9

PS> Get-MgSubscribedSku -IncludeBillingDetails:$true | Where-Object { $_.BillingCardLast4 -eq '5505' } |
Set-MgSubscribedSku -BillingAccountId '129ea005-7e9d-48d6-91d3-a298c65f4df9'

This would be very helpful !