Manual:Accounts Receivable: Difference between revisions
| Line 2: | Line 2: | ||
===Sales Order=== | ===Sales Order=== | ||
'''Menu Location:''' Inventory / Inventory Order / Order | '''Menu Location:''' Inventory / Inventory Order / Order | ||
# Order From / Ship To (Ship To defaults to Ordered By, but can be edited) | |||
# Cust PO – enter customer PO if they have one | #Order From / Ship To (Ship To defaults to Ordered By, but can be edited) | ||
# Terms – enter terms of payment (if different from default) | #Cust PO – enter customer PO if they have one | ||
# SalesPerson – enter salesperson | #Terms – enter terms of payment (if different from default) | ||
# Ship Via – enter carrier if specified | #SalesPerson – enter salesperson | ||
# Rush – check if a rush order | #Ship Via – enter carrier if specified | ||
# Due Date – enter date needed if necessary | #Rush – check if a rush order | ||
# Ship Date – displays ship date | #Due Date – enter date needed if necessary | ||
# Purchase Order Lines – enter the purchase order line items and update as needed | #Ship Date – displays ship date | ||
# Enter credit card information, if any or check C.O.D. | #Purchase Order Lines – enter the purchase order line items and update as needed | ||
#Enter credit card information, if any or check C.O.D. | |||
'''Buttons''' | '''Buttons''' | ||
:* '''Create AR Invoice''' – click to create invoice for displayed order | |||
:* '''Create PO''' – creates a purchase order for vendor | :*'''Create AR Invoice''' – click to create invoice for displayed order | ||
:* '''Print Label''' – creates shipping label | :*'''Create PO''' – creates a purchase order for vendor | ||
:* '''Create Pick List''' – creates pick list that can be printed to pick order for shipment | :*'''Print Label''' – creates shipping label | ||
:*'''Create Pick List''' – creates pick list that can be printed to pick order for shipment | |||
===Open Orders=== | ===Open Orders=== | ||
'''Menu Location:''' (Inventory / Inventory Order / Open Orders) | '''Menu Location:''' (Inventory / Inventory Order / Open Orders) | ||
:* Displays list and status of open orders | |||
:** Green = in stock | :*Displays list and status of open orders | ||
:** Yellow = partial | :**Green = in stock | ||
:** Red = Not received into inventory <br> | :**Yellow = partial | ||
:**Red = Not received into inventory <br> | |||
'''To Print Copy of Order(s):'''<br> | '''To Print Copy of Order(s):'''<br> | ||
1. Select orders using Ctrl+left mouse click on the record selection square[[File:RecordSelection.PNG]]<br> | 1. Select orders using Ctrl+left mouse click on the record selection square[[File:RecordSelection.PNG]]<br> | ||
| Line 33: | Line 38: | ||
===Inventory Receipt=== | ===Inventory Receipt=== | ||
'''Menu Location:''' Inventory / Inventory Receipt List <br> | '''Menu Location:''' Inventory / Inventory Receipt List <br> | ||
:Actual receiving of product from a BOL/packing slip | |||
:Actual receiving of product from a BOL/packing slip | |||
===Invoice Screen=== | ===Invoice Screen=== | ||
'''Menu Location:''' AR / Invoice | '''Menu Location:''' AR / Invoice | ||
: '''Buttons''' | |||
::* '''Create RMA''' - for returns a new order is created with a negative quantity to put item back into inventory | :'''Buttons''' | ||
::* '''Single Print''' – Reprints invoice | ::*'''Create RMA''' - for returns a new order is created with a negative quantity to put item back into inventory | ||
::* '''Print Labels''' – shipping labels | ::*'''Single Print''' – Reprints invoice | ||
::* '''Select Quote''' – allows for manually linking of quote to invoice (used rarely) | ::*'''Print Labels''' – shipping labels | ||
::* '''Select Order''' – allows for manually linking order to invoice | ::*'''Select Quote''' – allows for manually linking of quote to invoice (used rarely) | ||
::* '''Print ProForma''' – Similar to a packing slip (used for International Shipments) | ::*'''Select Order''' – allows for manually linking order to invoice | ||
::* '''Packing List''' – prints packing slip for shipment | ::*'''Print ProForma''' – Similar to a packing slip (used for International Shipments) | ||
::* '''Back Orders''' – prints list of back orders | ::*'''Packing List''' – prints packing slip for shipment | ||
::* '''Send Email''' – send invoice as an email | ::*'''Back Orders''' – prints list of back orders | ||
::*'''Send Email''' – send invoice as an email | |||
===Enter Invoice=== | ===Enter Invoice=== | ||
::1. Click Add | ::1. Click Add | ||
::2. Enter Bill To company | ::2. Enter Bill To company | ||
:::* Ship to will auto-populate, update if necessary | :::*Ship to will auto-populate, update if necessary | ||
::3. Enter Customer PO number, if applicable | ::3. Enter Customer PO number, if applicable | ||
::4. Enter SalesPerson, if applicable | ::4. Enter SalesPerson, if applicable | ||
| Line 67: | Line 75: | ||
===Email AR Invoices=== | ===Email AR Invoices=== | ||
'''Menu Location:''' Company | '''Menu Location:''' Company | ||
::1. Search and select Company | ::1. Search and select Company | ||
::2. Click the Addresses Tab | ::2. Click the Addresses Tab | ||
| Line 75: | Line 84: | ||
:::• '''Payment Email''' – enter email payment confirmation should be sent to | :::• '''Payment Email''' – enter email payment confirmation should be sent to | ||
::4. Click Save | ::4. Click Save | ||
===Email a Single Invoice=== | ===Email a Single Invoice=== | ||
'''Menu Location:''' AR / Invoice | '''Menu Location:''' AR / Invoice | ||
::1. Search and select the Invoice you want to email | ::1. Search and select the Invoice you want to email | ||
::2. Click[[File:Send_Email.png]] | ::2. Click[[File:Send_Email.png]] | ||
| Line 89: | Line 100: | ||
===Email Multiple Invoices=== | ===Email Multiple Invoices=== | ||
'''Menu Location:''' AR / Email Invoice Utility<br> | '''Menu Location:''' AR / Email Invoice Utility<br> | ||
:Note: One-time setup per customer is required (see Invoice Email Setup above)<br> | :Note: One-time setup per customer is required (see Invoice Email Setup above)<br> | ||
| Line 101: | Line 113: | ||
===Pay AR Invoice=== | ===Pay AR Invoice=== | ||
'''Menu Location:''' AR / Pay AR Invoice | '''Menu Location:''' AR / Pay AR Invoice | ||
::1. Select Company | ::1. Select Company | ||
::2. Select invoice(s) to apply payment to | ::2. Select invoice(s) to apply payment to | ||
:::* To select multiple Invoices use Ctrl+left mouse click on[[File:RecordSelection.PNG]] | :::*To select multiple Invoices use Ctrl+left mouse click on[[File:RecordSelection.PNG]] | ||
:::* If amount is less than invoice amount, highlight row and enter Amount Paid and Amount Credited, and then tab through the row | :::*If amount is less than invoice amount, highlight row and enter Amount Paid and Amount Credited, and then tab through the row | ||
:::* Amount to Pay will auto-calculate based on invoices selected | :::*Amount to Pay will auto-calculate based on invoices selected | ||
::3. Enter '''Payment Type''' | ::3. Enter '''Payment Type''' | ||
:::* If Check, select Check | :::*If Check, select Check | ||
:::** Enter Check No. in '''Check / Ref #''' | :::**Enter Check No. in '''Check / Ref #''' | ||
:::* If Credit Card, select Credit Card | :::*If Credit Card, select Credit Card | ||
:::**A dialog box will appear for entry of credit card information | :::**A dialog box will appear for entry of credit card information | ||
:::* Other Payments Types may be available: | :::*Other Payments Types may be available: | ||
:[[File:AR_Payment_Types.PNG]] | :[[File:AR_Payment_Types.PNG]] | ||
===Payment History=== | ===Payment History=== | ||
Menu Location: AR / Payment History | Menu Location: AR / Payment History | ||
:Shows all payments | :Shows all payments | ||
===Create Deposit=== | ===Create Deposit=== | ||
'''Menu Location:''' AR / Create Deposit | '''Menu Location:''' AR / Create Deposit | ||
:Shows list of all checks received | :Shows list of all checks received | ||
::1. Select records for the individual deposit | ::1. Select records for the individual deposit | ||
:::* To select multiple Invoices use Ctrl+left mouse click on | :::*To select multiple Invoices use Ctrl+left mouse click on | ||
::2. Click Create Deposit | ::2. Click Create Deposit | ||
::3. Select Receipts for this Deposit | ::3. Select Receipts for this Deposit | ||
:::* To select multiple Invoices use Ctrl+left mouse click on | :::*To select multiple Invoices use Ctrl+left mouse click on | ||
:::* Verify Total at bottom | :::*Verify Total at bottom | ||
::4. Click Create Deposit | ::4. Click Create Deposit | ||
:::* The amount of deposit will match the amount on deposit slip provided to your bank | :::*The amount of deposit will match the amount on deposit slip provided to your bank | ||
===Create EDI Invoices=== | ===Create EDI Invoices=== | ||
EDI = Electronic Data Interchange | EDI = Electronic Data Interchange | ||
:Sends electronic versions of invoices to customers | :Sends electronic versions of invoices to customers | ||
===Reports=== | ===Reports=== | ||
::* Open Orders | |||
::* Aging Report – lists of everyone owing money | ::*Open Orders | ||
::* Statement – lists of all invoices with amounts credited and what is still due | ::*Aging Report – lists of everyone owing money | ||
::* Sales Tax Return – sales tax on total gross sales report | ::*Statement – lists of all invoices with amounts credited and what is still due | ||
::*Sales Tax Return – sales tax on total gross sales report | |||
::**See insight reporting / Accounts Receivable for all available AR reports. | |||
===Enter a Purchase Order=== | ===Enter a Purchase Order=== | ||
:'''Menu Location:''' Inventory / Inventory PO / Purchase Order | :'''Menu Location:''' Inventory / Inventory PO / Purchase Order | ||
::1. Order From – enter Company Name | ::1. Order From – enter Company Name | ||
| Line 151: | Line 170: | ||
===Receive and Invoice Purchase Order=== | ===Receive and Invoice Purchase Order=== | ||
'''Menu Location:''' Inventory / Inventory PO / Purchase Order | '''Menu Location:''' Inventory / Inventory PO / Purchase Order | ||
::1. Search for Purchase Order | ::1. Search for Purchase Order | ||
::2. Click Receive PO | ::2. Click Receive PO | ||
::[[File:AR_Unassigned_Receipts.png]] | ::[[File:AR_Unassigned_Receipts.png]] | ||
::3. Click Yes | ::3. Click Yes | ||
:::* Creates an Inventory Receipt List | :::*Creates an Inventory Receipt List | ||
::[[File:AR_Inventory_Receipt_List.png]] | ::[[File:AR_Inventory_Receipt_List.png]] | ||
:::* From the Inventory Receipt List an Invoice can be created by clicking the “Create Invoice” button | :::*From the Inventory Receipt List an Invoice can be created by clicking the “Create Invoice” button | ||
===Enter an Invoice=== | ===Enter an Invoice=== | ||
'''Menu Location:''' AR / Invoice (the last invoice entered is displayed) | '''Menu Location:''' AR / Invoice (the last invoice entered is displayed) | ||
:1. Select [[File:Add.png]] from the Toolbar | :1. Select [[File:Add.png]] from the Toolbar | ||
:2. Enter Bill To Company | :2. Enter Bill To Company | ||
| Line 175: | Line 196: | ||
===Create an Invoice from an Existing Quote or Order=== | ===Create an Invoice from an Existing Quote or Order=== | ||
'''Menu Location:''' AR / Invoice | '''Menu Location:''' AR / Invoice | ||
::1. To Select an existing Quote, click [[File:Select_Quote.png]] | |||
::1. To Select an existing Quote, click [[File:Select_Quote.png]] | |||
::2. To select an existing Order, click [[File:Select Order.png]] | ::2. To select an existing Order, click [[File:Select Order.png]] | ||
:::* Information will auto-populate from existing Quote or Order and fields can be updated as necessary. | :::*Information will auto-populate from existing Quote or Order and fields can be updated as necessary. | ||
'''Verify the following:''' | '''Verify the following:''' | ||
::a. Date (typically the date of Sale) | ::a. Date (typically the date of Sale) | ||
:: b. Customer Name (if Company name does not exist, click Add Record) | ::b. Customer Name (if Company name does not exist, click Add Record) | ||
::c. Person (optional) | ::c. Person (optional) | ||
::d. Bill To and Ship To Addresses will automatically populate. If different, remove displayed address by clicking on – sign and then click on + sign to choose existing address from Address Table (or add new if needed) | ::d. Bill To and Ship To Addresses will automatically populate. If different, remove displayed address by clicking on – sign and then click on + sign to choose existing address from Address Table (or add new if needed) | ||
Revision as of 21:17, 12 May 2020
Accounts Receivable
Sales Order
Menu Location: Inventory / Inventory Order / Order
- Order From / Ship To (Ship To defaults to Ordered By, but can be edited)
- Cust PO – enter customer PO if they have one
- Terms – enter terms of payment (if different from default)
- SalesPerson – enter salesperson
- Ship Via – enter carrier if specified
- Rush – check if a rush order
- Due Date – enter date needed if necessary
- Ship Date – displays ship date
- Purchase Order Lines – enter the purchase order line items and update as needed
- Enter credit card information, if any or check C.O.D.
Buttons
- Create AR Invoice – click to create invoice for displayed order
- Create PO – creates a purchase order for vendor
- Print Label – creates shipping label
- Create Pick List – creates pick list that can be printed to pick order for shipment
Open Orders
Menu Location: (Inventory / Inventory Order / Open Orders)
- Displays list and status of open orders
- Green = in stock
- Yellow = partial
- Red = Not received into inventory
- Displays list and status of open orders
To Print Copy of Order(s):
1. Select orders using Ctrl+left mouse click on the record selection square
2. Click Print Selected Orders
3. Check either box that applies and then click OK
4. After clicking OK, you will then see the ReportPreview, which you can then either save or print.
Inventory Receipt
Menu Location: Inventory / Inventory Receipt List
- Actual receiving of product from a BOL/packing slip
Invoice Screen
Menu Location: AR / Invoice
- Buttons
- Create RMA - for returns a new order is created with a negative quantity to put item back into inventory
- Single Print – Reprints invoice
- Print Labels – shipping labels
- Select Quote – allows for manually linking of quote to invoice (used rarely)
- Select Order – allows for manually linking order to invoice
- Print ProForma – Similar to a packing slip (used for International Shipments)
- Packing List – prints packing slip for shipment
- Back Orders – prints list of back orders
- Send Email – send invoice as an email
Enter Invoice
- 1. Click Add
- 2. Enter Bill To company
- Ship to will auto-populate, update if necessary
- 3. Enter Customer PO number, if applicable
- 4. Enter SalesPerson, if applicable
- 5. Enter Ship Via, if preference
- 6. Enter AR Invoice Lines
- a. Select Code
- b. Enter Quantity
- c. Enter Part Number
- d. Enter Price (if different from default)
- e. Tab through Total
- f. If Tax Exempt, uncheck Tax box
- g. Enter Comment if needed
- h. Click Save
Email AR Invoices
Menu Location: Company
- 1. Search and select Company
- 2. Click the Addresses Tab
- 3. Complete the information in the Send Email area
- • Email Invoice – check if invoice should be emailed to customer
- • Invoice Email – enter email address invoice should be sent to
- • Payment Email – enter email payment confirmation should be sent to
- 4. Click Save
Email a Single Invoice
Menu Location: AR / Invoice
Email Multiple Invoices
Menu Location: AR / Email Invoice Utility
- Note: One-time setup per customer is required (see Invoice Email Setup above)
- 1. Run the Email Invoice Utility
- 2. Complete the box with the correct criteria and click OK
- • This will send the corresponding invoice(s) to all the companies that fit the criteria

