AR Invoice

Accounting ›› Virtual Accounting ›› Sage300 ››
Parent Previous Next

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.