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 / Small and medium business | Business Central, N... / Creating another row i...
Small and medium business | Business Central, N...
Suggested Answer

Creating another row in Business Central Report Based on Condition

(0) ShareShare
ReportReport
Posted on by Hot Potato 25

Hi, we are trying to automate our Packing List report to be used by our Warehouse for shipments. the report is based on a sales line. However, one of the condition is that for 1 item (lets say 1500 cases), if the cases per pallet is 500, that 1 item should divide into 3 pallets. Meaning in the report 3 lines on my report should show like below. This then will repeat to other items in the sales lines of the report until the whole shipment is finished with continuous Pallet No. . We have table where the no. of cases per pallets for each of our registered Item Nos. are defined. 

Item A= 1500 Cases, cases per pallet 500

Item B= 1000 Cases, cases per pallet 200

Item No.   Qty Pallet No.
Item A 500 1
Item A 500 2
Item A 500 3
Item B 200 4
Item B 200 5
Item B 200 6
Item B 200 7
Item B 200 8

Please Help me! Thank you

Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    JAngle 133 on at

    Seems like you would need a temporary table for the sales line or a custom table added to the report producing the list. You can then add to the temporary table based on your criteria and display that output in your report layout. Steven Renders  might be able to advise you on the development approach further.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,111 Moderator on at

    Have you defined the pallets as Item unit of measure so you can use that info to find out how many pallets you need?

    Have you started writing a report at all, if so maybe you should share the code you have written so far?

  • Hot Potato Profile Picture
    Hot Potato 25 on at

    The Unit of Measure for our sales lines are in Cases, and we don't have any table to define the pallet no. Of each sales lines and sales orders. We were thinking if this can be populated as a calculated field as the only data that we have in BC right now is a table that defines the no of cases per pallet, palletization type and transport method code.I haven't done yet the codes for it, but I was thinking to use for loop statement or while do... To populate a sequence no. which can serve as pallet no. In our warehouse. The whole report was done, only the column for pallet no. column is to be created. The idea is that the user will choose the palletization type in the sales header along with the Transport method, then a report from BC should indicate and compute the pallet no. for each of the sales line. Our warehouse uses another software integrated to Business Central hence we do not use Warehouse Function, we only  have Sales Order data to create this document. Thank you!

  • Hot Potato Profile Picture
    Hot Potato 25 on at

    Thank you very much for your time to check my case, however we don't utilize warehouse function now in Business Central ..we have an independent software for our warehouse integrated to Business Central. I will really appreciate if I can see ideas how it is done in other companies. Thanks!

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,111 Moderator on at

    Hi Hot Potato ,

    Thank you for providing valuable information to help you further.

    The best approach in my eyes would be to create a sales line buffer table that you use as the dataitem for your report.

    That table should consist of at least the PK from the Sales Line table and the result for the pallet calculation as you showed it in your first post.

    Then you can use that table to generate your report.

    The table can possible be temporary unless you want to store the result of the pallet calculation for further use or reference,

    I hope this helps you further.

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,362

#2
YUN ZHU Profile Picture

YUN ZHU 867 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans