Salesforce Trailhead - Billing Specialist - Momma Bear

Finally meeting the Momma Bear - Challenge # 15 - It has been known to hold trailblazers in a bear hug for months on end, breaking bones and crushing spirits.

If you get stuck, you will likely have to delete your orders. This will take some doing. Disable triggers in the managed package. Deactivate your process created in earlier steps. Take the quote back to Draft, remove Ordered, Contracted tick on the respective checkboxes. Remove the quote number from the order. Delete Quote Lines from the quote and you should have a virgin Q-00015 available.

To avoid getting into this bear trap, examine your order very carefully before activating it. Make sure the error in the Tax Calculation is addressed. Legal Entity has to be added manually so as to get rid of the error in tax.

I am sure you would need to delete the order and quote lines multiple times. To delete the order, remove the Quote reference in the order, remove provisioning date, contracted checkbox to be unchecked and any contract to be deleted. Then you can delete the order. Next, delete the Quote Lines and approve the quote.

I will just be repeating a lot of what is in this post on Answers. As that post has grown too lengthy, I am pasting here the key posts which will help navigate the challenges.

Wish you all the best and if you have any questions which are still not answered on the forum, just post where you are stuck at.


Found my issue: Product record for Major Solar Panels need to be populated with Subscription fields. very strange for this BUY product. Subscription Pricing = Fixed Price, Subscription Term = 1, Percent of total Base = Regular and Subscription Type = Renewable.
Still not passed the challenge. I am stuck in Total Amount, since there was a different NET UNIT PRICE on this opportunity, so it doesn't take the list prices...

How do I delete the Invoices, Orders, etc, without breaking the logic ?!?

From <https://success.salesforce.com/answers?id=9063A000000plDwQAI>



@Dennis -
So I recommend making the following updates to the product:
Subscription Pricing should be blank
Subscription Term should be blank
The other two Subscription fields are irrelevant if Subscrpition Pricing is blank

Then make sure that under the Pricing section, Pricing Method is set to "List" (this may be set, but the section is collapsed in your screenshot)

Try those updates and regenerate your quote line item (should only need to redo the Major Solar Panel).  Then update the Quote back to an open status, and re-close it to regenerate the orders, and so on.

From <https://success.salesforce.com/answers?id=9063A000000plDwQAI>



Ok, getting closer! Took your advice and cleared out the Quote Lines and added them, that worked, now the Order Product Consumption Schedules and Usage Summaries are auto-created! Here's the steps I'm following each time: 

1. Delete Orders, Make sure quote lines are removed from Q15, re-add QL’s then Approve Quote
2. Verify 2 Orders are created
3. Add Order Product Legal Entities to 4 Order Products. All 4 Order Products look good, Tax Calculation Status = 4. Completed, no Tax Error Message
4. Verify 2 Order Product Consumption Schedules and 2 Usage Summaries are created on the Solarbot Order Product
5. Add 2 Usage records on the Solarbot Order Product 1 for Micron and 1 for Request (with Matching ID’s). Both Usage records look good, status = Processed
6. Add Provision date to orders / activate them

From <https://success.salesforce.com/answers?id=9063A000000plDwQAI>



Working through the last challenge - I just wanted to outline the steps as I interpret them from requirements:
 On existing quote, edit lines and add all 4 products, with the panel-buy and panel-rent quantities set to 10
(Question - should the discount for the panel-rent be added here, or somehow applied at the invoice? - thoughts?)
 Approve the quote to generate the two orders
 Adjust the order product legal entities to applie CA tax.  NOTE that this took me several tries to get the taxes to calculate, for some reason.  Basically had to keep removing and adding the legal entity, and then once it calculated correctly for one product it seemed to work OK for the rest - not sure if anyone else has this experience.
 And this is where I have stopped.  My only question before I move on to invoice/contract is where to add the discount. 
 Let me know if anyone else is at this step yet, or if you need help getting here.

From <https://success.salesforce.com/answers?id=9063A000000plDwQAI>




