AP Invoice Status field in Expense Report Form

Epicor ERP 10
,
1

I have been asked to show the AP Invoice Status on the Employee Expense report. I see on the form that the AP Invoice Status field is tied to EmpExpense.InvoiceStatus but there is no such field in the EmpExpense table. Does anyone know where this comes from so I can add it into the RDD for the report? I also looked in the Header for the AP Invoice and I don’t see a Status field there either.
image

2

I’m going to wager that it’s got an EpiBinding, but nothing in the DB Field property?
image

If that’s the case, then it’s calculated at runtime and you will need to do the same for your report.
I would look at possibly using the APInvHead.OpenPayable field.
True = Open
False = Paid

You can also add in some more fields for your logic such as APInvHead.Posted and APInvHead.DocInvoiceBalance.

May I ask what screen you pulled that screenshot from?

1 Like
3

Thanks for the information. I think all I really need is whether it has been paid or not. That screenshot is from the Expense tab on the Time and Expense entry form. We have customized it but those fields are in the base form as well.

4

Again, that’s on you to create. There is no database field for it.

image
image301×602 11.6 KB

5

This is working now that I have added the OpenPayable to my RDD. Thanks!