Based on the customer’s requirement DATABASICS can integrate both Time and Expense entries records with Journal Entry in Dynamics SLthe 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
...
Time Codes
Expense Types
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.
...