SL Journal Entry Integration

Based on the customer’s requirement DATABASICS can integrate both Time and Expense records with the Journal Transaction screen (01.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.

Timesheet

Labor account can be tied with the type of time reported through a Time Code in DATABASICS (e.g. Regular, or Overtime), or it can be tied with an attribute in the Project structure (e.g. Direct Labor, or G&A).

Post Approved Transactions to Dynamics SL Journal Entry

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, Labor Class, Project and Task as well as other distribution data to fulfill the accounting requirement in a balanced posting.

Example DATABASICS Post to Dynamics SL Journal Entry profile:

Example DATABASICS Post to Dynamics SL Journal Entry

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.