Scenario User needs to creating a Report for Invoices and/or Cash Sales showing Est. Extended Cost, Est. Gross Profit, Est. Gross Profit Percent and other fields for each line item. Solution 1. Navigate to Reports > Sales > Sales by Customer > Customize 2. Under Edit Columns tab, expand the Sales folder > Item subfolder > Click on Name to display the Item Name 3. Still on the Sales folder, select Est. Extended… Continue reading Creating A Report Showing The Est. Extended Cost, Est. Gross Profit, Est. Gross Profit Percent And Other Fields For Each Line Item On Invoices And Cash Sales
Tag: gross profit
Create Custom Body Field To Show Total Amount of Estimated Gross Profit on Invoice
Scenario Some companies require to display the Estimated Gross Profit using a Custom Transaction Body Field on an Invoice record where the value is being sourced from a Saved Search. Solution Create Saved Transaction Search Navigate to Lists > Search > Saved Searches > New Click Transaction Search Title: Enter Title Example: Estimated Gross Profit Click Criteria Filter: Note: For every required field use the drop-down menu to select it and… Continue reading Create Custom Body Field To Show Total Amount of Estimated Gross Profit on Invoice
Show the Total Gross Profit and Total Gross Profit Percentage on Invoice
Scenario Show Total Gross Profit for Invoice Item Lines in the Invoice. Solution 1. Create Custom Transaction Line Field Navigate to Customization > Lists, Records, & Fields > Transaction Line Field > New Label: Enter Label Example: Purchase Price ID: Enter purchaseprice Type: Select Currency Store Value: Remove Checkmark Click Applies To tab Sale: Enter Checkmark Click Sourcing and Filtering tab Source List: Select Item Source From: Select Purchase Price Click Save 2. Create Custom Transaction Line Field Navigate to Customization > Lists, Records, & Fields > Transaction Line Field > New Label: Enter Label Example: Gross Profit… Continue reading Show the Total Gross Profit and Total Gross Profit Percentage on Invoice
Formulas for Sales achieved, Gross profit and Overdue/Collection percentages for sales commission calculation
Sales achieved % = (actual Sales / Target sales ) *100 for an associate for a specific month Gross Profit % = (Sales – COGS) / Sales *100 Overdue %= Overdue Invoices amount / Total Open invoices amount *100 : There will be open invoices with no overdue. Such invoices wont be considered for numerator.
Quote Gross Profit Calculation
How the Est.Gross profit is calculated for the below-mentioned quote record? Solution: Gross Profit = Sales – Discount – Est. Extended Cost You have a header discount of $1000 that applies to both line #1 & Line #2 and also line discount of $500 which applies to line #2 item only. The header discount of… Continue reading Quote Gross Profit Calculation
Enabling the Gross Profit Feature
To enable the Gross Profit feature: Go to Setup > Company > Enable Features. On the Transactions subtab, in the Sales section, check the Gross Profit box. Enable other features as desired. The Gross Profit feature is not directly dependent on other features, but may have limited utility without them. For example, the following related features can affect user access… Continue reading Enabling the Gross Profit Feature