Marking for Standard Costing

(0) Share

Report

Posted on by Praveenj

Hi,

We have a business scenario where we want to Mark each Sales Order Line with PO Line, basically to tag each Demand with the available supply. As we use Standard Costing, I believe we can't use the Manual Marking . We can't create PO's directly from SO's as well as consolidated PO's are created based the projections from other CRM. Which means their is no one to one relationship between PO and SO line quantity at the time of PO creation. Also the Site/Warehouse on the SO line is always different from the Site/Warehouse in PO as all PO's are raised from the central warehouse and also received at the Central warehouse. The goods are then sent to SO warehouse by Transfer Order. The lead times for PO's is anywhere between 8-12 weeks.

I have seen the following link which suggests that it can be done with small customization. But as per our Developer , this is not possible with the latest version.

https://www.axug.com/communities/community-home/digestviewer/viewthread?MessageKey=7dd4b3e1-d5aa-4a4c-8bec-e62d0ae0f781&CommunityKey=af0dadbe-c222-4660-9d1e-a9e3416c837a&tab=digestviewer

Can someone please advise the best possible solution to us. We are on Version 10.0.12.

Regards
Praveen

I have the same question (0)

All responses (17)

Answers (0)

tabarret on at

Like (0)

Report

Hello Praveen,

Can you explain why the customization is not possible in the latest version?

Was this reply helpful? Yes No
Praveenj 20 on at

Like (0)

Report

Hi Taylor,

Thank you for replying.

Our Developer has finally done the customization and I can see its working as per the intended functionality. We are able to mark Transfer order, Transfer Journals and PO's.

But now we are concerned that if we move this to prod, will it impact anything else, like Costing, Inventory Valuation etc. We are using Standard Costing only.

Would you be able to shed some light on this please.

Regards

Praveen

Was this reply helpful? Yes No
tabarret on at

Like (0)

Report

Hello Praveen,

It is very difficult for me to shed light on the impact that this customization will have on Costing, Inventory valuation, etc. Without knowing how the customization is created/coded, it's impossible for me to understand the true impact.

I would suggest developing a list of Test scenarios to walk through, and make sure that all of your costing is coming through as expected.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Taylor,

Marking of order is not supported in Dynamics 365 and it returns false in isSettled method of InventModelType_StdCost. using the post event handler I have returned true for this method. I am not sure if it will impact anywhere else.

Thanks,

Ashish

Was this reply helpful? Yes No
Praveenj 20 on at

Like (0)

Report

Thank you Ashish,

Hi Taylor, Ashish and me are in the same Team and Ashish has done this change. If you need any more information. Ashish will be able to answer.

Thanks

Praveen

Was this reply helpful? Yes No
tabarret on at

Like (0)

Report

Thank you Praveen and Ashish. In doing some research, I see that you opened a support ticket, and one of our engineers is consulting the Product group. Let's see what they suggest - please update the thread whenever you have more information from the Support team.

Was this reply helpful? Yes No
Praveenj 20 on at

Like (0)

Report

Thank you Taylor. Will update as soon as I receive any update from Product group.

Regards

Praveen

Was this reply helpful? Yes No
Praveenj 20 on at

Like (0)

Report

Hi Taylor,

Following is the response from our SR.

I have raised your concern to our backend team and asked for their suggestion.

Here is their advice for your reference:

From code perspective, if customer is changing IsSettled to be true for InventModelType_StdCost, the major impact is in InventOpenQtyCriticalDP (Check open quantities). Making IsSettle = true will impact this report. The original design is to exclude transactions from this report if they are standard cost and moving average. Now the report will include standard cost item. Customer need to understand this impact.

Ideally, such change won't impact inventory closing because anyhow this is standard cost. But the validation on such is recommended.

I also paste the reference for this method such that you can further justify

Please kindly note our scope of agreement as below:

Scope Agreement: This incident will be considered resolved and will be archived once we are able to provide a resolution/information

or a workaround for the issue described within the Issue definition section,

or if the issue is found to be 3rd party or customization related,

or if the issue is found to be due to a known problem or is by design or is not supported,

or if the issue is found to be system minimum hardware/software requirements being not met,

or if the issue is found to be resource limitation,

or if the issue does not occur again and there is no way to reproduce.

Would you please advise.

Regards

Praveen

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Taylor,

We got below response from MS:

From code perspective, if customer is changing IsSettled to be true for InventModelType_StdCost, the major impact is in InventOpenQtyCriticalDP (Check open quantities). Making IsSettle = true will impact this report. The original design is to exclude transactions from this report if they are standard cost and moving average. Now the report will include standard cost item. Customer need to understand this impact.

Ideally, such change won't impact inventory closing because anyhow this is standard cost. But the validation on such is recommended.

I also paste the reference for this method such that you can further justify

Will this change not impact the movement journal cost posting, return orders cost and inventory valuation report?

Thanks,

Ashish

Was this reply helpful? Yes No
tabarret on at

Like (0)

Report

Hello Ashish,

From an Internal Microsoft perspective, it is hard for me to give you an answer, as we only have expertise in the standard design of the product. I would defer your question to other members of the community that may have performed the same customization. And as always, I would recommend establishing a set of scenarios to run through and validate the movement journal cost postings, return order costs, and inventory valuation report.

Was this reply helpful? Yes No