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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
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?

(0) ShareShare
ReportReport
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

I have the same question (0)
  • LindaZ Profile Picture
    15 on at

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

  • LindaZ Profile Picture
    15 on at

    Thanks so much Zhu!

  • Suggested answer
    YUN ZHU Profile Picture
    96,281 Super User 2025 Season 2 on at
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,111 Moderator on at

    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
    15 on at

    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
    1,111 Moderator on at
    [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
    1,111 Moderator on at
    [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
    15 on at

    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
    15 on at

    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
    1,111 Moderator on at

    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

News and Announcements

Season of Giving Solutions is Here!

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…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,472

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 742 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 684 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans