MoonK Bronze Medal

hi @Dext3r, there should be a global accounting preference setting to age balances based on either transaction date or due date. If Due Date is set, there are invoices with a total of 119,961.95 which is not due (due date is after today), so you have the amount in the consolidated current. Then, you have unapplied credits…

You don't see the item in the inventory worksheet because the On Hand qty is 0. I think you can trick the system by entering a qty of 1 with a value on a date before the inventory worksheet date. I.e. Adjust in Qty of 1 on 1.20.2026 and then load the inventory worksheet. The item should appear and you should be able to…

Not sure if your item is also a lot numbered item. If so, Item Number sublist may serve you right.

Native reports cannot display transaction internal id. To obtain Invoice internal ids, you will need to create a search like AR aging report. SuiteAnswer #85341 and 1011618 have details to show you how to. I think this is your better bet on invoice internal id. I hope that helps.

I believe you are looking for the field named "Actual Ship Date". The date won't populate until the item fulfillment is marked shipped.

@Elizabeth W. Thanks for clarifying that and apologies for oversight of the request. I have looked and cannot find a way to update that system email template in the list of system email templates. It may be hidden somewhere. Often, people are emailing the statements based on scheduled workflow. In the workflow, you have…

The email template setup of the customer statement is based on the selected customer statement transaction form. If you choose "System Preference", the global preferred customer statement form will be used. If you choose a specific customer statement form, the email template is set on that specific customer statement…

It may sound like a redundant question, did you set to post against actual bank account than the undeposited funds account on the actual customer deposit screen?

Three things to make a sales order taxable: Subsidiary has the necessary Nexus Customer is taxable Item is taxable. If all of the above is setup, you should see a taxable sales order if the shipping state falls into the Nexus State. If not, we probably need to see more details to determine why the sales order is not…

Should the condition be AND? Name is not C0057249 AND email does not contain tiktok?

@User_PCF01 the transaction body field option does not require SuiteFlow to create a button. The native print button will be used with customized advanced pdf. In the customized advanced pdf, you need a If-then statement, i.e. <#If custbody_proformaInv?string == "Yes">Proforma Invoice<#else> ${record@title }</#if>…

In NetSuite, there are multiple ways to do this. Depending on the frequency of usage and how savvy your users are: You can simply create a new sales order form and sales order PDF. In the advanced pdf, you update the title to 'proforma invoice'. When a sales order is saved with this new sales order form, proforma invoice…

I have not tried it, but you can probably do it with a new vendor workflow. However, when you use the 'initiate workflow' action from the vendor bank detail workflow, you will need to pass the vendor id to the new vendor workflow. Good luck

Hello Brian, In general, saved searches can only reach one level up or down. The search starts from PO level and you can get information at the item receipt or bill level. Since the bill payments applies to the bills not on the PO, the PO search will not list the bill payment information natively. If you are savvy with…

You may want to look into this SuiteApp. It contains "Supplier Lot Number" which will then be used to generate lot number in your NetSuite instance. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/article_162780241331.html#bridgehead_162798558047

@Jam Amper-Oracle Thank you for providing SuiteAnswer 73979. The document states that : "The NetSuite 2024.2 release enables you to automatically generate new lot numbers by integrating with the Auto Generate Lot Number SuiteApp. After production you can then choose whether to retain or not retain the new lot number." Does…

The item type from the item record can source to the transaction column when the line item is added to the transaction. If your item is already added to the transaction before your field is setup, no value will display there. You, however, can uncheck the store value field, and the value from the item record will source to…

Thank you @Jervin Nicholas Teopengco-Oracle UTS case has been filed.

@Joahnna Given Uy-Oracle I have the same syntax error in my client's account, which is a brand new NetSuite account will be configured. We installed the SuiteSuccess bundles based on the deployment guide. The advanced pdf provisioned is called "NOAM - Charges Invoice PDF/HTML Template"…

@User_P2RPH Unfortunately, my client did not want to proceed this because it took too much time to address the issue with the feature. They opt for manual upload now. Also, I learned that you have to have 1 dedicated login for bank feed, so bank feed connection does not get kicked out if the login is used on the bank…

Thank you! My client's account got upgraded over the weekend, and I am seeking for more details from them. I will reach out for support if they need help. They said: "User complains that the file drag and drop box intermittently disappears"

Can we confirm if this defect is fixed? Thanks

Hi Support, Since this post is more than 10 years ago, can someone confirm if we have no feature to handle subsidiary shared ownership? Thank you.

@Michelle Jabanes-Oracle Yes, both functions are installed and enabled in the said account. Thanks

@Michelle Jabanes-Oracle The bundle is not in the account related to my profile. It's installed in my client's account. If you need further information, please PM me. Thanks

Try to add the following Formula (Numeric) to your criteria and you should be able to get the 100% committed items but not shipped. case when {quantity}={quantitycommitted} and {quantitycommitted} <>{quantityshiprecv} then 1 else 0 end Formula (Numeric) Value = 1

I am setting the same bank on bank feed for my client. They do not have MFA setup on the bank login, so they just need company id, user name and password to login. When logging in the bank connection on bank feed in NetSuite, it gave a MFA error initially and then the error disappeared for 2 days and came back on. We have…

Hello, I don't think you can do a setting on calculated date on Before Record Load. I think you can try switching it to Before Record Submit or After record submit, and you should be able to set the date.

It really depends on how the workflow is being triggered/loaded with the transaction. You must make sure the workflow trigger and/or workflow action correct to have the workflow running against your PO record. It looks like the workflow wont be triggered if the PO is loaded = Before record load. you have to make sure you…

Thanks for the response. We have read the SuiteAnswer already but we are trying to find a way to work around the lack of the feature. We have filed an enhancement (#685056 Allowing Item Group for SuiteBilling Subscription.) and it got approved today.