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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Reflect shipped items and tobe shipped items/amount in sales order overview for different shipment dates / cash flow

(0) ShareShare
ReportReport
Posted on by 52

Hello,

We do drop shipments. I work as follows: I enter the sales orders into BC.  Once the items are shipped, I invoice the client and I know when to receive the payment, in this case 15 days from invoice date. I can see this payment due date also already in my BC Sales order overview, while waiting for the items to be radu and shipped. So this we use for cash flow.

Now lately it happens that 1 sales order is shipped over for example 4 different dates (as we have to fill containers up to 95%, and so it happens that 1 sales order can be spread over different dates, in different containers)

The BC sales order overview shows only the 1 Sales order and the total amount of that sales order.  Even If I have already shipped and invoiced a part of that sales order.

So Sales order is : USD 80,000
26 June: shipped and invoiced items worth USD 55,000
5 July: to ship items worth USD 20,000
30 July: to ship last part worth USD 5,000

How can I have BC reflect in the sales order overview what is still to be shipped for that particular order and on which dates? (So I can manage my cash flow) 

Can anyone advise me or anyone have a totally other solution?  We are farely new with BC and I just don't seem to find a way to make this happen.

Thank you,

Amber

I have the same question (0)
  • Suggested answer
    IB-29041624-0 Profile Picture
    1,191 Moderator on at

    I would suggest that you take a look at the Customer - Order Detail report.

    There you can filter the order lines on shipping date.

    It would be possible to refine that report f.ex. using Power BI. But it should at least give you some of the data you need out of the box.

  • Suggested answer
    Dallefeld Profile Picture
    235 User Group Leader on at

    Inge offers a good solution for managing your sales orders.

    Fact is that there is nothing you can do to help your cash flow other than separate your sales order into multiple sales orders.

    Also, don't forget that you can have Cash Flow Payment Terms on your customer master records that is different from the payment terms used to calculate due dates that print on invoices and are used in the customer ledger. For example, customer is Net 30 but you always seem to receive payment in 37 days. Your CF Payment Terms can be Net 37 while regular payment terms are Net 30. This gives you a bit more accurate Cash Flow Forecasts. I assume you are using the Cash Flow Forecast capabilities in BC.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 572 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 331 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 330 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans