Updating Item UomGroup via Service Layer - possible or not?

[mgregur]

Dear Experts,

After some testing, I have found that it is not possible to update UomGroup of an Item through Service Layer. Can anyone confirm, or maybe tell me if I'm missing something, maybe some field that also needs to be updated with change of UomGroup?

I've tried PATCH both with and without updating the UomEntries:

{
    "ItemCode": "SLtest",
    "UoMGroupEntry": 17,
    "InventoryUoMEntry": 5,
    "DefaultSalesUoMEntry": 5,
    "DefaultPurchasingUoMEntry": 5,
    "DefaultCountingUoMEntry": 5
}

{
    "ItemCode": "SLtest",
    "UoMGroupEntry": 17
}

Each time the response is following:

{ "error": { "code": "-2028", "message": "No matching records found (ODBC -2028)" }}

Any help would be appreciated.

BR,

Matija

[mgregur]

Hi,

can anyone confirm? ankit.chauhan1 nidhisingh14 is this maybe a known bug?

BR,

Matija

[ANKIT_CHAUHAN]

Hi mgregur,

It would be better to share few screenshots showing what is the setup and which field you are trying to update.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[mgregur]

Dear ankit.chauhan1,

testing is done through Postman:

The field in the client/DB I am trying to update is OITM.UgpEntry:

If I change it through the client, it changes correctly. But update via Service Layer gives the error:

{ "error": { "code": "-2028", "message": "No matching records found (ODBC -2028)" }}

This was also tested through a simple IF scenario, and updating this field is not possible. But the question is why, as this should be possible as long as there are no transactions for that item.

BR,

Matija

[mgregur]

ankit.chauhan1 any thoughts on this?

BR,

Matija

[ANKIT_CHAUHAN]

Hi mgregur,

In order to change the UoMGroupEntry, can you add all UoMEntry related to that UoMGroup (by importing ITM12 template) and test the issue again?

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[mgregur]

Hi ankit.chauhan1,

Tried it just now with below structure, still got the same error.

{
    "ItemCode": "SLtest",
    "UoMGroupEntry": 18,
    "ItemUnitOfMeasurementCollection": [
        {
            "UoMType": "iutInventory",
            "UoMEntry": 6,
            "DefaultBarcode": null,
            "DefaultPackage": null,
            "Length1": 0.0,
            "Length1Unit": null,
            "Length2": 0.0,
            "Length2Unit": null,
            "Width1": 0.0,
            "Width1Unit": null,
            "Width2": 0.0,
            "Width2Unit": null,
            "Height1": 0.0,
            "Height1Unit": null,
            "Height2": 0.0,
            "Height2Unit": null,
            "Volume": 0.0,
            "VolumeUnit": null,
            "Weight1": 0.0,
            "Weight1Unit": null,
            "Weight2": 0.0,
            "Weight2Unit": null,
            "ItemUoMPackageCollection": []
        },
        {
            "UoMType": "iutPurchasing",
            "UoMEntry": 6,
            "DefaultBarcode": null,
            "DefaultPackage": null,
            "Length1": 0.0,
            "Length1Unit": null,
            "Length2": 0.0,
            "Length2Unit": null,
            "Width1": 0.0,
            "Width1Unit": null,
            "Width2": 0.0,
            "Width2Unit": null,
            "Height1": 0.0,
            "Height1Unit": null,
            "Height2": 0.0,
            "Height2Unit": null,
            "Volume": 0.0,
            "VolumeUnit": 2,
            "Weight1": 1.0,
            "Weight1Unit": 3,
            "Weight2": 0.0,
            "Weight2Unit": null,
            "ItemUoMPackageCollection": []
        },
        {
            "UoMType": "iutSales",
            "UoMEntry": 6,
            "DefaultBarcode": null,
            "DefaultPackage": null,
            "Length1": 0.0,
            "Length1Unit": null,
            "Length2": 0.0,
            "Length2Unit": null,
            "Width1": 0.0,
            "Width1Unit": null,
            "Width2": 0.0,
            "Width2Unit": null,
            "Height1": 0.0,
            "Height1Unit": null,
            "Height2": 0.0,
            "Height2Unit": null,
            "Volume": 0.0,
            "VolumeUnit": 2,
            "Weight1": 1.0,
            "Weight1Unit": 3,
            "Weight2": 0.0,
            "Weight2Unit": null,
            "ItemUoMPackageCollection": []
        }
	]
}

BR,

Matija

[former_member374449]

Hi mgregur,

I tried same as your and I can able to update the UoM Group of ItemCode in Item Master Data by Service Layer.

Thanks & Regards.

Manish Pant

[mgregur]

Hi manish.pant005,

What version / FP are you on?

Thank you,

Matija

[former_member374449]

Hi mgregur,

I am using the SAP Business One 10 version for HANA FP 2202.

Thank you.

Manish Pant

[ANKIT_CHAUHAN]

Hi mgregur,

I would suggest you to create an incident for SAP Business One support team to get it investigated.

Kindly mention the link of this discussion while creating the incident.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support