Judith Culanding-Oracle Bronze Crown

Hi @Amy C. Here's the explanation on the difference of the two filter: Age As Of Date: This date determines how transactions (bills, credits, etc.) are aged—i.e., in what aging “bucket” they appear (Current, 1-30 Days, 31-60 Days, etc.). It looks at open balances as of the date you specify, and ages them based on…

Hi @IMassawe, Here's what we recommend in such cases: Create Vendor Return Authorization for defective items. Move the defective stock out of available inventory (VRA or inventory adjustment). Receive replacement items when they arrive, against the VRA or as directed by your finance/accounting policy. Ensure proper…

Hi @Vernita Per checking, Date Driven type of Term Discount is not yet supported under Electronic Payments. Here is the related Enhancement I found: 339104 Electronic Payments: Support Date Driven Term Discounts for Bill Payment Processing, Invoice Payment Processing, and Batch when Approval Routing = F. You can go…

Hi @Dext3r The Search Filter section is the only available filters you can use in the page. Unfortunately, customizing the page is not yet possible. See related Enhancements below: 294873 Electronic Payments > Payment Processing > Bill Payment Processing > Ability to Customize the Page 465818 Electronic Bank Payment> Bill…

Hi @khearnen, As the issue appears to occur only with a specific access, it may be related to performance. Please note that the Community Guru team can only test issues using standard test accounts. If we are unable to replicate the issue in our environment, our ability to identify an exact solution is limited. In these…

Hi @User_Q1DPO Just checking in if you were to see the previous comments. Let us know if you need clarifications. Thanks! We would greatly appreciate if you can click "Yes" on “Did this answer the question?” below the comment/s that helped in your concern. Doing so will help other community members who might have the same…

Hi @User_Q1DPO You can easily verify this through the Created From field of the Credit Memo form. Credit Memo can be created directly from Invoice, Return Authorization or Customer Refund. Created From Invoice# means it is created directly from Invoice Created From Customer Refund# means it is created from a Cash Sale…

Hi @User_08WG, I have tried other formula setup as suggested from sample uses but the Formula column won't even appear on the Results and Preview page. Here's what I've found regarding the use of that specific formula: NetSuite Window Function Limitations: Not all environments or record types fully support window functions…

Hola, Estamos encantados de tenerle con nosotros hoy. Gracias por crear este hilo. Por favor, permita que nuestros gurús revisen su preocupación y realicen su investigación inicial. Nos pondremos en contacto de nuevo si tenemos novedades al respecto. Para nuestros otros miembros, siéntanse libres de compartir sus ideas o…

Hi @khearnen, Just checking in if you were to see the previous comments. Let us know if you need clarifications. Thanks! We would greatly appreciate if you can click "Yes" on “Did this answer the question?” below the comment/s that helped in your concern. Doing so will help other community members who might have the same…

Hi @khearnen, Kindly test the following: Map the AR account Import using the Standard Form (Advanced Options > Custom Form) Import without Running the scripts and workflow (Advanced Options > Run Server SuiteScripts and trigger Workflows ) Make sure to test this in your Sandbox account. If the error persists, we highly…

Hi @khearnen, Have you checked if the developer or the new employee record has the same setup of the Advanced Options from Step 2: Import Options from your original access and all mapping used are the same? If the Payment is being applied, make sure that transactions are not in Paid in Full Status. Kindly send all the…

Hi @Chelsea Jacobs, Unfortunately the feature you are looking for is not yet possible in NetSuite. Though, there is already a filed Enhancement request for this which is the 65280 AR Aging and AP Aging (A/R Aging & A/P Aging) - Provide ability to rename interval column headings (0-30, 31-60, 61-90). You can recreate the…

Hi @User_VI798, You can send a follow up and ask for an update for the ticket. Support team will reply 2-3 days at most. Cases cannot be left open for long so they'll need to reply. For faster communication, you can call the Support hotline (hotlines can be found in SuiteAnswers page). Note that you need to be an…

Hi @User_ZI0Y5 Have you followed all 3 Steps mentioned on the comment below? https://community.oracle.com/netsuite/english/discussion/comment/16901314#Comment_16901314 If yes and the negative balance still appears, I highly suggest that you file a support case for the issue you are encountering. They have the necessary…

Hi @NE_JohnC, Adding the filters still returns the correct data on my end. We highly suggest that you file a support case for the issue you are encountering. They have the necessary tools to investigate on your concern further. We are unable to reproduce the issue in our standard test account which unable us to investigate…

Hi @NE_JohnC Please send the screenshot of the Available Filters tab.

Hi @NE_JohnC Can you confirm if the $ Sales and # Column are the Formula fields from the Results tab highlighted below? If yes, what is the result in using the standard field Transaction : Quantity and Transaction : Amount? The Transaction : Quantity and Transaction : Amount fields are the one I initially tested and shows…

Hi @NE_JohnC Can you send us the screenshot of the Items tab of this transaction?

Hi @User_ZI0Y5 Just checking in if you were to see the previous comments. Let us know if you need clarifications. Thanks! We would greatly appreciate if you can click "Yes" on “Did this answer the question?” below the comment/s that helped in your concern. Doing so will help other community members who might have the same…

Hi @User_08WG, Can you explain more your formula and what are you trying to come up with the Saved Search? Kindly send also the screenshot of the Criteria tab. Thanks!

Hi @NE_JohnC I replicated the report and both the Transaction : Quantity and Transaction : Amount shows correct Sum values on my end. Can you also send the screenshot of the report results vs the actual transaction with items? Thanks!

Hi @User_VI798, Kindly follow through your Support ticket, you can also ask your Account Manager to escalate the ticket if it is really urgent, you can add the implementation schedule or the Date Needed to the information so they can reassess the Urgency of the concern. For now, verify if the Bill Capture is enabled in…

Hi @NE_JohnC Can you send us the screenshot of the actual Criteria and Results tab including the results view of the report? Thank you!

Hi @User_ZI0Y5 Yes, following the Step #1 does not resolve the entire issue, you need to follow up until Step #3 to successfully remove the pending deposit balance under customer record. Since the Customer Deposit balance only reflects creation of Customer Deposit and application on transaction to a Customer Deposit or JE…

Hi @gbradley No, you can only set the default account in general from Account Preferences. Currently, there is no feature available to set a default account per Subsidiary. If you'd like to explore customization as an alternative, we recommend you contact your Account Manager so they can generate the engagement with the…

Hi @User_ZI0Y5 Steps to resolve the issue: Create a Journal Entry to correct the Customer Deposit balance (reverse the Deposit Application entry with $5 amount) Apply the JE to an existing Payment or Customer Deposit via Transactions > Customer > Accept Customer Payment. In apply tab, select the JE then select the Payment…

Hi @gbradley Just checking in if you were to see the previous comments. Let us know if you need clarifications. Thanks! We would greatly appreciate if you can click "Yes" on “Did this answer the question?” below the comment/s that helped in your concern. Doing so will help other community members who might have the same…

Hi @User_68KLQ Just checking in if you were to see the previous comments. Let us know if you need clarifications. Thanks! We would greatly appreciate if you can click "Yes" on “Did this answer the question?” below the comment/s that helped in your concern. Doing so will help other community members who might have the same…

Hi @User_68KLQ If you will just add another item for the transaction, you can do the usual transaction import with the following changes: In Data Handling = Select Update In Field Mapping, map the Internal ID to make sure that the correct transaction will be updated Map the Item and other fields to be added If you wanted…