average cost

Options
prasanna
prasanna Member Posts: 35 ✭
edited March 19 in Accounts Hosted

Hi I am using reckon hosted ,


how do we run a report for all the items including average cost and last cost price

Appreciate anyone can help ASAP

Prasanna

Comments

  • Nickiu
    Nickiu Reckon Staff Posts: 43 Reckon Staff
    Options

    Hey @prasanna

    You can run a Inventory Valuation Summary report. This should included the Stock on hand and Avg Cost. If you double click on the item, this should pull all the historical data of that specific item.


    Hope this help.

    Cheers

    Nick

  • prasanna
    prasanna Member Posts: 35 ✭
    Options

    Thanks for your Support

    how do we get the last purchase cost

  • Nickiu
    Nickiu Reckon Staff Posts: 43 Reckon Staff
    edited March 19
    Options

    If you run an  Inventory Valuation Summary report, Click magnify on the item, then sort by date. you should be able to find the last purchase cost.


    Thanks

    Nick

  • prasanna
    prasanna Member Posts: 35 ✭
    Options

    Great !

    Thanks Nick

    also, if you can please let me know how to run margin report for items

  • prasanna
    prasanna Member Posts: 35 ✭
    Options

    Hi Nick


    what do you mean by ,"Click magnify on the item"

  • prasanna
    prasanna Member Posts: 35 ✭
    Options

    Hi Nick

    it doesn't bring up last purchase price at all

  • Nickiu
    Nickiu Reckon Staff Posts: 43 Reckon Staff
    Options

    Hey @prasanna


    To get a margin report for items, please run a Gross Margin by Inventory Item by going to Reports > Industry Specific > Retail Reports > Gross Margin by Inventory Item.

    or Reports > Industry Specific > Manufacturing and Wholesale > Profitability by Product


    Cheers,

    Nick

Categories