AR Aging

Summary

Project based accounts receivable invoices that haven’t been paid. This is a Projects360 feature and the underlying data is controlled by a periodic (batch) process.

Dynamics 365 Menu Item(s)

• Project Management and accounting > Projects360 > Accounts Receivable > Contract open Invoices
• Project Management and accounting > Projects360 > Accounts Receivable > My open Invoices
• Accounts receivable > Customers > All customers > Customers (Button tab) > Transactions (Button)
• Project management and accounting > Project invoices > Project invoices > Customer transactions (Button)

Legacy data model’s data entities

• PMBI_deFACTARAging

New data model’s data entities

• PMBI_PMIPInvAgingEntity
• FNBI_CustTransEntity
• PMBI_ProjInvoiceJourEntity
• PMBI_EnumsTableEntity
• PMBI_ProjProposalJourEntity
• PMBI_ProjInvoiceTableEntity
• PMBI_PMIPInvAgingEntity

Synapse link approach tables

• PMIPInvAging
• CustTrans
• ProjInvoiceJour
• PMBIENUMSTABLE
• ProjProposalJour
• ProjInvoiceTable
• PMIPInvAging
  

Field level functional description

• AgedBy: Numeric code indicating the method or criteria used for aging accounts receivable.
• AgingDate: The date on which the aging calculation is performed or reported.
• ARAging_AmountCUR_: The accounts receivable amount in the transaction currency as of the aging date.
• ARAging_AmountMST_: The accounts receivable amount in the company’s accounting currency as of the aging date.
• ARAging_InvoiceAmount_: The total invoice amount in the transaction currency for the aging period.
• ARAging_InvoiceAmountMST_: The total invoice amount in the accounting currency for the aging period.
• ARAging_Period01_ to ARAging_Period12_: The accounts receivable amounts for each specific aging period (e.g., current, 1-30 days past due, etc.) in the transaction currency.
• AgedByName: The descriptive name of the aging method or criteria.
• CompCurrencyCode: The code for the company’s accounting currency.
• CustTransRecID: Unique identifier for the customer transaction record.
• DueDate: The date when the receivable is due for payment.
• PMIPInvAgingRecID: Unique identifier for the project invoice aging record.
• ProjectInvoiceBillingApprover: Identifier for the person or role responsible for approving the project invoice billing.
• ProjInvoiceDate: The date of the project invoice.
• ProjInvoiceID: The unique identifier for the project invoice.
• ProjInvoiceProjID: The project identifier associated with the invoice.
• ProposalID: The identifier for the related proposal, if applicable.
• StatRepInterval: The interval or period used for statistical reporting.
• TranCurrencyCode: The code for the transaction currency.
• TransDate: The date of the transaction.
• Voucher: The voucher number or reference for the transaction.
• CustAccountNum: The customer’s account number associated with the aging record.