DYNAMICS ACCOUNT RECEIVABLES – PREBILLING
Before the process of exporting ticket data to Dynamics, some steps should be taken.
Set the date range for the tickets you want to review and possibly correct before invoicing.
Review the report for discrepancies in material prices, taxes, orders, etc.
Your company should have procedures for incorrect tickets.
To void the ticket, call up the ticket to the screen using the ticket lookup. Click the Void check box and then Save.
Create a replacement ticket by using the manual ticket entry. You should note the old ticket number in the remark box of the new ticket. You should go back to the Void ticket and reference the new ticket number as well. It's good practice when you need to explain why a ticket was Void.
AR INVOICING – Exporting data to Dynamics
THE BILLING PROCESS
Leaving the Filter Ranges as shown above, will qualify all Customers, all Orders from all the Material Categories.
Select the From and To Dates of the tickets you want invoiced.
The Print Transactions box, when checked, will display the invoices on the SMSTurbo invoice form.
Check off Customer Tickets
On the first billing attempt, you will have to determine the starting invoice number so it isn't duplicated with existing numbers in Dynamics
Click the OK Button to continue billing
Confirm you wish to generate invoices? Click Yes
This is the dialog for ticket data exported to the txt.file, Click OK
There may be customers in SMSTurbo that are not set up in Dynamics. Their tickets will reject when you attempt to import the ticket data into Dynamics. If a file was established in the Billing SetUp screen for Customer Export, a dialog screen will ask if you want to Export Customers for this Ticket Batch to customers.csv? Click Yes
A good practice for New Customers would be to add the CustomerID, Customer name/address and Order(s) in SMSTurbo first, then in Dynamics add the Customer using the same information. Then you wouldn't need the Customers.csv file in the Billing SetUp screen.
Display Transactions? Yes
Sample of SMSTurbo Invoice. You can print, email or save these invoices.
The SMSTurbo ticket now references the invoice # 10003
The DynamicsInvoices.txt file saved in Users/Public/Public Documents
The Customers.csv file saved in Users/Public/Public Documents
The Customers.csv file should be imported into Dynamics before importing the DynamicsInvoices.txt file. DynamicsInvoices.txt file will be imported into Dynamics to create Accounts Receivable Invoices and General Journal entries.