Try adding at the end of the formula: (ROUND(TRUNC(({jobmain.projectedenddate}-TRUNC({jobmain.startdate}))/7)*5 + MOD({jobmain.projectedenddate}-{jobmain.startdate},7) - CASE WHEN TO_NUMBER(TO_CHAR({jobmain.projectedenddate},'D')) < TO_NUMBER(TO_CHAR({jobmain.startdate},'D')) THEN 2 ELSE 0 END))+2

That's good - it confirms the Summary and Detail reports are properly connected. The issue might be the scaling of the customized Summary report. In your screenshot, I noticed that one of the footer icons shows up in the wrong place: Can you try using a different browser to see if that helps with the scaling?…

Could you please clarify what you mean by "will a non-intercompany sale be eliminated when posted to an account marked "Eliminate Intercompany Transactions"? Do you plan to use the Advanced IC Journal for that, and what would that transaction's purpose be? If you use a GL account with the "Eliminate Intercompany…

It can be Accounts Payable/Receivable or any applicable GL account. Not the Bank account, but possibly "Bank Fees", which is a P&L expense account. The best check with your lead accountants.

NetSuite will skip the application for CR4 if you don't tick its related "Apply" checkbox. When you ticked all the "Apply" boxes, including the one for CR4, NetSuite assumed you needed all marked transactions to be applied. When you are creating a Vendor Credit and making the application from there, you can't select…

Understood. If you are noticing a repeating pattern, then you can simply add +1 or +2 to constantly increase the "days difference" based on your preference.

Thanks for the response. What happens if you click on "View Detail" instead of clicking on individual lines?

Could you please advise: What are the actual dates? What do you expect the difference to be? What difference do you get via formula?

Hi @User_Y64EF, I am not sure where the confusion is. The Utilization is set on the Employee Record and is Monthly by default. It is not set on the Project Task. ............ Your question: I'd like to establish whether it's possible to set a Target Billable Utilization per week or month for each employee (rather than for…

Hi @User_NG5TG, Please try: Formula (Numeric) = ROUND(TRUNC(({jobmain.projectedenddate}-TRUNC({jobmain.startdate}))/7)*5 + MOD({jobmain.projectedenddate}-{jobmain.startdate},7) - CASE WHEN TO_NUMBER(TO_CHAR({jobmain.projectedenddate},'D')) < TO_NUMBER(TO_CHAR({jobmain.startdate},'D')) THEN 2 ELSE 0 END)

Compared to the Legacy RevRec, ARM is significantly more robust. This is one of the reasons it has more controls and restrictions to ensure the integrity of end-to-end processes for Revenue Recognition, Cost Amortization, and Revenue Reclassification. The process I described is the only way to fix the Deferred Revenue…

Hi @Muzzyelk, When you change the Deferred Revenue Account on an Item, it only applies to Revenue Elements / Arrangements created after the change. If you want to correct it for the existing source transaction (e.g., Sales Order), you would need to: Delete all Sales Order's dependent transactions (e.g., Revenue JE, Plan,…

Hi Hormese Paul, The COGS/Tax/Shipping and other lines are integral to the NetSuite architecture and cannot be removed from the Transaction Record. When creating a Workbook, you can exclude these lines: If you have more than 2,000,000 Monthly Transaction Lines, then you should definitely consider moving up to Enterprise or…

Hi @ZShah, Because you are posting the selected Bank Account, one side of the entry would already be the GL account for the bank. When you do a "New Charge", you must choose the Debit Account (e.g., Bank Fees) as the Credit = Bank. When you do "New Deposit", you must choose the Credit Account (Customer Prepayments), as the…

Hi @SDTHL, When you did the following: --- When I create a payment on Pay Single Supplier I have VB1 - remaining amount after credits £24 VB2 - £12 CR4 - £12 (standalone and not applied to a invoice) I tick the Apply box for all three and save. --- Did you expect the CR4 to apply to VB1 instead of VB2?

Thanks for confirming, @Mathias_Netsuite, You can exclude specific Vendor Bills from the Electronic Payments by unchecking the "EFT Bill Payment" checkbox on the related Vendor Record.

Is it possible it was unchecked only recently? I noticed that it had generated a "Current Number": Could you create a new test customer and see if it still auto-generates a number?

The reason you may have only one result when using "Display Name" is: You have only one item with populated "Display Name". You have only one item with the custom status of "Active" or "Extension." Can you replace "Display Name" with "Name" and see if anything changes? If not, can you check how many items you have with the…

You have many custom fields in the Search, and I assume the issue is caused by one of those. Natively, the Name shouldn't display as "Oracle_3242_Eff.03/27/23" even if you change Pay Rate, etc. Please do the following: Copy the search with only the "Display Name" field in the results. Is it still showing twice? If yes, add…

Hi @Nilesh Gupta, Thanks for confirming you aren't using Summary Type. Can you share a screenshot of the fields you are using in the results? For example, do you have any joins (i.e., to System Notes)? Which field(s) in the results differ on the Saved Search rows? You should have only one line per item if you remove that…

Hi @Casey Keating, You should be able to get the "Balance" on a Saved Search without using the "Balance" field. Can you try the following? You can enter additional criteria to narrow down the results further. You can also show the Subsidiary Balance in Results as separate Group Rows or separate Columns.

Hi @User_Jen, Yes, you can do that: Here are the reference fields:

Hi @Mathias_Netsuite, It is not purely an informative field, as by editing each Payment Method, you can set some pre-defined parameters: The Payment Method is only available for Customer Payments. When you say, "does not make sure that particular bills do not come in the payment file", are you referring to the Electronic…

Thank you, Team!

Hi @User_7CG4X, The "Fully Billed" status is based on "Billed Quantity", not "Billed Amount". You can edit the Bill and reduce the quantity (you can still set the amount to 400), so there is some left on the PO to be billed later. Once done, the PO status should be updated.

Hi @User_YVT0P, You can use the "Clone Environment" option: Another option is to use the "Migration" tool to create an Artifact Snapshot from Production and import it to the Sandbox/Backup environment.

Hi @User_8RJ16, You are on the right track - the issue you are seeing is most probably caused by enabled auto-numbering for Customers. You can disable it via Setup -> Company -> Auto-generated Numbers.

Thanks for confirming, @User_P2QHQ, Are you using this for a Parent Bank Account with Base Currency or a Subsidiary and/or non-Base Currency Bank account?

Thanks, @Nilesh Gupta, Are you using any Summary Types under results? It would help if you also shared a screenshot for the Results section. Thanks.

Do you have anything entered under "Available Filters"? Here is an example: