Connections
- Release notes
- Technical Documentation
Core extensions
- Release notes
- Introduction
- Company colors
- Exchange rate import
- Reciprocal exchange rate
- User security audit detail report
- General and inventory journal import
- General Journal for Multiple Legal entities
- 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
- 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
- Technical guide
- Roadmap and release schedule
- Definitions and Acronyms
Finance utilities
- Release notes
- Introduction
- Setup
  - Cash and bank management
  - Accounts payable
  - Accounts receivable
  - Validation
  - Budgeting
    - Budget import
  - Encryption/decryption
    - Encryption/decryption
  - Electronic reporting export
- Processing
  - Cash and bank management
  - Accounts payable
  - Accounts receivable
    - Customer remittance import
  - Validation
  - Budgeting
    - Budget import
    - Example file format
  - Electronic reporting export
    - Export electronic reporting file
- Other
  - Data entities
  - GER configuration
- Technical guide
  - Web API Endpoint
  - Technical Architecture
- Roadmap and release schedule
- FAQ
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
License manager
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
- Inquiries
  - Documents
  - Exceptions
- Other
Care Services
- Release notes
- Introduction
- Schedules Inquiries and Reports
- Services Management
- Common Processes
- Setup
- Billing
  - Community and Disability Care
  - Residential Care and Retirement Villages
  - Accommodation-Payments
  - Refunds
  - New Billing Code and Rates Updates
- Collection-letters
  - Residential Care services
  - Community care
- Receipts
- Funding
- Periodic Jobs
- Services Australia Integration
- Other
FAQ

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

Note: This standard entity doesn’t support Modern bank reconciliation.
Interim solution to import Modern bank reconciliation matching rules, see ER migration

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: (pre-Modern bank reconciliation for ‘Mark new transactions’ reconciliation matching rules) • 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: (pre-Modern bank reconciliation for ‘Mark new transactions’ reconciliation matching rules)
• 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.

Electronic reporting export

Electronic reporting export connections

Organisation administration > Electronic reporting > Electronic reporting export connections

Order	Entity
1	Electronic reporting Azure blob connection settings
1	Electronic reporting FTP connection settings
1	Electronic reporting SFTP connection settings

Document types

Organisation administration > Document management > Document types

Order	Entity	Standard / Finance utilities entity	Additional Finance utilities fields for standard entity
1	Document types	Standard	• Electronic reporting export connection (DFUGEREXPORTCONNECTION)

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