roydas
1
Dear friends
Good Day,
I am trying to develop report for stock movement that should show daily stock movement of WH1,WH2 with in the date filter.
Report format
Item number Description Opening balance Sales Closing balance
I am selecting Item ledger entry table to generate report.
My quesion are
-
What should be the Key (Posting date, Location code,Item number) and sum index field Quantity is this OK ?
-
Date Item - Item ledger entry table
DataItemTableView - SORTING(Posting Date,Location Code,Item No.) ORDER(Ascending) WHERE(Location Code=FILTER(WH1|WH2))
ReqFilterFields - Posting Date
GroupTotalFields - Posting Date,Location Code
- OpeningBalance(ItemNo : Code[20];StockDate : Date) : Decimal
iteml.SETCURRENTKEY(“Posting Date”,“Location Code”,“Item No.”);
iteml.SETFILTER(“Posting Date”, ‘%1…%2’, 311208D,StockDate);
iteml.CALCSUMS(Quantity);
EXIT(iteml.Quantity);
i DONT KNOW WHAT WENT WRONG, THE REPORT DOES NOT POPULATE ANY DATA. PLEASE HELP/CORRECT ME.
Thanks
Roy
I would rather suggest Do the report using Analysis report. It will be easier.
roydas
3
Hi Amol
Could you please explain how do i do Analysis report
Thanks
roy
Look at the Financial Management–>Inventory–> Analysis & Reporting–> Analysis Report
You will get Idea…
IF you are working on India Database then I would suggets you to have a look at the report “Daily Stock Movement”… Might be of some help.
/Anup
roydas
6
Hi Anup
Where can i find the report “Daily stock movement” ?
satish
Financial Management->General Ledger->Reports->Excise Reports->Daily Stock Movement
This is just for reference… you will get some idea how to build ur report.
He is outside India. So How he can view India localization report ???
He is outside India. So How he can view India localization report ???
Very True Amol…
Noticed his location post ur comment…
Miss judgement by just seeing name (thanks for ponting out or else he would be busy searching for the report)