Difference between revisions of "Microsoft Dynamics Export"

From Rts
Jump to: navigation, search
Line 1: Line 1:
This article will explain how to configure a Microsoft Dynamics Export in RTS. In <code> Actions -> Export -> Microsoft Dynamics </code>
+
A Microsoft Dynamics export is used to create calculations using data that is captured in RTS and creating your own Report that can be exported into a CSV file. This file then can be uploaded into Microsoft Dynamics software or into an Excel Spreadsheet. The configuration of the report and the exporting can be done in <code> Actions -> Export -> Microsoft Dynamics </code>
  
 
==Configuring MS Dynamic Export==
 
==Configuring MS Dynamic Export==
  
Configuring the export is done by selecting the '''Configure Export''' button in the MS Dynamics Export window.
+
By configuring the export in the MS Dynamics Export window, using the '''configure export button''', you are creating your own Microsoft dynamics report.
 
 
:''Note: Make sure, when making any changes to the configuration window, to click on the save and close button.''
 
  
 
===Creating an Account===
 
===Creating an Account===
  
Creating an account will allow you to configure the export that will be uploaded to Microsoft Dynamics.  
+
Setting the account name is used for the name of the account the export is created for.  
  
 
:1) Select '''Add/Edit Account''' to create the new account name.  
 
:1) Select '''Add/Edit Account''' to create the new account name.  
  
:2) Once an account is created then allocations and the value (Viewing the Gross, Net, or Tax of the location) of the export can be configured.
+
:2) Once an account is created then fields, allocations within the fields, and the value (Viewing the Gross, Net, or Tax of the location) of the export can be configured.
  
===Creating Allocations===
+
===Creating Microsoft Dynamic Fields===
Allocations are created to distribute amounts to ledger accounts that are within Microsoft Dynamics.  
+
Fields are created to distribute amounts to ledger accounts that are within Microsoft Dynamics.  
  
 
:1) Select '''Add Field''', then insert the name of the Allocation, the account number associated with it, and whether it is credit or debit.  
 
:1) Select '''Add Field''', then insert the name of the Allocation, the account number associated with it, and whether it is credit or debit.  
 +
  
 
[[File:MSDynamicsAddField.gif | 800px ]]<br><br>
 
[[File:MSDynamicsAddField.gif | 800px ]]<br><br>
  
===Assigning Items to Allocations===
+
===Assigning Allocations to Microsoft Dynamics Fields===
 +
 
 +
[[Deposit Total | Deposit sections]], subtotal, and concession items can be set as allocations.
  
[[Deposit Total | Deposit sections]], subtotal, and concession items can be set as items to allocations fields.
+
:1) Highlight the allocation item on the left-hand side
  
:1) Highlight the item on the left-hand side
+
:{| class="mw-collapsible mw-collapsed wikitable"
 +
|-
 +
! scope="col"| Allication
 +
! scope="col"| Description
 +
|-
 +
! scope="row"| Shift Admissions
 +
| total tickets for the shift before the deposit has closed
 +
|-
 +
! scope="row"| Shift Ticket Gross
 +
| ticket net before the deposit closed
 +
|-
 +
! scope="row"| Shift Ticket Net
 +
| ticket gross before the deposit closed
 +
|-
 +
! scope="row"| Shift Ticket Tax 1
 +
| tax category 1 amount set before the deposit closed
 +
|-
 +
! scope="row"| Shift Ticket Tax 2
 +
| tax category 2 amount set before the deposit closed
 +
|-
 +
! scope="row"| Daily Admissions
 +
| ticket gross after the deposit closed
 +
|-
 +
! scope="row"| Daily Ticket Gross
 +
| ticket gross before the deposit closed
 +
|-
 +
! scope="row"| Daily Ticket Net
 +
| ticket net after the deposit closed
 +
|-
 +
! scope="row"| Daily Ticket Tax 1
 +
| tax category 1 amount set after the deposit closed
 +
|-
 +
! scope="row"| Daily Ticket Tax 2
 +
| tax category 2 amount set after the deposit closed
 +
|-
 +
! scope="row"| Cash Deposit
 +
| cash sales when the deposit closed
 +
|-
 +
! scope="row"| OverUnder
 +
| over/under the total when the deposit closed
 +
|-
 +
! scope="row"| Credit Visa
 +
| total sales amount from visa cards
 +
|-
 +
! scope="row"| Credit MC
 +
| total sales amount from master card
 +
|-
 +
! scope="row"| Credit Amex
 +
| total sales amount from American express
 +
|-
 +
! scope="row"| Credit Discover
 +
| total sales amount from discover
 +
|-
 +
! scope="row"| Credit Other
 +
| total sales amount from other credit cards
 +
|-
 +
! scope="row"| Advance Internet Sales
 +
| total advanced internet sales
 +
|-
 +
! scope="row"| Advance Station Sales
 +
| total advanced station(s) sales
 +
|-
 +
! scope="row"| Matured Sales
 +
| Tickets that were sold for performance(s) and were picked up at the location
 +
|-
 +
|}
  
 
:2) Select '''<<< Add''' and then this will then move the item over to the selected field.
 
:2) Select '''<<< Add''' and then this will then move the item over to the selected field.
 
  
 
[[File:MSDynamicsAddItem11-8-20.gif | 750px ]]<br><br>
 
[[File:MSDynamicsAddItem11-8-20.gif | 750px ]]<br><br>
Line 35: Line 100:
 
