Connections
- Release notes
Core extensions
- Release notes
- Introduction
- Company colors
- Exchange rate import
- Reciprocal exchange rate
- User security audit detail report
- General and inventory journal import
- Business process links
- Import budgets
- DMF Toolbox
- Print Management
- Data Anonymization
  - Data Anonymization
  - FAQ
- Other
  - Data-entities
  - Security-configuration
- FAQ
  - FAQ
  - Coming Soon
Electronic Data Interchange (EDI)
- Release notes
- Introduction
- FAQ
- Core module
  - Introduction
  - Process overview
  - Trading partner and documents
  - Setup
  - Processing
    - Functional acknowledgement outbound
    - Functional acknowledgement inbound
  - Managing files
  - Workspaces
    - EDI Document maintenance workspace
  - Inquiries
    - Functional acknowledgement received
    - Trading partner documents
  - Other
  - Technical guide
    - Web API
    - Technical FAQ
- Customer module
- Vendor module
- 3PL module
- Freight forwarder for Landed cost module
  - Introduction
  - Process overview
  - FAQ
  - Setup
  - Processing
  - Workspaces
    - Landed cost processing workspace
  - Other
    - Data entities
    - Security configuration
- Integration systems module
  - Introduction
  - Setup
    - Integration systems
    - Trading partners
  - Processing
    - Customer
    - Customer group
- Roadmap and release schedule
- Definitions and Acronyms
Finance utilities
- Release notes
- Introduction
- Setup
  - Cash and bank management
  - Accounts payable
  - Accounts receivable
  - ABN and IRD validation
    - ABN lookup and validation
    - IRD number validation
  - Budgeting
    - Budget import
  - Encryption/decryption
    - Encryption/decryption
  - Electronic reporting export
- Processing
  - Cash and bank management
  - Accounts payable
  - Accounts receivable
    - Customer remittance import
  - ABN and IRD validation
    - ABN lookup and validation
    - IRD number validation
  - Budgeting
    - Budget import
    - Example file format
  - Electronic reporting export
    - Export electronic reporting file
- Other
  - Data entities
- Technical guide
  - Web API Endpoint
- Roadmap and release schedule
- FAQ
Forex contract
- Release notes
- Introduction
- Setup
  - Forex contract parameters
  - Forex over allocation
- Processing
- Other
  - Data entities
  - Security configuration
- Roadmap
Insights for D365 FO
- Release notes
- Introduction
- Setup
- Periodic monitoring
  - Periodic monitoring configuration
  - Number sequence monitoring
- BatchJob monitoring
- Review and set up monitored data
- Azure Application Insights
  - Dashboards
  - Alerts on Azure Azure Application Insights
- Limitations
- Security configuration
- FAQ
- Definitions and Acronyms
Item creation wizard
- Release notes
- Introduction
- FAQ
- Setup
  - Item creation parameters
  - Item creation workflows
  - Item creation
  - Item setup
    - Item status
    - Item creation workflows
  - File management
    - File management
- Processing
- Periodic tasks
  - Update item status
  - Item creation
    - Creation import files
    - Item import
  - Item status
    - Automatic status update
- Inquiries
  - Creation import sessions
- Other
License manager
Product Lifecycle Management (PLM)
- Release notes
Security Insights for D365 FO
Smart Business Form Email Manager (Smart Send)
- Release notes
- Introduction
- FAQ
- Setup
- Processing
  - Email processing
  - Electronic Reporting
- Other
- Roadmap
Solutions for DocuSign and Dynamics 365
- Release notes
- Introduction
- FAQ
- Setup
- Inquiries
  - Documents
  - Exceptions
- Other

Cash and bank management

Finance utilities includes the following data entities in Cash and bank management:

Financial utilities parameters

Cash and bank management > Setup > Advanced bank reconciliation setup > Financial utilities parameters
Data entity: Financial utilities parameters

Financial utilities connection

Cash and bank management > Setup > Advanced bank reconciliation setup > Financial utilities connections

Order	Entity
1	Financial utilities connections
2	Connection - FTP
2	Connection - SFTP
2	Connection - Azure blob
2	Connection - Sharepoint

Bank accounts

Cash and bank management > Bank accounts > Bank accounts

Entity	Additional Finance utilities fields for standard entity
Bank accounts	EFT parameters: • BPAY batch ID (DFUBPAYBATCHID) • Extra balance line on EFT (DFUEXTRABALANCELINE) • Include balance line in record count (DFUBALANCELINECOUNT) • Total line order (DFUTOTALLINEORDER) • Use vendor bank name (DFUUSEVENDBANKNAME) • User identification (DFUEFTUSERID) Import financial utilities connection: • Financial utilities connection (DFUCONNECTIONNAME)

