sorry, here are the results when I set location to Korea : Office (AP)

screenshots

Hi, Thank you for your response. I tested your suggestions and here are my replies: I check the cost by location to make sure that it was being calculated correctly. You can see in the below screenshot that, while reporting in the AP location, we still get the same amount. For the search, I conducted it exactly as you…

Hi @Mikko De La Fuente-Oracle , I tested it and unfortunately, the result was blank. REPLACE(REGEXP_SUBSTR({message},'Company:(.*)Position'), 'Company:', '') Text Message is the field we are reporting on.

Hi, You are correct. I converted to a Client Script and using 2.0 (1.0 generated a SS error), now everything is working as expected. Thanks, Hunter MacLean

Thanks @Emilia Ironov-Oracle Looking forward to hearing others feedback on how to tackle this issue. Regards, Hunter

I went back and re-tested the URL several times and it seems ok now. I think the only one that has a problem is a customer with an '&' in it's name. As you can guess, it cuts off the customers name at the ampersand. Any ideas on a solution for this?

Hi @"Herdi Rana-Oracle", Thanks for your reply. I think regarding the Detailed Inventory Valuation report, I need to get the Lot Numbers to show and then I can associate that data with our landed cost data on the Item Receipt to calculate profitability. The tricky part I've seen with Inventory Valuation report is that when…

@"Herdi Rana-Oracle" I think I figured it out. I had to enclose each of the landed cost category formulas with NVL as when there was no landed cost, it was causing a problem with the sum. It's not pretty, but it works! SUM(NVL(DECODE(NVL(SUBSTR({memo}, 0, INSTR({memo}, ':')-1), 'Cost'),'Renumeration',{amount}),0)) +…

Hi @"Herdi Rana-Oracle" The second solution works well for us, however, I could not figure out how to get the Total Landed Cost formula to work. It is always $0 for me. I also tried removing the SUM() from the formula, but still $0. I'll try a few more things and see if I can get it to work, but it's not critical. Thanks…

Hi @"Herdi Rana-Oracle" Just checking in before the weekend if you have any updates, otherwise we can circle-back next week. Thanks

Hi @"Herdi Rana-Oracle"! Sorry for the delayed reply. Attached are a few screenshots. Also below are the details of each formula so it's easier for you to copy if needed. Criteria - Formula (Numeric): case when {account} IN ('613130 CHARGES ACCOUNTS : Other external charges : Commissions and professional fees : Commission…

Hi Pauline, This is helpful for Main Line data, but what about for the Line Level data? Thanks, Hunter

Hi @"Herdi Rana-Oracle"! Thank you again for your prompt and detailed reply. I have the results below, however, the problem still persists. I will file a case with NetSuite Support directly. 1) For this step, I ran Reallocate Items for that item and location. I found 2 transactions from 2018 and 2019. Closed those…

In my first image, you can't determine what the item number is so I'm attaching a full page screenshot here: Also, I understand that the 1 unit is not available. I also checked for outstanding orders that may have encumbered the product. I'm pretty sure I closed the only other order that would have this product…

Hi Herdi! Thank you for your details response. I did some more testing and was unable to come up the same results. I started with Transaction Line: Subsidiary any of Asia Pacific, Hong Kong, Shenzhen Trading (subsidiary names shortened for brevity). and, Type is Item Receipt. I know this works as we get over 11k results. I…

Hi @"Herdi Rana-Oracle"! Thank you for your response, and your understanding is pretty spot-on. This would be an inventory-based workbook, meaning its primary purpose should be to report on-hand, available, etc. numbers. The relationship we need to make is gathering some related transactional information. Per your question…