DATABASICS can integrate both Time and Expense entries records with Journal Entry in Dynamics SL.
Mapping to Expense Accounts
Time Codes
Expense Types
the Journal Transaction screen (01.010.00) in Dynamics SL.
Based on a completed workflow per customer requirements in DATABASICS, tailored postings are 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 (e.g.
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.
...