Historical AR Transactions

In Scope

Technical: CustInvoiceJour | ID: D365FO-TRX-CUSTINVOICEJOUR-HISTORICAL_AR_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: CustInvoiceJour

This object has high complexity or dependency level

Review sequencing requirements before loading

Field Definitions(5)

Rules & Considerations(38)

constraint

validation

Sample Load Data(3)

_scenario	InvoiceIdRPK	InvoiceDateR	TotalAmountR	CurrencyCodeR	CustomerAccountR	Status	DueDate	TaxAmount	Description	InvoiceType	DocumentDate	InvoiceStatus	SalesTaxGroup	PostingProfile	CashDiscountCode	PaymentTermsName	SalesOrderNumber	ItemSalesTaxGroup	MethodOfPaymentName	PurchaseOrderNumber	ConfirmedShippingDate	InvoiceCustomerAccountName	DefaultDimensionDisplayValue	ReportingCurrencyAmount	DeliveryCity	DeliveryName	DeliveryStreet	DeliveryZipCode	DeliveryCountryRegionId	LedgerDimensionDisplayValue
Example values from field definitions	INV001	2023-10-26	1250.0	USD	US-001	Open	2023-11-25	100.0	Hardware sales for October	Invoice	2023-10-26	Open	DOMESTIC	GEN	2%10NET30	Net30	SO-12345	GOODS	EFT	PO-C001	2023-10-25	Contoso Inc.	BUSUNIT-USA/DEPT-SALES	—	—	—	—	—	—	—
Credit Note - Partially Applied	CRN005	2023-10-20	-500	GBP	UK-002	Partially Applied	2023-11-19	-80	Return of defective items	CreditNote	2023-10-20	Open	EU-IMPORT	INTER	—	Net30	—	GOODS	—	PO-C002-RET	2023-10-18	Fabricam Ltd.	BUSUNIT-UK/DEPT-RETURNS	-600	—	—	—	—	—	—
Paid Invoice - International	INV002	2023-09-15	750	EUR	DE-003	Paid	2023-10-15	142.5	Consulting services	Invoice	2023-09-15	Paid	EU-SALES	INTER	—	Net30	SO-12346	SERVICES	SEPA	PO-DE-XYZ	—	Adatum AG	BUSUNIT-DE/DEPT-SERVICES	800.25	Berlin	Adatum AG HQ	Hauptstr. 10	10115	DEU	401100-DE-SERVICES

Example values from field definitions

InvoiceIdRPK: INV001
InvoiceDateR: 2023-10-26
TotalAmountR: 1250.0
CurrencyCodeR: USD
CustomerAccountR: US-001
Status: Open
DueDate: 2023-11-25
TaxAmount: 100.0
Description: Hardware sales for October
InvoiceType: Invoice
DocumentDate: 2023-10-26
InvoiceStatus: Open
SalesTaxGroup: DOMESTIC
PostingProfile: GEN
CashDiscountCode: 2%10NET30
PaymentTermsName: Net30
SalesOrderNumber: SO-12345
ItemSalesTaxGroup: GOODS
MethodOfPaymentName: EFT
PurchaseOrderNumber: PO-C001
ConfirmedShippingDate: 2023-10-25
InvoiceCustomerAccountName: Contoso Inc.
DefaultDimensionDisplayValue: BUSUNIT-USA/DEPT-SALES
ReportingCurrencyAmount: —
DeliveryCity: —
DeliveryName: —
DeliveryStreet: —
DeliveryZipCode: —
DeliveryCountryRegionId: —
LedgerDimensionDisplayValue: —

Credit Note - Partially Applied

InvoiceIdRPK: CRN005
InvoiceDateR: 2023-10-20
TotalAmountR: -500
CurrencyCodeR: GBP
CustomerAccountR: UK-002
Status: Partially Applied
DueDate: 2023-11-19
TaxAmount: -80
Description: Return of defective items
InvoiceType: CreditNote
DocumentDate: 2023-10-20
InvoiceStatus: Open
SalesTaxGroup: EU-IMPORT
PostingProfile: INTER
CashDiscountCode: —
PaymentTermsName: Net30
SalesOrderNumber: —
ItemSalesTaxGroup: GOODS
MethodOfPaymentName: —
PurchaseOrderNumber: PO-C002-RET
ConfirmedShippingDate: 2023-10-18
InvoiceCustomerAccountName: Fabricam Ltd.
DefaultDimensionDisplayValue: BUSUNIT-UK/DEPT-RETURNS
ReportingCurrencyAmount: -600
DeliveryCity: —
DeliveryName: —
DeliveryStreet: —
DeliveryZipCode: —
DeliveryCountryRegionId: —
LedgerDimensionDisplayValue: —

Paid Invoice - International

InvoiceIdRPK: INV002
InvoiceDateR: 2023-09-15
TotalAmountR: 750
CurrencyCodeR: EUR
CustomerAccountR: DE-003
Status: Paid
DueDate: 2023-10-15
TaxAmount: 142.5
Description: Consulting services
InvoiceType: Invoice
DocumentDate: 2023-09-15
InvoiceStatus: Paid
SalesTaxGroup: EU-SALES
PostingProfile: INTER
CashDiscountCode: —
PaymentTermsName: Net30
SalesOrderNumber: SO-12346
ItemSalesTaxGroup: SERVICES
MethodOfPaymentName: SEPA
PurchaseOrderNumber: PO-DE-XYZ
ConfirmedShippingDate: —
InvoiceCustomerAccountName: Adatum AG
DefaultDimensionDisplayValue: BUSUNIT-DE/DEPT-SERVICES
ReportingCurrencyAmount: 800.25
DeliveryCity: Berlin
DeliveryName: Adatum AG HQ
DeliveryStreet: Hauptstr. 10
DeliveryZipCode: 10115
DeliveryCountryRegionId: DEU
LedgerDimensionDisplayValue: 401100-DE-SERVICES

Rule Validation Summary

Source Rule Count: 38
Governed Rule Count: 38