This portal is to open public enhancement requests for IBM Sterling products and services. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).
We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:
Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,
Post an idea.
Get feedback from the IBM team and other customers to refine your idea.
Follow the idea through the IBM Ideas process.
Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.
IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.
ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.
See this idea on ideas.ibm.com
Is there an approach that would allow a user to get an audit history for all Items for a specific Tenant/Enterprise and receive the data in a format that can be converted to a CSV file. The intent is to have a business user be able to evaluate all adjustment transactions done in IBM for a specific Node across all SKUs that were changed in a given period.
As a business, it would be useful to have the ability to "report" against inventory adjustments made to our inventory within our enterprise US & CA. It's challenging to evaluate the full scale of an issue when we can only view audit trails SKU by SKU. A perfect solution from our perspective would be to have the ability to "export" the table shown in the attached screenshot from the Audit search tool in IBM into a CSV format. Furthermore, the current version of the Supply Audit forces a user to define SKUs. We'd like the option to leave this field blank, so the request returns all supply changes in the audit results.
What is your industry? | Consumer Products |
How will this idea be used?
This feature will be used in situations where we need to audit supply changes that are posted to the IV that come from our WMS. We use a Middleware (Mulesoft) that handles filtering and transformation of the messages coming from the WMS. Given, the MW can encounter errors, we have a business need to be able to cross-check the 2x systems, to identify any erroneous behavior. For example, we recently had an issue were MW re-posted the same adjust Supply message many times over. This resulted in overstatement of ATP and caused overselling and lots of order cancellations. When trying to evaluate the full scope of the issue, it was very difficalt because A. We can only via the audit history in a web-based UI (via order Hub) B. Can only audit by individual SKUs C. Cannot export the table returned in the results into a Excel file. |
By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.
Audit Supply/Demand are both available in API form or via OrderHub UI. However the lookup must be restricted to per SKU lookup in order to maintain acceptable performance expectation, if multiple SKU is required please perform separate calls. For example https://api.watsoncommerce.ibm.com/inventory/{tenantId}/v1/audits/supplies/search-requests
Alternative please look into the use of supply change events https://www.ibm.com/docs/en/intelligent-promising?topic=formats-new-event#newevent__SupplyChange which allow OOB attribute and custom attributed to be exposed. On the use of custom attribute, see https://www.ibm.com/docs/en/intelligent-promising?topic=application-custom-attributes and https://www.ibm.com/docs/en/intelligent-promising?topic=demand-inventory-audit
Please have a look, If there is a needed to convert specifically from json -> CSV there are many open source libraries that can be used for the same task.