AMOUNT-BASED RECEIPTING OF ORDERS IN BUSINESS CENTRAL

(1) Share

Report

Posted on by Ola01

Hi,

Please how do I raise purchase orders based on total value and then draw down against that value through amount‑based receipting, rather than using quantities.
For example, I raised a PO for Consultancy fee (Service) for £10,000 and I want to raise a GRN for £6,000 while reducing the PO to £4,000. How can this be achieved in BC or is there a way to achieve the draw down without using GRN?

Thanks.

Ola

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

AndrewThomas81 201 on at

Like (1)

Report
Copy link

Link copied!

Hi Ola

This is not possible in Business Central as all purchase/sales lines must contain a quantity, I know in other ERP systems this can be done.

I have had this request before, and one solution is to load the purchase order for a quantity of 10,000 for a Unit Cost of £1. This will allow you to receipt and invoice the quantity for the desired value. However at some point you will need to adjust the total order quantity to allow it to be deleted, unless the draw down is equal to the original quantity/amount.

It could also be acheived by inserting one line for £10,000 and then when draw down is anticipated changing the order to reflect, for example changing the first line to £6,000 and inserting a new line for the remaining £4,000.

Couple of possible answers for you :)

Was this reply helpful? Yes No
Verified answer

Dhiren Nagar 2,705 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi,

This is not possible in standard BC. You can do it only through Quantities.

Here is what you can try.

1 - Create PO with Amount as 10000 and Quantity as 1 or 100.

2 - When you want to receive 6000, enter the Qty. to receive as 0.6 or 60.

3 - Outstanding PO amount will be 4000 and qty as 0.4 or 40.

This way using Quantity as Percentage you can fulfill your scenario, through it will be a workaround.

Alternatively you can create a field of Receipt Amount, on validate of which you can update the Qty. to Receive field with logic of Receipt Amount/Total Amount * Quantity.

✅ Tick the checkbox below to mark the answer as verified, if it helped resolve your question.

Regards,

Dhiren.

LinkedIn - https://www.linkedin.com/in/ca-dhiren-nagar-5079081b2/

Blog - https://dhirennagar.blogspot.com/

Was this reply helpful? Yes No
Ola01 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @Dhiren Nagar, how can this be done "Alternatively you can create a field of Receipt Amount, on validate of which you can update the Qty. to Receive field with logic of Receipt Amount/Total Amount * Quantity." Thanks.

Was this reply helpful? Yes No
Suggested answer

Dhiren Nagar 2,705 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi @CU04050308-0,

You need to write AL code for this.

Following are the steps but AL code you need to develop with the help of Developer or technical consultant.

1 - Create a field on Purchase Line and Purchase Order, Invoice subform pages - Receipt Amount - Decimal.

2 - Write logic on validate Receipt Amount / Amount Including VAT * Quantity. The specific fields you need to change as per scenario. Also If Receipt Amount > Outstanding Amount then error (It can not be more than outstanding amount)

3 - Publish the app, test and deploy in Production.

✅ Tick the checkbox below to mark the answer as verified, if it helped resolve your question.

Regards,

Dhiren.

LinkedIn - https://www.linkedin.com/in/ca-dhiren-nagar-5079081b2/

Blog - https://dhirennagar.blogspot.com/

Was this reply helpful? Yes No
Ola01 2 on at

Like (0)

Report
Copy link

Link copied!

@Dhiren Nagar, I will discuss this with the consultant. Thanks.

Was this reply helpful? Yes No
Ola01 2 on at

Like (0)

Report
Copy link

Link copied!

@AndrewThomas81, Thanks for your response.

Was this reply helpful? Yes No
Suggested answer

Alex A 3,003 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You can create the PO like this:

- Set Quantity on the PO line = 10,000

- Set Unit Cost = 1

- Total = £10,000

- To draw down £6,000, receive 6,000 quantity

- Remaining quantity = 4,000/£4,000 left on the PO

Was this reply helpful? Yes No