Options

Find Sales Invoice No from Sales Shipment no

anushafdoanushafdo Member Posts: 32
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

Comments

  • Options
    David_SingletonDavid_Singleton Member Posts: 5,479
    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.
    David Singleton
  • Options
    anushafdoanushafdo Member Posts: 32
    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
  • Options
    vijay_gvijay_g Member Posts: 884
    I always use the item invoice line functionality from the posted shipment as per attached pic.
  • Options
    eyolfthoeyolftho Member Posts: 18
    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.
  • Options
    anushafdoanushafdo Member Posts: 32
    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.
Sign In or Register to comment.