Editing Invoicing

Jump to navigation Jump to search

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.

Latest revision Your text
Line 37: Line 37:
  
 
'''Invoice #''' - invoice number is generated based on the Next Invoice # in the Setup module.
 
'''Invoice #''' - invoice number is generated based on the Next Invoice # in the Setup module.
<br>'''Reference #''' - The order number the invoice was generated for.
+
'''Reference #''' - The order number the invoice was generated for.
<br>'''Balance due'''- Calculated field showing the balance due on the invoice.
+
'''Balance due'''- Calculated field showing the balance due on the invoice.
<br>'''Invoice Date''' – Automatically populated based on the date the invoice was generated.
+
'''Invoice Date''' – Automatically populated based on the date the invoice was generated.
<br>'''Terms''' – Invoice terms for that customer.
+
'''Terms''' – Invoice terms for that customer.
<br>'''Due Date''' – Due date based on the invoice date and the terms.
+
'''Due Date''' – Due date based on the invoice date and the terms.
<br>'''PO#''' - If the order being invoiced has a PO number, the PO number will carry over to this field.
+
'''PO#''' - If the order being invoiced has a PO number, the PO number will carry over to this field.
<br>'''Billing Status'''– If you are syncing SME with QuickBooks, the billing status will be imported from QuickBooks. You can use this field to void an invoice, or click Actions > Void Invoice. Make sure you uncheck Export to QuickBooks so SQLink doesn’t try to sync the voided invoice.
+
'''Billing Status'''– If you are syncing SME with QuickBooks, the billing status will be imported from QuickBooks. You can use this field to void an invoice, or click Actions > Void Invoice. Make sure you uncheck Export to QuickBooks so SQLink doesn’t try to sync the voided invoice.
<br>'''Invoice Type''' – This field is not editable and shows the type of invoice (combined, itemized, partial, fixed, dollar amount, percent)
+
'''Invoice Type''' – This field is not editable and shows the type of invoice (combined, itemized, partial, fixed, dollar amount, percent)
  
 
== Types of Invoices ==
 
== Types of Invoices ==
Line 50: Line 50:
 
When creating a service or install order, select the '''Invoice Type'''. The type you select will change how the order is invoiced. Watch the video or read the description below.
 
When creating a service or install order, select the '''Invoice Type'''. The type you select will change how the order is invoiced. Watch the video or read the description below.
  
