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

(0) Share

Report

Posted on by Community Member Microsoft Employee

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.

Categories:

Customization

All responses (1)

Answers (0)

CFROTON 4,710 on at

Like (0)

Report

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.