Reconciliation matching rules

Cash and bank management > Setup > Advanced bank reconciliation setup > Reconciliation matching rules

Entity	Additional Finance utilities fields for standard entity
Reconciliation matching rules	Step 2: Do not mark when there are matching bank transactions: • Group by document number (SYSTEMGENERATEDTYPE = ECL_GroupByDocumentNum) • Include in (DFUBANKRULEACTIVATEINCLUDEIN) Step 3: Extended financial details: • Company (DFUCOMPANY) • Offset company (DFUOFFSETCOMPANY) • Offset account type (DFUOffsetAccountType) • Offset account (DFUOFFSETLEDGERDIMENSIONDISPLAYVALUE) • Account’s financial dimension values (DFUDEFAULTDIMENSIONDISPLAYVALUE) • Offset account’s financial dimension values (DFUOFFSETDEFAULTDIMENSIONDISPLAYVALUE) • Offset account bank statement field (DFUOFFSETACCOUNTFIELDNAME) • Offset account reference bank statement field (DFUOFFSETACCOUNTREFERENCEFIELDNAME) • Settle transaction (DFUSETTLETRANS) • Settle transaction bank statement field (DFUSETTLETRANSFIELDNAME) • Auto-post customer payment journal (DFUCUSTPAYMAUTOPOST) • Auto-post and transfer customer payment journal (DFUCUSTPAYMAUTOPOSTTRANSFER) • GST group (DFUTAXGROUP) • Item GST group (DFUTAXITEMGROUP) • Description mask (SAB_DESCRIPTIONMASK)

Entity

Additional Finance utilities fields for standard entity

Reconciliation matching rules

Step 2: Do not mark when there are matching bank transactions:
• Group by document number (SYSTEMGENERATEDTYPE = ECL_GroupByDocumentNum)
• Include in (DFUBANKRULEACTIVATEINCLUDEIN)
Step 3: Extended financial details:
• Company (DFUCOMPANY)
• Offset company (DFUOFFSETCOMPANY)
• Offset account type (DFUOffsetAccountType)
• Offset account (DFUOFFSETLEDGERDIMENSIONDISPLAYVALUE)
• Account’s financial dimension values (DFUDEFAULTDIMENSIONDISPLAYVALUE) **
• Offset account’s financial dimension values (DFUOFFSETDEFAULTDIMENSIONDISPLAYVALUE) **
• Offset account bank statement field (DFUOFFSETACCOUNTFIELDNAME)
• Offset account reference bank statement field (DFUOFFSETACCOUNTREFERENCEFIELDNAME)
• Settle transaction (DFUSETTLETRANS)
• Settle transaction bank statement field (DFUSETTLETRANSFIELDNAME)
• Auto-post customer payment journal (DFUCUSTPAYMAUTOPOST)
• Auto-post and transfer customer payment journal (DFUCUSTPAYMAUTOPOSTTRANSFER)
• GST group (DFUTAXGROUP)
• Item GST group (DFUTAXITEMGROUP)
• Description mask (SAB_DESCRIPTIONMASK)

** Note: Ensure the Financial dimension configuration for integrating applications dimension format aligns with dimensions on the bank reconciliation matching rule before importing the Reconciliation matching rules entity. General ledger > Chart of accounts > Dimensions > Financial dimension configuration for integrating applications.
Define data entity format for Default dimensions integration and Ledger dimensions integration.
See link for more detail.

Bank statement format

Cash and bank management > Setup > Advanced bank reconciliation setup > Bank statement format
Bank statement format entities are a combination of Finance utilities entities and additional fields added to standard entity.

Order	Entity	Standard / Finance utilities entity	Additional Finance utilities fields for standard entity
1	Bank statement format	Standard	• Custom format (SAB_FINCUSTOMFORMAT) • ABSR file type (SAB_FINFILETYPE) • Field delimiter (SAB_FINFIELDDELIMITER) • Record code field position (SAB_FINFIELDPOSITION) • Record code field length (DFUIMPORTLENGTHRECORDCODE)
2	Custom line codes	Finance utilities	-
3	Bank statement format lines	Finance utilities	-
4	Line codes format	Finance utilities	-

Note: If comma is used in Field delimiter on the Bank statement format, set SAB_FINFIELDDELIMITER Text qualifier to Yes in Mapping details.

Accounts payable

Finance utilities includes the following data entities in Accounts payable:

Vendor bank accounts

Accounts payable > Vendors > All vendors - Bank accounts on Vendor FastTab