{{#ev:youtube| b4ETBOoSBkU }}
+
<videoflash>b4ETBOoSBkU</videoflash><br>
  
 
<h3>Combined</h3>
 
<h3>Combined</h3>
Line 92: Line 92:
 
#      Make sure the '''Inc Count''' column has the right quantity you want to include on the invoice (3).
 
#      Make sure the '''Inc Count''' column has the right quantity you want to include on the invoice (3).
 
#      Click '''OK'''.
 
#      Click '''OK'''.
<br>[[File:PartialInvoiceMaterials.png]]
 
  
 
<h3>Fixed Total</h3>
 
<h3>Fixed Total</h3>
Line 101: Line 100:
 
<br>2.    Save the order and notice the '''Fixed Rates''' tab appears (image below).
 
<br>2.    Save the order and notice the '''Fixed Rates''' tab appears (image below).
 
<br>3.    Enter the '''fixed amount''' for labor, materials and services in the Fixed Amount column.
 
<br>3.    Enter the '''fixed amount''' for labor, materials and services in the Fixed Amount column.
<br>4.    Choose a bucket to pass the income through in the Item column (for example if you don't tax labor, choose a service item that is set as non-taxable such as your SMP_Item).
+
<br>4.    Add labor and materials to the order as you normally would. The Fixed Rates tab will show you your cost in the '''Item Cost''' column. Compare costs to your fixed rates by viewing the Item Profit column.
<br>5.    Add labor and materials to the order as you normally would. The Fixed Rates tab will show you your cost in the '''Item Cost''' column. Compare costs to your fixed rates by viewing the Item Profit column.
+
<br>5.    When you are ready to invoice the order, your customer will receive an invoice for the fixed amount set on the Fixed Rates tab.
<br>6.    When you are ready to invoice the order, your customer will receive an invoice for the fixed amount set on the Fixed Rates tab.
 
  
 
[[File:FixedRates.jpg]]
 
[[File:FixedRates.jpg]]
 
 
  
 
<h3>Percent of Total</h3>
 
<h3>Percent of Total</h3>
Line 164: Line 160:
  
 
'''**NOTE**''' If you are syncing SME with QuickBooks, the invoice will also be in QuickBooks after your next sync.
 
'''**NOTE**''' If you are syncing SME with QuickBooks, the invoice will also be in QuickBooks after your next sync.
 
 
== Video Showing Invoices Syncing to QuickBooks ==
 
If you are syncing SME with QuickBooks, watch the video below to see how the invoices created in SME sync to QuickBooks and how income is passed.
 
 
{{#ev:youtube| LWcmKN2GbnE }}
 
 
 
You will also want to understand how to setup the [[Default Export to QuickBooks Settings]] and review the [[SQLink]] section of the wiki.
 
  
 
== Email or Print Invoice ==
 
== Email or Print Invoice ==
Line 194: Line 181:
  
 
[[File:ReportAvailability.jpg]]
 
[[File:ReportAvailability.jpg]]
 
 
== Rollback Invoice and make changes to the order ==
 
 
<br>'''DELETE PAYMENT'''
 
<br>If you have a payment applied on the invoice you are trying to edit, delete the payment first.
 
<br>
 
<br>'''ROLLBACK INVOICE'''
 
<br>1. Go to the invoice.
 
<br>2. Click '''Actions''' > '''Rollback Invoice'''.
 
<br>3. Click '''Yes''' to confirmation window. The order associated with the invoice will change from the status of 'Invoiced' back to 'Closed'.
 
<br>'''NOTE:''' if you are syncing with QB and the invoice is in QB, make sure you go to QB and delete the invoice. Rolling it back in SME doesn't delete it out of QB.
 
<br>
 
<br>'''EDIT ORDER'''
 
<br>Locate the service or install order and make the changes to the order. If you don't have permission to edit a closed order, have someone with permissions reopen the order or make the changes to the closed order for you.
 
<br>
 
<br>'''RE-INVOICE THE ORDER'''
 
<br>'''NOTE:''' If you want to use a different invoice number, before you invoice the order, go to the Totals tab and click '''Reset''' next to the invoice number. Otherwise the invoice number will be the same as the original invoice number.
 
<br>[[File:ResetNextInvoiceNumber.png]]
 
<br>1. In the order, click '''Actions''' > '''Generate Invoice'''.
 
<br>2. The order status will change to 'Invoiced' and an invoice is created.
 
  
 
== Batch Print or Batch Email Invoices ==
 
== Batch Print or Batch Email Invoices ==
Line 229: Line 195:
 
[[File:ToBePrintedFlag.png]]<br>
 
[[File:ToBePrintedFlag.png]]<br>
  
'''Note''' - If you are syncing SME with QuickBooks and you checked the option to '''Set To Be Emailed''' by default, if the Billing
+
'''Note''' - If you are syncing SME with QuickBooks and you checked the option to '''Set To Be Emailed''' by default, if the customer doesn't have an email address, the invoice won't be able to sync to QuickBooks.
Customer doesn't have a matching email address with QuickBooks, the invoice won't be able to sync over.
+
 
<br>
 
'''Error:'''
 
<br><u>
 
810: There was an error when saving a Invoice.  QuickBooks error message: The email address specified for this customer is invalid, and the transaction is marked 'To be e-mailed'.
 
</u><br>
 
'''Solution:''' Apply correct email to Billing Customer or uncheck '''To Be Emailed'''.
 
<br>
 
<br>
 
 
'''Void Invoice'''
 
'''Void Invoice'''
 
Click '''Action''' > '''Void Invoice''' to void the invoice. The billing status on the invoice changes to Voided. The invoice is closed and moves the order from invoiced to closed.
 
Click '''Action''' > '''Void Invoice''' to void the invoice. The billing status on the invoice changes to Voided. The invoice is closed and moves the order from invoiced to closed.
Line 250: Line 208:
 
#    Void the invoice in QuickBooks.
 
#    Void the invoice in QuickBooks.
 
#    Void the invoice in SME.
 
#    Void the invoice in SME.
 +
  
 
== Calculate Finance Charge ==
 
== Calculate Finance Charge ==
In order to apply a finance charge on an invoice, you need to enter a finance charge % on the customer record. When you enter a new customer in SME, you can either enter the finance charge rate or if you are using the default charge, the default finance charge rate will be entered for you.
+
In order to apply a finance charge on an invoice, you need to enter a finance charge % on the customer record. When you enter a new customer in SME, you can enter the finance charge on the Account tab shown below.
  
 
[[File:Customer_FinanceCharge.jpg]]
 
[[File:Customer_FinanceCharge.jpg]]
  
You can apply finance charges to invoices for the customer individually, or have SME apply finance charges to all overdue invoices in SME.
+
You can also setup SME to enter a default finance charge for all customers you create. Then you can apply finance charges to invoices for the customer individually, or have SME apply finance charges to all overdue invoices in SME.
 
 
 
 
'''Setup days past due to calculate chare'''
 
<br>1. Go to Setup > Company > Order.
 
<br>2. Click '''Edit'''
 
<br>3. Locate the setting for '''Calculate finance charges when invoice is  ___ days past due'''. Enter the number of days.
 
<br>4. Click '''Save'''.
 
<br>[[File:DaysPastDue.png]]
 
 
 
  
 
'''Set the Default Finance Charge'''
 
'''Set the Default Finance Charge'''
Line 277: Line 227:
 
[[File:SetDefaultFinanceCharge.jpg]]
 
[[File:SetDefaultFinanceCharge.jpg]]
  
<br>4.      Locate the''' Finance Chg''' % field. Enter your finance charge in terms of monthly finance charge amount.  For example, enter 1.0 if you want 12% finance charge per year or 1% per month.
+
<br>4.      Locate the''' Finance Chg''' % field. Enter your finance charge in terms of yearly finance charge amount.  For example, enter 12.0 if you want 12% finance charge per year or 1% per month.
 
<br>5.      Select '''Save'''.
 
<br>5.      Select '''Save'''.
  
Line 315: Line 265:
  
 
[[File:utilities_generateFinanceCharge.jpg]]
 
[[File:utilities_generateFinanceCharge.jpg]]
 +
  
 
== Apply Deposit To Invoice ==
 
== Apply Deposit To Invoice ==
Line 341: Line 292:
 
#      In the '''Apply Prepayment window''' enter the amount of the deposit to apply to the invoice.
 
#      In the '''Apply Prepayment window''' enter the amount of the deposit to apply to the invoice.
 
#      Click '''OK'''.
 
#      Click '''OK'''.
 
 
== Post Credit to Invoice in SME ==
 
If you are syncing SME with QuickBooks, you will want to enter your credits in QuickBooks. Click [[Credits Entered in QuickBooks]] to see how the QB Credit syncs to SME. If you aren't using QuickBooks, you can apply a credit to an invoice in SME and a credit memo is generated in the Receivables module.
 
 
#      Go to the invoice you need to apply a credit to.
 
#      Click '''Actions''' > '''Post Credit'''.
 
#      In the Credit window, enter the Credit Amount and type notes if necessary. (image below)
 
#      Click '''OK'''.
 
 
[[File:CreditAmount.jpg]]
 
 
<u>View the credit on the invoice:</u>
 
#      Select the Totals tab on the invoice.
 
#      Locate the Credits field. The credit posted will be populated here. Notice the Balance Due field.
 
 
<u>Review the credit memo in Payments:</u>
 
#      In the Invoice, select the '''Payments''' tab.
 
#      Double click on the credit on the payment tab.
 
 
The Credit Memo will open in the Payments section of the Receivables module. (image below)
 
 
[[File:AppliedCredit.jpg]]
 
  
 
<h3>Credits Entered in QuickBooks</h3>
 
<h3>Credits Entered in QuickBooks</h3>
Line 387: Line 315:
  
 
<br>[[File:RetainedAsACredit.png]]
 
<br>[[File:RetainedAsACredit.png]]
 
 
== Statement ==
 
To email your customer a statement, click '''Actions''' > '''Statement'''.
 
 
Your customer will receive an email from you with an invoice attached summarizing the balance due.
 
 
[[File:Statement.jpg]]
 
 
To change the report that is emailed:
 
#    Go to '''Setup''' module > '''Company'''.
 
#    Click '''Printing'''.
 
#    Click '''AR Invoice''' in the For This Report list.
 
#    Select the report you want to use in the '''Use This Template''' drop down field.
 
 
 
== Past Due Notice ==
 
Click '''Actions''' > '''Past Due Notice''' to email your customer a past due notice for an overdue invoice. Before you do this, you need to setup your past due report in the Setup module.
 
 
Setup your Past Due Report
 
#      Go to '''Setup''' module > '''Company'''.
 
#      Click '''Printing'''.
 
#      Click '''Edit'''. (<span style="color:orange"> 1 </span>)
 
#      Select '''AR PastDue'''. (<span style="color:orange"> 2 </span>)
 
#      In the '''Use This Template''' field, select the report template you want to be sent for the past due notice. (<span style="color:orange"> 3 </span>)
 
 
[[File:PastDueTemplate.jpg]]
 
 
<h3>Notifications for Past Due Customers</h3>
 
For customers consistently late on payments or with a very large balance, you can setup a notification to notify SME Users when creating a new order that the customer is behind in the account.
 
Click [[Notifications]] to read how to setup a notification on a customer record.
 
 
== Update Customer and Billing Address ==
 
If you change the address on the site tab or billing tab for a customer record, the address on the invoice won’t automatically be updated. To update the customer address (site tab) on the invoice, Click '''Actions''' > '''Refresh From Customer'''. To update the billing address, click '''Actions''' > '''Refresh from Billing'''.
 
 
[[File:Actions_RefreshFromCustomer.jpg|left]]<br>
 
 
== Change the Invoice Billing Address or Company ==
 
 
<h3>Change the billing company on an invoice</h3>
 
#      Go to the Invoice.
 
#      Click '''Actions''' >''' Roll back Invoice'''.
 
#      Go to the order the invoice was generated from.
 
#      On the Details and Settings tab, select the '''Billing''' tab.
 
#      Click '''Change Billing Company'''.
 
#      In the Searching for Billing Company window, double click on the new billing company.
 
#      Click '''Save'''.
 
#      Click '''Actions''' > '''Generate Invoice''' to regenerate the invoice with the correct billing company.
 
 
<h3>Change the company billing address on an invoice</h3>
 
To change the billing address on an invoice, you will need to roll back the invoice, change the billing address in the customer record, and then re-invoice the order.
 
#      Go to the Invoice.
 
#      Click '''Actions''' > '''Roll back Invoice'''.
 
#      Go to the Customer and edit the billing address.
 
#      Go to the order the invoice was generated from. Click '''Actions''' > '''Generate Invoice'''.
 
 
<h3>If you need to keep the original invoice number:</h3>
 
Take a screenshot of the invoice Details and Settings tab so you can reference the invoice number, invoice date, terms etc.
 
#      In the invoice, Click Actions > Roll back Invoice.
 
#      Go to the Customer and edit the billing address.
 
#      Click Actions >New Combined Invoice.
 
#      On the Invoice, Details and Settings tab locate the Invoice # field. Click [[File:browse.jpg]] to enter the invoice number. (If you don’t see this icon, you need to add the permission to initialize numbers to your user group settings)
 
 
[[File:InvoiceNumberField.jpg]]
 
 
<br>5.      Select the '''Service Orders''' or '''Install Orders''' tab to add the service or install orders to the invoice.
 
<br>6.      Click '''Save'''
 
 
== Search Invoices ==
 
The search functionality is the same throughout SME. You can search invoices the same way you can search orders, customers and leads. You can choose which columns you are viewing in your search window, sort/group/filter by the data in each column, and export your data to excel. The different search views you setup can be saved for use later.
 
 
In Invoicing, you can click '''Search''' to search open invoices, closed invoices or all invoices.
 
 
[[File:SearchOpenInvoices.jpg]]
 
 
<h3>Find all open invoices</h3>
 
 
<br>'''-'''        Go to Receivables module > Invoicing.
 
<br>'''-'''        Click '''Search''' > '''Search Open Invoices'''.
 
<U>OR</U> simply hit '''F5''' on your keyboard to open the same search window showing all open invoices.
 
 
[[File:SearchOpenInvoices_7.1.png]]
 
<br>'''-'''        Double click on the invoice you want to open.
 
<br>'''-'''        Click on the column headers to sort by the data in the column.
 
<br>'''-'''        Add columns to the search window
 
*      Click '''Views''' > '''Add/Remove Fields'''.
 
*      In the Grid Columns window, check the columns you want to add.
 
*      Click '''OK'''.
 
*      To save the new view, click '''Views''' > '''Save View'''.
 
 
<h3>Find all overdue invoices</h3>
 
To setup a search view that will show you all overdue invoices:
 
<br>1.      Go to '''Receivables''' module > '''Invoicing'''. Click '''Search''' > '''Search Open Invoices''' OR hit '''F5''' on your keyboard to open the search open invoice window.
 
<br>2.      In the Search window, click '''Views''' > '''New View'''
 
<br>3.      In the Grid Columns window, check the following fields and any other fields you want to include.
 
 
*      Billname
 
*      CustName
 
*      InvoiceNumber
 
*      InvoiceDate
 
*      DueDate
 
*        Total
 
*      Payments
 
*      Balance
 
*        LateFees
 
 
<br>4.      Click '''OK'''.
 
<br>5.      Rearrange the order of the columns by dragging and dropping the column headers where you want them.
 
<br>6.      Set the column width by clicking your mouse between the column headers and dragging them into position.
 
<br>7.      Click [[File:FilterIcon.jpg]] at the bottom of the search window to apply the filter on the due date.
 
 
*      Click '''Press the button to add a new condition'''.
 
*      Click '''UID''' and select '''Due Date'''.
 
*      Click '''Equals''' and select '''Is Past'''.
 
*      Click '''OK'''.
 
 
<br>8.      To save the new view, click Views > Save View. Enter a name for your new view and click OK.
 

Please note that all contributions to High5Wiki may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see High5Wiki:Copyrights for details). Do not submit copyrighted work without permission!

Cancel Editing help (opens in new window)