Wiki

Case Status
Log In

Wiki

 
Customizable Invoice Report - …
  • RSS Feed

Last modified on 2/20/2015 9:50 AM by User.

Customizable Invoice Report - Reference For IFields

Overview

This article serves as a reference for the report fields of a customizable invoice report.  It focuses on the money content of an invoice and how the customizable invoice report calculates values for the suite of earnings, commission, overage, received and receivable report fields.  
 

Types of Invoices

There are three types of orders:  Commissioned, Customer, and Vendor.  Likewise, there are three types of invoices that correspond to these orders.
 
Commissioned Invoices

Commissioned invoices reference material, freight, tax, etc in reference to their sell amounts.  They also contain amounts for commission and overage.  Any payments for this invoice will be for amounts to be received from the customer to cover amounts of commission and overage.  

Customer Invoices
Customer invoices reference material, freight, tax, etc. in reference to their sell amounts. There are no commissions or overages.  Any payments for this invoice will be amounts received from the customer to cover the sell amount charged to the customer for the material, freight, tax, etc.

Vendor Invoices
Vendor invoices reference material, freight, tax, etc. in reference to their cost amounts.  They also contain amounts for commission and overage.  Payments exist in two categories:
1)  Payments can be for the amount to be received from the vendor to cover overage and commission charges on the vendor invoice.
2)  Payment can be for the amount to be paid to the vendor to cover the cost of material, freight, tax, etc.

 

Report Fields

There are a set of report fields that are the basis for all other report fields used in customizable invoice reports.  Each of these report fields contain conditional logic based on the type of invoice being processed.  The table below indicates if a value is calculated or not for the three invoice types.  

Report Field Commissioned Customer Vendor
Commission yes no yes
Overage yes no yes
OverageSplit* yes no yes
Profit no yes no
Material Cost no no yes
Material Sell yes yes no
Freight Cost no no yes
Freight Sell yes yes no
Restock Cost no no yes
Restock Sell yes yes no
Misc. Cost no no yes
Misc. Sell yes yes no
Tax yes yes yes

Note that cost fields are calculated only in vendor invoices.  Sell fields are calculated in commissioned and customer invoices but not vendor invoices.  Commission and overage fields are calculated in commissioned and vendor invoices but not in customer invoices.

* OverageSplit is the split of the overage that is kept as a part of earnings.

 

These report fields build off the report fields above and are also the basis of other report fields used in customizable invoice reports..

Report Field Calculation
InvoiceSellAmount MaterialSell + FreightSell + RestockSell + MiscSell + Tax
InvoiceCostAmount MaterialCost + FreightCost + RestockCost + MiscCost + Tax
TerritoryCommissionCredit Commission * TerritoryCommissionPercentage(agency % of commission)
TerritoryOverageCredit OverageSplit * TerritoryOveragePercentage (agency % of overagesplit)
TerritorySalesCredit InvoiceSellAmount * TerritorySalesPercentage (agency % of sales)

 

Earnings
Earnings are based on the amount of money expected to be received from the customer or vendor.  On a commissioned invoice, earnings are based on the commission and the overage split of the overage.  The same is true for vendor invoices.  For customer invoices, the earnings are from the profit of sell of material, freight, restock, etc. less the cost of material, freight, restock, etc.  For customer invoices, the report fields Profit and Earnings are synonymous.

Invoice Type Calculation
commissioned invoice Commission + OverageSplit
customer invoice sell (material, freight, restock, etc) - cost (material, freight, restock, etc)
vendor invoice Commission + OverageSplit

 

Profit
Profit is a specialized case of Earnings.  It is only calculated for customer invoices.

Invoice Type Calculation
commissioned invoice no value
customer invoice sell (material, freight, restock, etc) - cost (material, freight, restock, etc)
vendor invoice no value

 

TerritoryEarningsCredit
TerritoryEarningsCredit are the agency's cut of the earnings from a commissioned or vendor invoice.

Invoice Type Calculation
commissioned invoice TerritoryCommissionCredit + TerritoryOverageCredit
customer invoice Profit
vendor invoice TerritoryCommissionCredit + TerritoryOverageCredit


Received Report Fields

Invoice reports contain a suite of 'Received' report fields.  These fields represent the amount of money received in the form of posted payments in Oasis.



Received
The Received report field indicates the total amount of posted payments received for an invoice.  For commissioned and vendor invoices, payments are made for earnings only (commission and overage).  For customer invoices, payments are made to pay for material, freight, restock, etc.  Within this payment is an implicit amount that applies to the earnings/profit of the customer invoice.

Invoice Type Calculation
commissioned invoice Total amount of all payments posted for the invoice.  (will be payments for commission and overage only)
customer invoice Total amount of all payments posted for the invoice.  (will be payments for earnings and material, freight, restock, etc.)
vendor invoice Total amount of all payments posted for the invoice.  (will be payments for commission and overage only)


