@MoonK I added that but it is still returning sales orders with back ordered items on them. 😕

@Ivy Lopez-Oracle That is the exact criteria I was using on the search and pricing is blank until I pull the Pricing: Price Level and Pricing: Unit Price in. I think it has to do with being under the Euro Pricing tab on the item record. So I looked to SuiteAnswers for that and found this article. Using the formula brought…

I was able to find a work around. I pulled All Items and All Items with Price Level. Then compared the two to see what was missing.

@Clarisa De Torres-Oracle Thank You! I had to spell out the month and it worked for me. I really appreciate the help!

@Michelle Jabanes-Oracle Thank you so much! That worked. I appreciate the help with this

Hi @Michelle Jabanes-Oracle Sorry I have been on vacation. I have not been able to resolve this yet. To answer your questions, see below. Please provide us with the following information below. What is the exact name of the report? Is this a standard or a custom report? Custom Report - PG - Sales By Prod Category YTD What…

Hi @Patrick Fresnosa-Oracle I did double check that and they are able to see everything

I was able to create a search to match the income statement, but does anyone know how to write the formula to compare This Year vs Last Year? Criteria Results Results from other report to compare TY vs LY

@Patrick Fresnosa-Oracle Thanks for your help! I appreciate it. :)

Hi @Patrick Fresnosa-Oracle For IL, we only charge the state tax of 6.25%, but am order came in today and it is calculating based on the Tax Group, which is incorrect. Thanks for the information. 😊

@Ivy Lopez-Oracle Thank you! I have it turned on in the sandbox and not production yet. Thanks for the help!

Hi @Dominica Sevilla-Oracle I just tried it and still am still getting the same result that returns the total of the sales on income statement

Hi @Dominica Sevilla-Oracle I tried removing the type and even went to a report that matches the Income Statement Sales to the penny that only has this criteria. But the formula for GP also matches Sales to the penny. Looking at the formula, I don't see what is causing this issue. It looks like it should work to me. 🤔 I…

@Jack Daryl Espiel-Oracle Thank you so much! The code worked perfectly. This should be a standard feature. It is so helpful for my accounting department.

Hi @Jack Daryl Espiel-Oracle. No there is not a reference on the CS to the deposit it was made to. I was wondering if there was a script similar to the one that Pauline provided for showing the related deposit on the Customer Payment screen. That was super helpful. But it would also be beneficial on the Cash Sale@Pauline…

@Pauline Joy Cac-Oracle. Is there a way to also use a script to add the Deposit Information to a Cash Sale?

@Pauline Joy Cac-Oracle. I was able to get it working in Production. I think it was because I did not have the ID set properly on the Custom Body Field. Thank you for posting this. It has made our accounting teams day!

@Ivy Lopez-Oracle Thank you for the information. I tested and made the Company and Individual and the Convert button did show.

Hi @Pauline Joy Cac-Oracle. I tried the user event script in the sandbox and it worked perfectly. But when I released in Production I get this error. Any idea what this means? Notice (SuiteScript) TypeError: Cannot call method "setLinkText" of null (Related Deposit$2300770#43)

Hi @Dominica Sevilla-Oracle Thank you for the feedback. I tried your formula and it returns the total of of Income and not Gross Profit.

@Jack Daryl Espiel-Oracle Thank you for the information!

@Niks Blando-Oracle Thank you! This will save a lot of time

@Kristoffer Viray-Oracle Thank you for the information. Unfortunately making it mandatory in the Accounting preferences sets it on all forms. We only want to make it mandatory on things that hit the GL Accounts

@Patrick Fresnosa-Oracle Thank you so much for the help! ?

@Dominica Sevilla-Oracle Thank you so much! Appreciate the help :)

@Tiru Chembeti We are also looking for this solution. Can you advise how we get access to this bundle? Martha

@Micah Timbol-Oracle I did figure out the issue. The new departments I added, I chose include children. I had to go back and select all the subsidiaries instead and then they show up. Thanks for the help!

@Dominica Sevilla-Oracle Yes that was the issue. Thank you so much for the help!

Hi @Joy Noreen Magoling-Oracle They were finally able to fulfill the order. I am not sure what the issue was. But thank you for the suggestions. I will know what to check if it happens again

@Tiru Chembeti Thank you for the help. I will try to build a workflow to populate the correct tax code on new customers. @Patrick Fresnosa-Oracle Thank you for the other things to check. I forgot that you had to set the Nexus in the Subsidiary, so that helped me to figure out why a new US State was showing taxable but…