Difference between revisions of "Sales Invoice"

(Tag: 2017 source edit)
Line 7: Line 7:
  
 
*The user should setup the following [[Maintenance]] Module in order to proceed on using the [[Sales Invoice]]
 
*The user should setup the following [[Maintenance]] Module in order to proceed on using the [[Sales Invoice]]
*#[[Customer]]
+
*# [[Customer]]
*For detailed instructions on how to setup the needed [[Maintenance]] Module, the user may visit the following Job Aid pages:
+
*# [[Item Master]]
*#[[Customer Aids]]
+
*# [[Warehouse]]
 
+
* The user must have the following record in order to proceed on using the [[Sales Invoice]]
*The customer should have a [[Sales Order]] and [[Delivery Receipt]] Record in order to create a Sales Invoice. Instructions on how to create the following records can be found below:
+
*# [[Sales Order]]
*#[[Sales Order Aids]]
+
*# [[Delivery Receipt]]
*#[[Delivery Receipt Aids]]
 
  
 +
{| class="wikitable" style="box-sizing: inherit; border-collapse: collapse; border-spacing: 0px; background-color: rgb(248, 249, 250); font-size: 14px; color: rgb(34, 34, 34); margin: auto; border: 1px solid rgb(162, 169, 177); font-family: "Open Sans", Roboto, arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"
 +
|+ style="box-sizing: inherit; padding-top: 8px; padding-bottom: 8px; color: rgb(119, 119, 119); text-align: left; font-weight: bold;" |Sales Invoice Record Status
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |'''Status'''
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |'''Description'''
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''UNPAID'''
 +
| style="" |If the Sales Invoice has been created
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''PARTIAL'''
 +
| style="" |If the Sales Invoice has been paid partially.
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''PAID'''
 +
| style="" |If the Sales Invoice items has been completely paid.
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''CANCELLED'''
 +
| style="" |If the Sales Invoice is cancelled.
 +
|}
 +
<br />
 
=====Sales Invoice Record List=====
 
=====Sales Invoice Record List=====
[[File:Sales Invoice Record List.png|center|thumb|Sales Invoice Record List]]
+
=====Creating Sales Invoice=====
  
=====Adding Sales Invoice=====
+
# Go to Sales then Click [[Sales Invoice]]
[[File:Adding Sales InvoiceV2.png|center|thumb|862x862px|Adding Sales Invoice]]
+
# Click '''Add Sales Invoice'''
 
+
# Choose Customer then Tag the [[Delivery Receipt]]
*'''Adding Sales Invoice Information'''
+
# Fill up the Necessary Fields then Click '''Save'''
  
 +
<br />
 
{| class="wikitable"
 
{| class="wikitable"
!Field
+
|+Creating Sales Invoice Information
!Description
+
!'''Field'''
!Expected
+
!'''Description'''
 +
!'''Expected Values'''
 
|-
 
|-
 
|1.Invoice Date
 
|1.Invoice Date
Line 32: Line 51:
 
|•Date
 
|•Date
 
|-
 
|-
|2.Reference
+
|2.Customer
|•Reference number of the Invoice Transaction
+
|•Name of Customer
|•Text
+
|•Customer List from Customer Maintenance Module
 +
|-
 +
|3.Delvery Receipt Number
 +
|•Delivery Receipt to be Invoiced
 +
|•Delivery Receipt List from the assigned Customer in Delivery Receipt Module
 +
|-
 +
|4.TIN
 +
|•TIN Number of the Customer
 +
|•Auto-generated base from customer information in Customer Maintenance Module
 
|-
 
|-
|3.Due Date
+
|5.Terms
|•Due date of the Sales Invoice
+
|•Number of Days for the customer to settle the sales transaction
|•Date
+
|•Auto-generated base from customer information in Customer Maintenance Module
 
|-
 
|-
|4.Notes
+
|6.Address
|•Other Remarks for the transaction
+
|•Name of Customer
|•Text
+
|•Set of Customer List provided in Customer Maintenance Module
|}Notes:
 
 
 
*Item Details cannot be edited on the Sales Invoice.
 
**Item Details can only be edited when reverting back the [[Delivery Receipt]] status to '''PREPARED'''
 
**Any updates done in the [[Delivery Receipt]] will be carry over when tagging it to Sales Invoice.
 
*For detailed steps on how to create a Sales Invoice, you can visit the Sales Invoice Job Aids which can be found [[Sales Invoice Aids|here]]
 
 
 
=====Editing Sales Invoice=====
 
[[File:Editing Sales InvoiceV2.png|center|thumb|855x855px|Editing Sales Invoice]]
 
 
 
*'''Editing Sales Invoice Information'''
 
 
 
{| class="wikitable"
 
!Field
 
!Description
 
!Expected Values
 
 
|-
 
|-
|1.Invoice Date
+
|7.Invoice Date
 
|•Date when the transaction has been invoiced.
 
|•Date when the transaction has been invoiced.
 
|•Date
 
|•Date
 
|-
 
|-
|2.Reference
+
|8.Reference
 
|•Reference number of the Invoice Transaction
 
|•Reference number of the Invoice Transaction
 
|•Text
 
|•Text
 
|-
 
|-
|3.Due Date
+
|9.Due Date
 
|•Due date of the Sales Invoice
 
|•Due date of the Sales Invoice
 
|•Date
 
|•Date
 
|-
 
|-
|4.Notes
+
|10.Notes
 
|•Other Remarks for the transaction
 
|•Other Remarks for the transaction
 
|•Text
 
|•Text
|}Notes:
+
|-
 +
|11.Item
 +
|•List of Items to be Invoiced
 +
|•Item List provided in the Item Master Maintenance Module
 +
|-
 +
|12.Description
 +
|•Description of the Item
 +
|•Alphanumeric
 +
|-
 +
|13.Quantity
 +
|•Quantity of items to be delivered
 +
|•Numeric
 +
|-
 +
|14.Unit of Measure
 +
|•Unit of Measure of the Item
 +
|•Types of Unit of Measure provided in the Unit of Measure Maintenance Module.
 +
|-
 +
|15.Price
 +
|•Initial price per unit of item
 +
|•Numeric
 +
|-
 +
|16.Discount
 +
|•Discount Amount to be applied on the item depending on the Discount type chosen.
 +
|•Numeric
 +
|-
 +
|17.Tax
 +
|•Quantity of items to be delivered
 +
|•Numeric
 +
|-
 +
|18.Amount
 +
|•Total Amount of the Item
 +
|•Numeric(Auto-generated)
 +
|}
 +