Entity	Additional Finance utilities fields for standard entity
Vendor bank accounts	• Biller code (DFUBILLERCODE) • Lodgement reference (DFULODGEMENTREF) • Bank code (ECL_BANKCODE) • Bank particulars (ECL_BANKPARTICULARS) • Bank reference (ECL_BANKREFERENCE)

Vendor methods of payment

Accounts payable > Payment setup > Methods of payments

Entity	Additional Finance utilities fields for standard entity
Vendor payment method	• Sundry method of payment (DFUSUNDRYPAYM) • Auto payment reference number (DFUAUTOPAYMENTREFNUMBER) • BPAY method of payment (DFUBPAYPAYM) • Generate file per payment line (DFUFILEPERPAYMLINE) • Payment control > Lodgement reference is mandatory (DFUVALIDATELODGEMENTREFISMANDATORY) • Payment attributes > Lodgement reference (DFUATTRIBUTELODGEMENTREFENABLED) • File name mask (DFUFILENAMEMASK)

Entity

Additional Finance utilities fields for standard entity

Vendor payment method

• Sundry method of payment (DFUSUNDRYPAYM)
• Auto payment reference number (DFUAUTOPAYMENTREFNUMBER)
• BPAY method of payment (DFUBPAYPAYM)
• Generate file per payment line (DFUFILEPERPAYMLINE)
• Payment control > Lodgement reference is mandatory (DFUVALIDATELODGEMENTREFISMANDATORY)
• Payment attributes > Lodgement reference (DFUATTRIBUTELODGEMENTREFENABLED)
• File name mask (DFUFILENAMEMASK)

Self billing invoicing / RCTI

Finance utilities includes the following data entities for Self billing invoicing / Recipient-Created Tax Invoice (RCTI)

Accounts payable parameters

Accounts payable > Setup > Accounts payable parameters

Entity	Additional Finance utilities fields for standard entity
Vendor parameters	• Enable self billing invoicing (DFUSELFBILLINGINVOICING) • Invoice date (DFUSELFBILLINGINVOICEDATE) • Posting date (DFUSELFBILLINGPOSTINGDATE)

Self billing invoice groups

Accounts payable > Setup > Self billing invoice groups
Data entity: Self billing invoice groups

Vendors

Accounts payable > Vendors > All vendors

Entity	Additional Finance utilities fields for standard entity
Vendors V2	• Self billing invoicing (DFUSELFBILLINGINVOICEGROUP)

Accounts receivable

Finance utilities includes the following data entities in Accounts receivable:

Reference number type

Accounts receivable > Setup > Reference number type
Data entity: Reference number type

Customer references

Accounts receivable > Customers > All customers: Customer references
Data entity: Customer references

ABN and IRD number validation

Validation providers

Organisation administration > Setup > Validation providers

Order	Entity
1	Validation providers
2	Validation provider - ABN

Legal entities

Organisation administration > Organisations > Legal entities

Entity	Additional Finance utilities fields for standard entity
Legal entities	For ABN validation: • DXCABNValidationEnabled • DXCABNValidationProviderTypeTable_Name For IRD number validation: • DXCCountryRegionId

Budgeting

Finance utilities includes the following data entities in Budgeting:

Budget utilities parameters

Budgeting > Setup > Basic budgeting > Budget utilities parameters
Data entity: Budget utilities parameters

Accounts receivable - AR utilities

Finance utilities - AR utilities includes the following data entities in Cash and bank management:

Note: The forms and additional fields are only available where additional licensed feature Finance utilities - AR utilities is enabled

Remittance format

Accounts receivable > Payments setup > Remittance format

Order	Entity
1	Finance utilities template file
2	Remittance format
3	Finance utilities template file section
4	Finance utilities template file line section

Financial utilities connections

Accounts receivable > Payments setup > Financial utilties connection

Order	Entity
1	Financial utilities connections
2	Connection - FTP
2	Connection - SFTP
2	Connection - Azure blob
2	Connection - Sharepoint

Accounts receivable parameters

Accounts receivable > Setup > Accounts receivable parameters

Entity	Additional Finance utilities fields for standard entity
Customer parameters	• Create prepayment (DXCARCREATEPREPAYMENT) • Auto post customer payment journal (DXCARAUTOPOSTCUSTPAYMJOUR) • File attachment document type (DXCARDOCUTYPEID)

Methods of payment

Accounts receivable > Payment setup > Methods of payment

Entity	Additional Finance utilities fields for standard entity
Customer payment method	• Error account customer (DXCARCUSTACCOUNTERROR) • Settle transactions (DXCARSETTLETRANSACTIONS) • Posting date (DXCARPOSTINGDATETYPE) • Reference number type (DXCARREFERENCENUMBERTYPE) • Remittance format