Why Data is missing in Starting and Endingunits field in ZOQL export of RatePlanChargeTier object?
In ZOQL export on RatePlanChargeTier Object there is no starting and Units populated.
If you are using Overage charge model in your subscription then there will not be any starting and Ending Units.
There will not be any Starting and Ending units while we create the Product Rate plan for Overage charge model.If you have used any of the below charge models then there will be startng unit and Ending unit.
Volume, Tiered, Tiered with Overage.
Workaround: Use IncludedUnits as Ending Unit and Starting unit as 0 to achieve the desired result.
Eg ZOQL query:
select Id, StartingUnit,IncludedUnits as EndingUnit from RatePlanChargeTier where RatePlanCharge.ChargeModel='Overage Pricing' and Subscription.Status='Active' and IncludedUnits is not null
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √