Bee Yook

Hi @Joy Noreen Magoling-Oracle, This Item is lot numbered assembly and below costing method shown "Standard" in item master, however if the location doesnt have average cost, it would take last purchase price of 53.25. Example of the average cost shown in locations Location B : 85.23 - executed inventory revaluation.…

in Item fulfillment gl impact for transfer order Comment by Bee Yook Dec 14, 2023 12:49AM

Hi, @R. Dieka Pribadi G. E. it's setup in accounting sublist in item master. but this is just a gl account code . I m trying to understand how do system get the average cost from below amount as stated in 140005 inventory:finished goods Thanks in advance for your valuable explanation. Best Regards, Bee Yook

in Item fulfillment gl impact for transfer order Comment by Bee Yook Dec 8, 2023 6:21AM

Hi, @Michelle Jabanes-Oracle, thank you for your confirmation. Best Regards, Bee Yook

in What permission rights for Transactionline table for stock balance used for SuiteAnalytics Connect Comment by Bee Yook Dec 8, 2023 2:51AM

HI, @Micah Timbol-Oracle, currently our accounts team using journal to separate the cost , seem no other solution will help them to speed up their job except using allocation expenses. Anyway, thanks. Best Regards, Bee Yook

in Segregation of IT expenses to each department Comment by Bee Yook Dec 8, 2023 2:50AM

Hi, @Michelle Jabanes-Oracle, Yes, you are right, on hand quantity by location in item page, like above. please advise what would be the permission rights? Thank you & Best Regards, Bee Yook

in What permission rights for Transactionline table for stock balance used for SuiteAnalytics Connect Comment by Bee Yook Dec 5, 2023 10:56AM

Hi, @Michelle Jabanes-Oracle, Thank you for your valuable idea. However it seems no transaction_line or transactionline table shown for custom role (KFMSRKK) as below screen captured. Is there any other permission rights that i miss out ? Thanks in advance. Best Regards, Bee Yook

in What permission rights for Transactionline table for stock balance used for SuiteAnalytics Connect Comment by Bee Yook Nov 30, 2023 11:38PM

Hi @Michelle Jabanes-Oracle, Yes, already have this item permission rights with "view" only, However the actual table should be "transaction_lines", according to our vendor for Power BI, she said the table where she can get the details only transaction_lines(she shared below link to me) . Is this true ? Is below sufficient…

in What permission rights for Transactionline table for stock balance used for SuiteAnalytics Connect Comment by Bee Yook Nov 30, 2023 12:34PM

Hi, @Michelle Jabanes-Oracle, I tried ticked "Sales role" and permission for items with view. it seems no "transactionline" table show. Is there any other advice? Thanks & Best regards, Bee Yook

in What permission rights for Transactionline table for stock balance used for SuiteAnalytics Connect Comment by Bee Yook Nov 29, 2023 6:01AM

Hi, @Niks Blando-Oracle Thank you very much for your answer. Looking forward for this NetSuite Guided learning to be released in future. Thanks & Best Regards, Bee Yook

in NetSuite Guided Learning disappeared / missing Comment by Bee Yook Nov 28, 2023 1:05PM

@Nicole Mendoza-Oracle, Thanks for your valuable explanation. How about any idea how to allow iHRMS system to save the csv file to file cabinet in NetSuite System ? Will explore more in suiteanswer for POST HTTPS Requests Thank you & Best Regards, Bee Yook.

in how to automate csv file from HR system to NetSuite System Comment by Bee Yook Nov 2, 2023 12:50AM

Hi @Nicole Mendoza-Oracle, Thank you very much for your valuable advice. How do iHRMS push the data(csv) to file cabinet in NetSuite System ? The automation will be in scheduled scripts and get the csv file from file cabinet. How about can we using REST API integration between iHRMS and NetSuite System ? Would appreciate…

in how to automate csv file from HR system to NetSuite System Comment by Bee Yook Nov 1, 2023 12:15AM

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

in Error msg in Transfer Order, othererror:TypeError: Cannot read property "0" from undefined Comment by Bee Yook Jun 27, 2023 8:38AM

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

in Customer Return Authorise (two approvals) Comment by Bee Yook Jun 20, 2023 12:42AM

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…

in Why is a custom segment not appearing in Income Statement Criteria Column? Comment by Bee Yook May 15, 2023 2:18AM

@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…

in Customer Return Authorise (two approvals) Comment by Bee Yook May 10, 2023 1:48AM

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.

in HOW TO REMOVE? -Custom Selection for price level on a Cash Sale and Invoice Transaction Comment by Bee Yook Mar 27, 2023 8:15AM

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

in How to CSV Import for sales Order with inventory detail & pending fulfilment status Comment by Bee Yook Mar 8, 2023 8:51AM

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

in Consolidated payment or Invoice Group Comment by Bee Yook Aug 19, 2022 12:51AM

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…

in Consolidated payment or Invoice Group Comment by Bee Yook Aug 18, 2022 2:19AM

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

in Add a customized saved search or shortcut in customer dashboard Comment by Bee Yook Jul 22, 2022 2:04AM

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…

in Add a customized saved search or shortcut in customer dashboard Comment by Bee Yook Jul 20, 2022 6:04AM

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

in Script with PO reference number with space Comment by Bee Yook Jun 28, 2022 3:17AM

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…

in Script with PO reference number with space Comment by Bee Yook Jun 27, 2022 12:58AM

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.

in Trend Graph (daily) in dashboard Comment by Bee Yook Mar 28, 2022 12:39AM

@ 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)…

in Trend Graph (daily) in dashboard Comment by Bee Yook Mar 24, 2022 7:36AM

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…

in AE:How to convert GMT to Malaysia time zone Comment by Bee Yook Dec 7, 2021 7:06AM

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

in Convert String to date in saved search Comment by Bee Yook Nov 10, 2021 5:37AM

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".…

in Convert String to date in saved search Comment by Bee Yook Nov 10, 2021 2:23AM

MFA for Oracle Community

Bee Yook Blue Ribbon

Comments