Good morning, Finance Systems Analyst
Dynamics 365 Finance · Crownstone Acquisition Ltd · Migration Project
Vendor Invoice Entry
14
Invoices pending
Period Close
Open
August period
Migration Mapping
23
Exceptions to resolve
Exception Management
5
Unmatched payments
68
Active Vendors
1
PO Mismatches
23
Migration Exceptions
1
SoD Conflicts
Vendor
Invoice
Payment
Procurement
General
| Vendor Account | Vendor Name | Vendor Group | Currency | Payment Terms | Status | Oracle Migration Status |
|---|
Showing 1–20 of 68
Invoice
Vendor
Functions
Post
| Invoice Number | Vendor | Invoice Date | Amount | Purchase Order | Matching Status | Workflow Status |
|---|
Dimensions
Main Accounts
Setup
| Dimension Code | Dimension Name | Active Values | Oracle Mapping | Migration Status | Notes |
|---|---|---|---|---|---|
| FIN-DIM-CC | Cost Centre | 12 | CC-5041 (INACTIVE) ⚠ | Invalid Mapping | Maps to inactive Oracle CC-5041. Must remap to CC-3010 before migration. |
| FIN-DIM-BU | Business Unit | 3 | Crownstone UK Operations | Mapped | Maps to Oracle Business Unit correctly. |
| FIN-DIM-DEPT | Department | 8 | Partial — 6/8 mapped | Partial | 2 Alderton departments have no Oracle equivalent. Review required. |
| FIN-DIM-PROJ | Project Code | 4 | — | Not Mapped | Oracle does not use project codes at this level. Migration decision required. |
⚠ 1 critical mapping error (FIN-DIM-CC → CC-5041 INACTIVE) · 1 partial mapping · 1 unmapped dimension · These must be resolved before Oracle migration can proceed.
Journal
Functions
Post
| Journal Number | Description | Date | Amount | Financial Dimension | Status | Oracle Migration |
|---|---|---|---|---|---|---|
| VJRN-0088 | August IT Accrual | 14-Aug-2024 | £8,400.00 | FIN-DIM-CC:5041 ⚠ | Error | Will fail — maps to inactive CC-5041 |
| VJRN-0087 | August AP Clearing | 13-Aug-2024 | £24,600.00 | FIN-DIM-CC:1010 | Posted | Ready |
| VJRN-0086 | July Rollover | 01-Aug-2024 | £11,200.00 | FIN-DIM-BU:UK | Posted | Ready |
Purchase Order
Receive
Invoice
General
| PO Number | Vendor | Amount | Status | Invoice Matched | Notes |
|---|---|---|---|---|---|
| D365-PO-0154 | VEN-0047 · Meridian Consulting Ltd | £12,600.00 | Received | ⚠ Match Exception | VINV-0291 matching exception. See FIN-INC-0006. |
User
Security Roles
Workflow
| User ID | Full Name | Roles | SoD Risk | Last Login | Status |
|---|
Migration Mapping
Exceptions
Validate
8
Name Mismatches
5
Missing Oracle Suppliers
4
Dimension Gaps
3
Tax Code Mismatches
2
Duplicate Risks
1
Workflow Differences
Vendor → Oracle Supplier Mapping
68 vendors · 23 exceptions| D365 Vendor Account | D365 Vendor Name | Oracle Supplier ID | Oracle Supplier Name | VAT Match | Exception | Status |
|---|
Financial Dimensions → Oracle Cost Centres
D365 DimensionOracle Cost CentreStatus
FIN-DIM-CC: 5041→
CC-5041 ⚠ INACTIVEInvalid
FIN-DIM-CC: 1010→
CC-1010 Corporate FinanceMapped
FIN-DIM-CC: 1020→
CC-1020 Accounts PayableMapped
FIN-DIM-CC: 3010→
CC-3010 IT ApplicationsMapped
Tax Code Mapping
3 mismatches
D365 Tax CodeOracle Tax CodeStatus
STANDARD (20%)→
T1 (20%)Matched
ZERO (0%)→
T0 (0%)Matched
EXEMPT-FIN→
No Oracle equivalent ⚠No Match
REDUCED-5→
No Oracle equivalent ⚠No Match
IMPORT-VAT→
No Oracle equivalent ⚠No Match