Share
Report
39Wrong subtotal on Posted Sales Invoice when a Deposit had been applied
I wonder why customers who use Microsoft Dynamics Business Central (BC in the rest of the text) accept Microsoft's way of handling customer deposits and deposits paid to suppliers.
On an invoice, usually, there is a detail section which specifies the list of items sold (quantity, sales price, etc.) and there is a total section in which we find: the total of items sold, the taxes and the total invoice including taxes. Then, we specify what has been paid and/or what remains to be paid. We agree to say that the sale will be the total of items sold before taxes.
I realize that with BC, this is not the case when using Prepayment Invoice. BC applies Deposit paid (and deducted it) from the Sales Invoice.
On an invoice, usually, there is a detail section which specifies the list of items sold (quantity, sales price, etc.) and there is a total section in which we find: the total of items sold, the taxes and the total invoice including taxes. Then, we specify what has been paid and/or what remains to be paid. We agree to say that the sale will be the total of items sold before taxes.
I realize that with BC, this is not the case when using Prepayment Invoice. BC applies Deposit paid (and deducted it) from the Sales Invoice.
I use Microsoft Dynamics Business Central on the cloud
This Version :
This Version :
I will explain the steps we follow with BC for a normal transaction.
- First we enter a Sales Order for the customer.
- In my example, this is an item that will be sold for $2,025 plus taxes = 2,328.25$.
- We will issue a Prepayment invoice which is equivalent to 50% of the total including taxes of the Sales Order, i.e. 1,164.13$.
- We will enter a Cash Receipt to pay this Prepayment Invoice.
- When the customer comes to pick up their merchandise, we must issue an invoice for the item sold for $2,025 + taxes, i.e. $2,328.25. On the invoice, the deposit already paid by the customer of $1,164.13 should reduce the total payable of the invoice.
- Customer will pick-up the stock, the invoice and will pay the balance of it i.e. 1,164.12$
Step 1 : The Sales Order. : All good.
Step 2 : Prepayment Invoice : All good.
F7 for “Sales” Invoice Statistics
Step 3 Cash receipt : all good.
Step 4 : not good. The amount of the Sales aren’t right because he deducted the Deposit (Prepayment invoice paid at Step3!)
F7 for Sales Invoice Statistics
Firstly there is the problem of having a good subtotal of the merchandise sold on the invoice. We had to modify our invoice form so that BC did not include the lines with general ledger account #21210 for customer deposits.
Already, I'm wondering why I would have to pay to have a good subtotal on a sales invoice as BC should give me a right amount on the invoice.
Already, I'm wondering why I would have to pay to have a good subtotal on a sales invoice as BC should give me a right amount on the invoice.
My concern grows when I realize that the Posted Sales Invoices screen does not show the correct subtotal. So, if I want to export this data into Excel to do some checking or other analysis, the column Amount and Amount including tax are not right because of the Deposit deducted from it.
If I look at the report Customer Sales Statistics, well all numbers of Sales are wrong because BC takes the Deposit as a Sale (in minus) but it’s not a Sale….
And so on for other screens or reports. Still the same problem, the deposit should not reduce the amount of the invoice but should reduce the amount remaining to be paid on the invoice only...
Thank for your help in advance or comments!
All responses (
Answers (
