Consumption to Cost Centre Uploader for SAP Business ByDesign

[PaulMcnally]

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:

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 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.

[ashuklacplus]

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

 

[alex_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

[PaulMcnally]

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

[PaulMcnally]

Hi Ankur,

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

Kind regards,

Paul

[alex_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

[danik2]

Hi Paul,

is it possible to use this for consumption in externally managed locations?

Thanks,

Daniel