Finance | Project Operations, Human Resources, ...

Cost Center in Inventory On-hand

(0) Share

Report

Posted on by oldman.logan

565

Hi. I am trying to display the cost center in the inventory on-hand form.

The cost center is there in the inventtable with name dimension[2].

I added a method CostCenter as in below screenshot for the form and tried to display the dimension[2].

However, it appears blank in the form. Am I missing something? Please let me know how I can fix this.

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Why do you need a cost center for your inventory on hand?

Most inventory transactions (e.g. the purchase of items) are usually pure balance sheet transactions for which no cost center is needed.

Can you find out more about this requirement and why this is needed?

Also consider that inventory related transactions get summarized when they are posted in GL, i.e. when the voucher is created.

Best regards,

Ludwig

Was this reply helpful? Yes No
oldman.logan 565 on at

Like (0)

Report
Copy link

Link copied!

Thanks Dr. Ludwig for your reply. We have inventory at different sites and warehouses. In one of our warehouses, we store the items of our sister concern company. These companies are set as different cost centers since the operations are joint and small to setup as a separate company on AX. So in this case, we have items from the sister company stored in same site, same warehouse but different cost center. So when we want to get a list of on-hand inventory, it would be easier to sort the list by cost center. Or at least display the cost center per item.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi iron.apologist,

Many thanks for the feedback.

Is the cost center the only criteria that allows you differentiating between your own stock and the one of your sister company?

I hope that you are using some other additional inventory dimensions for that purpose, such as shelves, racks, etc. or possibly batch or serial numbers to identify those items because when it comes to financial dimensions as the only separation criteria, things can get tricky.

Do you know if any other differentiation criteria exists or is the cost center really the only one?

Best regards,

Ludwig

Was this reply helpful? Yes No
oldman.logan 565 on at

Like (0)

Report
Copy link

Link copied!

There are very few products of the sister company so we haven't used any other criteria on them. The form "Item Details" provides the option to display the cost center, however, the on-hand report will not provide it.

Back to my original question, is there a reason why it is appearing blank? Inventtable is one of the data sources.

Was this reply helpful? Yes No
oldman.logan 565 on at

Like (0)

Report
Copy link

Link copied!

Any advice?

Was this reply helpful? Yes No
guk1964 10,888 on at

Like (0)

Report
Copy link

Link copied!

How do you physically control /identify the stock ie how does a storeman know to which company any particular piece of inventory belongs?

are there separate POs for same item?

How do does mrp or shortage analysis or costing work? If you hold stock for the same item for each company will it be at the same cost or will each have its own cost? i.e. do you by warehouse or by Site?

It would be simpler with a separate warehouse, or Site - it can physically be the same place with the same locations.

Then you can value inventory by warehouse etc. You can also use a site dimension link - to either Site or warehouse

You might also ant to look into the use of a balancing financial dimension..

However, it might not be so easy to make such changes in a live system -these are fundamental design decisions.

Was this reply helpful? Yes No
oldman.logan 565 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your reply. We use the cost center field in the "item details" list to identify which items belongs to the sister company. There are no same items from either companies because its a different field of business. Yes, we plan to move the said items to a separate warehouse in the system at a later stage even though its physically in the same place. But this can be done at a later stage. It is not easy at this point because this is the process the company has been following before I joined.

Was this reply helpful? Yes No
oldman.logan 565 on at

Like (0)

Report
Copy link

Link copied!

From above replies, should I infer that displaying the cost center in the on-hand report is difficult or not possible? Appreciate your support in this regard. I cannot change the current structure followed in the system currently but this will be done gradually and a new warehouse will be created for the items of the other company. Currently, please let me know if there's any possible options to display the cost center in the on-hand report and why the above method does not work. Many thanks.

Was this reply helpful? Yes No
guk1964 10,888 on at

Like (0)

Report
Copy link

Link copied!

If the items are unique by 'company'/'cost centre', then you should be able to add a filter and run report by items specific range .

Within the existing warehouse create one location range for each company e.g, prefixed cc1 and cc2 .

Do a one off stock transfer.

The physical locations can be the same. e.g. an existing location like wh-01 - will continue to represent cost centre company 1- and you would move some of that stock to e.g. wh-cc-02 - this is a virtual not a physical move.

Then you can run the report by location.

Was this reply helpful? Yes No
oldman.logan 565 on at

Like (0)

Report
Copy link

Link copied!

[quote user="magic1949"]
If the items are unique by 'company'/'cost centre', then you should be able to add a filter and run report by items specific range .

Within the existing warehouse create one location range for each company e.g, prefixed cc1 and cc2 .

Do a one off stock transfer.

The physical locations can be the same. e.g. an existing location like wh-01 - will continue to represent cost centre company 1- and you would move some of that stock to e.g. wh-cc-02 - this is a virtual not a physical move.

Then you can run the report by location.
[/quote]
This is a form actually. Not a report. I am trying to get the form to display the cost center corresponding to the item.

Was this reply helpful? Yes No