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... / Drop shipment with pre...
Small and medium business | Business Central, N...
Unanswered

Drop shipment with prepayment - error when posting Salesinvoice

(1) ShareShare
ReportReport
Posted on by Groefte 56
We are on BC Application  Version 24.2.20227.20460
 
Has set up a Drop shipment with prepayment 30% on both sales order and purchase order. 
Prepayment invoices are paid and closed.

Forgot that it was Drop shipment so made a purchase receipt on the purchase order.... created a sales invoice and picked up 
the sales delivery and here I am stuck when posting the Salesinvoice
 
Error message:
The total Prepayment amount, which is deducted excl. VAT must be at least 300.
 
Have checked that the amount of prepayment invoices matches the % indicated on the sales order and purchase order.
Cannot cancel purchase receipt lines or sales delivery lines.
 
Any idea what to look for.
Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • Groefte Profile Picture
    Groefte 56 on at
    Have recreated above scenario in our demo company and the same error result appears.

    If I run a test report on the sales invoice, there is no error message and the prepaid amount appears correctly and is deducted.

    If I run preview posting the error appears
    Error message:
    The total Prepayment amount, which is deducted excl. VAT must be at least 300.
     
    Any help will be appreciated - thank you.
  • Andy Wingate Profile Picture
    Andy Wingate 326 on at
    Hi,
     
    I have tried to re-create your error - but it's all working for me - here are the exact steps i took - what did I do differently from you?
     
    Create Sales Order, set as drop ship, set 30% prepayment, post prepayment Invoice.
    Create Purchase Order, set Sell-to as the drop ship cust, set 30% prepayment, post prepayment.
    Post - Receive on the PO
    Draft an SI, set cust, get shipment lines - post 
     
    Here is a short vid of my steps: https://www.screenpresso.com/=fQ3hg
     
    Hope that helps!
    A
     
     
     
  • Groefte Profile Picture
    Groefte 56 on at
    Thank you very much for reaching out to help.

    The difference is that you released SO and PO after posting prepayment invoices - I posted payments, otherwise everything else was done in exactly the same order.

    I will try doing it your way and see if it makes a difference.
     
    (Are we on the same BC version (Version 24.1.18927.19282))

    I can see that we received an update to Version 24.2.20227.20460 this morning.
  • Groefte Profile Picture
    Groefte 56 on at
    Have tried in exactly the same way as you have - unfortunately I got the same error result:
    The total Prepayment amount, which is deducted excl. VAT must be at least 300.

    Then I tried to execute a scenario in the order we normally execute for a drop shipment
    Create Sales Order, set as drop ship, set 30% prepayment, post prepayment Invoice.
    Create Purchase Order, set Sell-to as the drop ship cust, set 30% prepayment, post prepayment invoice.
    post - Payment
    Post SI directly from SO or post a delivery and Draft an SI, set cust, get shipment lines - post .. then it works both ways - no errors
    So the errors appear when you start with Post - Receive on the PO.
     
    But still have a posted receipt from the purchase order and a posted delivery from the sales order - from my very first attempt - that I cannot cancel or post.
     
    If anyone has an idea "how to" with posted delivery/receipt it would be appreciated

     

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,135

#2
YUN ZHU Profile Picture

YUN ZHU 733 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 612

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans