Bee Yook Blue Ribbon

HI, @Elychelle Gulen-Oracle, Thanks for your explanation. for your update, the Case # 5531480 that i raised last last week, they closed it because our support type is Basic and this is their comment "After reviewing your question/concern regarding Variances in accounts , we recommend that you use the available…

Hi, @Micah Timbol-Oracle, After discussion internally, still Journal is much faster that allocation expenses process. Anyway, thanks for your confirmation that only two way to do this cost allocation (either through Expense Allocation or by creating a manual journal entry to record it) Thanks & Best Regards, Bee Yook.

HI, @Elychelle Gulen-Oracle, Once again, thanks for your valuable input on this issue. May i know what would be the best practice in order to reduce the interplant stock transfer and purchase price variance ? Appreciate any valuable advices. Best Regards, Bee Yook

@Elychelle Gulen-Oracle, Thank you very much. ok. yes, i have already raised case to Oracle Support. waiting for their reply. Once again, thanks a lot ! Best Regards, Bee Yook

Hi, @Joy Noreen Magoling-Oracle Thank you for your answer for my question # 3. However i still don't understand the where the cost from which location. 2) Where is the cost of 86.35 from (in GL code of 140005 : Inventory FInished Goods) ? In fact, i tested in Sandbox many times, still can not understand where the cost…

Hi @Joy Noreen Magoling-Oracle, Thank you very much for the SuiteAnswer links. Yes, you are right, by right, it should be auto revaluated if no inventory revaluation performed for that location and shouldn't have any interplant stock transfer variance or purchase price variance for transfer order transactions. Recently, i…

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

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

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

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

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

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

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…

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

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

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

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…

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.