Tigran Shahnazaryan · CEO @ Novelance · Gold Crown

Hi @User_815U9, Let's say you have two Sales Orders: Sales Order 1 - Customer/Dealer is ABC, the End User is XYZ Sales Order 2 - Customer is XYZ (the End User) Would you send the first invoice to ABC and the second to XYZ? Would you recognize the revenue for the first SO under ABC and the second under XYZ? Also, do you…

Hi @bm136, Could you clarify what you mean by "if we do an edit on the PO"? Do you make any changes to the PO Line Fields? Bills are linked with POs via hidden "Transaction Line ID". The transactions will become unlinked if the "linking line" is replaced on the PO or the Bill.

Here is the reference Saved Search (you can drill-down on the summary to see the details):

Hi @Dext3r, NetSuite considers "System" a User with ID -4 (sometimes -5). If you want to enter a condition in a Workflow for a "System" user, you can do that via:

Thanks for the additional information. We can combine multiple lines into one/combined line on a Saved Search: Is this something that might work for you? On a Saved Search, we can't add a "Subtotal" line after listing individual lines.

Thanks for the screenshot of the sorting tab. You are right - I didn't notice that some Total Amounts were misplaced on your screenshot. I have a few questions: Is this a report run for one Subsidiary and single-currency transactions? Is this happening when the report is run in the Admin role? Did you try to clear the…

Hi @User_32GQL, Can you share a screenshot of your Saved Search Result? The part that isn't clear to me is: "But what I want it show all bills of one vendor and subtotal of vendor in one page." Did you mean to say "...subtotal of the vendor on one line/row"?

Hi @Dext3r, Do you have the Custom Sublist created? The "Other Sublist Fields" will appear once you have a Custom Sublist. You can create a Custom Sublist via Customization -> Forms -> Sublists -> New.

Thanks for the response. Do you "Post Time" and record Time Entry as a Cost via the Job Costing feature?

Hi @Anisha., When you create a Sales Order directly in NetSuite, does it create the Customer Deposit, too? What you are describing doesn't seem to be a native behavior. It was probably set up during the integration for a specific business use case.

Hi @Dirk Nieuwkamp, I have two questions: Are you invoicing the "freelancer hours" back to your customers? What do you mean when you say, "offset the vendor bill with the project hours"?

Hi @User_2LD8N, You can create a Custom "Subcustomers" Sublist and hide the native one. That way you can get rid of the "New Sublead" and other buttons:

Hi @Maleeka , Could you share the screenshot of the "Sorting" tab of the report? I assume it is the Summary version of the report. The report screenshot that you shared has everything sorted by the Total Amount. Are you expecting something else?

Hi @User_GNSOF, The Release Preview account is a separate NetSuite instance, similar to Sandbox. NetSuite provides the RP accounts so customers can preview the new features and test their customizations to ensure they will work as expected when Production is upgraded. If you created the Items in the RP account that were…

Hi @MatB, You can use Advanced PDF/HTML for Customer Statements. There are two versions included by default: The multi-currency version often requires tweaking to work properly.

Hi @User_8UBAC, Natively, the "To Be Emailed" field isn't being tracked in NetSuite system logs. For this and a few other fields, you would need a customization to enable tracking.

It should. If you are unsure, you can try that in Sandbox first.

If you do the JE "non-specific" and the refund to a "specific" customer, then the amount may show up in the AR aging.

@Patrick Fresnosa-Oracle, Why do you think this U5 defect is taking so long to resolve? Per NetSuite official guidance, 80% of U5 defects are resolved within 4 E-Fix releases: Core product E-Fix releases are published monthly, so this defect should have been resolved a while ago.

Yes, it can. On the JE, make sure you choose the Customer/Name on the AR line.

No worries at all. The main issue is that you physically deposited $250 and only recorded $230 in the bank. You can now do the following: DR $20 Bank | CR $20 AR (Customer name) This will ensure the original transaction was recorded correctly. Then, you can process the customer refund: DR $20 AR (Customer name) | CR $20…

Thanks for confirming. Can you check the GL impact of your entry? You mentioned you only applied 230 to AR. So, where did you credit the extra $20? DR $250 (Bank) | CR $230 (AR) + CR $20 (***)

Did you deposit $230 or $250 into the Bank?

Hi @TThompson-CM, What is the status of the Defect report #667177?

I understand why you only debited $230 into AR. Because the customer paid $250, that's what you need to debit to the bank. Perhaps it is easiest to book that extra $20 to the AR and then reverse it via the Customer Refund transaction.

Hi @User_0B8DH, The original entry was DR: Bank | CR: Accounts Receivable You would need to do DR: Accounts Receivable | CR: Bank

Hi @SuiteCandy-Oracle, I agree that the description of the limitation is confusing. It is probably related to automation, such as "processing Customer Refunds via Electronic Payments". NetSuite may allow only one primary bank account to be selected for such transactions.

Hi @Honey Soe, You cannot display the header level Location on AP Aging Summary report. The GL impact is based on line-level, which is why only line level can be added to the report. You can have a Bill that has a Location ABC on the header and Location XYZ on the line (e.g., it was manually changed). In this instance, the…

Hi @User_P7UX4, The "A/P Balance" shows the "total impact on A/P accounts." It doesn't show cumulative balances, assumes vendor payments use the same class and department, and may sometimes show incorrect data. That's a confusing KPI, and I don't recommend using it. The "Payables" is always accurate and easier to…

The External ID should be unique for each record type. Using 1001 as an External ID for a non-Group record should not be a problem.