Best Of

Sorry, forgot to post the script:

function postSourcing(context) {
        // Get the current record object
        var currentRecordObj = currentRecord.get();
    
        // Get the ID of the field that triggered the event
        var fieldId = context.fieldId;
 
        if (fieldId == 'item') {
            var item = currentRecordObj.getCurrentSublistValue({
                sublistId: 'item',
                fieldId: 'item'
            });
            if(item != ''){
                // Set the value of the 'itemlocation' field in the currently selected line
                currentRecordObj.setCurrentSublistValue({
                sublistId: 'item',
                fieldId: 'quantity',
                value: 9,
                })
 
                // Set the value of the 'itemlocation' field in the currently selected line
                currentRecordObj.setCurrentSublistValue({
                    sublistId: 'item',
                    fieldId: 'inventorylocation',
                    value: 9,
                })
            }
        }
    }

Hi @Greg Ebel,

Can you try adding this to your internal CSS template:

• td { padding: 4px 6px; border-left: 1px solid black; border-right: 1px solid black; border-top: 1px solid black; border-bottom: 1px solid black; }
• th { font-weight: bold; font-size: 8pt; vertical-align: middle; padding: 5px 6px 3px; background-color: #e3e3e3; color: #333333; padding-bottom: 10px; padding-top: 10px; border-left: 1px solid black; border-right: 1px solid black; border-top: 1px solid black; border-bottom: 1px solid black;}

Let us know if this has worked for you. Thanks! ☺️

If it is not creating the work orders for the sub assemblies, you need to update your BOM Revisions to reflect Source=Work order. It probably says 'stock' right now? I don't have one handy that shows a subassembly, but if you have these on BOM Revisions as a sub assembly, the choices will include 'Work Order'. Once the source is set on the BOM Revisions, creating the work orders automatically for the Sales Order will include the work orders needed for the sub assemblies.

Make Sense?

~angela

I am probably going to have another set of consultants take a look, there are maybe a couple of other options that might be available to try to solve this. Saved Searches and or a more use of some of the other features of the functionality.

Hi @Jervin Nicholas Teopengco-Oracle This is working. Thank you!

My problem is solved! Sorry I didn't get an answer. My issue was not having the "Core Admin" box checked. This resolved it for me after checking the box for Core Admin. We do not have Team Selling turned on.

@Veronica Steluta Mincior-Oracle

Good morning, it seems that my code has worked for multiple items! I recently had some orders come over with more than 1 item in the cart, and the data was passed over without error!

@User_6YD5L Please see the screenshots for SS

Thank you

Thanks @Patrick Fresnosa-Oracle - I checked and found the error. The currency's default locale field was set to United States. I updated it to India and the reports got corrected with it. Thanks for providing directions.

The override currency format was not marked originally so I did not have to update it.