Skip to main content
Solved

lot number conversion with attribute carry over

  • May 5, 2023
  • 3 replies
  • 99 views
B
Freshman I

We have a scenario where we sometimes need to convert lot numbers from one type to another.

My question is. Is there a way to do this and have the attributes automatically carry over from the old lot number to the new lot number?

Best answer by hkabiri

@bclemons The attributes are linked to InventoryID which is a uniqueID (noteID) behind the scene and changing the InventoryID (InventoryCD Field on DB) or Lot serial Number on UI should not unlink them from their corresponding Attributes.

    3 replies

    hkabiri
    Acumatica Moderator
    Forum|alt.badge.img+8
    • hkabiri
    • Acumatica Support Team
    • May 5, 2023

    @bclemons  It depends on what you mean by conversion and if this action result into a new record being created or adjust the existing one. If record on table remain the same the corresponding attributes would remain linked.

    Please provide more details on which attributes and how the conversion is being done.

    SAM KABIRI | L2 Support Engineer | hkabiri@acumatica.com | www.acumatica.com
      B
      Freshman I
      • bclemons
      • Author
      • Freshman I
      • May 8, 2023

      We currently have an 8 digit lot number system and are currently converting the existing inventory to a 10 digit system. so we would like to convert the existing inventory to the new system without losing the specific attributes associated the existing products. Basically we are trying to keep all the existing records and attributes and not create a new line of records.

      hkabiri
      Acumatica Moderator
      Forum|alt.badge.img+8
      • hkabiri
      • Acumatica Support Team
      • Answer
      • May 8, 2023

      @bclemons The attributes are linked to InventoryID which is a uniqueID (noteID) behind the scene and changing the InventoryID (InventoryCD Field on DB) or Lot serial Number on UI should not unlink them from their corresponding Attributes.

      SAM KABIRI | L2 Support Engineer | hkabiri@acumatica.com | www.acumatica.com
        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