Last challenge continued:
 Once I created the orders, I updated the products with the legal entity to calculate tax.
Then on the SolarBots, I had to go in and add usage records, and tie those to the usage summary records.
 Then I activated the orders.  For the SolarBots order, no contract is getting created - tells me I can't have a negative term.  I tried setting the end date out 12 months but it didn't help.  Default term on the product is 1.
 Also, the SolarBots order and order product don't update with the priceses from the usage/usage summaries, so I am not sure what is going on there.
 Lastly, no Invoices are getting created (my current "Check" error is looking for Invoice Lines)
 Looking for any hints/clues as to what to check!  Thanks

From <https://success.salesforce.com/answers?id=9063A000000plDwQAI>


For the quotes, make sure that all of your products are marked with the Provisioning Method, and that your Process Builder is updating Provisioning Method in Order By on create.  Not sure what else could cause it not to create both (question - are all the products there on the single order?)

For the credit, you add that once you create the invoice, by adding a Credit Note to the Account, and then a Credit Line to the Credit Note - Then you allocate it to the invoice (before it is paid).

For tax, you have to set up a legal entity (just name it something like "CA"), and set up the rate, tax rule, and tax treatment.  Then once you create your order and order lines, you have to go in to each Order Line and add the legal entity, at which point the taxes should calculate.

The error message is what you will get basically until you get both orders created, I believe.


From <https://success.salesforce.com/answers?id=9063A000000plDwQAI>

If I recall correctly, you don't need to set the Tax Treatment, or anything except the Legal Entity.  When I did it, I added Legal Entity and saved, and it auto-populated the rest (the Rule came from the Product, so that was there, but the other fields were not updated by me).  Also, I didn't create a specific Tax Rule for CA, just used the normal Tax Rule that already existed.  The Tax Treatment was added to that.  Not sure if Salesforce will be picky about that (it should work with another rule though, as I understand it, as long as it says Taxable = Yes)
The Tax Treatment uses the Tax Rate that corresponds to the Tax Code field, so only those two things need the Tax Code.
Provisioning Complete date being populated is what triggers the Order to be Activated, so it is how you "complete" the order.  Once the order is Activated, it activates the Order Products, and then you can create an Invoice (using the Invoice Schedule, go in and set the date and time it runs, then save, and it automatically runs and creates invoices based on Order Products meeting the criteria - I recommend checking out the section for creating invoices in the help file for this, there are lots of tiny details about what dates have to be set before the Invoice Schedule run date, and other criteria that have to be met on each of the products - they SHOULD meet the criteria, but you may want to double-check before running the schedule)


From <https://success.salesforce.com/answers?id=9063A000000plDwQAI>



@Mitesh -
I would focus on the non-SolarBots Order and Invoice.  The SolarBots Order does not have to be paid as per the requirments, and once you have the Usage and Usage Summaries set up on that Order Product, you don't have to mess with it any more for the badge.  It never updated with an amount or tax for me.
Based on your error I would focus on making sure the other three products have taxes calculated properly.  Then make sure the order has Invoice Batch = White Glove Batch.  If that checks out, and you have activated the order, you need to schedule an Invoice, or you can update the order with "Bill Now" to generate it.  Once the Invoice is generated, you will want to pay it off (add cash Payment via the related list on the invoice), and add the Credit Note and Credit Line to the Account, and allocate that Credit Line to the Invoice Line for the panel rental.
Those are the main things I think - at this point just need to try things out and re-check.  Sounds like you are close!


 Mitesh Sharma
Problem is that in the credit Note I am not able to see the Invoice Line for product Panel Rental.

The Invoice has to be in Posted status, maybe?


 Dennis Keizer
Got it! Had to create 3 Payment Allocation (Invoice Lines) on the invoice line items. Was not in the requirements though. After this, success celebrations. Woohoo!



