User-ID in Delivery Note and Sales-Invoice

cosch1
cosch1 Member Posts: 37
edited 2009-09-29 in NAV/Navision Classic Client
Hi,
i would like to print the user-id on Delivery Note and Sales-Invoice.
Has anyone an idea how to do it? There's no record where this field is to get from..... :lol:

Many thanks for help from northern germany
cosch

Answers

  • DenSter
    DenSter Member Posts: 8,307
    It's the field called "User ID" in the "Sales Shipment Header" and "Sales Invoice Header" tables.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • cosch1
    cosch1 Member Posts: 37
    thanks for answering, but i need the user id from the person who created the order.....
  • nromain
    nromain Member Posts: 57
    you can create a new field "Creator ID" in the sales header and in the posted Shipment/Invoice/Credit memo tables (with the same Field ID for the transferfields). Then Init the field with USERID when you create a new sales header. Then plug the new field in your reports.
  • cosch1
    cosch1 Member Posts: 37
    nromain wrote:
    you can create a new field "Creator ID" in the sales header and in the posted Shipment/Invoice/Credit memo tables (with the same Field ID for the transferfields). Then Init the field with USERID when you create a new sales header. Then plug the new field in your reports.

    :lol: Many thanks, it's so easy and works perfectly! =D>

    With greeetings from germany
    cosch

Categories