Hey @Toni L, Try the following formula: {amountPaid} * NULLIF({custcol_gs_purchased_nb_classes}, 0) / NULLIF({amount}, 0)

Hey @Toanne Termeer Yes, we regularly customize SCM Mobile for our customers. This article has useful information and links with guides on how to do that: https://suiteanswers.custhelp.com/app/answers/detail/a_id/102936/loc/en_US

Hey @Divya Unnikrishnan, The SuiteTax supports the Withholding Tax Setup for VAT countries. Do you need it for a non-VAT country?

Hey @User_63KD7, That would have been great to have the option to combine both parameters. Natively, the Bill Duplicate Detection is based only on the matching reference number. You need a customization for the Duplicate Detection to combine the Vendor and Reference Number.

Custom solutions and 3rd party solutions, such as VersaPay, allow requesting Customer Payments from Estimate/Quote and Sales Order records. The received payments are recorded as Customer Deposits. Another option is to create a customization to send a "Prepayment Invoice" from the Sales Order.

"Billing" and "Sending Payment Link" are different things. You can't do the Billing before approving the Sales Order. You can send the Payment Link before approving the Sales Order.

Hey @User_63KD7, Assuming you recorded the "Affiliate Receivable", when the cash is received, you will create a Journal with: DR: Bank | CR: Affiliate Receivable

Hey @A K M Farid, Natively, NetSuite doesn't support subsidiary-specific pricing. You would need a customization to support that.

Hey @BM136, Yes, there are a few ways to do that. Some customers ask to build a custom solution for that. There are also third-party tools that have such functionality, such as VersaPay.

Hey @User_ZD341, The easiest would be to create a custom workflow that would send the required emails before the Invoice Due Date. The sent email will be saved on the related Invoice to facilitate reporting and auditing.

Hey @User_63KD7, The questions you have aren't natively supported by the NetSuite Bank Reconciliation module. You would need to build a customization to support your business requirements.

Hey @Maria Gabriela Barbosa-Oracle, You may need a workflow with a script to make this work seamlessly. The solution would need to prevent the execution of the native Void Payment. The custom "Void Payment" would execute the custom workflow, and when everything is approved, another Workflow Action would auto-process the…

At this point, the best might be to open a Support Case with NetSuite and ask them to investigate. They have access to a replica account and can check the configuration and find the issue. Some of the things that I typically see missing for my customers didn't work for you. Without access to your account, I am making…

Hey @gbradley, The best option is to create a Workflow that would swap the form based on the transaction's Subsidiary.

I am not sure why the "Manage Intercompany Return Authorizations" never shows anything for you; it might be related to your Intercompany Configuration. In any case, let's try to solve the issue you have using a manual method. In Subsidiary B: Create a manual Purchase Order to Subsidiary A Reference the intercompany SO and…

There is no easy way to do that for the existing Sales Order. The only other way is to delete all original and incorrect transactions and re-create them, which isn't preferable, either. Mistakes happen, and using the Inventory Adjustment is the best option in this case. You can enter Memo/User notes on related…

Hey @Divya Unnikrishnan, You can create a "USD Reporting Parent" subsidiary that is on top of the INR subsidiary. This will facilitate the Consolidated Reporting both in USD and INR, and you can use Consolidated Exchange Rates to convert the INR to USD for reporting purposes. I recommend doing this first in the Sandbox.

Hey @GSONI, You should be able to do that via Inventory Adjustment. First, you can "deduct" the wrong SN, then "add in" the correct SN. Ensure that you apply the exact unit cost to the positive adjustment as NS used on the negative adjustment. If you're using the Average Cost, then you must date the negative on Day 1 and…

Hey @Valdi, The best practice is to edit the required forms and clear the labels of the line-level fields that you want to hide. That way, the field values are still populating in the back-end, not affecting system processing, but the fields are natively hidden from the UI/Form.

Hey @PatrickConrad, Did you try using the "Manage Intercompany Return Authorizations" process?

By default, the "Search" is available for both PO and Bill. Are you creating them for the same Vendor and Subsidiary? There might be differences in the number of Items displayed in your example, which is why the "Search" might be unavailable if there aren't many results.

Hey @Ken Zhang-Oracle, I assume you are making the CSV imports via the Admin role. With a standard role, the checkbox 'Yes/No' should have a more noticeable impact.

The "Bank Details" record is available for custom workflows:

Hey @Yee Yie, You should be able to recognize the revenue every 4 months. A rule like this should work: I assume you recognize the Term 3 based on Sales Order, Subscription, or Invoice. You can do an RMA, Change Order, or a Credit Memo to reverse the Term 3 revenue.

Hey @User_Q1DPO, I agree that it would have been useful and consistent with the "Days" option. For some reason, NetSuite didn't design the report to show the "number" on the report header for values other than "Days". We can't modify this report to show that.

Hey @Maria Gabriela Barbosa-Oracle, You need a custom workflow or a script for that.

Hey @User_K51C7, The solution that you described is the most optimal to match a Vendor Bill and Payment in different currencies.

Hey @User_63KD7, NetSuite has a Quality Control (QC) module, but it is primarily used for Manufacturing. In your case, it would be best to build a custom workflow. The Workflow will set every Item Receipt to "Inactive" or "Locked" status on creation and require an approval before activating it.

If one of the Custom Records is set up "As Parent" for the other one, you can use the established join to source and filter field values.

Hey @VanillaTango, In theory, you can do that via Saved Search and no customization. In practice, it will be hard to do. You have to rely on the "Applying Transaction" join to get the data for Item Fulfillments and Invoices. Line-level searches repeat results per line, so it will be tricky to exclude the duplicate lines…