Notes:
  
 
*Item Details cannot be edited on the Sales Invoice.
 
*Item Details cannot be edited on the Sales Invoice.
**Item Details can only be edited when reverting back the [[Delivery Receipt]] status to "PREPARED"
+
**Item Details can only be edited when reverting back the [[Delivery Receipt]] status to '''PREPARED'''
 
**Any updates done in the [[Delivery Receipt]] will be carry over when tagging it to Sales Invoice.
 
**Any updates done in the [[Delivery Receipt]] will be carry over when tagging it to Sales Invoice.
*For detailed steps on how to edit a Sales Invoice, you can visit the Sales Invoice Job Aids which can be found [[Sales Invoice Aids|here]]
 
  
 
=====Sales Invoice Options=====
 
=====Sales Invoice Options=====
[[File:Sales Invoice Options.png|center|thumb|Sales Invoice Options]]
+
{| class="wikitable" style="box-sizing: inherit; border-collapse: collapse; border-spacing: 0px; background-color: rgb(248, 249, 250); font-size: 14px; color: rgb(34, 34, 34); margin: auto; border: 1px solid rgb(162, 169, 177); font-family: &quot;Open Sans&quot;, Roboto, arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"
 
+
|+ style="box-sizing: inherit; padding-top: 8px; padding-bottom: 8px; color: rgb(119, 119, 119); text-align: left; font-weight: bold;" |Actions Available base on Sales Invoice Record Status
*For detailed steps on how to export a Sales Invoice, you can visit the Sales Invoice Job Aids which can be found [[Sales Invoice Aids|here]]
+
! style="background-color:rgb(234, 236, 240);text-align:center;" |Status
 
+
! style="background-color:rgb(234, 236, 240);text-align:center;" |View
=====Sales Invoice Record Options=====
+
! style="background-color:rgb(234, 236, 240);text-align:center;" |Edit
[[File:Sales Invoice Record Options.png|center|thumb|Sales Invoice Record Options]]Notes:
+
! style="background-color:rgb(234, 236, 240);text-align:center;" |Print Invoice
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Export to CSV
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Cancel
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''UNPAID'''
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''PARTIAL'''
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''PAID'''
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |
 +
|- style="box-sizing: inherit;"
 +
| style="background-color:rgb(248, 249, 250);text-align:start;" |'''CANCELLED'''
 +
| style="background-color:rgb(248, 249, 250);vertical-align:middle;text-align:center;" |☑
 +
| style="background-color:rgb(248, 249, 250);vertical-align:middle;text-align:center;" |
 +
| style="background-color:rgb(248, 249, 250);vertical-align:middle;text-align:center;" |☑
 +
| style="background-color:rgb(248, 249, 250);vertical-align:middle;text-align:center;" |☑
 +
|
 +
|}
 +
Notes:
  
 +
*The user may edit the details of the record while viewing the record.
 
*The user can only delete the Sales Invoice record if it is on '''UNPAID''' status.
 
*The user can only delete the Sales Invoice record if it is on '''UNPAID''' status.
 
*Cancelling the Sales Invoice Record can revert the status of Delivery Receipt to '''PREPARED'''.
 
*Cancelling the Sales Invoice Record can revert the status of Delivery Receipt to '''PREPARED'''.
 
*Records that has '''PAID''' status can only be reverted to UNPAID if the [[Receipt Voucher]] entry has been cancelled.
 
*Records that has '''PAID''' status can only be reverted to UNPAID if the [[Receipt Voucher]] entry has been cancelled.
*For detailed steps on how to View, Edit, Print and Export a Sales Invoice, you can visit the Sales Invoice Job Aids which can be found [[Sales Invoice Aids|here]]
 
  
=====Sales Invoice View Record=====
+
{| class="wikitable" style="margin: auto;"
[[File:Sales Invoice View Record.png|center|thumb|Sales Invoice View Record]]
 
<br />Notes:
 
 
 
*The user can edit the details of the record while viewing it
 
 
 
{| class="wikitable"
 
 
|+Categories:
 
|+Categories:
 
! colspan="2" |'''Modules'''
 
! colspan="2" |'''Modules'''
Line 112: Line 181:
 
|-
 
|-
 
|Maintenance
 
|Maintenance
|[[Customer]]<nowiki> | </nowiki>[[Item Master]]<nowiki> | </nowiki>[[Tax]]
+
|[[Customer]]<nowiki> | </nowiki>[[Item Master]]<nowiki> | </nowiki>[[Warehouse]]
 
|-
 
|-
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
|-
 
|Sales Aids
 
|[[Sales Quotation Aids]]<nowiki> | </nowiki>[[Sales Order Aids]]<nowiki> | </nowiki>[[Delivery Receipt]]<nowiki> | </nowiki>[[Sales Invoice]]
 
|-
 
|Financials
 
|[[Accounts Receivable Aids]]<nowiki> | </nowiki>[[Receipt Voucher Aids]]
 
 
|-
 
|-
 
|Maintenance Aids
 
|Maintenance Aids
|[[Customer Aids]]<nowiki> | </nowiki>[[Item Master Aids]]<nowiki> | </nowiki>[[Tax Aids]]
+
|[[Customer Aids]]<nowiki> | </nowiki>[[Item Master Aids]]<nowiki> | </nowiki>[[Warehouse Aids]]
 
|-
 
|-
 
|Others
 
|Others
 
|[[Sales Process]]
 
|[[Sales Process]]
 
|}<br />
 
|}<br />

Revision as of 13:22, 25 November 2021

Sales Invoice

This module allows the user to keep track the status of the transactions of a customer if it is Unpaid, Partial Payment, Paid or Cancelled.

Requirements before using Sales Invoice
Sales Invoice Record Status
Status Description
UNPAID If the Sales Invoice has been created
PARTIAL If the Sales Invoice has been paid partially.
PAID If the Sales Invoice items has been completely paid.
CANCELLED If the Sales Invoice is cancelled.


Sales Invoice Record List
Creating Sales Invoice
  1. Go to Sales then Click Sales Invoice
  2. Click Add Sales Invoice
  3. Choose Customer then Tag the Delivery Receipt
  4. Fill up the Necessary Fields then Click Save


Creating Sales Invoice Information
Field Description Expected Values
1.Invoice Date •Date when the transaction has been invoiced. •Date
2.Customer •Name of Customer •Customer List from Customer Maintenance Module
3.Delvery Receipt Number •Delivery Receipt to be Invoiced •Delivery Receipt List from the assigned Customer in Delivery Receipt Module
4.TIN •TIN Number of the Customer •Auto-generated base from customer information in Customer Maintenance Module
5.Terms •Number of Days for the customer to settle the sales transaction •Auto-generated base from customer information in Customer Maintenance Module
6.Address •Name of Customer •Set of Customer List provided in Customer Maintenance Module
7.Invoice Date •Date when the transaction has been invoiced. •Date
8.Reference •Reference number of the Invoice Transaction •Text
9.Due Date •Due date of the Sales Invoice •Date
10.Notes •Other Remarks for the transaction •Text
11.Item •List of Items to be Invoiced •Item List provided in the Item Master Maintenance Module
12.Description •Description of the Item •Alphanumeric
13.Quantity •Quantity of items to be delivered •Numeric
14.Unit of Measure •Unit of Measure of the Item •Types of Unit of Measure provided in the Unit of Measure Maintenance Module.
15.Price •Initial price per unit of item •Numeric
16.Discount •Discount Amount to be applied on the item depending on the Discount type chosen. •Numeric
17.Tax •Quantity of items to be delivered •Numeric
18.Amount •Total Amount of the Item •Numeric(Auto-generated)

Notes:

  • Item Details cannot be edited on the Sales Invoice.
    • Item Details can only be edited when reverting back the Delivery Receipt status to PREPARED
    • Any updates done in the Delivery Receipt will be carry over when tagging it to Sales Invoice.
Sales Invoice Options
Actions Available base on Sales Invoice Record Status
Status View Edit Print Invoice Export to CSV Cancel
UNPAID
PARTIAL
PAID
CANCELLED

Notes:

  • The user may edit the details of the record while viewing the record.
  • The user can only delete the Sales Invoice record if it is on UNPAID status.
  • Cancelling the Sales Invoice Record can revert the status of Delivery Receipt to PREPARED.
  • Records that has PAID status can only be reverted to UNPAID if the Receipt Voucher entry has been cancelled.
Categories:
Modules
Sales Sales | Sales Quotation | Sales Order | Delivery Receipt | Sales Invoice
Financials Accounts Receivable | Receipt Voucher
Maintenance Customer | Item Master | Warehouse
Job Aid Modules
Maintenance Aids Customer Aids | Item Master Aids | Warehouse Aids
Others Sales Process