Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Prepayment Sales Amount reporting - Not possible?

(1) ShareShare
ReportReport
Posted on by
We are not able to do item reporting from the item ledger entries and value entries for prepayment sales,
 
We have a client that does a 100% prepayment
 
After the prepayment has been posted, and the sales order is then shipped and invoiced, the system does not reverse the pre-payment and post the invoice, rather it posts the ship and invoice with a sales value of zero on the lines, the printed invoice has zero for the sales value.
 
If you look at the item ledger entries for those shipped and invoiced lines, and they show zero sales value and there is no reference to the sales value on the posted sales invoice lines
(Adjust cost item entries does not do anything)
 
 
You can reproduce this by creating a sales order
Manually updating the prepayment amount on the order to 100%
Posting the prepayment invoice
Pay that invoice (Or turn off the Check prepayment when posting in sales setup)
Ship and invoice the sales order
 
Looking at the item ledger entries and value entries there is no sales value, looking at the posted sales invoice there is no sales value
 
This has broken our item reports that were looking at the sales values on the sales lines and item ledger entries
 
Anyone know how we can get around this?
  • Suggested answer
    Shauna Langley Profile Picture
    879 Super User 2025 Season 1 on at
    Prepayment Sales Amount reporting - Not possible?
    Hi,
     
    When I try the steps above I do see a sales value, below screenshot.
     
    When I drill down into the value entries I also see the sales amount.
    On the printed version of the posted sales invoice you could exclude the prepayment lines
     
    Not sure this helps but I was able to get the ILE and Value Entries with a sales amount.
     

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

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

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Featured topics

Product updates

Dynamics 365 release plans