AgeInDays on Payables and Receivables Header Difference

Business Applications Financials
,
1

Hi there

2 questions please:

  1. Table/Field Differences: On Payables and Receivables Header tables, there is a field called AgeInDays. On the Receivables Header, it’s a work field and on the Payables Header, it’s not a work field. Can you confirm why they differ - is there a reason Payables Header needs to store the value permanently? I just want to understand how/if the fields are utilised differently for a use case being worked on.
  2. List Form Load Data Events: When adding a Load Data on List Form to Customer and Supplier Invoice Header apps to set the Age in Days in the list view, it sets the field in Supplier Invoices fine but not on Customer Invoices. Would this be due to it being a work field on Receivables Header?

Thank you.

2

In regards to question 1, I’m going to speculate a little here, as I was not involved in the original implementation of some of these date values. That value along with some other attributes (e.g., Days Until Due) is calculated and populated when the user edits the record (i.e., goes to the detail view). It has to be because it constantly changes as we hit midnight each day. Because of this, storing it didn’t have a lot of value, as it would usually be wrong (the other option would have been to have a job run every night to update them). Therefore, one team made the decision to make it a workfield and the other to store it. Finally, I would agree with your analysis that your update on the load data event is not working because it is a work field.

3

Thanks, @michael.tebben .