Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

DealerPrice field to be copied from item table to sales invoice line

Posted on by Microsoft Employee

I have added dealerprice in the item table and sales invoice line, Sales Cr.Memo Line, whenever the user post the sale invoice, the relevant line item dealerprice should copy to sales invoice line and also Sales Cr.Memo Line

where can i added the code? Appreciate your help on this

Thanks

*This post is locked for comments

  • Jaideep Sengupta Profile Picture
    Jaideep Sengupta 430 on at
    RE: DealerPrice field to be copied from item table to sales invoice line

    Write the code on  No. field in the table to update the dealer price in the Sales Line. Keep the same field ID in the Sales Invoice Line and Sales Cr. Memo Line. It will itself get updated during posting.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: DealerPrice field to be copied from item table to sales invoice line

    Hi,

    If you want dealerprice updated in sales invoice line and sales cr. Memo Line after posting the Sales Invoice then you have to look inside CU 80 and search "SalesInvLine" and "SalesCrMemoLine" and insert your code at first search.

    Thanks & Regards

    Niraj Kumar

    niraj-msnav.blogspot.com

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: DealerPrice field to be copied from item table to sales invoice line

    Add the field only in Table and don't add in form. (but make sure that it will show if you press Ctrl+F8 Zoom)

    Please check OnValidate trigger of No. and how Item description is copied from Item Card to Sales Line

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: DealerPrice field to be copied from item table to sales invoice line

    This is the idea, which I too have the same, but how to fill the dealerprice, while validating the item no in sales Line ( I dont want show the Dealerprice in sales line form)

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: DealerPrice field to be copied from item table to sales invoice line

    I will suggest to add the filed in Sales Line table (make sure that field ID and data type are same in Sales Line, Sales invoice Line and Sales Cr. Memo Line tables)

    Fill the field while validating the item no.

    The value will be posted to Sales Invoice Line and Sales Cr. memo Line without writing any code.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans