Prepayment Sales Amount reporting - Not possible? - Business Central Online

nev

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?