Historical AP Transactions

In Scope

Technical: VendInvoiceJour | ID: D365FO-TRX-VENDINVOICEJOUR-HISTORICAL_AP_TRANSACTIONS

See how this object fits into Open Transactions History

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: High
Sequencing: Stage 4 - Opening Balances
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: VendInvoiceJour

This object has high complexity or dependency level

Review sequencing requirements before loading

Field Definitions(5)

Rules & Considerations(28)

constraint

validation

Sample Load Data(4)

_scenario	IsPostedR	InvoiceIdRPK	InvoiceDateR	InvoiceAmountR	VendorAccountR	Status	DueDate	Voucher	Approved	Approver	Correction	DataAreaId	PostedDate	AccountType	CurrencyCode	DocumentDate	ExchangeRate	JournalNumber	PaymentAmount	InvoiceAccount	SettlementDate	TotalTaxAmount	TransactionType	CashDiscountCode	PaymentReference	PaymentTermsName	SalesTaxGroupCode	SettlementVoucher	CashDiscountAmount	InvoiceDescription	PurchaseOrderNumber	CompanyBankAccountId	ItemSalesTaxGroupCode	PaymentCurrencyAmount	LedgerDimensionDisplayValue	DefaultDimensionDisplayValue
Example values from field definitions	Yes	INV-MIG-001	2022-03-10	550.0	US-10001	Paid	2022-04-09	APJ-2022-000101	Yes	SysAdmin	Normal	USMF	2022-03-10	Vendor	USD	2022-03-08	1.0	MIG-APJ-2022	550.0	US-10001	2022-03-25	30.25	Invoice	—	CHK78901	NET30	US_NC	BNK-2022-000055	0.0	Consulting Services Q1 2022	PO-2022-0050	USOPER1	ALL	550.0	200100-022-008-001	022-008-001
Historical Credit Note (EUR)	Yes	CRN-MIG-002	2022-08-01	120.5	DE-00005	Paid	2022-08-31	APJ-2022-000250	Yes	—	CreditNote	DEMF	2022-08-01	Vendor	EUR	2022-07-30	—	MIG-APJ-2022	120.5	DE-00005	2022-08-15	22.9	CreditNote	—	—	NET30	DE_ST	—	—	Credit for faulty goods	PO-2022-0150	—	FULL	—	200100-023-009-002	023-009-002
Historical Open Invoice (GBP) for Cutover	Yes	INV-MIG-003	2023-01-20	875.2	GB-00010	None	2023-02-19	APJ-2023-000010	Yes	UserB	—	GBMF	2023-01-20	Vendor	GBP	2023-01-18	—	MIG-APJ-2023	—	GB-00010	—	175.04	Invoice	1PCT10	—	NET30	GB_ST	—	—	Office Supplies Q1 2023	—	—	STD	—	200100-024-010-003	024-010-003

Example values from field definitions

IsPostedR: Yes
InvoiceIdRPK: INV-MIG-001
InvoiceDateR: 2022-03-10
InvoiceAmountR: 550.0
VendorAccountR: US-10001
Status: Paid
DueDate: 2022-04-09
Voucher: APJ-2022-000101
Approved: Yes
Approver: SysAdmin
Correction: Normal
DataAreaId: USMF
PostedDate: 2022-03-10
AccountType: Vendor
CurrencyCode: USD
DocumentDate: 2022-03-08
ExchangeRate: 1.0
JournalNumber: MIG-APJ-2022
PaymentAmount: 550.0
InvoiceAccount: US-10001
SettlementDate: 2022-03-25
TotalTaxAmount: 30.25
TransactionType: Invoice
CashDiscountCode: —
PaymentReference: CHK78901
PaymentTermsName: NET30
SalesTaxGroupCode: US_NC
SettlementVoucher: BNK-2022-000055
CashDiscountAmount: 0.0
InvoiceDescription: Consulting Services Q1 2022
PurchaseOrderNumber: PO-2022-0050
CompanyBankAccountId: USOPER1
ItemSalesTaxGroupCode: ALL
PaymentCurrencyAmount: 550.0
LedgerDimensionDisplayValue: 200100-022-008-001
DefaultDimensionDisplayValue: 022-008-001

Historical Credit Note (EUR)

IsPostedR: Yes
InvoiceIdRPK: CRN-MIG-002
InvoiceDateR: 2022-08-01
InvoiceAmountR: 120.5
VendorAccountR: DE-00005
Status: Paid
DueDate: 2022-08-31
Voucher: APJ-2022-000250
Approved: Yes
Approver: —
Correction: CreditNote
DataAreaId: DEMF
PostedDate: 2022-08-01
AccountType: Vendor
CurrencyCode: EUR
DocumentDate: 2022-07-30
ExchangeRate: —
JournalNumber: MIG-APJ-2022
PaymentAmount: 120.5
InvoiceAccount: DE-00005
SettlementDate: 2022-08-15
TotalTaxAmount: 22.9
TransactionType: CreditNote
CashDiscountCode: —
PaymentReference: —
PaymentTermsName: NET30
SalesTaxGroupCode: DE_ST
SettlementVoucher: —
CashDiscountAmount: —
InvoiceDescription: Credit for faulty goods
PurchaseOrderNumber: PO-2022-0150
CompanyBankAccountId: —
ItemSalesTaxGroupCode: FULL
PaymentCurrencyAmount: —
LedgerDimensionDisplayValue: 200100-023-009-002
DefaultDimensionDisplayValue: 023-009-002

Historical Open Invoice (GBP) for Cutover

IsPostedR: Yes
InvoiceIdRPK: INV-MIG-003
InvoiceDateR: 2023-01-20
InvoiceAmountR: 875.2
VendorAccountR: GB-00010
Status: None
DueDate: 2023-02-19
Voucher: APJ-2023-000010
Approved: Yes
Approver: UserB
Correction: —
DataAreaId: GBMF
PostedDate: 2023-01-20
AccountType: Vendor
CurrencyCode: GBP
DocumentDate: 2023-01-18
ExchangeRate: —
JournalNumber: MIG-APJ-2023
PaymentAmount: —
InvoiceAccount: GB-00010
SettlementDate: —
TotalTaxAmount: 175.04
TransactionType: Invoice
CashDiscountCode: 1PCT10
PaymentReference: —
PaymentTermsName: NET30
SalesTaxGroupCode: GB_ST
SettlementVoucher: —
CashDiscountAmount: —
InvoiceDescription: Office Supplies Q1 2023
PurchaseOrderNumber: —
CompanyBankAccountId: —
ItemSalesTaxGroupCode: STD
PaymentCurrencyAmount: —
LedgerDimensionDisplayValue: 200100-024-010-003
DefaultDimensionDisplayValue: 024-010-003

Rule Validation Summary

Source Rule Count: 28
Governed Rule Count: 28