Find Sales Invoice No from Sales Shipment no

anushafdo

Hi
Is there a way to find Sales Invoice No from Sales Shipment no. I am trying to create an item ledger entry report and user insists that (if it is a sale) the related Invoice No to be printed instead of the Shipment from Item Ledger Entry. He also raise several shipment and invoices for single order (part delivery).

Please help

David_Singleton

This is a very common request in Navision, form clients that really don't understand the way Navision handles partial shipments. Generally the only way to do this is to map out all the shipments and invoices for a particular orders number, matched by item number and date and quantity. Then on the ILE report you can show all the invoice numbers that might have invoiced that ILE in part or in full. If the client strictly invoices per shipment, then there will only be one matching invoice numbers per shipment, but that is rare, even clients that swear they never combine shipments often do it without realizing.

anushafdo

David Singleton wrote:

This is a very common request in Navision, form clients that really don't understand the way Navision handles partial shipments. Generally the only way to do this is to map out all the shipments and invoices for a particular orders number, matched by item number and date and quantity. Then on the ILE report you can show all the invoice numbers that might have invoiced that ILE in part or in full. If the client strictly invoices per shipment, then there will only be one matching invoice numbers per shipment, but that is rare, even clients that swear they never combine shipments often do it without realizing.

Thank you for the reply. This manager too swore that they raise invoice per shipment :shock: (they select Ship and Invoice every time). Being the negative inventory blocked, they adjust the Qty to Ship in sales order to match the available quantity. When the inventory is available again they do the same thing for remaining item.
Required format is like this

Item No: XXXXX1
Date ----> Invoice No ----> Positive ----> Negative ----> Balance
01-01-14 ----> Opening Balance---------------------------     100
02-01-14 ---->XYZ-01---->--------------->   10---->             90
02-01-14----> XYZ-02---->---------------->    5---->             85
03-01-14----> XYZ-99---->---------------->    5---->             80
and so on for each item ledger entry lines for this item 

I cannot figure out how map the invoice no for that Shipment no. If I use the Order No, I ended up picking the first invoice and really not sure that would be the invoice for that quantity/transaction.

Confused.

Thank you advance

Shaf

vijay_g

I always use the item invoice line functionality from the posted shipment as per attached pic.

eyolftho

The value in the [Document No.] field of the Item Ledger Entry is the shipment number...check the underlying Value Entry records...if the shipment is invoiced
you should find at least one record where the [Document No.] is the invoice number.

anushafdo

That's it. Thank you Vijay, I am now going through the coding behind that to find a way (reinstalled 2009 R2).

By the way I forgot to mentioned this installation is still 4.0 SP3.