Solved

How to update Lot serial Attributes in Receipts screen using API calls.

  • 25 July 2023
  • 7 replies
  • 166 views

Userlevel 1

Hi Team,
We have a requirement as we create a receipt via API calls and insert line details with the insertion of attributes ..(using PUT request) Receipt is created with line details and released but attributes are not inserted. can you please review and suggest the best way possible to achieve it.

Thank you!

icon

Best answer by RohitRattan88 28 July 2023, 21:32

View original

7 replies

Userlevel 7
Badge +11

Hi @SanthoshB09 

Can you tell me which attribute you want to add through API call? Share the screenshot if possible.

Userlevel 1

Thank you @jinin for the response, I am unable to update lot serial attributes in the receipts screen through the API calls, here is the screenshot.
Can you suggest to achieve this and help with that please.
 

 

Userlevel 7
Badge +11

Hi @SanthoshB09 

As per the below screenshot, can you add the attributeDetails as a separate entity?
I believe the attribute section will function based on the customization in place.

 

 

Userlevel 7
Badge +4

Hi @SanthoshB09 as @jinin suggested, extend your endpoint to map Attributes:

Please review my Endpoint definition to GET attribute details:

 

 

POSTMAN call and result:

 

To create, just make a Put call to InventoryItem endpoint and pass your body accordingly

Hi @RohitRattan88 
 

Currently, when posting into the values into the AttributeDetails we must put the Line Details and Attributes as Linked entities in the Web Service Endpoint, this allows us to post an attribute, but it only posts into the first available Attribute, as we have to change it from an Object to a single field.


If we change the AttributeDetails to Detail, this does not seem to allow us to update the Attributes, it posts successfully but does not actually update the Attributes.

Can you provide some clarification on this? We are using this with PurchaseReceipts.

 


Json Payload:
{
  "Branch": {
    "value": "MAIN"
  },
  "Details": [
    {
      "Allocations": [
        {  
        "RGWSExpiryDate": {
            "value": "2024-05-17T00:00:00+10:00"
          },
          "RGWSPackDate": {
            "value": "2024-05-17T00:00:00+10:00"
          },
          "Location": {
            "value": "WHOLESALE R01C02L04"
          },
          "LotSerialNbr": {
            "value": "240517-3"
          },
          "Qty": {
            "value": 250
          },
          "SplitLineNbr": {
            "value": 1
          },
          "ExpirationDate": {
            "value": "3000-01-01T00:00:00+11:00"
          },
          "rowNumber": 1
        }
      ],
      "LineDetails": {
          "AttributeDetails": [
          {
            "rowNumber": 1,
            "note": null,
            "Attribute": {
              "value": "DATECODE"
            },
            "Value": {
              "value": "01/01/2024"
            }
          }
        ],
         "Location": {
          "value": "WHOLESALE R01C02L04"
        },
        "LotSerialNbr": {
          "value": "240517-3"
        },
        "Qty": {
            "value": 0
          },
        "SplitLineNbr": {
          "value": 1
        },
        "ExpirationDate": {
          "value": "3000-01-01T00:00:00+11:00"
        },
        "rowNumber": 1
      },
      "Branch": {
        "value": "MAIN"
      },
      "InventoryID": {
        "value": "JOSELOT3"
      },
     "LineNbr": {
        "value": 1
      },
      "Location": {
        "value": "WHOLESALE R01C02L04"
      },
      "POLineNbr": {
        "value": 1
      },
      "POOrderNbr": {
        "value": "000324"
      },
      "POOrderType": {
        "value": "RO"
      },
      "ReceiptQty": {
        "value": 5
      },
      "Warehouse": {
        "value": "WHOLESALE"
      },
      "rowNumber": 1
    }
  ],
  "Location": {
    "value": "MAIN"
  },
  "VendorID": {
    "value": "ACITAISYST"
  },
  "VendorRef": {
    "value": "TBO4 - 20240506151327"
  }
}​​​​​​​

Userlevel 7
Badge +4

@paul27 

Have you tried extending LineDetails as detail/array instead of linked entity? same goes for Attribute details.

In my screenshot above, i am extending both as detail entities, not linked.

Userlevel 7
Badge +4

@paul27 

Also review the following project: GitHub - Acumatica/Acumatica-LotSerialNbrAttribute-2023R1-ONWARD: Adding Attribute Support to Lot/Serial Number

Reply


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