- • Upon clicking OK the emails are sent, and a report is generated showing all the invoices that were sent. If any errors occur, make the necessary corrections to the email address and use the single email method above.
- If there are several invoices for a company, invoices will be combined into one .PDF file and one email will be sent to the company.
Pay AR Invoice
Menu Location: AR / Pay AR Invoice
- 1. Select Company
- 2. Select invoice(s) to apply payment to
- 3. Enter Payment Type
- If Check, select Check
- Enter Check No. in Check / Ref #
- If Credit Card, select Credit Card
- A dialog box will appear for entry of credit card information
- Other Payments Types may be available:
- If Check, select Check
Payment History
Menu Location: AR / Payment History
- Shows all payments
Create Deposit
Menu Location: AR / Create Deposit
- Shows list of all checks received
- 1. Select records for the individual deposit
- To select multiple Invoices use Ctrl+left mouse click on
- 2. Click Create Deposit
- 3. Select Receipts for this Deposit
- To select multiple Invoices use Ctrl+left mouse click on
- Verify Total at bottom
- 4. Click Create Deposit
- The amount of deposit will match the amount on deposit slip provided to your bank
- 1. Select records for the individual deposit
Create EDI Invoices
EDI = Electronic Data Interchange
- Sends electronic versions of invoices to customers
Reports
- Open Orders
- Aging Report – lists of everyone owing money
- Statement – lists of all invoices with amounts credited and what is still due
- Sales Tax Return – sales tax on total gross sales report
- See insight reporting / Accounts Receivable for all available AR reports.
Enter a Purchase Order
- Menu Location: Inventory / Inventory PO / Purchase Order
- 1. Order From – enter Company Name
- 2. Ship To – enter Ship To Company Name
- 3. Enter Purchase Order Lines
- a. Enter Quantity
- b. Select Part Number
- c. Update Price
Receive and Invoice Purchase Order
Menu Location: Inventory / Inventory PO / Purchase Order
Enter an Invoice
Menu Location: AR / Invoice (the last invoice entered is displayed)
- 1. Select
from the Toolbar - 2. Enter Bill To Company
- 3. Enter Ship To Company if different from Bill To Company
- 4. Enter Customer PO if provided
- 5. Enter Ship Via if specified
- 6. Enter SalesPerson if applicable
- 7. Enter AR Invoice Lines
- a. Enter Code
- b. Enter Quantity
- c. Enter part number (Select from inventory list)
- d. Verify Price
Create an Invoice from an Existing Quote or Order
Menu Location: AR / Invoice
Verify the following:
- a. Date (typically the date of Sale)
- b. Customer Name (if Company name does not exist, click Add Record)
- c. Person (optional)
- d. Bill To and Ship To Addresses will automatically populate. If different, remove displayed address by clicking on – sign and then click on + sign to choose existing address from Address Table (or add new if needed)
- e. Customer’s PO number, if applicable
- f. SalesPerson, if applicable
- g. Code (usually P1 for Inventory Sales or S1 for Service)
- h. Quantity
- i. Part Desc will auto-populates from the Inventory Table
- j. Line Desc will auto-populate from the Inventory Table
- k. Unit of product being sold (i.e. each, case, bottle, etc.)
- l. Price (Unit) you are charging customer
- m. Price will auto-calculate; Tab through fields
- n. If item is nontaxable, tab to and uncheck this box
- o. Comments pertaining to this invoice, if applicable
- p. Click Save


