Also, kindly confirm if ''S&C last received IBAN'' and ''S&C IBAN'' are custom fields. And how would you like to be notified by the alert? Thank you!

Appreciate sharing this workaround with Community, @manuelsaomartinho! ? I will further check and coordinate if an alert using workflow or script is possible with this.

Thank you for your update, @Buckeye1497! Glad it worked now. ?

Appreciate your response, @Camila O! ? I have coordinated your concern to our SuiteBuilder Gurus to further assist you. Thank you! ?

Let us know if you need further assistance on this. Thank you! ?

Hi @Strategit_Shunta4, Thank you for posting again in the community! ? Please allow some time for the gurus/members to check on your concern and get back with more information. To everyone, do not hesitate to share your knowledge. ?

Hello @Benjamin Paul - USA, 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. To other users, feel free to join in the discussion as well. ?

Hi @Camila O, Good day! Hope you are doing well. ? Kindly confirm the following: 1. What are the steps to reproduce your concern? 2. What is your expected result? 3. What is the actual result? 4. Are you trying to customize your EFT file to include the Bill Reference Number? Appreciate your response! ?

You're welcome, Andie! ?

Hi @Buckeye1497, Please be advised that the Item : Location field pulls up values from the Item Record and not on the Sales Order Item Line. I made some testing on my end, if both of the Main Line and Item Line Location have the same value and you use the standard field Location on your Sales Order Transaction Form, you…

Hi @SanjeevV, Yes, only the QTY pending billing will be included in the computation of the Amount. Thank you! ?

Hi @Andie, Good day! Hope you are doing well. ? I have made some testing on my end and I was able to confirm that when Auto-generated Numbers is enabled for Employees, on Saved Searches the Available Filter Employee list will show in the format ID Employee Name : Employee Name. Upon further checking, there is a related…

Hi @SanjeevV, Good day! Hope you are doing well. ? Please be advised that the Saved Search formula, CASE WHEN {quantity}-{quantitybilled}=0 THEN 1 ELSE 0 END means that Item Lines that have no pending Invoice will not be included in the results. Hence, the Item Lines with partially invoiced and not yet fully invoiced are…

Hi @Buckeye1497, Good day! Upon further testing, I have also added a Subtotal Item line on my CSV Import and its Location was successfully updated without getting the error message to enter an amount. Again, I would suggest creating another CSV file that only has Internal ID and Line ID columns to avoid getting the error…

Hi @User_CS3KK, Please be advised that I am coordinating your concern with our SuiteCloud gurus who handle scripting so they can further help you. Thank you! ?

Hi @manuelsaomartinho, Good day! Hope you are doing well. ? I would suggest creating a Saved Search to compare the Vendor Bills and Vendor Records Bank Details. However, upon checking, currently, the ability to pull up Vendor Entity Bank Details on a Transaction Saved Search is an enhancement request logged under…

You're welcome, @SanjeevV! ?

Hi @Ibraam, Good day! Hope you are doing well. ? We appreciate you sharing this discussion. This is very helpful to the Community. ?

Hi @Buckeye1497, I would suggest creating another CSV file that only has Internal ID and Line ID columns to avoid getting the error about the Amount as it is not necessary with the CSV Import Field Mapping for updating the Main Line and Item Line Location. As only the below fields need to be mapped: If you are updating the…

Hi @User_CS3KK, Thank you for your response! ? Yes. that is also possible. What I have in mind is a custom field, and its value will be based on the proportion of the amount collected for the Line Item relative to the total Amount Paid. A sample formula can be seen below: Custom Field Value = Amount (Line Item) * Amount…

Hi @SanjeevV, 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. Hope…

Hi @Buckeye1497, Thank you for your response. ? Upon checking the error message, the Error message is about Amount. Kindly confirm if your CSV Import same as below, because this CSV import field mapping does not include any Amount. Also, when I tested on my standard test account, I have not encountered any prompt when…

Hello @Ben Belzer, Welcome to NetSuite Support Community! ? 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 @Kedalene, Good day! Hope you are doing well. ? Thank you for sharing the SuiteAnswers. Upon further checking the ability to mass attach files to records via CSV Import is currently a system limitation. An enhancement request is logged under Enhancement 220827 Import/Export > Import CSV Records > Ability to link…

Hi @Strategit_Shunta4, Good day! Hope you are doing well. ? Upon further reviewing our resources, I was able to confirm that the ability to remove the Receiving function of a Purchase Order with Expense lines only is currently a system limitation. As explained, this is by design as supported by SuiteAnswers Article Answer…

You're welcome, @User_CS3KK! ? Upon checking, Amount Paid has a value of 0.00 because the results are currently pulling the Line Item level (because of the Item category (Custom Column) criteria), but the Amount Paid is on the Main Line. Hence, when the Amount Paid field is added, on the Item Line level it has a value of…

Hi @Fartleby, 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. Hope…

Hi @SanjeevV, Good day! Hope you are doing well. ? I created a Saved Search that will pull up Invoices that are partially and fully paid by Payments created within the day. I have also included criteria to narrow down the Invoices with Sales Reps belonging to a specific department. Here are the steps you may take: 1. On…

Thank you for your insight, @JohnCirocco! ? Hi @User_CS3KK, Good day! Hope you are doing well. ? Please be advised that Main Line refers to the Header section. When Main Line = T, the Line Item Information are hidden and the search only pulls up the main line header information. When Main Line = F, the line with asterisk…

Please be advised that I have also removed the attachment as it may contain sensitive information. ?