View on GitHub

BCS Itera

Extensions for Microsoft Dynamics 365 Business Central

Extensions | What's new | User Guide

Expense Reports

Expense Reports solution in BC enables the following:


To use the solution, Expense Reports Setup must be opened and following fields filled:

Field Explanation
Expense Report Nos. To specify Expense report number series. Value can be chosen from No. Series List.
Expense Document Nos. To specify Expense document number series. Value can be chosen from No. Series List.
Vendor Registration No. Field Solution uses vendor registration number for automatic detection of Vendor. Since different country localisations use different fields for storing this data, we have made this value selectable by User. This selection is recommended but NOT mandatory.
Default Allowance Account No. field To specify Default G/L account for posting Daily allowance sum. Value can be chosen from G/L Accounts list.

All expense documents are posted via journal and User can select a Journal Template and Batch for this. During app installation a General journal batch named APP-EXPREP is created.

To use digitization partner CostPocket functionality, action Registration must be used for one time. User information in CostPocket registration form page is used to determine Primary user, who shall receive e-mail from CostPocket along with instructions how to use CostPocket app. After successful registration connection with CostPocket is established.

Job Que Entries for automatic importing of expense reports/documents can be created with button “Job Que Entries” (can be found in More Options -> Actions) . If Job Que entry doesn’t exist, then system creates it. Job que entry for expense documents is only needed when documents without report is allowed.

For predetermined cost types User can setup default cost accounts. That can be done in Cost Types page. Now when expense documents are imported from CostPocket, system assigns a default G/L cost account determined by document’s cost type. Note! Default cost account is assigned to cost document only when existing Vendor is detected via Registration No. or VAT Registration No.

Approval of an expense report and setting it up is similar to Setting Up and Using a Purchase Approval Workflow. On page Workflows use button “New Workflow from Template” and just select Expense Report Approval Workflow. After enabling the workflow, User can post an expense report only when it’s been approved (status becomes Released).
To notify for example a bookkeeper about a new imported expense report, use workflow template Expense Report New Entry Notification Workflow.

Solution is ment to be used with logic:
User operates daily/weekly in CostPocket app, taking pictures of expense documents and adding them to an Expense report. Bookkeeper operates in BC, receiving expense reports with connected expense documents from CostPocket. Checks postings, sends for approval and posts report with documents.
For special cases where Expense reports are not used, User can mark Allow Documents without Report, which makes individual document posting possible.


Expense Reports

Manual creation of an expense report is usually done after manual creation of expense documents. User can add documents to report with action Add documents to Report.

Expense reports (with status Report ready) will be imported from CostPocket, when user presses button Get Reports from CostPocket. Among with an expense report all expense documents, that are connected to this report, shall also be imported to BC.
On Expense report card User can see total sum of expense documents in LCY.
User can edit submitter information by selecting value from Employees table to Submitter No. field. When selecting new value system asks if documents (report lines) should also be updated.
User must set posting date for report and all connected expense documents by entering value to field Posting Date.

User can change Sum of Daily Allowance and Allowance Account No. if needed.

User can open list of connected expense documents when clicking on Number of Documents field value.

Dimensions selected to expense report shall be used on all connected documents and document rows (if confirmed by user). Default dimensions attached to submitter employee are also automatically added to all connected documents.

Approval process is similar to Use Approval Workflows.

Posting of an expense report means that all connected expense documents are posted along with Sum of daily allowance. Documents are posted individually.

Posted expense reports can be found in Posted Expense Reports archive.

Expense Documents

Manual creation of expense document is possible and is similar to regular purchase invoice.

Vendor and Submitter must be used. When getting documents from CostPocket system looks for Vendor Registration No. and/or VAT Registration No. in order to find Vendor from existing Vendors. Similarly submitter e-mail is used to look for Employee with matching company Email from Employees.
User can make multiple document lines with different posting groups (to manage VAT).
Dimensions are applied for document header and lines.

Most common picture file formats (like .png .jpg .jpeg) are supported and can be uploaded as picture attachments. Additionally as document attachments all kinds of documents can be added (for example digitally signed documents) to document attachments.

Expense document’s Billing Type can be Personal or Company, depending on finances used.

Currency exchange rate can be adjusted by Currency Factor field.

User can work with documents on document card or in expense documents list (mainly to assign Vendor/Submitter/Expense account).
When an expense account is assigned to document header, User shall be prompted, if document lines should also be updated.
User can check posting with action Post Preview.
Solution will make posting entries to both Vendor ledger entries and Employee ledger entries (when Submitter has paid for expense document using personal finances).

Documents are usually posted from Expense Report. In special case, when Allow documents without reports selection is used, expense documents can be imported separately with action Get Documents from CostPocket and then a document can also be posted from Expense Document list/card.

Posted expense documents can be found in Posted Expense Documents archive.

To undo an erroneous Expense Document posting, User must select the general ledger entry and with action Reverse Transaction… system creates a reverse entry (entries identical to the original entry but with opposite sign in the amount field) with the same document number and posting date as the original entry. After reversing an entry, User must make the correct entry.

For more information please contact BCS Itera AS: