Skip to Content
Product Information
Author's profile photo Paul McNally

Consumption to Cost Centre Uploader for SAP Business ByDesign

SAP Business ByDesign supports a process called “Consumption to Cost Centre” which allows you to issue or receive stock into a logistics area and assign the costs of this transaction to a particular cost centre.  An example of using this would be moving a box of consumable items, such as gloves, into a production area by booking the whole box off stock.

As standard this is a manual process within SAP Business ByDesign which works really well when you only need to update one or two items at a time, however if you have a lot of items to process in one go it can be very time consuming and prone to error.

In order to ease this situation we have developed a new uploader to allow you to mass create consumption to cost centre transactions by using a very simple Excel template:

Upload%20Template%20for%20Consumption%20to%20Cost%20Centre%20Uploader

Consumption to Cost Centre Uploader Template

After saving this Excel file as XML data (a save as type option in Excel), we then use the standard File Input process provided within SAP Business ByDesign to process this file and create the relevant consumption to cost centre transactions based on the data entered into the template:

Confirmation%20Journal%20Report

Confirmation Journal Report

The result is a streamlined method of creating multiple consumption to cost centre transactions.

You can find out more on the SAP Store.

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ankur SHUKLA
      Ankur SHUKLA

      Hello Paul,

      Many thanks for sharing this new functionality in ByDesign; indeed very useful and time-saving in prouction flows!

      Does something similar exist or planned for "Consumption for Project (Task)" scenario?

      We have several Customers asking for a way to mass-consume loose items from the Warehouse shelves directly into Projects whithout going through the PSO and Delivery flow; ofcourse the current manual process flow is working but it would be nice to have an uploader like this doing the job.

      Thanks,

      Ankur SHUKLA

       

      Author's profile photo Paul McNally
      Paul McNally
      Blog Post Author

      Hi Ankur,

      Yes it should be possible to develop such an uploader as there is a web service available.

      Kind regards,

      Paul

      Author's profile photo Alexander Sinel
      Alexander Sinel

      Hi Paul,

       

      Looks great!

      We also raised several requests for similar functions time ago - still we get solutions postponed from release to release e.g. now we are expecting it with 2111 but our hope has almost melted. I think, you know my feelings, we all know...

      1. Inventory Counts (Product Counts). Mass upload products from Excel to SAP ByDesign - https://influence.sap.com/sap/ino/#/idea/210704
      2. Mass upload line items to item table- Product Count (non-3PL site) & Inventory Adjustment (3PL site) - https://influence.sap.com/sap/ino/#/idea/245151
      3. Mass upload line items to item table - https://influence.sap.com/sap/ino/#/idea/218311

      Paul, what do you think, is it possible to develop similar solution for:

      1. Stock transfer
      2. Scrapping
      3. Inventory adjustment
      4. Consumption to cost center
      5. Goods movement
      6. Product count
      7. Inventory Notification

      Thank you for your reply!

      Cheers,

      Alexander

      Author's profile photo Paul McNally
      Paul McNally
      Blog Post Author

      Hi Alexander,

      Yes it would be nice if these were all standard!

      We have created uploaders already for stock transfer orders, goods movements and consumption to cost centre.

      The way we view it is if there is a web service available to do the transaction then we can develop an uploader to process them in bulk.

      So based on that, scrapping should be possible, notifications as well but inventory adjustments don't look available.

      Kind regards,

      Paul

      Author's profile photo Alexander Sinel
      Alexander Sinel

      Hello Paul,

      Thank you for your reply here, it makes sense for me. I will pass it to our IT, so guys could look into such opportunity.

      Cheers,

      Alex