SL Voucher and Adjustment Integration

Based on the customer’s requirement DATABASICS can integrate reimbursable Expense records with the Voucher and Adjustment screen (03.010.00) in Dynamics SL.

After a completed workflow in DATABASICS, per customer requirements, a tailored posting is batched and presented to SL Transaction Import through a control macro using a comma separated file.

Bi-directional dataflow ensures the validity of data in the posting, e.g. that the user selects an assigned project / task, and the charge is associated with the correct account.

Mapping to GL Accounts

Mapping to the appropriate GL account(s) will be according to the customer’s requirement:

Expense Report

Expense Types in DATABASICS will be mapped to Expense Accounts in the SL. Multiple Expense types can be mapped to the same expense account to support the customer’s requirement: e.g Taxi/Rideshare and Mileage can both be associated with the Ground Transportation Account.

Post Approved Transactions to Dynamics SL Voucher and Adjustment

Data in the extract file created by DATABASICS will be provided according to the Control Macro requirement and any special instructions provided by the customer related to their specific process requirement as outlined in an agreed design.

Data can include Subaccount, Project and Task as well as other distribution data to fulfill the accounting requirement in a posting for reimbursement and accounting.

Example DATABASICS Post to Dynamics SL Journal Entry profile:

Example DATABASICS Post to Dynamics SL Voucher and Adjustment

NOTE: DATABAICS has the ability to rollback a posted batch as long as it is not processed in ADP yet. You may need to contact support@data-basics.com or submit a ticket online to request a rollback to posted expense batch.