Skip to main content
Solved

Expiration and Lot serial numbers are null in Webservice endpoints

  • Feb 16, 2023 5:34 PM UTC
  • 5 replies
  • 157 views
  • Translate All
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.

View original

    5 replies

    Dmitrii Naumov
    Community Manager
    Forum|alt.badge.img+7

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

    Translate
    Freshman I
    • ChrisHaddy
    • Author
    • Freshman I
    • Feb 16, 2023 6:08 PM UTC

    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

    Translate
    Dmitrii Naumov
    Community Manager
    Forum|alt.badge.img+7
    • Dmitrii Naumov
    • Community Manager
    • Answer
    • Feb 16, 2023 6:47 PM UTC

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

    Translate
      Freshman I
      • ChrisHaddy
      • Author
      • Freshman I
      • Feb 16, 2023 8:11 PM UTC

      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

      Translate
      Chris Hackett
      Community Manager
      Forum|alt.badge.img
      • Chris Hackett
      • Acumatica Community Manager
      • Mar 20, 2023 9:32 PM UTC

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

      Translate
      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