CUST_PL - Customer profitability
What is CUST_PL
This procedure primarily reports Sales invoice performance in many different styles/sequences using the TRADE/Invoice marking grid contents. These contents are the individual invoices/debit/credit note details with the sales proceeds and cost of sale held in the Invoice currency. The Cost of Sales is secured when the Sales Invoice is produced using the latest estimates/actuals available. There is a specialist procedure (TRADECOS) that does allow for the update of the Cost of Sales and Margin values.
The effect of maintaining the cost of sale in the sale invoice currency, results in a realistic value but not necessarily 100% correct according to the accounting records of the purchase.
The purpose of this report is provide Management information, not fiscal reconciliation. If the target currency for the report is different to the sale invoice currency, the exchange rates selected will be applied to both proceeds and cost of sale.
There is a feature to include allocated sales that are not invoiced. This will utilize the same TRADE valuation as FInCalc and VALUATION i.e. adjusted value including Costs but no F&O P&L.
There are 2 styles:
The detail mode will report the content per row according to the selection in 'Levels row.'
The summary style is blocking INVOICE periods for side-by-side comparison.
The orientation selection (level row) allows you to view per client/commodity, per client, per commodity, per shipped destination, per family of client account, per department and per broker/agent.
The historical records are always available. You would need to include the archived details for invoice periods of more than 12 months ago.
There is an INVENTORY/retail oriented report that provides similar information, see
ITURN