Bee Yook Blue Ribbon

Hi, Gurus, Have resolved this issue, the error due to the transfer price is zero. ticked on 'use item cost as transfer price' and ticked on 'TO_costed' field. Thanks & Best Regards, Bee Yook

@Dominica Sevilla-Oracle, thanks for your valuable advices. i believe that we have to look for solution provider to solve this authorization

Hi, @Patrick Fresnosa-Oracle, Revenue Sales currently 1 account code (gl code in COA). We tried in Sandbox by created custom segment for "Item Type" , ticked Sales Transaction and we updated the field with value of "Assembly" or "Inventory Item". In Item, we set the "Assembly" and "Inventory Item" accordingly.. For…

@Dominica Sevilla-Oracle, Thank you for your comments. I have raised support case ticket. They recommendation as below :- Why standard Approval process is followed on Return Authorizations rather than the Approval rule per advanced approvals. , we recommend that you use the available documentation in SuiteAnswers to…

Hi, @BWM- Shem, Do you manage to remove the "custom" in price level in sales order entry ? Could you share with me the scripting ? what is the script name ? Would be appreciated if you could share. Thanks & Best Regards, Bee Yook.

Hi, Niks Blando-Oracle, Thank you for your explanation and guides. The issue has been resolved. Once again, thank you very much.

Hi, @Elychelle Gulen-Oracle, Thank you very much for your guides and explanation. Best Regards, Bee Yook

Hi @Katerina Winklerova, Thanks for your confirmation and valuable advices. Seems we have no way to activate "Consolidated Payment" except waiting for the enhancement. As for Invoice Group, I have tested in Sandbox to combine all invoices from sub-customers into 1 Invoice Group, However i couldn't find a way to combine all…

HI @Elychelle Gulen-Oracle, Thank you so much for your brilliant idea! It really helps me .. Once again, thanks. Best Regards, Bee Yook

Hi, @Elychelle Gulen-Oracle, Thanks for your valuable time on the guides. How about the customized report for "A/R Payment History By Payment (FC)" ? This report i replicated from A/R Payment History By Payment and just added Foreign currency amount column on it. Is there any way to add this report link or anyway for…

Hi, @Mikko De La Fuente-Oracle, Thank you very much for your hints. It working well now. Just added poNum.trim() in filters, that's it. filters[filters.length] = new nlobjSearchFilter('otherrefnum', null, 'equalto', poNum.trim()); Once again, thanks a lot! Best Regards, Bee Yook

Hi, @Mikko De La Fuente-Oracle, Thanks for your advise. I know how to use trim() in saved search but how to apply it in script ? I not understand the statement in the script.. where to put the trim in .. Is it under variable like below ? var poNum = checkStr(nlapiGetFieldValue(trim('otherrefnum'))); Or…

Hi @Joy Noreen Magoling - Oracle-Oracle, Thank you very much for your explaination. Yes, you are right! I have raised a case and they attached my case to the same defect number. Once again, thanks. Best Regards, Bee Yook.

@ Kristoffer Viray-Oracle , Thank you to you too . I just noticed after 3pm (malaysia time), Pacific time is 12am, the trend graph show the figure for 24 Mar 2022 (today), i guess this is time zone issue.. is anyone know where i can set for this time zone for trend graph ? currently, we set our time zone as (GMT+0:00)…

Dear Mikko, Thanks for your valuable advice. Yes, i tried below command but it's still didnt shown malaysia time. TO_CHAR(TO_TIMESTAMP_TZ(TO_CHAR({createddate},'MM/DD/YYYY HH24:MI:SS'), 'MM/DD/YYYY HH24:MI:SS TZH'), 'MM/DD/YYYY HH24:MI:SS TZH:TZM') Could you please advise what will be the correct formula for this…

Dear Ivy, Thank you so much for your hints. Yes, you are right, found there are records with WSA-20210326A20210327 instead of WSA-20210326-20210327.. that cause the error.. Once again, thank you very much.. it really helped. Kind regards, Bee Yook

Dear Ivy, Thank you for your quick replied. For Formula(Text), it working fine. However Formula(date), it shown the following error or as attached: "An unexpected error has occurred. Please click here to notify support and provide your contact information." Yes, you are right, the actual fieldname is "inventorynumber".…