How do we Block Items from making Transactions?

Hello Linkedin Folks,

I hope everyone is doing great.

Today, I will take you into a small topic that will help you to block or unblock the item master in bulk from making transactions like Purchases, sales, or inventory.

Here, I am going to show you the DMF functionality. So we can easily export the details and make the necessary changes then we can import it.

Let us check which is the data entity used for this task and how we can do it.

Steps:

Go to System Administration --> Workspaces --> data management

Create an export project and name the project and click on add entity.

then add the entity "Default order settings", and fill in the Target data format as Excel. then click on Add and close the window.

after that Press, the Export now button from the action pane under the Export option.

it will take some time depending on the data size and you will get the excel file with the data.

once the export is completed you will see the above screen which will give you the summary of your Job.

you can download the file if it succeeded, if it fails you can check the execution log and staging data and you can see the errors.

then open the downloaded excel file. you can see 3 columns named ISINVENTORYPROCESSINGSTOPPED, ISPROCUREMENTPROCESSINGSTOPPED, and ISSALESPROCESSINGSTOPPED. these are the 3 columns that we need to change as per the requirement. by default, it will be marked as NO. therefore if you wish to block it change it to YES.

here in the below image, I have highlighted those columns in yellow and I have highlighted items I want to block in red.

Thank you for your time and support. I would appreciate your feedback on my articles. it will encourage me to do more and we can learn together.

Learn & Share

Aslam Ali