At the moment on a purchase order and a purchase invoice you can work with quantities.
But especially in the construction industry 80% of the invoices are only amounts and no quantities.
Especially with installments they are based on amounts.
If you enter a purchase order and only receive a part if the amount you now have the enter it in the quantity field. If you do this you have rounding issues. Also for the end users it is very friendly.
Comments
Recurring requirement indeed in the construction industry (or any project oriented business) and it seems to be a big loophole in standard BC unfortunately.
Category: Purchasing
Any there any vendors or applications/ work arounds?
Category: Purchasing
Similar Example.
Once a PO is created. You should be able to receive and invoice the PO multiple times based on the invoice dollar amount without having to utilize the QTY feature.
Example
Current-
A job is created. 1 line for $100. QTY 1 - Description- Paining service.
1 PO is created
Invoice 1- Supplies $50
If I invoice for $50, the PO will close out because the QTY of 1 will have to be consumed. A new PO will have to be completed and job planning lines will have to be tied in to the PO in order for the service to be completed.
IDEA-
A job is created. 1 line for $100. QTY 1 - Description- Paining service.
1 PO is created
Invoice 1- Supplies $50 (Same PO)
invoice 2- Transportation $20 (Same PO)
Invoice 3- Labor- $30 (Same PO)
AP should be able to go into 1 PO and enter the invoice cost in the "Direct unit cost" and invoice WITHOUT The PO closing out.
We do not want to utilize decimals
We do not want to guess on QTY in order to keep the PO open
We do not want to put "cost" in "qty" and "qty" in "cost"
as solutions.
Category: Purchasing
Scenario 1:
A user can create a purchase order with the following lines. This is because he buys something at a vendor and he get three times an invoice (total is 1.000 euro).
Purchase Order:
Description Amount Amount received
Installment 1 333,33 333,33
Installment 2 333,33 0
Installment 3 333,34 0
In this case he give the first installment free (creates a purchase receipt order) and when the invoice is entered they can pick up the received line.
Scenario 2:
Also another scenario is that you buy bricks (for example). Those bricks aren’t counted with quantities. Only with amounts. So in this case you buy 20.000 euro’s of bricks.
Scenario 3:
This is almost the same as scenario 1. Only in this scenario you keep per installment 5% behind and you pay it later (the functionality of keeping amounts behind for payment is construction functionality. But you need amounts only because of the roundings).
Purchase Order:
Description Amount Amount received
Installment 1 333,33 333,33
Installment 2 333,33 0
Installment 3 333,34 0
Purchase Invoice (three times):
Description Amount
Installment 1 316,66
The last (fourth) invoice would be:
Description Amount
Last term 50,-
Category: Purchasing
Business Central Team (administrator)
Thank you for your feedback. We are considering resolving this product suggestion through open source contributions from our community.
You can contribute by assigning yourself on following GitHub issue: https://github.com/microsoft/BusinessCentralApps/issues/182.
Sincerely, Business Central Team