SAGE300 ACCOUNT RECEIVABLES - PREBILLING
Before the process of exporting ticket data to SAGE300, 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 SAGE300
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.
On the first billing attempt, you will have to determine the starting invoice number so it isn’t duplicated with existing numbers in SAGE300.
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 csv.file, Click OK
There may be customers in SMSTurbo that are not set up in SAGE300. Their tickets will reject when you attempt to import the ticket data into SAGE300. 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
Display Transactions? Yes
Sample of SMSTurbo Invoice. You can print, email or save these invoices.
The SMSTurbo ticket now references the invoice # 10000
The SAGE300Invoices.csv 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 SAGE300 before importing the SAGE300Invoices.csv file. SAGE300Invoices.csv file will be imported into SAGE300 to create Accounts Receivable Invoices and General Journal entries.