Toanne Termeer Bronze Medal

Hi @Dominica Sevilla-Oracle and @JohnCirocco Thank you for providing me the answers that I needed. Unfortunately it's not possible to show the correct information for our customers which is very annoying. We will have to look for another solution. If anyone has an idea I'd love to hear it. Toanne

Hi @JohnCirocco Thank you for your answer, I will have the right information now in the search but I do have 2 more questions: We would like to add a custom field on the item record to this search, but I don't see any option to add it I also want to add this search as a Sublist on the Entity form, but unfortunately this…

Hi @Joy Noreen Magoling-Oracle Thank you for providing me the enchancement request, I voted for it right away, That makes my search and result immediately clear. Unfortunately there is no default setting for date/revision. Thank you for your help! Toanne

Hi @Ivy Lopez-Oracle, one more question about the Costed Bill of Materials Inquiry. I test this option with all Standard cost items. Our customer will not use the stanard cost for the Raw Materials (components) but they will use Fifo or Lot Numbered. Do you know if we can still use the Costed Bill of Materials and de…

Hi @Ivy Lopez-Oracle , I did change the resources in the Work center and I did finished the Revaluing Standard Cost Inventory. I try to add a new routing to my assembly item (and revaluating standard cost) but the Top Level Conversion cost are still the samen. I do see the expected results if I change my 'BOM Display…

Hi @John Griffin That seems to work! thank you for your tip! Although my Top level Conversion Cost are not calculated even the Finished item has a Routing with cost templates Costed Bill of materials inquiry: Additional question about the Top level Conversion cost, how is the field calculated? The calculated conversion…

Hi @Ivy Lopez-Oracle , I am, I have a semi finished product, that calculates the correct value after the 'Revaluing Standard Cost' (although i guess, i just find my conversion costs very high). How is this calculated? My finished product (Of which my semi-finished product is a part) is not calculated, even though I have…

Hi @Ivy Lopez-Oracle I first need to test if this is realy the answer. I test a couple work orders completion but so far not the answer that i hoped for. If it will provide the solution off course I will click 'yes' to the answer you provide me. ? Have a good day!

Hi @Ivy Lopez-Oracle Thank your for your answer. I think this wil help because the setting was on 'Based on Custom Schedule' at 7.00 PM. I just changed it to 'After Transaction Entry' so I think this will resolve the issue for calculating the projected value direct and correct. Also thanks for providing the SuiteAnswers…

Hi @Joy Noreen Magoling-Oracle Thank you for your answer. You have completely understood my issue correctly. I know there is a option 'Costed Bill of Materials Inquiry' this displays the cost for the routings steps and the inventory but this option only works when you use Standard Cost. You can run this inquiry for a…

Hi @Erick Dela Rosa-Oracle For the error with the character limit, i copied your code and I haven't made any changes to your code. It's strange that the new date is calculated correctly but the character limit for the formula is exeeded. I will check the error in the workflow and the character limit by the Support Team.…

Hi @Erick Dela Rosa-Oracle , I just used your example formula but I get an error that the length of the workflow has been exceeded. When I create a sales order, the expected ship day is calculated correctly. When I check the Workflow History I see that the 'Value was not set succesfully' despite the fact that the date on…

Hi @Joy Noreen Magoling-Oracle , Our customers use the Work in Progress en they would also like to see the Cost of the routings steps in the projected value. So not only the raw materials in the Bill of Materials but also the steps for the Manufacturing Routings. Do you know there is a solution for this? The solutions you…

Hi Shadid, I think you first need to 'Build' your assembly item with the components. After the assembly build the Average cost will be displayed on the purchase/inventory tab. @Joy Noreen Magoling-Oracle helped me with a simular question:…

Hi @Erick Dela Rosa-Oracle Thanks for your answer. I will test the formula's en maybe with different workflows. Thanks for your help!

Hi @Joy Noreen Magoling-Oracle This is very helpfull thank your for these answers! I think option 1 and maybe option 2 will possibly work for our customer. I hope both options also works with a completely new assembly item and BOM (and not a copy of an existing Bom/Item). Thank your so far for your help. Kind Regards,…

Hi @Erick Dela Rosa-Oracle, That clears things up, thanks for your explanation. Our first day of the week in the general prefences is Monday, should it be: '1 - Monday, 2 - Tuesday, 3 - Wednesday etc'. or is it always '1 - Sunday , 2 - Monday, 3 - Tuesday' etc? Do you may also have a solution how to add the Default Ship…

Hi @Erick Dela Rosa-Oracle , Thank you for the new formula. One question, what are the 1, 6, 3, 7, 2 for id's ? Can you tell me what this formula does now? So that I understand the Formula? Is it related to the default Ship day that is set on the customer? This is de list for the Shipping days: (Edit on Customer and Source…

Hi @Erick Dela Rosa-Oracle, Thanks for your help, the date is no count correct. Although the counted date is visable after submit the sales order. What do i have to do to change this action after they add a new item on the sales order? Is it possible with a Sublist Action to change this tigger? In the sublist actions I…

Hi @Erick Dela Rosa-Oracle , Thank you for your respons. I'm not that good in workflows with formula's so I hope you are able to help me. The situation in printscreens: Assembly Item information: Field 'Lead Time in Days' Field on Sales ordeR: Field ID 'Lead Time Days' on transaction: Workflow: Hope these screenshots helps…

Hi @Ivy Lopez-Oracle, Thank you for your answer. I just looked up the enhancement and immediately voted for it. What I did for now is: Add a custom field on the Item with the Minimum Order Quantity Add a new transaction line field on the Purchase Order en source from the new custom field on the Item The minimum order…