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
We are in the Constuction industry, we had this scenario. It is not construction, but you have similar situation in other businesses, businesses order in dollars and receive in dollars. It's annoying BC doesn't have solution for this. As a workaround we are entering dollars in QTY column (Unit if measure is Dollar) and receiving in dollars. Users are not happy with this workaround but no other way we can receive in exact dollars.
Category: Purchasing
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.ExampleCurrent-A job is created. 1 line for $100. QTY 1 - Description- Paining service.1 PO is createdInvoice 1- Supplies $50If 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 createdInvoice 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 decimalsWe do not want to guess on QTY in order to keep the PO openWe 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 receivedInstallment 1 333,33 333,33Installment 2 333,33 0Installment 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 receivedInstallment 1 333,33 333,33Installment 2 333,33 0Installment 3 333,34 0Purchase Invoice (three times):Description AmountInstallment 1 316,66 The last (fourth) invoice would be:Description AmountLast 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