AR Invoice

Parent Previous Next

SAGE100ERP ACCOUNT RECEIVABLES - PREBILLING



Before the process of exporting ticket data to SAGE100 ERP, 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 SAGE100 ERP

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 SAGE100 ERP.



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 SAGE100 ERP.  Their tickets will reject when you attempt to import the ticket data into SAGE100 ERP.  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 SAGE100ERPInvoices.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 SAGE100ERP before importing the SAGE100ERPInvoices.csv file.

Sage100 ERPInvoices.csv file will be imported into SAGE100ERP to create Accounts Receivable Invoices and General Journal entries.