web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
    Dallefeld Profile Picture
    193 User Group Leader on at
    RE: Reflect shipped items and tobe shipped items/amount in sales order overview for different shipment dates / cash flow

    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.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,041 Moderator on at
    RE: Reflect shipped items and tobe shipped items/amount in sales order overview for different shipment dates / cash flow

    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.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,132

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,615

#3
Sumit Singh Profile Picture

Sumit Singh 2,912

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans