Hi Jack I found out our Company's address was not in the Sandbox. Once I have populated the address, add the BR/ codes and also reduce the logo size to 10%, the Logo is now smaller and the company address appeared on the statement. However, which part of the codes is controlling the alignment of the Logo? I would like the…

Hi Jack My issue is not the fact that its printing 2 pages. But the issue that the company logo is distorted and the company address is not appearing. I have submitted these issues to sending this idea(issue) via the Enhancement Request in SuiteIdeas. But its rather strange when you use the codes I sent you, it works on…

Hi Niks I thought that was the case. I have hidden these fields: inventory location & inventory subsidiary in the SO form in Sandbox. but it still would not allow me to fulfil the SO. There are must be something else in the accounts or company settings that cause these fields to be displayed and affects fulfilment of SO.…

Hi Jack Thank you for your advice. I reduced the image to 15%. it still gives me the wrong logo size, company name appears but should be below the logo and also our company address is not appearing below the company name. see below the correct statement display should as below: Before the change to add the additional…

the above screenshot was for a Euro customer - the print originated from Customer record>Actions>Generate Statement. On the Print Individual Form, on the Form field, I selected Custom Statement. when I run the custom statement for a £ customer(which is our entity's base currency), it prints only the first page (see below)…

Hi Jack Sorry, I was not in the office when you requested for the codes. I don't know if it its ok to send the codes in text format. thank you

Hi Jack Thank you! would appreciate your help on this.

Hi Niks I managed to resolve this. I didn't realise there is a dropship expense account in each item record. so the issue is resolved.

Hi Jack It did print something without error but shows a completely different statement layout with the logo everywhere(though I have sized it down to 25%) . Would appreciate your advice. Thank you Before all the changes, the Standard Statement, print template and email template are as below. It gives the correct statement…

Hi Jack Thank you for your email. I made all the changes as per screenshots 2& 3 below. When i went to a customer record, click on Actions>Generate Statement. On the next screen, the Form field: it displayed: Custom Statement. Click on Print and this error message appears. See screenshot 1 below: Error. Would appreciate…

Hi Kristoffer Strange, I was looking for Main on the dropdown list earlier and couldn't find it. But now I have found it! Thank you so much for your advice.

Hi Kristoffer Thank you so much for your solution! This new custom field is currently created in Custom subtab on the Assembly Build Form. How can I can move this field SO ref field from the Custom subtab to the Primary Info subtab?

Hi Jack Would be grateful for your response to my last query. Thank you

Hi Clarisa Thank you for explaining this. yes, the Per Line on Transactions in our Set Up Taxes page was enabled. You have answered my query.

Hi Jack Thank you for the detailed instructions and links. It was very helpful. I went to a customer to test the changes you have advised me. On the customer page>Actions>Generate Statement, I selected the start and end date, checked show only open items. Form field, selected Custom statement. Then Print. The message that…

Hi Jack, thank you so much for your advice. Question 1: I inserted those 2 lines in Custom Statement pdf/html template . then click on preview to see if the column has been inserted in the layout. the message I received was: Multi currency customer setting was detected. Please use Multi Currency Advanced Printing Template…

Hi Ivy Thank you for your comments. Unfortunately, I don't seem to be able to get to the enhancement ~=#77321. I can see Help on top of our Menu but not Support. our support from Oracle is a basic subscription. is there another way of getting to the enhancement? I am also an administrator. where do i have to enable so I…

Hi Katerina Thank you so much for the solution to the problem. I have never used Analytics in NetSuite before. But at least I could exported it like a trial balance in csv format and pivot the data in Excel.

Hi Kristoffer, Thank you for your help!

Hi Kristoffer Thank you so much for advice. When creating the "Created by" field, should the Type be Free-form Text or List/Record and store value(checked)? This field should be picking up from record: users in the Actions of the first state: Initiation. or Thank you

Hi Katerina Thank you for your advice. I have already looked at the balance sheet and profit & loss separately. but what I am after its a Budget Trial balance - this combines both profit and loss and balance sheet in one report. This is truly a basic requirement. Maybe I will need to create a saved search for a budget…

Hi Joy Thank you for the suggestions. These reports includes items committed only. we have sales orders that include uncommitted items, too. we would like a report that shows Thank you so much for your patience in dealing with my query. I really do appreciate your help. I think I might have to create a saved search report…

Hi Joy Thank you for your test to our issue. I now understand about the open sales order report. Its useful to know. However, how do we create a report to show the remaining value of sales orders yet to be fulfilled regardless if it has been advanced billed or not? Or is there a report already existed in NetSuite that…

Hi Joy The Open Sales Orders report lists open customer orders that have not yet been billed. The report includes the date of each sales order, order number, customer, status, and amount. this is per Oracle link below. how do i customise the report to show the remaining open orders amounts for partially fulfilled/pending…

Hi Joy Thank you for your advice. I tried changing the date. but the SO is still not showing on the open sales order the date of the SO was 1 sep22 but it was created on 7/9/22. would this affect the SO being included in the open sales order? i even add in the filter - date created and still wouldn't show. the status of…

Hi Joy Sorry for the delay in replying to your text. I was away. Attached is the screenshot for the filter and edit column of the original open sales order report. The sales orders with status pending fulfilment were not showing in the above open sales order report have advanced billing . For each item, you can see the…

Hi Clarissa Thank you so much . Your comments are really helpful.

Hi Elychelle , thank you.

Hi Elychelle Thank you for letting me know that this bundle 1099 Vendor Payment Report is free. we are thinking of using Avalara for e-filing. Track1099 by Avalara bundle - the 2nd bundle on the list . is this also free? do I have to download both bundles to customise the saved search?