Vendor Open Balances

In Scope

Technical: VendTransOpen | ID: D365FO-TRX-VENDTRANSOPEN-VENDOR_OPEN_BALANCES

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: VendTransOpen

This object has high complexity or dependency level

Review sequencing requirements before loading

Field Definitions(5)

Rules & Considerations(31)

validation

constraint

Sample Load Data(4)

_scenario	TRANSDATER	DocumentDateR	OffsetAccountTypeR	OffsetAccountDisplayValueR	DUE	INVOICE	VOUCHER	AMOUNTCUR	AmountMST	TRANSTYPE	ACCOUNTNUM	DataAreaId	CURRENCYCODE	DocumentNumber	InvoiceAccount	PostingProfile	SalesTaxAmount	AmountReporting	TransactionText	CashDiscountCode	PaymentReference	PaymentTermsName	PurchOrderNumber	PaymentMethodName	CurrencyExchangeRate	LedgerDimensionDisplayValue	DefaultDimensionDisplayValue
Example values from field definitions	2024-02-20	2024-02-15	—	—	2024-03-20	SUPP_INV001	APINV-0001	1250.75	1250.75	Invoice	US-VEN001	USMF	USD	GRN-9876	—	DEFAULT	100.5	1250.75	Opening Balance - Q1 2024 Invoice	—	—	Net30	PO-10001	Check	1.0	200100-022-008	022;008
Open Invoice - Multi-Currency with Dimensions	2024-03-10	2024-03-05	—	—	2024-04-10	INV-EUR-005	APINV-0002	850.2	935.22	Invoice	EU-VEN005	USMF	EUR	—	—	EUR	0	1028.74	Opening Balance - European Supplier Invoice	—	—	Net45	PO-10002	EFT	1.1	200100-023-009	023;009
Open Credit Note - Multi-Currency, Central Payment	2024-02-25	2024-02-20	Ledger	500100-023-009	2024-03-25	CN-EUR-001	APCN-0001	-150	-165	CreditNote	EU-VEN005	USMF	EUR	RMA-555	EU-VEN006	EUR	0	-181.5	Opening Balance - Credit Note for Goods Return	—	—	Net30	—	EFT	1.1	200100-023-009	023;009

Example values from field definitions

TRANSDATER: 2024-02-20
DocumentDateR: 2024-02-15
OffsetAccountTypeR: —
OffsetAccountDisplayValueR: —
DUE: 2024-03-20
INVOICE: SUPP_INV001
VOUCHER: APINV-0001
AMOUNTCUR: 1250.75
AmountMST: 1250.75
TRANSTYPE: Invoice
ACCOUNTNUM: US-VEN001
DataAreaId: USMF
CURRENCYCODE: USD
DocumentNumber: GRN-9876
InvoiceAccount: —
PostingProfile: DEFAULT
SalesTaxAmount: 100.5
AmountReporting: 1250.75
TransactionText: Opening Balance - Q1 2024 Invoice
CashDiscountCode: —
PaymentReference: —
PaymentTermsName: Net30
PurchOrderNumber: PO-10001
PaymentMethodName: Check
CurrencyExchangeRate: 1.0
LedgerDimensionDisplayValue: 200100-022-008
DefaultDimensionDisplayValue: 022;008

Open Invoice - Multi-Currency with Dimensions

TRANSDATER: 2024-03-10
DocumentDateR: 2024-03-05
OffsetAccountTypeR: —
OffsetAccountDisplayValueR: —
DUE: 2024-04-10
INVOICE: INV-EUR-005
VOUCHER: APINV-0002
AMOUNTCUR: 850.2
AmountMST: 935.22
TRANSTYPE: Invoice
ACCOUNTNUM: EU-VEN005
DataAreaId: USMF
CURRENCYCODE: EUR
DocumentNumber: —
InvoiceAccount: —
PostingProfile: EUR
SalesTaxAmount: 0
AmountReporting: 1028.74
TransactionText: Opening Balance - European Supplier Invoice
CashDiscountCode: —
PaymentReference: —
PaymentTermsName: Net45
PurchOrderNumber: PO-10002
PaymentMethodName: EFT
CurrencyExchangeRate: 1.1
LedgerDimensionDisplayValue: 200100-023-009
DefaultDimensionDisplayValue: 023;009

Open Credit Note - Multi-Currency, Central Payment

TRANSDATER: 2024-02-25
DocumentDateR: 2024-02-20
OffsetAccountTypeR: Ledger
OffsetAccountDisplayValueR: 500100-023-009
DUE: 2024-03-25
INVOICE: CN-EUR-001
VOUCHER: APCN-0001
AMOUNTCUR: -150
AmountMST: -165
TRANSTYPE: CreditNote
ACCOUNTNUM: EU-VEN005
DataAreaId: USMF
CURRENCYCODE: EUR
DocumentNumber: RMA-555
InvoiceAccount: EU-VEN006
PostingProfile: EUR
SalesTaxAmount: 0
AmountReporting: -181.5
TransactionText: Opening Balance - Credit Note for Goods Return
CashDiscountCode: —
PaymentReference: —
PaymentTermsName: Net30
PurchOrderNumber: —
PaymentMethodName: EFT
CurrencyExchangeRate: 1.1
LedgerDimensionDisplayValue: 200100-023-009
DefaultDimensionDisplayValue: 023;009

Rule Validation Summary

Source Rule Count: 31
Governed Rule Count: 31