Skip to main content

Notifications

Community site session details

Community site session details

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

Manual sales prepayment

(0) ShareShare
ReportReport
Posted on by 64

Dear All,

The company receive prepayments from its client. Due to Italian regulation we have to issue invoice or payment is arrival.

The company business makes usual to create pre-payment invoice before the order is created and also to change the order deleting items after pre-payment invoice is issued.

How can I manage that in business central?

Kind regards

  • JasonW Profile Picture
    120 on at
    RE: Manual sales prepayment

    Steve, when you say "the Sales Order is set to Released" is that automatic or manual? For us, it appears we have to do it manually to change the Sales Order status from "Pending Prepayment"?

  • Giovanni Azrak Profile Picture
    64 on at
    RE: Manual sales prepayment

    Good day.

    Advance Payments Localization for Czech (Extension) - Business Central | Microsoft Docs

    This does the juob. Regrefully not available for Italian localization.

    Best regards

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Manual sales prepayment

    John,

    Ugh! You want to delete the line that had the Posted Pre-payment Invoice generated against and the Posted Pre-Payment Invoice has already been paid? You cannot delete the line since it has a Posted Pre-Payment linked to it. However, you can perform a Pre-Payment Credit Invoice. This will reverse the Pre-Payment against the Sales Order and make the Sales Order whole again. However, this is an ugly solution since you have to Post the Prepayment Credit Memo. Then refund the money to the Customer (or fake return the funds). Then the document will show no prepayment. Here are some screen shots of my test:

    1. SO with Prepayment posted and paid for

    pastedimage1612451962768v3.png

    2. On SO, click Actions/Posting/Prepayment/Post Prepayment Credit Memo. Now the only reason I am doing this is to reverse the Prepayment on the Line that was prepaid. I have fake refunded the money to a GL Account to clear the Credit Memo so the Sales Order shows Released and not Pending Prepayment.

    pastedimage1612452449506v4.pngpastedimage1612452707109v5.png

    Now I can after posting my fake Cash Receipts Refund, change the Quantity on the Line, Delete the Line, or whatever editing is needed. Please NOTE that you did receive a Prepayment that you will have to apply back to this Sales Order by creating a new Prepayment invoice and then applying the Fake refund to the Invoice.

    Again, its not pretty but doable.

    Hope this helps.

    Thanks,

    Steve

  • Giovanni Azrak Profile Picture
    64 on at
    RE: Manual sales prepayment

    Good day,

    Thanks for your support my issue is in deleting line with posted pre-payment.

    Kind regards

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Manual sales prepayment

    John,

    If you need to modify the Sales Order after the Prepayment Invoice was posted and paid, the Reopen the Sales Order and first Personalize the Sales Line section to add the field 'Prepmt. Line Amount Excl. Tax'. Then make sure the new additional lines show 0 when inserted. (see pic below). You can then release. The final Invoice will include these new lines due.

    pastedimage1612395942713v1.png

    Hope this helps.

    Thanks,

    Steve

  • Giovanni Azrak Profile Picture
    64 on at
    RE: Manual sales prepayment

    Dear Steven Chinsky,

    Good day.

    Thanks for your answare and the paper.

    What to do if after posting Prepayment Invoice and before posting final Invoice the client need to change its order? The order is locked and I can't edit the line.

    Kind regards

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Manual sales prepayment

    John,

    If I follow you correctly, your Company received prepayments from your customers. Italian regulation requires you to issue an Invoice for the prepayment so you can post the prepayment against an invoice. In BC you can do all this very easily:

    1. Create Sales Order to Customer and Items to be sold.

    2. On the Sales Order or Customer Card, setup a Prepayment percentage value

    pastedimage1611956306394v1.png

    3. On the Sales Order, click Actions/Posting/Prepayment/Post Prepayment Invoice. This Posted Prepayment Invoice is created and you can send to your Customer to pay against.

    pastedimage1611956332270v2.png pastedimage1611956400305v3.pngpastedimage1611956586242v4.png

    4. The Sales Order status is set to Pending Prepayment awaiting the acutal Prepaymenet Invoice to be paid (post Caash Receipts)

    pastedimage1611956637672v5.png

    5. After you post Cash Receipt, the Sales Order is set to Released and you can Post Ship and Invoice. Note that the Invoice will reverse the Prepayment against the Invoice total and any remaining balance will be in AR. If prepayment is 100%, no AR will be posted.

    [View:/cfs-file/__key/communityserver-discussions-components-files/758/80534_5F00_Prepayments.pdf]

    Here is the Prepayment manual handout you can use.

    Hope this helps.

    Thanks,

    Steve

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 815

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 1

#3
Mansi Soni Profile Picture

Mansi Soni 569

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans