Hello @Vernita, Good day! ? Noted that the first formula you have only has 1 closing parenthesis compared to the formula you used for HTML which has 3 closing parenthesis. Kindly try using only 2 closing parenthesis since you added 1 opening parenthesis on this formula. I hope this will work on your end. Let us know. Thank…

Hello @Sean-C, Good day! ? Per checking, the ability to change the payment output file format from .txt to .csv is only available in the paid version of the Electronic Bank Payments bundle which gives you the ability to edit native payment file templates. If this is not available, you may refer to your NetSuite Account…

Hello @Faizan, Good day! ? Sharing you the tests I did on my end for this concern. Created a Sales Order with 5 quantity Fulfilled only 3 quantity Billed the whole Sales Order Closed the partially fulfilled Sales Order Created Credit Memo for the unfulfilled 2 quantity Result: The Quantity On Hand and Quantity Available…

Hello @User_NMR8A, Good day! ? Upon checking, the desired functionality is currently unavailable. This is logged under Enhancement 227451 Payments> System Information> System Notes: To be able to track the history of payment application to invoices. Unfortunately, there's no provided alternate solution for this. Hoping for…

Apologies for the confusion. ?‍♀️ Under the Criteria tab, kindly set Main Line to Either. This will display two lines on the result. One for the Item Line which will show the Item Name; then, another one for Main Line which will show the Payment's details. Hope this helps. Thank you! ?

Greetings, @PaulFleetwood. ? Apologies for the late response on this. Upon checking and consulting this on my end, I am tagging this as a potential defect as you are also noticing the behavior on closed period. You can expect an email for us to file a case on your behalf. Hoping for your understanding on this matter. Thank…

Hello @Martha Hakes, Good day! ? I found the following SuiteAnswers articles that might be helpful on your concern 68352 Create An Alert When On Hand Quantity Goes To Zero In The Item Search 80101 Saved search to Send Email Alerts when Quantity Available for a Location was Zeroed Out Kindly check these Saved Searches to…

Hello @Strategit_Shunta4, Good day! ? Upon checking, the desired fields cannot be displayed on the said Report. This is under Enhancement 107409 Reports>Sales>Sales by Item Detail>Customize>Please include the "Payment Date" in the list on the Sales Folder under Add Fields. Even though it only mentioned Sales by Item…

Thanks for the additional information provided, @User_CXOD8. ? Upon checking, it is best to reach out to Versapay to check this error. Hoping for your understanding on this. Feel free to update this thread on their response. Thank you! ?

Hello @User_1IB5T, Good day! ? Kindly check if using Item Saved Search is feasible on your end. You can utilize the Transaction Fields.... as an additional filter. I hope this helps. Let us know. To other users, feel free to share your insights on this as well. Thank you! ? By the way, expand your NetSuite knowledge by…

Hello @Janis001, Good day! ? Apologies for the late response on this. As per Field Help for Make Inventory Available, check this box to make on-hand inventory stored at the location available to orders; clear this box to exclude on-hand inventory stored at the location from the available count. I hope this clarified your…

Hello @User_CXOD8, Are they receiving an error? Kindly provide the exact error message received. Hoping for your response. I also suggest to reach out to Versapay to discuss this as well. To other users, feel free to share your insights on this. Thank you! ?

Hello @Strategit_Shunta4, Kindly check if Sales By Customer Detail Report is feasible on your end. Navigate to Reports > Sales > Sales By Customer Detail > Customize Under Columns tab, expand Sales Transaction Expand Item, then select Name Under Filters tab, expand Sales Transaction Select Transaction Type, then choose…

Hello @User_YMWNR, Glad to have you with us today. Thank you for creating another thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. Also, expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on…

You're welcome, @Camila O. ❤ I'm glad this clarified your concern. Thanks! ?

Hello @User_KK0TH, Good day! ? Upon checking, the desired behavior is currently unavailable. This is logged under Enhancement 97339 Consolidate Billing/Invoicing to the Parent Customer for Sales Orders Created for Sub customers. Hoping for your understanding on this system limitation. You can also vote for the said…

Greetings, @Strategit_Shunta4. ? As a workaround, you can create a Saved Search instead. Here's a sample Saved Search. Navigate to Lists > Search > Saved Searches > New Select Transaction Rename the Saved Search Under Criteria tab, add the following: Type = Invoice Status = Invoice: Paid In Full Main Line = False COGS Line…

Thank you @Niks Blando-Oracle for checking this as well. ❤ Hello @Benjamin Paul - USA, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment/s that helped in your concern. Doing so will help other community members who might have the same concern find the answer easier and…

Hello @Camila O, As per my testing for this concern, it is a standard behavior that the status of the Requisition will be Closed once the Purchased Order associated to it was received. Can you confirm what is the expected behavior? Sharing you the changes on the Document Status of the Requisition I created, you can compare…

Hello @ImeldaSanchez, Good day! ? Upon checking, the desired behavior is unavailable. As a workaround, you may grant Customer Center Access to Customer so that they may input order details as well as Credit Card information. The workarounds we provide may or may not work for some users; as such, it is best to discuss it…

Hello @Strategit_Shunta4, Upon checking, the desired behavior is currently an Enhancement logged as 168385 Reports>Customers/Receivables>A/R Payment History by Payment: Ability to show the items linked to the paid invoice. Hoping for your understanding on this system limitation. You can also vote for the said Enhancement…

Hello @Dirk Nieuwkamp, Good day! ? As mentioned, negative bin on hand occurs when a bin transfer was created and then deleted. However, the ability to view deleted records is not yet possible in NetSuite as this is logged under Enhancement 177604 Audit Trail > Ability to view Deleted Files or Records deleted by the user in…

Hello @Harry Pham, Good day! ? Apologies for the late reply as I was out of the office the past days. I reviewed the Enhancements filed for this concern, and there's no provided information for the main reason on why this is not yet possible. However, rest assured that these Enhancements are being work on for it to be…

Hello @JPrice, Glad to have you with us today. Thank you for creating another thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. Also, expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now. To…

Hello @Camila O, Glad to have you with us today. Thank you for creating another thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. Also, expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.…

Hello @Janis001, Glad to have you with us today. Thank you for creating another thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. Also, expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.…

Hello @User_O6D8L, Good day! ? Apologies for the late response as I was out of the office the past days. Kindly mark the Overwrite Sublists under Advanced Options and see if the desired result be encountered. As CSV Import can affect large volume of records, we highly suggest to try this on single record first to ensure…

Hello @TiffHas, Glad to have you with us today. Thank you for creating another thread. ? Allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. Expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now. To…

You're welcome, @User_YMWNR! ? I'm glad that it is now working properly on your end. Also, expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now. Thank you! ?

Hello @Surfnbruin, I would just like to confirm what is the EDI you are referring to? Is this a third party integration? Thank you! ?