Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Tagging items in invoices
Microsoft Dynamics NAV (Archived)

Tagging items in invoices

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi, 

I admit that I am not very familiar with Nav, so I appreciate any help that anyone can provide.

I manage a sales team where part of our job is to upsell items, and we enter the orders into Nav. I've been given the task to determine how much money we make from the upsells. Is there a way to 'tag' an item in line item entry to show that it was an 'upsell'? I don't want it to interfere with anything related to our finance department, and it has to be something we can easily report on in the future. 

What are my options?

Thanks so much for your help. 

*This post is locked for comments

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Tagging items in invoices

    Not available in standard, but you could customize by adding a boolean on the item card and on the sales line to mark them and then modify the posting routine to pass that value to the ledger entries.

  • Suggested answer
    4BzSoftware Profile Picture
    4BzSoftware 6,071 on at
    RE: Tagging items in invoices

    Hi Mike Jones,

    It needs to be customized here. In my opinion, we can approach as Item Substitutions:

    1. There is a place to define Main Item and its Upsell Items.

    2. On Sales Line Detail factbox, display number of Upsell Items available when user inputs Main Item.

    3. Check mark Upsell Items for report purpose if they are added to the Sales Document.

  • Suggested answer
    RobertasR Profile Picture
    RobertasR 5,002 on at
    RE: Tagging items in invoices

    Hi Mike,

    upselling items is not what NAV does well, and there is nothing in the standard to 'tag' item as recommended or see recommended items when selling.

    One of the workarounds you could use is using specific Dimension Code (for example, SALES TYPE with one of the values being RECOMMENDED). Then for any recommended item on the sales order you could put the Dimension Code 'Recommended' which will make it pretty straightforward to report with any reporting tool.  Of course, the dimension is a bit 'finance related'.

    The other way is to utilize 'Purchasing Code'. If you create a Purchasing Code RECOMMEND that is neither drop-ship or special order (both boxes un-ticked) and add add this purchasing code to each line that was sold as recommended, this code goes into the Item Ledger Entry and can be reported on with any reporting tool.

    Hope that helps.

    Robertas

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Tagging items in invoices

    Hi,

    Thanks for your reply!

    I should have been more clear with my question.

    When inputting a phone order, our representatives recommend additional items to the customer to see if the customer is interested or not. It could be any item in the system. If the customer wants the item, we add it to the order.

    I need the ability to track which recommended items have been successfully added to orders. I need a way for the representative to 'tag' the recommended item after they've put it in an invoice so that I can report on it later.

    Thanks.

  • Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Tagging items in invoices

    On the item card you have Item category code and product group code which you can use to categorize them.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans