Solved

Expiration and Lot serial numbers are null in Webservice endpoints

  • 16 February 2023
  • 5 replies
  • 47 views
C
Rank

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

icon

Best answer by Dmitrii Naumov 16 February 2023, 19:47

View original

5 replies

Dmitrii Naumov
Rank
Userlevel 7
Badge +5

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

C
Rank

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

2 Attachments
Dmitrii Naumov
Rank
Userlevel 7
Badge +5

@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.

C
Rank

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

2 Attachments
Chris Hackett
Rank
Userlevel 7
Badge

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved