Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

How to add multiple quantities for an item and have these quantities reflected in the invoice?

Posted on by 15

In my business, each product has both a carton quantity and weight quantity. The items are stored and transported in cartons and the weight is used to calculate the price. Some items have a set weight per carton while others fluctuate.

How do record both these quantities for an item and input both in an invoice or purchase order? Further how do I allow differences in weight for the items that do not have set weights?

Basically I'd like the customisations to produce invoice lines like this.

pastedimage1680254946982v1.png

Any ideas would be helpful. Open to suggestions on coding or other add-ins/implementation providers that can help do this

Categories:
  • LindaZ Profile Picture
    LindaZ 15 on at
    RE: How to add multiple quantities for an item and have these quantities reflected in the invoice?

    Thank you Inge. Would you be open to sharing how the solution was developed?

  • LindaZ Profile Picture
    LindaZ 15 on at
    RE: How to add multiple quantities for an item and have these quantities reflected in the invoice?

    Thanks so much Zhu!

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,035 Super User 2024 Season 2 on at
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: How to add multiple quantities for an item and have these quantities reflected in the invoice?

    Here is a good starting point that will help you get started with the tools and setup you need to begin developing in AL.

    learn.microsoft.com/.../devenv-get-started

    When it comes to the specific details around the specific solution you want to develop i do have some idea around that. I developed a similar solution some years ago.  

  • LindaZ Profile Picture
    LindaZ 15 on at
    RE: How to add multiple quantities for an item and have these quantities reflected in the invoice?

    Hi Inge,

    I'd like to do the customisations myself on business central online. Our business is running on a small budget and implementation could get very expensive, so I'm planning to learn the development skills myself.  

    Are there any procedures you would suggest to get started and codes you may know for this quantity customisation?

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: How to add multiple quantities for an item and have these quantities reflected in the invoice?
    [quote user="LindaZ"]

    Thanks Inge,

    In relation to customisation, is there anyway I can customise the code myself as opposed to getting a third party?

    What would the procedure to customising entail?

    [/quote]

    Hi LindaZ

    If you are not a trained Business Central developer or you plan on becoming one then I would seek help for this task.

    But if you are ready to achieve the skills needed to do this it is a task you can get started with. 

    The challenge with this specific is that it requires that you interact with the standard functionality of the system.

    If you are running Business Central online there is no cost if you want to do the customizations yourself, If you run Business Central on prem you will need a license for the program objects you will be using,

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: How to add multiple quantities for an item and have these quantities reflected in the invoice?
    [quote user="LindaZ"]

    Thank you Daniele,

    I could not find the option for 'Fields' in the item card, could that be something that requires customisation at all?

    [/quote]

    Daniele is describing functionality that is not a part of Business Central, so that makes his answer a bit confusing.

    To add new fields you need to develop and extension to the item table using AL and Visual Code.

    And to add logic for those fields for the rest of the application - more development is needed.

    So to get the perfect solution to your requirement you will need customization.

     

  • LindaZ Profile Picture
    LindaZ 15 on at
    RE: How to add multiple quantities for an item and have these quantities reflected in the invoice?

    Thank you Daniele,

    I could not find the option for 'Fields' in the item card, could that be something that requires customisation at all?

  • LindaZ Profile Picture
    LindaZ 15 on at
    RE: How to add multiple quantities for an item and have these quantities reflected in the invoice?

    Thanks Inge,

    In relation to customisation, is there anyway I can customise the code myself as opposed to getting a third party?

    What would the procedure to customising entail?

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: How to add multiple quantities for an item and have these quantities reflected in the invoice?

    To allow different weight on different packages of the same product you will need a customization. There is no support for that out of the box in Business Central.

    For items like that i would recommend that you use weight as the base unit of measure and customize the handling of the number of packages.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans