Skip to main content
Solved

Expiration and Lot serial numbers are null in Webservice endpoints

  • February 16, 2023
  • 5 replies
  • 136 views
C
Freshman I

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.

    5 replies

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

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

    C
    Freshman I
    • ChrisHaddy
    • Author
    • Freshman I
    • 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+7
    • Dmitrii Naumov
    • Acumatica Moderator
    • 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.

      C
      Freshman I
      • ChrisHaddy
      • Author
      • Freshman I
      • 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
      • Chris Hackett
      • Acumatica Community Manager
      • March 20, 2023

      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*.
      Terms & ConditionsAccessibility statement
      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