Synthesis

Synthesis

SPM documentation (v4.6.3.x)- April 13th 2011 – Written by Rémi Equoy

Introduction

The customer Invoice Synthesis tab enables to synthesize the costs and the profit of a customer invoice, including the percentage fees.

To create a Synthesis, the customer invoice must be in a validated status and saved.

Lines are created on demand by using the Create lines button. Only not exiting lines will be created. To update a line, erase it first.

Invoice details

• Type (line's type) P:Part Number - S:Service - O:Other - F:Fees
• Label: Part Number or Service or Code or Fees, depending of the line's type
• Qty: Quantity invoiced or 1 when line is a fee line
• UOM: available only for PN lines. All unit prices will be expressed according of this unit.
• Invoiced price: Invoiced unit price
• Purchase price: Purchase unit price located in the Item form converted in the invoice UOM and shown with the purchase currency.
• Renewal price: Renewal unit price available when the customer order is done.(located into the Requisition) UOM will be converted while creating lines. The currency will be the one indicated in the Requisition.
• Trading price: Trading unit price typed in the Requisition (Push down menu/Purchase prices). UOM will be converted while creating lines. The Currency is not displayed in this column because it must be the same as the the Renewal price's currency.
• Costs: Sum of costs allocated for the entire line (Costs aren't a unit price), converted into the line's currency.
• Gross profit: compute Qty x [ Invoiced price - max(Purchase price,Renewal price) ] - Costs
• Agent %: Percentage fee due to the agent person
• Agent commission : compute [Gross profit] x [Agent %]
• Net profit: compute [Gross profit] - [Agent commission]. (
• Sales commission (check box) : define net profit which will be included into the the sales commission amount

Commissions

The percentage fees and commissions are computed by using the following calculating rules:

• Agent commission

       base = sum of all { [Agent commission] x [invoice currency rate] }

       payed = [base] x [commission currency rate]

• Sales commission

       base = sum of all { [Net profit ticked] x [invoice currency rate] } x [Sales percentage fee]

       Sales commission payed = [base] x [commission currency rate]

• Purchase commission

       base = sum of all { [Qty] x [Renewal price - Trading price] x [invoice currency rate] } x [Purchase percentage fee]

       Purchase commission payed = [base] x [commission currency rate]

The Commissions have been payed check box, when ticked, freezes the commission calculation. (See Commission Overview)

Invoice's synthesis

The synthesis enables to display the net profit which will be earned by the company when if the invoice is payed.

• Total Invoice total amount excluding taxes
• Purchase compute sum of all { [Purchase price] x [Qty]  x [invoice currency rate] }
• Costs compute sum of all { [Costs] x [invoice currency rate] }
• Commissions compute [Agent commission] + [Sales commission] + [Purchase commission]
• Net Benefits compute [Total] - [Purchase] - [Costs] - [Commissions]

NOTE: If the Invoice is in Closed-Not settled status (see Statuses), the Net Benefits will be reduced by the due value.

The Exclude from accounting check box enables to discard the invoice from all accounting analysis view. This check box can be ticked manually or will be set automatically when the invoice is canceled.

To improve the check, when a profit result (Gross profit, Net Profit and Net Benefits) is less than zero, the value is displayed in red.

See also - Customer Invoice Overview - Commission Overview - Customer Invoice -

Created with the Freeware Edition of HelpNDoc: Full featured Documentation generator