Update of Invoice Header not allowed in BAQ

, ,

Dear Team,
I tried to update the UD field in InvcHead table from Updatable dashboard. I’m getting the below error message.

Server Side Exception

BPM runtime caught an unexpected exception of ‘NullReferenceException’ type.
See more info in the Inner Exception section of Exception Details.

Exception caught in: Epicor.ServiceModel

Error Detail

Correlation ID: dba5bb3c-506a-426f-b8d6-bf78b1758af5
Description: BPM runtime caught an unexpected exception of ‘NullReferenceException’ type.
See more info in the Inner Exception section of Exception Details.
Program: Epicor.Ice.dll
Method: InnerPost
Line Number: 389
Column Number: 21
Original Exception Type: NullReferenceException

Client Stack Trace

at Epicor.ServiceModel.Channels.ImplBase1.ShouldRethrowNonRetryableException(Exception ex, DataSet[] dataSets) at Ice.Proxy.BO.DynamicQueryImpl.Update(DynamicQueryDataSet queryDS, DataSet queryResultDataset) at Ice.Adapters.DynamicQueryAdapter.<>c__DisplayClass27_0.<Update>b__0(DataSet datasetToSend) at Ice.Adapters.DynamicQueryAdapter.ProcessUbaqMethod(String methodName, DataSet updatedDS, Func2 methodExecutor, Boolean refreshQueryResultsDataset)
at Ice.Adapters.DynamicQueryAdapter.Update(DynamicQueryDataSet queryDS, DataSet updatedDS, Boolean refreshQueryResultsDataset)
at Ice.UI.App.BAQDesignerEntry.BAQTransaction.b__379_0(Int32& rowReturned)
at Ice.UI.App.BAQDesignerEntry.Forms.BAQDiagramForm.ShowQueryResults(DataSet dsResults, getQueryResult getResults, ReportAdditionalInfo additionalInfo)
at Ice.UI.App.BAQDesignerEntry.BAQTransaction.CallUpdate()

Inner Exception

Object reference not set to an instance of an object.

Below is my Qry for updatable BAQ:

[Customer].[Name] as [Customer_Name],
[InvcHead].[InvoiceNum] as [InvcHead_InvoiceNum],
[InvcHead].[LegalNumber] as [InvcHead_LegalNumber],
[InvcHead].[InvoiceAmt] as [InvcHead_InvoiceAmt],
[InvcHead].[InvoiceDate] as [InvcHead_InvoiceDate],
(InvcHead.InvoiceDate) as [Calculated_Fromdate],
(InvcHead.InvoiceDate) as [Calculated_ToDate],
[InvcHead].[ASNNumber_c] as [InvcHead_ASNNumber_c]
from Erp.InvcHead as InvcHead
left outer join Erp.Customer as Customer on
InvcHead.Company = Customer.Company
and InvcHead.CustNum = Customer.CustNum

Need to update on the ASNNumber_ column.

IsaiSelvan. S

I just created and tested a very similar dashboard w/o issue, what is the full Epicor version?
Silly question, but can you verify the UD field exists in the current env?

Is the Invoice already posted?

I’m guessing that Invoice Header records can’t be changed after being posted. You could test this to see if it works on an unposted invoice.

If that is the case and you need to update that filed after posting, you’ll probably need to implement the UD field via a UD table as a child table of the InvcHead table.

Dear @ckrusen,
i tried to update the unposted invoice, but i’m getting the null reference error.
I’m disable the existing BPM also.

Does the update work in BAQ designer?

No @ckrusen

As a test, I made a uBAQ on just the InvcHead, to update two UD fields.

Here’s the Update -> General Properties tab

Here’s the Update -> Update Processing tab

Your uBAQ differ much on the Update tabs? Specifically the “Processing method” and “BPM Update Processing” sections.