:''Note: Make sure to highlight the Allocation field that is getting the new Item assigned to it or else it will default assigning the item to the first allocation on the right-hand side.''
 
:''Note: Make sure to highlight the Allocation field that is getting the new Item assigned to it or else it will default assigning the item to the first allocation on the right-hand side.''
  
:Shift Admissions -  total tickets for the shift before the deposit has closed
+
==Exporting Microsoft Dynamics Export==
 
 
:Shift Ticket Gross - ticket gross before the deposit closed
 
 
 
:Shift Ticket Net - ticket net before the deposit closed
 
 
 
:Shift Ticket Tax 1 - tax category 1 amount set before the deposit closed
 
 
 
:Shift Ticket Tax 2 - tax category 2 amount set before the deposit closed
 
 
 
:Daily Admissions - total tickets for the day after the deposit has closed
 
 
 
:Daily Ticket Gross - ticket gross after the deposit closed
 
 
 
:Daily Ticket Net - ticket net after the deposit closed
 
 
 
:Daily Ticket Tax 1 - tax category 1 amount set after the deposit closed
 
 
 
:Daily Ticket Tax 2 - tax category 2 amount set after the deposit closed
 
 
 
:Cash Deposit - cash sales when the deposit closed
 
 
 
:OverUnder - over/under total when the deposit closed
 
 
 
:Credit Visa - total sales amount from visa cards
 
 
 
:Credit MC - total sales amount from master card
 
 
 
:Credit Amex - total sales amount from American express
 
 
 
:Credit Discover - total sales amount from discover
 
 
 
:Credit Other - total sales amount from other credit cards
 
 
 
:Advance Internet Sales - total advanced internet sales
 
 
 
:Advance Station Sales - total advanced station(s) sales
 
  
:Matured Sales -
+
This export can be run either by a date range or by selecting certain deposit total reports.
  
 +
:When you select the export button on the MS Dynamics Export window, RTS creates a CSV file that is saved to the Documents section of your machine.
  
==Exporting Microsoft Export==
+
:You can then upload the CSV file to the Microsoft Dynamics Software or to an Excel Sheet
  
There are two types of exports that can be done in RTS, one is by a specific deposit and the other is by a date range of the deposit.
+
[[File:MSDynamicsExportReport.png]]<br><br>
  
:*When you select the export button on the MS Dynamics Export window, RTS creates a CSV file that is saved onto the machine.
+
:''Note: This example of a MS Dynamics Export was uploaded to Google Sheets. Also, this export was edited for the understanding of how the fields are to look within the export.''

Revision as of 20:59, 15 November 2020

A Microsoft Dynamics export is used to create calculations using data that is captured in RTS and creating your own Report that can be exported into a CSV file. This file then can be uploaded into Microsoft Dynamics software or into an Excel Spreadsheet. The configuration of the report and the exporting can be done in Actions -> Export -> Microsoft Dynamics

Configuring MS Dynamic Export

By configuring the export in the MS Dynamics Export window, using the configure export button, you are creating your own Microsoft dynamics report.

Creating an Account

Setting the account name is used for the name of the account the export is created for.

1) Select Add/Edit Account to create the new account name.
2) Once an account is created then fields, allocations within the fields, and the value (Viewing the Gross, Net, or Tax of the location) of the export can be configured.

Creating Microsoft Dynamic Fields

Fields are created to distribute amounts to ledger accounts that are within Microsoft Dynamics.

1) Select Add Field, then insert the name of the Allocation, the account number associated with it, and whether it is credit or debit.


MSDynamicsAddField.gif

Assigning Allocations to Microsoft Dynamics Fields

Deposit sections, subtotal, and concession items can be set as allocations.

1) Highlight the allocation item on the left-hand side
Allication Description
Shift Admissions total tickets for the shift before the deposit has closed
Shift Ticket Gross ticket net before the deposit closed
Shift Ticket Net ticket gross before the deposit closed
Shift Ticket Tax 1 tax category 1 amount set before the deposit closed
Shift Ticket Tax 2 tax category 2 amount set before the deposit closed
Daily Admissions ticket gross after the deposit closed
Daily Ticket Gross ticket gross before the deposit closed
Daily Ticket Net ticket net after the deposit closed
Daily Ticket Tax 1 tax category 1 amount set after the deposit closed
Daily Ticket Tax 2 tax category 2 amount set after the deposit closed
Cash Deposit cash sales when the deposit closed
OverUnder over/under the total when the deposit closed
Credit Visa total sales amount from visa cards
Credit MC total sales amount from master card
Credit Amex total sales amount from American express
Credit Discover total sales amount from discover
Credit Other total sales amount from other credit cards
Advance Internet Sales total advanced internet sales
Advance Station Sales total advanced station(s) sales
Matured Sales Tickets that were sold for performance(s) and were picked up at the location
2) Select <<< Add and then this will then move the item over to the selected field.

MSDynamicsAddItem11-8-20.gif

Note: Make sure to highlight the Allocation field that is getting the new Item assigned to it or else it will default assigning the item to the first allocation on the right-hand side.

Exporting Microsoft Dynamics Export

This export can be run either by a date range or by selecting certain deposit total reports.

When you select the export button on the MS Dynamics Export window, RTS creates a CSV file that is saved to the Documents section of your machine.
You can then upload the CSV file to the Microsoft Dynamics Software or to an Excel Sheet

MSDynamicsExportReport.png

Note: This example of a MS Dynamics Export was uploaded to Google Sheets. Also, this export was edited for the understanding of how the fields are to look within the export.