Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Inventory Quantity & Valuation report at period end
- Thread starter EveSat
- Start date
- Thread starter
- #4
Hello again, I tried both item valuation report via transaction cost and location detail cost.
The location detail cost, does let me choose a cut-off date.
What I wanted to see is a report like the one shown by location details costs but with the cut off date which I can export to excel. The one which I run via transaction costs, though I can set the date, it will give all the transaction details. I will only need the each item quantity and valuation at the cut off date. In this report the exported excel file includes so many rows corresponding to every transactions though reflecting the same average cost per row for each item.
Again, my goal is to see each item's quantity, total value and ave cost by period end ie. Sept 30, which is our YE. This is to reconcile with my ending inventory amounts in the GL at year end.
The location detail cost, does let me choose a cut-off date.
What I wanted to see is a report like the one shown by location details costs but with the cut off date which I can export to excel. The one which I run via transaction costs, though I can set the date, it will give all the transaction details. I will only need the each item quantity and valuation at the cut off date. In this report the exported excel file includes so many rows corresponding to every transactions though reflecting the same average cost per row for each item.
Again, my goal is to see each item's quantity, total value and ave cost by period end ie. Sept 30, which is our YE. This is to reconcile with my ending inventory amounts in the GL at year end.
- Thread starter
- #5
Location Details is 'as of now'.
You could export all ICHIST transactions after Sept 30 and reverse the quantity field and apply that net change to your location detail values. So you're taking today's values and reversing all transactions that happened after your target date.
You could export all ICHIST transactions after Sept 30 and reverse the quantity field and apply that net change to your location detail values. So you're taking today's values and reversing all transactions that happened after your target date.
- Thread starter
- #7
- Thread starter
- #9
- Thread starter
- #11
- Status