How Subscription custom field can be auto filled with dynamic value?
Our business uses subscription management to fulfil Supply Chain services for its customers.Only Usage based charge pricing is used. The usage quantity and invoice ref doc value is fetched in the subscription on weekly basis from Mainframe systems via EAI (using web services)There’s a custom field defined at Subscription>product bill line level: ‘Invoice Ref Doc’- this contains the value in text format. This value is passed to the actual AR invoice as business requires it for their internal purpose. Also, the AR grouping rule is based on this value.
Our Business has few services that has fixed charge and now they want to use ‘Recurring Sale Price’ to fulfil fixed charge services in the subscription. With this, they want the ‘Invoice Ref Doc’ value for ‘Recurring Sale Price’ services should be auto-populated. And this value should be dynamic, i.e. for customer OSR #123, service SKU #987, billing period 04/01/24 to 04/30/24, the Invoice Ref Doc value should be 123987040124. For next period say 05/01/24 to 05/31/24- the Invoice Ref Doc value should be 123987050124. Similarly for other customer say OSR # 456, same service SKU #987, billing period 04/01/24