SQL Troubles: D365: AP

D365: AP

Disclaimer: Attempting to map the various sources based on the AP functionality and features. So, this is work in progress. Some links might stop working!

Accounts Payables

Vendors

setup

template to pre-populate records: doc, V1
default offset accounts: doc, BP1, BP2
Procurement categories
matching policies: Keener

Orders

Purchase orders

confirmed

automation: Most

received
invoiced

Purchase agreements

Invoices

Pending vendor invoices
Invoice journal
Global invoice journal
Vendor invoices

automation: Microsoft, Larsen, The Future of Finance, Edwards at DynamicsCon
setup: FinOps Corner
processing: FinOps Corner

Invoice register
Invoice pool
Invoice approval

Payments

Vendor payment journal
Payment transfers
Vendor postdated checks
Promissory notes

Promissory note journal

Draw
Redraw
Settle

Remittance journal

automation: Most

Broker and royalties

Broker contracts
Broker claims
Royalty agreements
Royalty claims
Differential reasons

Inquiries and reports

Product receipt
Vendor aging report
Vendor open transactions report
Vendor transactions report
History by transaction report
Broker open AR invoices report
Vender reports

Account statement
Top 100 vendors
Vendor balance list
Vendor balance list with credit limit
Vendor base data
Vendor invoice turnover
Vendor phone list
Vendor to ledger reconciliation
Vendors
Vendor Bank Account Inquiry
Vendor certification inquiry

Purchase order reports

Ledger posting for purchase orders
Pre-upgrade remaining accruals
Purchase agreement certification compliance

Invoice

Approval journal history and matching details
Invoice history and matching details
Invoice journal
Accrued purchases excluding sales tax report
Invoices not approved report
Invoice specification report
Vendor invoice journal report
Vendor invoice transactions report

Payment

Payment fee
Promissory note journal
Promissory note statistics
Vendor posted payment journal report
Promissory note journal report

Periodic tasks

Foreign currency revaluation
Vendor to ledger reconciliation report
Import one-time vendors and invoices
Process one-time vendors and invoices
Create prenotes
Submit proposed vendor changes
Tax 1099

Import vendor invoices
Vendor marked transaction details
All marked transaction details

Setup

Accounts payable parameters
Accounts payable workflows

Vendor invoice approval workflow

setup: Microsoft

Invoice capture
Aging period definitions
Line of business
Vendor posting profiles
Vendor reasons
Summary update parameters
Terms of delivery
Set up calculation for invoice issue due date
Vendor write-off reason codes
Forms
Advanced notes

groups
setup

Policy setup

policy rule types
policies
expenditure reviewers

Invoice matching setup

Price tolerances
Matching policy
Invoice totals tolerances
Charges tolerances
Item price tolerance groups

Charges

Charges code
Vendor charges group
Item charge groups
Automatic charges

Payment setup

Methods of payment
Payment days
Payment schedules
Terms of payment
Cash discounts
Payment fee
Cover page for payments report
Process automations
Payment calendar
Payment calendar configuration
Payment format code sets
Return format error codes
Return format status mapping

Invoice capture

Overview
Installation & Configuration

Configure expenditure reviewers (doc)

Microsoft AppSource
Document Intelligence invoice model (doc)
FastTrack sessions: Dec-2022 (preview), Sep-2023 (GA)
Hendrik M Larsen's posts: Invoice Capture (preview)
Dan's Corner: Invoice Capture (preview)
DAFTD365 channel
Alternatives: ExFlow, Data Management import

Subscription Billing

Ashraf's posts: Expense deferrals
Explore dynamics' posts: Accrual schemes
Strategix' posts: Post deferral outside posting date range

Processes

Create Invoice journal (V1)
Vendor Register:

approved by validation level: Shoman

New Features

[10.0.39] New vendor invoice center: Baumgarten
[10.0.39] Document type settings for transferred invoice document from Invoice capture
[10.0.39] Adding purchase order's requester and orderer as the invoice approver: Baumgarten
[10.0.38] 'Vendor invoice templates': Bristra, Nextone,
[10.0.38] Customer and vendor netting: Microsoft
[10.0.37] 'Vendor Invoice Register Approved': Baumgarten