Open Forum

Expand all | Collapse all

General tab fields for Document Cross Reference

  • 1.  General tab fields for Document Cross Reference

    GOLD CONTRIBUTOR
    Posted 8 days ago

    We have operated on NAV for 15 months now and are better users than when we started.

    Navision is supposed to be a relational data base, but Column Views out of the box are not defined very well. Our VAR indicated that initial column views are defined by Microsoft and any additional column view fields require setting up object sets.
    Computer setups use to work with a tailoring questionnaire. An initial setup fields typically required for wholesale distribution and or manufacturing would be very helpful.


    The document flow in Navision does not cross reference one document to the other
    The General Tab of each document should have two fields that notate:

    The document it was created from and a previously posted document should be appended and notate the downstream document created from it.

    Forward and backward document references should exist in the general tab for these two groups Quote
    Sales Order
    Pick Ticket
    Packing List
    Posted Sales Shipment
    Posted Sales Invoice

    Purchase return
    Purchase Return Order
    Purchase Return Shipment
    Purchase Credit Memo
    Posted Purchase Credit memo 

     

    Has anyone modified Nav to accomplish this, how many hours did you VAR require to implement it?

    Did anyone combine Ledger Entries and Warehouse entries into a combined resource?

    Thank you for your insights




    ------------------------------
    Michael Heatherly
    controller
    Lesman Instrument Company
    BENSENVILLE IL
    ------------------------------


  • 2.  RE: General tab fields for Document Cross Reference

    TOP CONTRIBUTOR
    Posted 6 days ago
    As far as the document references go, the reason you don't see many of them on the documents themselves is because there is not guaranteed a 1 to 1 relationship. This is an exaggeration, but I could easily have 100 shipments and 75 invoices for a single sales order. The exception to this is the quote and the order. That is a 1 to 1 and those fields exist out of the box on the general tab. When it is 1 to many, there are actions to allow you to drill into the details, or you can use the Navigate feature.

    For the warehouse and the item ledger (I am assuming this is the ledger you mean) they are separated for a reason. They actually have nothing to do with each other, which I know sounds a little strange. Unless you are using serialized inventory tracking there really is no way to tie them together. Imagine you buy 10 of them same item split across 10 purchase orders, all for different costs. Your Item Ledger and Value Entries will track this. Then someone puts them away into a Bin, which is tracked in the Warehouse Entry table. If you were to go pick one of those in order to sell it, you would have no idea which one you were selling. Also this could again be a 1 to many relationship. You could buy 100 of an item and put each one into 100 separate bins.

    I hope that's not too confusing.

    ------------------------------
    Matt Traxinger
    NAV Developer
    ArcherPoint Inc.
    San Antonio TX
    ------------------------------



  • 3.  RE: General tab fields for Document Cross Reference

    GOLD CONTRIBUTOR
    Posted 5 days ago
    Thank you for the clarification.

    Regarding the Warehouse Entry of a Purchase Receipt , it shows the Po number, a ledger entry would show a Purchase Receipt as a Positive
    adjustment linked to a Purchase receipt record, that is in turn linked to a Purchase Order Line. It would be helpful to see the Purchase Order Number and the PO line # on Ledger record along with the Purchase Receipt. 

    Inventory Ledger Record

    ------------------------------
    Michael Heatherly
    controller
    Lesman Instrument Company
    BENSENVILLE IL
    ------------------------------



  • 4.  RE: General tab fields for Document Cross Reference

    TOP CONTRIBUTOR
    Posted 3 days ago
    ​With a reporting tool like Jet Reports, you may be able to link the Leger Entry to the Purch. Rcpt. Line (Table 121) which contains the Purchase Order Number and Line No.

    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    -----------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

    NAVUG/BCUG FOCUS Houston March 13-14, 2019
    Join "SuperAdmins To The Rescue" March 13 at 10:15am
    Why attend Focus? Video Blog: https://www.navug.com/blogs/lewis-rosenberg/2019/02/25/time-for-focus


    Twitter: @RosenbergL
    LinkedIn: https://www.linkedin.com/in/rosenbergl
    ------------------------------



  • 5.  RE: General tab fields for Document Cross Reference

    TOP CONTRIBUTOR
    Posted 2 days ago
    You should be able to see the Line No. field in the Item Ledger. It will be under Document Line No. Granted this is the line on the receipt, but it almost always ties exactly to the original order as well.

    I've never dug deeply enough to figure out why the Order Type, Order No., and Order Line No. fields don't always get filled in. I've always suspected it was some sort of warehouse process where orders are pulled into a single warehouse receipt document and they are posted all at once, but I don't know for sure. If that is the case it gets back to that 1 to many relationship between a single ledger entry and multiple documents.

    ------------------------------
    Matt Traxinger
    NAV Developer
    ArcherPoint Inc.
    San Antonio TX
    ------------------------------