Creating new Analysis Types

jiipm

Hi everyone,

I'm quite a novice with NAV so I hope you don't mind

What I am trying to do is create a new Analysis Type to see the quantities shipped, but the available options in the Item Ledger Entry Type Filter do not contain Qty. Shipped. How can I edit the available options to include what I need?

I tried finding the information from NAV help files, MS CustomerSource and by searching on these forums, but wasn't able to find an answer...

kine

The "quantity shipped" means "sold" - it means you need to take all entries with type "Sale" and sum the quantity.

jiipm

kine wrote:

The "quantity shipped" means "sold" - it means you need to take all entries with type "Sale" and sum the quantity.

Thank you for your answer Although the way I've understood is that the type "Sale" refers to the ones that have been invoiced as well as shipped. Am I correct?

If I am, then with "Sale" the results are missing the items that have been already shipped in the period but are going to be invoiced in the next period.

kine

No, the item is Shipped (it means deducted from inventory) by creating the Sales entry in Item Ledger Entry table. Item is invoiced, if the Item Ledger Entry has some "Invoiced Qantity". And this is independent process.

jiipm

kine wrote:

No, the item is Shipped (it means deducted from inventory) by creating the Sales entry in Item Ledger Entry table. Item is invoiced, if the Item Ledger Entry has some "Invoiced Qantity". And this is independent process.

Ok, thank you again, it seems I was a bit confused with the terms