Skip to main content
Solved

Expiration and Lot serial numbers are null in Webservice endpoints


Hey All,

I have been working with the following API’s to look for LotSerial# and expiration of products to no avail

I’ve added Lot/Serial Nbr. as a returned field to:

StorageDetailsInquiry.StorageDetails
StorageDetailsByLocationInquiry.StorageDetailByLocation


And all seem to return 

"LotSerialNumber": {},

Despite being present in  InventoryAllocationInquiry.Results.LotSerialNumber.

Any tips for requesting this information?

Chris

Best answer by Dmitrii Naumov

@ChrisHaddy you should first edit the generic inquiry to include the Lot Serial Nbr in the UI grid and then add it to the endpoint. That should help.

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

5 replies

Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+6
  • Acumatica Moderator
  • 595 replies
  • February 16, 2023

@ChrisHaddy  have you also added the field to the Inquiry itself? Can you access it from the UI of  Storage Details?


  • Author
  • Freshman I
  • 6 replies
  • February 16, 2023

Hey Dmitrii!

Thanks for taking the time to respond.

I believe I have addressed the inquiry part- but i believe i have not done the storage details UI part correctly.

Ive added a screenshot for the inquiry, with the field added, and then a second for storage details, in which i think i am missing the required column.

Is that correct?

Thanks again

Chris


Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+6
  • Acumatica Moderator
  • 595 replies
  • Answer
  • February 16, 2023

@ChrisHaddy you should first edit the generic inquiry to include the Lot Serial Nbr in the UI grid and then add it to the endpoint. That should help.


  • Author
  • Freshman I
  • 6 replies
  • February 16, 2023

Hey Dmitrii,

Is this what you were envisioning? I currently return nothing, but is that due to the sql statement not accounting for inventory items that are not in the shipping state?

Chris


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2655 replies
  • March 20, 2023

Hi @ChrisHaddy  were you able to find a solution? Thank you!


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