Inventory report grouped by item and batch. (XMLPort)

delaghetto

Hi, is there any standard NAV report that shows inventory for item and Lot?

If not, what would be the most direct way of getting a list of items and lots??

For example:

Item Lot
1001 A
1001 B
1001 C
1002 D
1002 E
...

Whats most important is that the same Item - Lot is not repeated.

postsaurav

Hi,

Not Sure about standard, but you can easily get the information by creating a report which is grouped on Item No and Lot No from Item Ledger Entries.

Hope it clears the doubt.

delaghetto

Thanks for the answer, Indeed, from report designer I could group by item no. and lot no.

Sorry I did not explain the final objective for this question. What Im actually trying to do is an XMLport where I print the stock for each item/lot. So it would be something like this:

<line1>
<ItemNo>1001</ItemNo>
<LotNo>A</LotNo>
<Qty>20</Qty>
<line1>
<line2>
<ItemNo>1001</ItemNo>
<LotNo>B</LotNo>
<Qty>30</Qty>
<line2>

I don't know hoy to "group by" in a XMLport. If I use Item Ledger entry, I'm going to have repeated lines for a same Item/Lot

davmac1

You can write a NAV query and have it group on item, location, and lot.

delaghetto

davmac1 wrote:

You can write a NAV query and have it group on item, location, and lot.

Can we use query in XMLPorts?

davmac1

You can use the integer table, then have all the fields come the query with the addition of some code to run and read the query.
Should work the same way as a report based on a query.