Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 297 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Create total of same Item no.
Leshabela
Member Posts: 35
Hi all,
i'm using tabel name = Inventory Valuation id =1001 and want to add a footer where totals of item no. of the same should be shown(added)
e.g
item no. 64
item no. 64
item no. 78
item no. 79
total item no. 64
thanx,
i'm using tabel name = Inventory Valuation id =1001 and want to add a footer where totals of item no. of the same should be shown(added)
e.g
item no. 64
item no. 64
item no. 78
item no. 79
total item no. 64
thanx,
Learning Never End.
0
Comments
Try to lookup the word "Group Footer", "Group Totals" or "Total Fields" in the development manual.
Good luck!
If it was hard to write, it should be hard to understand."
ID=1001, Inventory Valuation. Do you mean REPORT ??
If So, you must be BRAVE, this is no simple report !!!
For a new report you would do something like this:
In the Report DataItem for "ITEM", go to properties and specify the "TotalFields" as the field you want to add up. i.e. "Quantity"
Still in properties specify in the "GroupTotalFields" the field you want to group by. i.e. "no."
Then on the report, create a new section. This will be Item,GroupFooter. In the Group Footer put the "No." field and the "Quantity" field. this will give you something like:
Item No. AB123 Total Qty 46
Item No. AB124 Total Qty 32
That should give you the direction and some idea of what to do.
(Please note that it probably is useless to sum Item Quantities. Values is another story.)
If it was hard to write, it should be hard to understand."
This report should show this grouped by Inventory Posting Group, and you should be able to filter on the Gen. Bus. Posting Group from the customer.
There should be a total for each Inventory Posting Group.
Any help would be appreciated.
Document No., Vendor No., Order Date, Posted Date, Amount, Outstanding Amount
I used the "Purchase Lines" table and needed to group all lines that had the same Document No. and then create totals for Amount and Outstanding Amount.
Thanks, I'm glad someone else already asked about a task of this type because I needed this today and now my work is complete.
Thanks.
Thanks.