Hi Ludwig,
Below are the details for the issue I am having. I would like to know if there's any way to avoid the overstating of the PPV when posting a PO that has cost components from the Costing Sheet. My goal is to avoid customization of the costing sheet or the process for posting cost components when posting a purchase order.
When creating the costing sheet calculations for a Unit Based node or a Surcharge node, I can only define the rate calculation for the cost component using the Site storage dimension.
I’m trying to alleviate an overstated Purchase price variance when placing a purchase order for an item. The issue is that I can create a Purchase price and calculate a cost price based on the item variant but when I post the PO product receipt, the system brings in an unnecessary cost component from the costing sheet because the costing sheet only sets the cost per the item’s site. There’s no simple way to articulate this so please see my attached documentation and screen shots
I’m using an item with the Configuration, Size, and Color product dimensions to differentiate the costs of the item per variant. I want to use the Costing Sheet to calculate the different costs based on percentages (Surcharge) and fixed amounts (Unit based) of the cost components contained within the costing sheet.
I created two separate costing versions to differentiate the item variants using the 1st Configuration compared to the SMP Configuration product dimension. When D365O calculates the cost in the Item Price form, it knows which costs components to include.
I have the following cost components configured in the costing sheet for Site = MainOffice:
Agent = 2%
Duty = 1%
Freight = 3%
If the purchase price of the item with Configuration = 1st, Size = Large, and Color = Black is $20, then the cost of the item will be $21.20, because the 2% Agent fee = 0.40, the 1% Duty = .20, and the 3% Freight = 0.60.
I have the following cost components configured in the costing sheet for Site = SecOffice:
Agent = 2%
Overhead = $6
If the purchase price of the item with Configuration = 1st, Size = Large, and Color = Blue is $25, then the cost of the item will be $31.50, because the 2% Agent fee = 0.50, and the Overhead flat fee is $6.
I have a Sample cost component configured in the costing sheet for both sites MainOffice and SecOffice because I can purchase samples of the product to either site. The Sample cost component has a cost of $10 for Site = MainOffice and $15 for Site = SecOffice.
If the purchase price of the item with Configuration = SMP, Size = Large, and Color = Magenta is $40, then the cost of the item in Site = MainOffice is $50 because the Sample flat fee is $10
When I create a purchase order with the following product configurations I’m expecting to only see the related cost components (1st/Large/Black) in the product receipt posting, the system posts those cost components accurately but it also includes the $10 Sample Cost Component because it is associated with the MainOffice site thereby creating an “overstated” purchase price variance.
When I go to the Item Price form and check the standard cost transactions, I can see why it created the variance.
I look forward to your response.
Best regards,
Brandon
