Tigran Shahnazaryan · CEO @ Novelance · Gold Crown

Hi @David Hali, That's a valid concern. Could you check the NetSuite Ship Central to see if it works for you? https://www.netsuite.com/portal/assets/pdf/ds-netsuite-ship-central.pdf One of the features is: Consolidate orders. Automatically identify orders that are going to the same customer location and pack those items…

Hi @User_JED7G, Could you please share a few screenshots to help us resolve your issue more efficiently? For example, it is unclear to me if you are referring to an invoice that your company is issuing or an invoice issued by another company that you are paying. Thank you.

Hi @User_JED7G, When you say, "how much of the invoices paid in the AR report is sales tax," are you referring to "partially paid" invoices that are still showing on AR Aging Report? Note that the payment itself is applied to the Invoice Total and not specifically against the Tax Amount. Here is a sample Transaction Saved…

Thanks for sharing the screenshots, @User_T00VZ, The images aren't very clear, and I might have missed the entered "Start Date" on the Sales Order and Purchase Order screenshots. Could you please re-upload the screenshots showing: Sales Order with a populated Start Date Purchase Order (before saving) with all the fields…

I didn't consider that use case. Are you using Standard/Legacy Tax, SuiteTax, or a third-party solution? Also, what is your parent subsidiary currency? Can you please also replace the original formula I proposed with this one? CASE WHEN {amountremainingisabovezero} = 'T' THEN ({netamountnotax} - {amountpaid}) ELSE 0 END

That makes sense, @User_1E7KR, Sandbox has several options to handle outbound emails. However, in 99% of use cases (the exception is login notification email, Saved Search alert email, and a few others), the email doesn't get sent to the actual recipient. The most common setting is to send emails generated in Sandbox to a…

Thanks for the clarification, @User_1E7KR, Can you confirm via https://9264337.app.netsuite.com/app/email/sentemaillist.nl (Sent Email List) that the email indeed wasn't sent by NetSuite? Sometimes emails are sent out but rejected/flagged by the receiving email server or filters. The Advanced Approvals SuiteSolution has a…

Those are sequentially generated "check numbers", which are available for user entry. The system assumes you don't have any "failed printed checks" (even though most Bill Payments aren't checks) and adds +1 to the previous number. NetSuite doesn't natively allow adding a prefix to Bill Payment Document Numbers.

Because Bill Payments don't have auto-generated Document Numbers, you can't natively add a prefix similar to, say, a Customer Invoice Document Number. For Bill Payments, you can do that via Workflow or a Script (i.e., to add a pre-defined prefix to all user-entered "Reference/Document Numbers" on Bill Payments).

Thanks for confirming, @User_NG5TG, Could you try the following formula and advise if this is what you were looking for:

Hi @CRATIV_Jason, That's a valid question. "Document Number" typically acts as a reference number. For transactions like Journal Entries, we turn "auto-numbering" on, so NetSuite adds sequential numbering for easier referencing and auditing. In most cases, Document Numbers are unique. However, with "Allow Override", you…

Hi @User_1E7KR, Did you build the workflow from scratch or are you using the Advanced Approvals SuiteSolution?

Thanks for the additional details, @User_NG5TG, When you said "...£123, 219.60 paid", were you referring to "Amount Remaining"? On your screenshot, the "Amount Paid" for £102, 683 is 0. Is this correct?

Hi @BWM- Shem, Are you trying to delete an image that you uploaded (e.g., Expense Report receipt)? NetSuite typically allows the image/file owners to edit/delete them. The permission that allows Custom Roles to delete any image/file is "Lists -> Documents and Files -> Level: Full". However, care must be taken when…

Hi @Kedalene, NetSuite doesn't allow the copying of Subsidiaries. The Subsidiary record is an essential "reference record". It drives most of the underlying functionality of the related transactions and records. This is why NetSuite designed the product so that Subsidiary records are created from scratch.

Hi @manuelsaomartinho and @Dale H, I agree that it is best to correct this issue. If not, the "No Vendor" will permanently appear in the AP Aging Detail report (you can remove it from AP Aging Summary by creating an adjusting JE with No Vendor debiting the AP Account). To correct this, you would need to: Re-open the…

Hi @mark petzold, It seems you would like to treat "multiple donations per customer per year" as "one total donation per customer per year". Can you try this formula and advise on the results? Field Value: Formula (Currency) Summary Type: SUM Formula: SUM(CASE WHEN TO_CHAR({trandate},'YYYY') = '2023' THEN {amount} ELSE 0…

Hi @User_T00VZ, To help with the troubleshooting, please advise on the following: Are you using standard or custom Start/End Dates? Are you using standard or custom Drop-ship PO Form? If you are using a custom form, is it linked to the SO form? Can you share a few screenshots? Thanks.

Hi @User_NG5TG, Can you please share a few screenshots with the actual amounts from transactions and what is missing? This will help to ensure everyone is aligned and your issue is resolved efficiently. Thanks.

Sure - here are some reference screenshots:

Hi @ER-Sree, Sure. For this to work, you need three main components. Field with a "Store Value" = "False" (e.g., Total Journal Amount) powered by a Saved Search. You already created this field (I wrote a savesearch to sum(dr) and linked it to the default value of this custom field.) Field with a "Store Value" = "True"…

You can do it with a Custom Sublist if you create it as a Custom Record with the required fields, filters, and configuration to show CC Charges on specified transactions and transaction types. Here is a reference: You can do it with just sublists if you add the reference transaction (e.g., JE or Check) on the Credit Card…

Hi @Febin Antony, Yes, you can create a KPI Scorecard to show the AR vs AP. You can also add Bank data to make the KPI Scorecard more informative. Here is an example:

I see what you mean, @User_DJ8IA, If the client absolutely wants to match the payment to CC charges, you can offer to add a multi-select CC Charges list to be selected on the payment transaction.

Hi @User_E15G4, Yes, there are several workarounds. For example: Create a Custom Field (Free-form Text) to enter multiple emails. Create a Workflow to copy those emails to the "Email" field on the PO, which can accept multiple email addresses. With this solution, the PO will be sent to multiple recipients.

Hi @GuppyPhish, The issue probably isn't related to NetSuite impacting the back-end or scripts. NetSuite pushes semi-annual releases in March and September. They also regularly push hotfixes, which are relatively minor and often applied to specific user accounts. The best option is to check the execution logs of the…

Hi @Gia My "Mei" Luc, In some cases, a field on a Sublist can be hidden via Permissions. "Amount" isn't one of those fields. There are several solutions to this. For example: Create a Custom Form for the required role Hide the standard/current sublist Create a custom sublist without the "Amount" field

Hi @User_NG5TG, Could you check if you have the Project attached to the Opportunity header or line?

Hi @User_GE47I, You would need to create a Commissionable Item Saved Search and use the custom checkbox in the Criteria. Once done, you would need to include the newly created Saved Search in the new/related Commission Schedule.

Hi @Tybrneryan, Please help me to understand your use case better: Do you have the same Base Currency in both subsidiaries? Are you doing an "Arm's Length" transfer where the item rate / transfer price is the same? Do you have the Use Item Cost as Transfer Cost preferences disabled?