Received Earnings
For commissioned and vendor invoices, Received and Received Earnings are the same (since payments are only made for earnings on these invoice types).  However, customer invoices are different.  Payments are for material, freight, restock, etc. but implicitly include amounts for Earnings (sell - cost).  Therefore, the portion of a payment that belongs to earnings must be calculated.

Invoice Type Calculation
commissioned invoice Total amount of all payments posted for the invoice.  (will be payments for commission and overage only)
customer invoice (Earnings / InvoiceSellAmount) * Received
vendor invoice Total amount of all payments posted for the invoice.  (will be payments for commission and overage only)

 

Received Profit
ReceivedProfit is a specialized case of ReceivedEarnings.  It is only calculated for customer invoices.  It is synonymous with received earnings of a customer invoice. 

Invoice Type Calculation
commissioned invoice no value
customer invoice (Earnings / InvoiceSellAmount) * Received
vendor invoice no value
 

 

Received Commission
For commissioned and vendor invoices, payments are for earnings.  Earnings include commission and overage.  Therefore, the portion of commission within the earnings must be calculated.  Customer invoices do not include commission.

Invoice Type Calculation
commissioned invoice (Commission / Earnings) * Received
customer invoice no value
vendor invoice (Commission / Earnings) * Received

 

Received Overage Split
For commissioned and vendor invoices, payments are for earnings.  Earnings include commission and overage.  Therefore, the portion of overage within the earnings must be calculated.  Also note that this is the overage split of the overage.  Customer invoices do not include overage.

Invoice Type Calculation
commissioned invoice (OverageSplit/ Earnings) * Received
customer invoice no value
vendor invoice (OverageSplit/ Earnings) * Received

 

Receivable Report Fields

Invoice reports contain a suite of 'Receivable' report fields.  These fields represent the amount of money to be received less the amount of money already received in the form of posted payments in Oasis.



Receivable
The Receivable report field indicates the total amount of money still to be received for an invoice.  For commissioned and vendor invoices, what is to be received is payment for earnings of the invoice.  For customer invoices, what is to be received is payment for material, freight, restock, etc.

Invoice Type Calculation
commissioned invoice Earnings - Received
customer invoice InvoiceSellAmount - Received
vendor invoice Earnings - Received

 

Receivable Earnings
The Receivable Earnings report field indicates the portion of earnings still to be received for an invoice.  For commissioned and vendor invoices, what is to be received is payment for earnings of the invoice.  Therefore, Receivable and Receivable Earnings are synonymous for commissioned and vendor invoices.  For customer invoices, what is to be received is payment for material, freight, restock, etc. but implicitly include amounts for Earnings (sell - cost).  Therefore, the portion of a payment that belongs to earnings must be calculated (which is done in ReceivedEarnings).

Invoice Type Calculation
commissioned invoice Earnings - Received
customer invoice Earnings - ReceivedEarnings
vendor invoice Earnings - Received

 

Receivable Profit

ReceivableProfit is a specialized case of ReceivableEarnings.  It is only calculated for customer invoices.  It is synonymous with receivable earnings of a customer invoice. 

Invoice Type Calculation
commissioned invoice no value
customer invoice Profit - ReceivedProfit
vendor invoice no value

 

Receivable Commission
The Receivable Commission report field indicates the portion of commission still to be received for an invoice.  For commissioned and vendor invoices, what is to be received is payment for earnings of the invoice.  Earnings include commission and overage.  Therefore, the portion of a payment that belongs to commissions must be calculated (which is done in ReceivedCommission).  Customer invoices do not include commission.

Invoice Type Calculation
commissioned invoice Commission - ReceivedCommission
customer invoice no value
vendor invoice Commission - ReceivedCommission

 

Receivable Overage Split
The Receivable Overage Split report field indicates the portion of overagesplit still to be received for an invoice. For commissioned and vendor invoices, what is to be received is payment for earnings of the invoice.  Earnings include commission and overage.  Therefore, the portion a payment that belongs to overage within the earnings must be calculated (which is done in ReceivedOverageSplit).  Also note that this is the overage split of the overage.  Customer invoices do not include overage.

Invoice Type Calculation
commissioned invoice OverageSplit - ReceivedOverageSplit
customer invoice no value
vendor invoice OverageSplit - ReceivedOverageSplit

 

Other Report Fields

The remaining report fields are for vendor invoices created to make payments to vendors.

 

Paid
Paid is the total amount of money paid to a vendor.  It is only valid for vendor invoices.

Invoice Type Calculation
commissioned invoice no value
customer invoice no value
vendor invoice Amount paid so far

 

Payable
Payable is the total amount of money still owed to a vendor.  It is only valid for vendor invoices.

Invoice Type Calculation
commissioned invoice no value
customer invoice no value
vendor invoice InvoiceCostAmount - Paid