Tuesday, June 11, 2019

Report that shows computation of Gross Profit for Drop Ship Transactions

Report that shows computation of gross profit for Drop Ship Transaction will help to understand if this type of transactions are making profit. However, this report is currently not available and logged under Enhancement 59387 : Reports > Profitability report on sales transactions for Drop Ship Transactions.

However, a saved search can be customized to show profitability of Drop Ship Transactions. The steps are as follows:
- Navigate to List > Management > Saved Searches > New > Transaction
- Under the Criteria subtab:
    - Filter : Type | Description : is any of Sales Order, Bill
    - Filter : Item Fields... > Drop Ship Item | Description | is true
    - Filter : Applying Transaction Fields... > Type | Description : is Purchase Order
- Under the Results subtab:
    - Field : Date
    - Field : Type
    - Field : Number | Custom Label : SO Number
    - Field : Applying Transaction | Custom label : PO Number
    - Field : Item
    - Field : Amount | Custom Label : Revenue
    - Field : Applying Transaction fields... > Amount | Function : Absolute Value | Custom Label : Cost
    - Field : Formula (Numeric) | Function : Absolute Value | Formula : {amount} - {applyingtransaction.amount} | Custom Label : Gross Profit
    - Field : Formula (Percent) | Function : Absolute Value | Formula : ({amount} - {applyingtransaction.amount}) / {amount} | Custom Label : GP%

Note: that this only applies when Bills generated from Purchase Orders are of equal amount. Actual costs are based on Bills.

3 comments:

  1. Now you get a complete idea about ways to make cash with Instagram. When you're happy, you've got happy thoughts and you're feeling happy. When you're sad, you've got sad thoughts and you're feeling sad. It is possible to also discover that friend in the business who will make you do more daily. Possessing a very best friend in the company is so essential for long-term success.

    auto refill followers

    ReplyDelete
  2. I admit, I have not been on this web page in a long time... however it was another joy to see It is such an important topic and ignored by so many, even professionals. I thank you to help making people more aware of possible issues. Profit, profitability

    ReplyDelete
  3. Wow, this is really interesting reading. I am glad I found this and got to read it. Great job on this content. I like it. ترفندهای بازی انفجار

    ReplyDelete