You’re offline. This is a read only version of the page.
Good day!
We would like to ask if it is possible to generate Unit Cost as of particular date. For example, we want to know the Unit Cost of an item as of March 1, 2017.
*This post is locked for comments
Good Morning Sir,
I have too display unit coast based on date filter ,
start date -1d
before starting report development i m facing issue
how i will get the value of unit cost in my report.
i saw this post, can you plz help me in that
i m not getting Avg. Cost Calc Overview report anywhere in my database.
Thanks
Hi omfwil,
Do you want to know the unit cost of past transaction ?, If so you can the Application Worksheet under "Entries" in the Ribbon section of the Item card.
Regards,
Hasitha Jayasuriya
If my response helped your question, please take a minute to "Verify" my response.
Hi again omfwil,
There's a Unit Cost field on the Item Card, but that will show you the current Unit Cost.
If you need to look at the Unit Cost as of a certain date, I suggest starting at: Item Card > Statistics > Statistics
In the Show as Lines, select Cost Specification, and in the Show as Columns field, choose Period.
Set Date, Location and Variant filters as needed. For your purposes the date filter should be 3/31/17 (in your date format, if you are not based in the US)
You can toggle the View by to Day, Week, Month, etc. For now, keep it at Day.
And the View as can be set to Balance at Date or Net Change. For what you are describing, Balance at Date should be what you need.
You can enable or disable the Include Expected (aka Include Expected Costs) and Calculate per Unit options as needed. You can try with and without them to see the impact on cost.
When ready, click on Show Matrix, and you will be presented with the Unit Cost.
I hope this helps. If my response has answered your question, please verify by clicking "Yes" next to "Did this answer your question?"
You can check that from the Item Card click on the drill down next to the Unit Cost field or you can use th Avg. Cost Calc Overview report.
goto item card, menu navigate/purchases, select (special) prices (page 7012). in that list you can setup the purchase prices, set there also start and end date. in this page you can filter by starting date to find prices for a specific date.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (