Hormese Paul · Lead Solution Architect · Bronze Trophy

Option B

Option C

Option C: I & IV

Hi @Michelle Jabanes-Oracle , I have also seen my colleagues use the below formula for the row numbers. Formula(Numeric)= ROW_NUMBER() OVER (ORDER BY SUM({amount})) formula(Numeric) = ROW_NUMBER() OVER(ORDER BY {internalid} ASC). // Not from a transaction, just a line sequence number that would just be 1, 2, 3, 4 down the…

Hi @Patrick Fresnosa-Oracle , Thank you for your constant support. Our Netsuite admin user has fielded a support case for the same.

Hi @Michelle Jabanes-Oracle , Thank you for the reply We have this feature enabled. I will contact the account manager for provisioning

Hi, It is the same contract (id) as in the Script Execution Log. The type of item is non-inventory item for sale. It is not a kit item.

Hi,@Patrick Fresnosa-Oracle We have analyzed the mentioned solution, the issue persist even for the contracts with single contract items. please go through the shared image below

Thank you for the quick reply. I had a quick check based on your reference but Our sales orders do not have a mix of direct posting items and revenue items. Still, we are encountering the issue. Will there be any other cause for the issue?

Hi, Thank you for your reply

Hi @Niks Blando-Oracle , Thank you for your quick reply and reference. I have watched the video but unfortunately, it does not answer my query.

Hi @Dominica Sevilla-Oracle , Thank you for your reply. I will try to contact the service team.

Hi @Dominica Sevilla-Oracle , Thank you for your detailed explanation.

Hi @Joahnna Given Uy-Oracle , Thank you for your reply.

Hi @Elychelle Gulen-Oracle , Thank you for your quick reply This answered my query.

Hi @Joahnna Given Uy-Oracle , We have tried the same solution from the mentioned suite answer but in the case of partial fulfillment, this solution will not work. Please advice.

Hi @Tiru Chembeti , I have got it. Thanks for your support.

Hi @Tiru Chembeti , Thank you for your quick reply.

Hi @Michelle Jabanes-Oracle , Thank you for your reply

Hi @Patrick Fresnosa-Oracle , Thank you for your quick reply.

Hi @Joahnna Given Uy-Oracle , Thank you for your reply. I will try to see if we can do any workarounds.

Hi @Joahnna Given Uy-Oracle , Please see the below screenshots.

Would the Item receipt of the PO and the Vendor return authorization GL impacts cancels each other out without processing the Sales order?

Hi @Niks Blando-Oracle , Can we just close the special order sales order line after completing the PO cycle?

Hi @Patrick Fresnosa-Oracle , Thank you for your quick reply.

Hi @Michelle Jabanes-Oracle , Thank you for the detailed explanation. It works on quote record save. I was planning to do the same on record load and not at saving the record. I will go with a script to achieve this requirement.

Hi @Ivan Griggs UK , Thank you for your thoughts. I will try out the same.

Hi @Katerina Winklerova-Oracle , Thank you for the insight.

Hi @Patrick Fresnosa-Oracle , This is a great tip for users like me who use saved searches for pulling financial data from Netsuite 😊.

Hi @Michelle Jabanes-Oracle , Thank you for your lightning-fast reply 😊. It was informative.