web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Which SQL Stored Proce...
Microsoft Dynamics SL (Archived)

Which SQL Stored Procedure does BI.AIC.00 execute?

(0) ShareShare
ReportReport
Posted on by Community Member

I am trying to update the TermsID value associated with Invoices. I have VBA which sets my preferred value within BI.BAM.00, but this logic does not get considered during the Automatic Invoice Creation process.

I imagine that upon clicking "Create Invoices" on BI.AIC.00, somewhere along the line a SQL Stored procedure is being executed to Insert the values. My thought is that if I cannot set the default within SL, I'll set it within SQL either by updating the INSERT or by creating a TRIGGER with an UPDATE.

I would prefer to update the Stored Procedure INSERT but would input to be sure I'm hitting the correct place and not overlooking anything.

*This post is locked for comments

I have the same question (0)
  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Which SQL Stored Procedure does BI.AIC.00 execute?

    From what I can tell, the screen itself is passing the parameters, so you would have to customize the screen to send additional information.

    The stored procs that are used grab the information being passed by the exe, so the code has to be manipulated to add the additional fields you need put in.  Are these populated during Billings Load? If not, then you need to specify the id fields that you want populated withing Billing Setup screen as well.

    Might be best to go with your Trigger.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans