Dynamics 365 Business Central – Month End Accruals for GRNI Purchase Orders and Unposted Purchase Invoices

Key points

• Use Purchase Lines page with Analysis Mode to filter unposted invoices (Document Type = Invoice, Type = G/L Account) and GRNI orders (Document Type = Order, Type = G/L Account, Amt. Rcd. Not Inv. Ex. VAT <>0)
• Apply date filters to exclude invoices from later periods and use the Pivot Function to summarize by GL code if needed
• Export filtered data to Excel and populate a Recurring General Journal to post month-end accruals and reversals
• This approach applies only to G/L Account line items; items can use Expected Costing in Inventory Setup for automatic accrual posting

Quotes

• “At the month end, you might have Purchase Invoices that are unposted for a variety of reasons.” (Establishes the business problem that accruals solve for proper period expense recording)
• “I tend to use Analysis Mode much more since the feature Add fields in Analysis Mode was added.” (Highlights that Analysis Mode is the recommended approach for creating ad-hoc month-end reports)

AL objects mentioned

As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.

• page 518 “Purchase Lines”
• page 283 “Recurring General Journal”
• page 461 “Inventory Setup”

Context

• Features: Analysis Mode, Add fields in Analysis Mode, Filtering in Analysis Mode, Pivot Function, Open in Excel, Expected Costing, Recurring General Journal

Source: The Dynamics Explorer, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.