Hello, Not to add to confusion here but this is what I am looking for ... any help or direction is very much appreciated. I am trying to develop a way for my customers to import customer payments and remittance information using a CSV import method. I want to import a short-paid Customer Payment and apply it to specific…

I would agree with 'sandylivingston' . I am providing an image of where you can select the form that does not reference this field (on which the field is hidden). You will of course need to create such a form first. Good luck with your test!

Hello, In order to help, I would need to know your setup for the field 'custentity9'. Regards, Ilija

Hello again, I would not recommend this option as it will have a negative impact on your inventory costing, it will reduce visibility also think of the side-effects of the Inventory Adjustment that affects the Inventory Asset for closed periods. I am not saying this could not work, you just need to make sure to adopt a…

Hello, That field is not exposed to saved searches, you would need to load this value in a custom column field after the dropship PO is created, then this value will be accessible to your saved searches. I had the same issue ;). Regards,

Hello, there are many ways of doing this. It is important to know the following first: 1. Do you use any of the advanced features such as RFQ that would assist you with the procurement process? 2. What type of costing do you use for your items (FIFO, LIFO, Average)? 3. Do you and how do you update purchase price on item…

Hello, Just to add to Mavell's post. You could possible write a SuiteGL plugin that would post to COGS at the time of SO approval, but then you have to write another plugin that would cancel out the COGS native GL impact once the Item Fulfillment transaction is created. I guess it is possible, but you are creating a…

Hello Nathalie, Unfortunately, you cannot import 'Credit Card Charge' transactions. I have however used expense reports to bring in these charges. I setup an 'expense category' that will hit a specific cc account. Every time the user uses the expense category on the expense report line, the charge is being posted within…

I just have one question before you commence scripting. In Home > Set Preference > General Tab > Defaults Section. Have you tried un-checking 'Use Multicurrency Expense Reports'? Keep in mind only one (default) currency will be used, but I would suggest you test this before you start scripting. Regards,

Hello, I would try finding the lead / customer that was created with the form. Try deleting these records and then the form. Regards,

Question: Do you need a unique promo code for each customer, or could you use one promotion and set certain user / use restrictions to that promotion? Regards,

Hello, Yes, this is possible. Did you already build a custom record? If yes, you can run a saved search on that custom record. In the Results tab you would need to expose the field that ties the custom record to the customer, and all relevant custom fields on the custom record as results columns. You now need to group all…

Hi, Please check out my blog, it explains everything. You may need SuitePromotions and you cannot (out of the box) apply multiple discounts without promotion functionality. Ilija

Hello, I would suggest you login to NetSuite, click on support tab and access SuiteAnswers. Once there, search for 'PHP Toolkit' and SuiteAnswers will return all information available relative to PHP integrations with NetSuite. Regards,

Hello, Unfortunately you can't, you can only import the Web Store layout you want use to display these items. The fields are: 'Related Items List Layout and Upsell Items List Layout'. I checked the item imports as well, it does not allow you to map related items. Which is strange I thought I saw that option at one point.…

Hello, I do not believe you can achieve this with SSP / SS unless you build your custom SSP / SS files which will communicate with your external REST service. Web Services will work, how will you write your application, what will you use (php / java)? I am assuming you are proficient in PHP in which case I propose you take…

Hello John, [LIST=1] [*]Log in as Admin and please go to Setup > Site Builder > Setup Website : Click 'Edit' next to your Website's / Company name [*]Click on the Shopping Tab : Registration Page Section [*]Check 'Password-Protect Entire Site' [*]Select 'Customer Registration is required' / 'Customer Registration is…

Hello Chris, As per your SSP question, everything is possible. You will need to build a suitelet though that would return the results in JSON format and then create your SSP file that would transform the data and output it in a browsers. I guess you can also leverage macros and templates. You will need to access the items…

Hello, here is the list of operators you can use: after anyof before between contains doesnotcontain doesnotstartwith equalto greaterthan greaterthanorequalto haskeywords is isempty isnot isnotempty lessthan lessthanorequalto noneof notafter notbefore notbetween notequalto notgreaterthan notgreaterthanorequalto notlessthan…

Hello, If anybody is looking for an answer to this one, I have an incredible discovery .... Apparently, if your email address was not entered all in lower-case, and you enter your email in lower case in Excel's Query Wizard, you want be able to open your report Query in Excel. You may have to re-type your email exactly as…

Hello, I am not 100% sure of a desired workflow. I can explain however the designed functionality in Netsuite. [LIST=1] [*]Creation of PO [*]Checking of the check-box 'Match Bill to Receipt' item line-level. [*]Processing Multiple Item Receipts against the same PO. Transactions > Purchases / Vendors > Receive Orders or…

Hello, when you sell a bundle, is the bundle an item group, kit or assembly item? Regards,

Hello, The Advanced Bin / Numbered Inventory Management feature allows for the following functionality that is not available in the regular bin management: [LIST] [*]Use bins on transactions without being required to per-associate bins on items (allows you to putaway items to any bin) [*]With this feature on, you are not…

Hello, There is no out-of-the-box functionality for this. At this point I can suggest building an 'Item Bin Number Search'. [LIST=1] [*]This search can give you all available fields, barcode info, etc. [*]Export this data to CSV [*]Use word's mailmerge or some other label software to create your labels. [/LIST] As you will…

Hello, disabling bin management will have no negative financial impact in Netsuite. Did you enable 'Advanced Bin Management' as well?

Hello, Great question. There is one work-around that you can explore: 1. On the picking ticket custom form >> Printing Fields Tab >> Columns Subtab >> Header section : In the 'Sort Line Items By' field select Location [LIST] [*]When you print your picking ticket in the Transaction >> Management >> Print Checks / Forms >>…

Hello, If I cannot get all the fields on the picking form, what I normally do is: 1. create another custom SO form. 2. Give it a title Picking Ticket, enable all the line item fields I want to see 3. Go to Transactions > management > Print Checks and Forms > Sales Order 4. Pick the newly created custom form (You may need…

Hello, What SuiteScript code are you using to do this? Regards,

No work-arounds as of yet, as far as I know.

Hello, Yes, definitely. I usually upload my css in Netsuite's File Cabinet. I then refer to my style-sheet in the header portion of the theme record. Here is how you can access the file cabinet: Documents > Files > File Cabinet. Please see the path in my image where I usually create my 'css' folder. Good luck!