Skip to main content
Solved

Get Unbilled Quantity per line in a POReceipt via API


Hi,

 

I am needing to get the Unbilled Quantity left on a Receipt.
I can only get the total of all lines, but not the breakdown.

Is there a way to do this?

/entity/Default/22.200.001/PurchaseReceipt/?$expand=Details&$filter=VendorID eq 'V000000001' and ReceiptNbr eq '000092'

here is my API Call URL. I have expanded details. there is nothing in custom etc

 



 

Best answer by nickacfield

The fix offered by   ​@Samvel Petrosov   for my other topic about seraching for POReceiptlines from PONumber also resolved this.

But thanks everyone.

Much appreciated!

View original
Did this topic help you find an answer to your question?

3 replies

Vignesh Ponnusamy
Acumatica Moderator
Forum|alt.badge.img+5

Hi ​@nickacfield,

In the UI, do you see a field having the Unbilled Quantity for each line? If not, you have to customize to create a new field that show the unbilled quantity of each line then you can map the custom field to the endpoint to retrieve through API. 

Hope that helps, feel free to post back if you have any questions.


  • Author
  • Freshman II
  • 5 replies
  • March 19, 2025

Thanks ​@Vignesh Ponnusamy ,

There certainly is not any Unbilled or Billed Quantity on the LINES of the receipt in the UI, only a total at the header level.  However they have the Billed/Unbilled on the LINES in the Purchase Oreder in the UI & API.
Are there steps for adding a new field?
I assume its going to be a calculation


  • Author
  • Freshman II
  • 5 replies
  • Answer
  • March 20, 2025

The fix offered by   ​@Samvel Petrosov   for my other topic about seraching for POReceiptlines from PONumber also resolved this.

But thanks everyone.

Much appreciated!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings