Stock movement report

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Solution (Not Verified) This post has 0 verified solutions | 9 Replies | 2 Followers

3 Posts
35 Points
Joined: 2012-10-8
Last Online:
2012-12-5 13:27
Location: lagos nigeria
roy das posted on 2012-10-8 11:54

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

1) What should be the Key (Posting date, Location code,Item number)  and sum index field Quantity is this OK ?

2) 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

3) 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

All Replies

Male
2,193 Posts
32,540 Points
Joined: 2006-4-10
Last Online:
2013-5-19 4:41
Location: Pune India
Moderator
Amol replied on 2012-10-8 12:15

I would rather suggest Do the report using Analysis report. It will be easier.

-Amol

http://dynamicsuser.net/blogs/amol

Don't forget to  the post(s) that solved your problem

3 Posts
35 Points
Joined: 2012-10-8
Last Online:
2012-12-5 13:27
Location: lagos nigeria
roy das replied on 2012-10-8 12:18

Hi Amol

Could you please explain how do i do Analysis report

Thanks

roy

Male
2,193 Posts
32,540 Points
Joined: 2006-4-10
Last Online:
2013-5-19 4:41
Location: Pune India
Moderator
Amol replied on 2012-10-8 12:30

Look at the Financial Management-->Inventory--> Analysis & Reporting--> Analysis Report

You will get Idea..

-Amol

http://dynamicsuser.net/blogs/amol

Don't forget to  the post(s) that solved your problem

43 Posts
830 Points
Joined: 2012-7-25
Last Online:
2013-4-2 11:45
Location: Kolkta-India
Solution (Not Verified) Anup Kumar Routh replied on 2012-10-8 16:24
Suggested by Anup Kumar Routh

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

3 Posts
35 Points
Joined: 2012-10-8
Last Online:
2012-12-5 13:27
Location: lagos nigeria
roy das replied on 2012-10-8 17:36

Hi Anup

Where can i find the report "Daily stock movement" ?

satish

43 Posts
830 Points
Joined: 2012-7-25
Last Online:
2013-4-2 11:45
Location: Kolkta-India
Anup Kumar Routh replied on 2012-10-9 19:09

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.

 

 

Male
2,193 Posts
32,540 Points
Joined: 2006-4-10
Last Online:
2013-5-19 4:41
Location: Pune India
Moderator
Amol replied on 2012-10-10 11:23

Anup Kumar Routh:

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 ????????

-Amol

http://dynamicsuser.net/blogs/amol

Don't forget to  the post(s) that solved your problem

Male
2,193 Posts
32,540 Points
Joined: 2006-4-10
Last Online:
2013-5-19 4:41
Location: Pune India
Moderator
Amol replied on 2012-10-10 11:23

Anup Kumar Routh:

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 ????????

-Amol

http://dynamicsuser.net/blogs/amol

Don't forget to  the post(s) that solved your problem

43 Posts
830 Points
Joined: 2012-7-25
Last Online:
2013-4-2 11:45
Location: Kolkta-India
Anup Kumar Routh replied on 2012-10-10 20:36

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)

 

Page 1 of 1 (10 items) | Get this RSS feed | Bookmark and Share