Hi @User_86LRJ, Thank you for your response. I made some testing on my end, I tried to run a Sales Order Saved Search instead but I was able to confirm that we cannot pull up Billing Schedules details. Unfortunately, the ability to pull up Billing Schedules details such as Bill Date and Bill Amount in a Saved Search is not…

Hi @Buckeye1497, Good day! Hope you are doing well. ? I have made some testing on my end using the same CSV Import setup as yours and I was able to successfully update the Sales Order Main Line and Item Line Location fields. Kindly provide the CSV error message that you have received so I can further check. Thank you! ?

Hi @Fartleby, Good day! Hope you are doing well. ? Upon further checking, there is no standard feature to post a pre-vendor credit yet. We only have the Vendor Prepayment feature, to record vendor deposits for vendors who require prepayments. You may need further customization to achieve such a feature as it is not yet…

Hi @User_86LRJ, Good day! Hope you are doing well. ? Yes, you can create a Billing Schedule Saved Search. Just navigate to Lists > Search > Saved Searches > New. Then, select Billing Schedule Search Type. However, upon further checking CSV Import for Billing Schedules is not yet available in NetSuite. It is also currently…

No worries about it, User_XQ321. Yes, I have tested it successfully. ?

Thank you for your response, @User_XQ321. ? Yes, the first Invoice was 44 days overdue and was picked up by the Invoice Dunning Procedure with Dunning Level for 30 days overdue rule. However, the second Invoice I tested is only 30 days overdue, that's why it was not picked up by the Invoice Dunning Procedure with 90 Days…

You may also try to test if it will work if you use Minimum Transaction Amount OR Total Overdue Balance on the Determine Dunning Level By dropdown. Also, you may check if the Invoices have Dunning Procedures assigned to them as the Assign Automatically To New Records is not marked on your Dunning Procedures.

Hi @Craig_Verde, Were you able to check this? ? If the information provided in my previous comment was helpful. then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment. This will also help other community members who might have the same concern find the answer easier.…

Hi User_XQ321, Thank you for patiently waiting. ? I made some testing on my end with the same setup as yours, and I was able to generate a Dunning Letter correctly. Here is a 44-day overdue Invoice that was picked up by the Invoice Dunning Procedure. I have also tested an Invoice Dunning Procedure with 90 Days Overdue…

You're welcome, @SanjeevV! ?

Thank you for your insight, @Tiru Chembeti. ?

Thank you for providing more information, @User_XQ321. ? I will test further first on my end to check the behavior.

Hi @SanjeevV, Good day! Hope you are doing well. ? Upon further testing, it is the standard behavior of the Sales by Sales Rep Detail report to show each line item of the transactions or applicable cost (e.g. shipping/handling) as the field Transaction Total (Revenue) is not available. I have found related Enhancement…

Hello @User_NC62U, Glad to have you with us today. Thank you for creating this thread. ? Please allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To other users, feel free to join in the discussion as well. ?

Hi @Strategit_Shunta4, Thank you for your response. We will further check this on our end and we will reach out if we have an update. ?

Hi @Craig_Verde, Good day! Hope you are doing well: Please test it out and let me know if this resolves your concern. 1. On the left of the screen, expand the folder "Transaction Line" 2. Expand the subfolder "Related Transactions Lines - Previous" 3. Click on "Transaction" 4. Double click on the field "Transaction" to…

Hi @Karanjot Singh, Were you able to check this? ? If the information provided in my previous comment was helpful. then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment. This will also help other community members who might have the same concern find the answer…

Hi @Strategit_Shunta4, Good day! Hope you are doing well. ? As you mentioned your environment base currency is JPY, hence, the Amount field will show values in JPY, as the USD is a Foreign Currency. Also, I made some testing and was able to confirm the same behavior where a Transaction Saved Search Amount field will pull…

Hi @User_XQ321, I have seen your other new thread for this new concern. Let us continue communicating on that thread instead. Thank you! ?

Hi @User_XQ321, Good day! ? Kindly provide screenshots of the following: 1. Invoice Level Dunning Procedure 2. Past due Invoice Also, please confirm if this Invoice Level Dunning Procedure was working before. If yes, are there any changes made that you are aware of? Thank you!

Hi @Karanjot Singh, Thank you for your response. Kindly add this Formula Numeric and remove the Date Created criteria instead: Formula = CASE WHEN {datecreated} BETWEEN (TRUNC(sysdate) - 9/24) AND (TRUNC(sysdate) + 15/24) THEN 1 ELSE 0 END Formula (Numeric) = equal to Value = 1 This will pull up Sales Orders created…

Hi @Cperez42985, Good day! Hope you are doing well. Kindly provide more information by providing screenshots of the sample line item of the order and how the discount is applied to the line item. Thank you!

You're welcome, @Altmann02! Glad to help. ?

Hello @User_E5P4R, Good day! Hope you are doing well. ? Upon checking Sales Orders cannot be linked to a Sales Report as it will only show Invoices, Cash Sales, and Credit Memos. If you prefer to bring the records as non-posting Sales Orders, for comparative reporting purposes, you may use the Sales Orders Reports instead…

Hi @Karanjot Singh, Good day! Hope you are doing well. I have made some testing and I was able to create a Saved Search that will pull up Sales Order created before a specific time. Here are the criteria I added to the Saved Search: Date Created = on today Formula (Numeric) Formula = CASE WHEN {datecreated} <…

Hi @Altmann02, Upon testing, using a Standard Vendor Bill Transaction form, I was able to create a Vendor Bill with an Expense Line only and I didn't get the error to add an Item Line. Based on research, the alert is most likely triggered by the script SCM LC Transactions CS which changes the function of setting the…

Hello @Altmann02, Thanks for posting your concern here! ? Kindly allow us to review your concern and we'll provide updates in this thread. To other members, feel free to share your insights on this too should you have any.

Hi Imelda, Were you able to check this? Thank you! ?

Hi Imelda, Good day! Hope you are doing well. ? The SuiteAnswers that you have mentioned is for pulling up Purchase Orders and Sales Orders Items details in a single Saved Search. It does not mean that it will show the Items relating to each transaction. Upon checking, if the item is neither Special Ordered nor Drop…

Hello @Christine Thomas, Welcome to NetSuite Support Community! ? Thanks for posting your concern here! Kindly allow us to review your concern and we'll provide updates in this thread. To other members, feel free to share your insights on this too should you have any. ?