Comments

  1. Thank you for putting this together. This was a great summary of the BULK of the questions. I had my own list as well but bouncing off of yours helped me knock this out. Cheers!

    ReplyDelete
    Replies
    1. Hi can you indicate a complete step on how you finished step 15 :'( im stuck for a few weeks now :'(

      Delete
  2. Hi Team,
    After activating Order, I am unbale to see the Usage Summary Records for Solar Bolt.

    ReplyDelete
  3. Hi, thank you for the wonderful blog. can you pls indicate the complete steps for challenge 15. :'( Im not quite familiar on the process. Thank you so much

    ReplyDelete
  4. Hi, First of All.. Thank you for such helpful Blog..

    But I am Still stuck on Challenge 15..
    "
    "We couldn't find the Order linked to the Quote named 'Q-00015', with the correct address, Invoice Batch, zeroed Total Amount, and Tax Amount. Please make sure the record exists, it contains the correct values according to the requirements, and please try again."

    My Orders Generates,
    1 BOTSolarBots 1.00 $0.00 $0.00 $0.00

    2 PANEL-BUYMajor Solar Panel 10.00 $5,000.00 $5,000.00 $50,000.00

    3 WARRANTY-MAINT Plan 1.00 $2,000.00 $2,000.00 $2,000.00

    4 PANEL-RENT 10.00 $200.00 $2,400.00 $24,000.00

    SUBTOTAL: $76,000.00

    Calculates Tax or Order $7600

    When Activating Order its asks for Default Subscription Term for PANELS-BUY

    And when I Generate Invoice, after activation..
    Invoice comes to $52,700
    Invoice Lines:
    Panel-Rent : $2200 (Adds Tax $200)
    Warranty : $500 (Does not add Tax)
    Panel-Rent: $50000 (Does not Add Tax)
    Is it coming down Correct.. Or where am I getting things Incorrect.. Kindly Help..

    ReplyDelete
    Replies
    1. I am to find the Reason..

      Now Invoice.. All adds up to $57750..
      Added Credit Note.. Added $1000 Credit Line.. Posted Credit Note. Allocated it to Solar Panel Rental Invoice Line.
      Added Cash Payment.. $56750.
      Allocated Payment to Remaining Invoice Lines..
      Invoice showing as PAID..

      but still the SAME ERROR:
      "We couldn't find the Order linked to the Quote named 'Q-00015', with the correct address, Invoice Batch, zeroed Total Amount, and Tax Amount. Please make sure the record exists, it contains the correct values according to the requirements, and please try again."

      Please help.. :(

      Delete
    2. I'm having same issue as you above - ('unknown") - i have exactly what you outlined above and still getting that message. Did you ever figure this out. I have tried two now in two different orgs witth same results. any any...bueller.

      Delete
  5. Here are all the steps summarised. May help to clear the challenge.

    1. Make sure Quote Line are added as per requirement and make Quote Approved.
    2. Verify 2 Orders are created. Making Quote Status Approved will check the Ordered checkbox and fill the Order By to generate order.
    3. Add Order Product Legal Entities to 4 Order Products. All 4 Order Products look good, Tax Calculation Status =Completed, no Tax Error Message.
    4. Verify 2 Order Product Consumption Schedules and 2 Usage Summaries are created on the Solarbot Order Product.
    5. Add 2 Usage records on the Solarbot Order Product 1 for Micron and 1 for Request (with Matching ID’s). Both Usage records look good, status = Processed. Here make sure that Matching ID of Usage Summary and Usage is same. Also, create usage via related list of First 2 Usage Summary generated in Orders related list.
    6. Add Provision date to orders / activate them
    7. Check contracted checkbox on Order
    8. Check Bill Now on Order to generate Invoice
    9. Once the Invoice is generated, you will want to pay it off. Add cash Payment via the related list on the invoice and add the Credit Note and Credit Line to the Account.
    10.Create 3 Payment Allocation (Invoice Lines) on the invoice line items.
    11.Change status of Invoice to posted so that invoice line status gets posted.
    12.Now go to Credit Note, and Allocate the $1000 amount to Major Solar Panel Rental.
    13.Now go to Payment and allocate Payment.

    ReplyDelete
    Replies
    1. Hi Anuj, I am getting issue in the Usage , it is not getting status = Processed. I tried everything and didn't found any issue.
      Can you help ?

      Delete
  6. I am getting an error when I try to change the quote status from "Draft" to "Approved". Can anyone suggest how to fix this?

    Error element myRule_1_A1 (FlowRecordUpdate).
    The flow tried to update these records: null. This error occurred: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY: SBQQ.QuoteAfter: execution of AfterUpdate caused by: SBQQ.OrderService.OrderServiceException: Attempt to de-reference a null object Class.SBQQ.OrderGenerator: line 109, column 1 Class.SBQQ.OrderService: line 23, column 1 Class.SBQQ.QuoteService.QuoteChangeBuilder.build: line 2841, column 1 Class.SBQQ.QuoteService: line 1212, column 1 Trigger.SBQQ.QuoteAfter: line 15, column 1. You can look up ExceptionCode values in the SOAP API Developer Guide.
    ________________________________________
    Flow Details
    Flow API Name: Create_Order_Once_Quote_is_Approved
    Type: Record Change Process
    Version: 2
    Status: Active
    Org: Apps Associates (00D4R000001VapA)
    Flow Interview Details
    Interview Label: Create_Order_Once_Quote_is_Approved-2_InterviewLabel
    Current User: James Van Steenburgh (0054R00000APfj5)
    Start time: 4/14/2020, 9:33 AM
    Duration: 0 seconds
    How the Interview Started
    James Van Steenburgh (0054R00000APfj5) started the flow interview.
    Some of this flow's variables were set when the interview started.
    myVariable_old = SBQQ__Quote__c (a0u4R00003cHjj8QAC)
    myVariable_current = SBQQ__Quote__c (a0u4R00003cHjj8QAC)
    DECISION: myDecision
    Outcome executed: myRule_1
    Outcome conditions:
    {!myVariable_current.SBQQ__Status__c} (Approved) Equals Approved
    UPDATE RECORDS: myRule_1_A1
    Find all SBQQ__Quote__c records where:
    Id Equals {!myVariable_current.Id} (a0u4R00003cHjj8QAC)
    Update the records’ field values.
    SBQQ__OrderBy__c = Provisioning Method__c
    SBQQ__Ordered__c = true
    Result
    Failed to update records that meet the filter criteria.

    ReplyDelete
    Replies
    1. A similar issue for me!

      System.DmlException Update failed. First exception on row 0 with id a1AS000000BJMfpMAH; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, SBQQ.QuoteAfter: execution of AfterUpdate caused by: System.CalloutException: Callout from triggers are currently not supported. (SBQQ)

      Any help is appreciated

      Delete
  7. Can You please help me with this. When I am trying to add products in order "To continue, enter a charge type" and the Order is not created.
    how can I pass this challenge please help me out.
    Thank you

    ReplyDelete
    Replies
    1. You'll need to choose a type on the Product.

      Delete
    2. Once you add ChargeType on Product make sure to remove product from quoteline and add it again

      Delete
  8. I am struck at Step 15 and trying out from a month. unable to figure out the issue. Any suggestions are highly appreciated.

    ReplyDelete
  9. Challenge 10 Not yet complete... here's what's wrong:
    We couldn't find the Invoice Scheduler record named 'High Priority Customers'. Please make sure the Invoice Scheduler exists, the record contains the correct values according to the requirements and please try again.

    ReplyDelete
  10. There are no invoices created from the order, when i Click on Bill Now. Is this usual?

    ReplyDelete
  11. To save Q-00015 from corrupting, i created another quote on "Burlington Textiles Corp of America".

    Added 4 products as quote lines:
    Product Name List Price Qty Net Total
    SolarBots $0.00 1 $0.00
    Major Solar Panel $5,000.00 10 $50,000.00
    Ursa Major Warranty and Maintenance Plan $2,000.00 1 $2,000.00
    Major Solar Panel Rental $200.00 10 $24,000.00

    Changed quote status from "Draft" to "Approved". Getting below error. Can someone help?

    Review the errors on this page.
    We can't save this record because the “Create Order Once Quote Is Approved” process failed. Give your Salesforce admin these details. This error occurred when the flow tried to update records: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY: SBQQ.QuoteAfter: execution of AfterUpdate caused by: SBQQ.OrderService.OrderServiceException: Attempt to de-reference a null object (SBQQ). You can look up ExceptionCode values in the SOAP API Developer Guide. Error ID: 753558622-262596 (-1645776798)k up ExceptionCode values in the SOAP API Developer Guide. Error ID: 753558622-262596 (-1645776798)

    ReplyDelete
    Replies
    1. Here is a help article from Salesforce on the error - https://help.salesforce.com/s/articleView?id=000313283&type=1

      Delete
    2. This comment has been removed by the author.

      Delete
    3. Even after looking at your link regarding the error, I'm still having the same issue after checking my package.

      Delete
  12. I received that same error message, and when I looked up the code it indicates that you don't have permissions to update the quote. Since I couldn't find anywhere in the permissions or setup (or the packages) that I could change this, I've created another dev org to attempt again.

    ReplyDelete
    Replies
    1. I found my mistake with this error: it's an update in the installed SF CPQ package for Solution Groups. I used the incorrect object.

      Delete
  13. Challenge 11 Not yet complete... here's what's wrong:
    We couldn't find the Invoice Scheduler record named 'High Priority Customers'. Please make sure the Invoice Scheduler exists, the record contains the correct values according to the requirements and please try again.

    ReplyDelete
  14. I'm Struck at Billing Specialist step 10

    help me to resolve this

    Challenge Not yet complete... here's what's wrong: We couldn't find the Invoice Scheduler record named 'High Priority Customers'. Please make sure the Invoice Scheduler exists, the record contains the correct values according to the requirements and please try again.

    Thanks

    ReplyDelete
    Replies
    1. Help from Salesforce - https://help.salesforce.com/articleView?id=blng_invoice_sched.htm&type=5

      References -
      The quizzes need you to understand billing concepts and these articles would help -
      https://help.salesforce.com/articleView?id=blng_date_guidelines.htm&type=5

      Overall billing help article - https://help.salesforce.com/articleView?id=blng_billing_parent.htm&type=5


      This challenge does require you to read through the Salesforce Billing articles to make things easier.

      Delete
  15. Question #9
    Provisioning Product Values
    Complete the Order Provisioning Process setup, maintaining the integrity of data moving from CPQ down to Billing. I'm getting this error and I don't know where to begin:

    Challenge Not yet complete... here's what's wrong:
    We couldn't find the correct object type for the 'Create Order Once Quote is Approved' process. Please check if the flow is correct according to the requirements and try again.

    ReplyDelete
  16. Hii,can anyone please tell me how to pass challege 16, i am done all the the requirement steps but still geting Same Error.
    Challenge Not yet complete... here's what's wrong:
    We couldn't find the Order linked to the Quote named 'Q-00015', with the correct address, Invoice Batch, zeroed Total Amount, and Tax Amount. Please make sure the record exists, it contains the correct values according to the requirements, and please try again.

    ReplyDelete
  17. Challenge Not yet complete... here's what's wrong:
    We couldn't find the Order linked to the Quote named 'Q-00015', with the correct address, Invoice Batch, zeroed Total Amount, and Tax Amount. Please make sure the record exists, it contains the correct values according to the requirements, and please try again.

    ReplyDelete
  18. Can Anyone help me with this ?

    Challenge Not yet complete... here's what's wrong:
    The field 'Invoice Batch' could not be found on the object Order. Please ensure the field was created according to the requirements and try again.

    Billing Superbadge.

    ReplyDelete
  19. A Dedicated Server requires an operating system that is compatible with the server hardware and the applications or services.

    ReplyDelete

Post a Comment

Popular posts from this blog

Salesforce Trailhead - Lightning Experience Reports & Dashboards Specialist - Build Sales Reports

Salesforce Trailhead - Billing Specialist super badge - The Invisible Bear