web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / NAV: Extra text-f...
Microsoft Dynamics NAV (Archived)

NAV: Extra text-field to Sales Line Table ???

(0) ShareShare
ReportReport
Posted on by BeanCounter 195

 Hi folks,

 I am wondering if it might be possible to add an extra text-field to the Sales Line Table?

We would like to get an extra text-field (25-30 characters wide) in the Sales Line Table to enter different reference-numbers that neeeds to be connected to the Item on the Sales-Line.

(Yes, I do know that Dimensions often are a very useful tool, though not in this particular case, helas)

However, the Sales Line Table looks extremly crowded with existing fields. Will that be a problem if You would like to add an extra text-field. Further, will it be difficult to add such a text-field?

/BeanCounter

.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi,

    Yes it is very easy to add in a field but you will need to think through were you need this e.g. flow to shipments / invoices. I suggest talking to your partner as this is a minor modification but may need to be though out fully.

  • BeanCounter Profile Picture
    BeanCounter 195 on at

    Hi Dave,

    Thank you very much for the information. 

    This extra text-field will be inserted between the Item-No-, Description-fields and the Quantity-, Unit Price Excl-, Line Discount %-, Line Amount Excl-, Qty to Ship-fields respectively.

    It will solely be used to keep track of a reference number, for each Sales Line, by which it should be possible to select the corresponding Sales Lines that comprises the reference number chosen. 

    The extracted Sales Line data will then be used to compile reports.

    (and as I mentioned in the post above, using dimensions is not an option in this case)

    Further, I reckon that the insertion of such an simple text-field will not impinge on the compability with future Navision releases. Is this a correct assumption? 

     

    /BeanCounter

  • Community Member Profile Picture
    Community Member on at

    Hi BeanCounter,

    Depending on your method of invoicing then this will be deleted off the sales line table when post the invoice (i.e. Invoice from sale order as opposed to get shipment lines)

    To add this you will need to have table designer and form designer on your license.

    Here's the steps (and please try on a test envoirnment first):

    1. Go the object designer and find the sales line table (table 37)

    2. Add in field for Reference - type test - length 30 (use field no. 50000)

    3. Save and compile

    4. Design the sales line form (form 43)

    5. Click on the Field Menu button in the header and highlight/select the new reference field. Click on the list form where you want to place the field.

    6. Save and compile

    This is such a minor modification that it will not be significant in upgrading.

    Hope this helps.

     

  • BeanCounter Profile Picture
    BeanCounter 195 on at

     

    Dave, thank you very much for your input.

     

    Regards

    BeanCounter

  • Community Member Profile Picture
    Community Member on at

    Glad to Help

  • Ron Saritzky Profile Picture
    Ron Saritzky 110 on at

    Just [perhaps] a silly question - are you currently using the field "Description 2"?  If not, you can just expose that field on the sales order and invoice forms - even rename the column heading if you choose.  The field is already in the database in the proper places.

     Ron

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans