Hi Mike, Olivier wrote a good whitepaper on this issue, it can be found here: http://www.it-ration.com/s.nl/it.I/id.165/.f Long story short, there might be a disconnect between the amount on your inventory receipt and the amount you pay you vendor on the Bill. It does not address the Landed cost but it might be a good…

You are correct, in this case we assume that the last price is the good one for the purpose of the script. You can always go back manually for the exception. Martin McNicoll, ing. IT-RATION CONSULTING inc. NetSuite Solution Provider T. 514.664.1023 x 100 M. 514.895.2789 F. 514.221.3681 www.it-ration.com

From a Vendor Bill, you have a link to the PO, the PO has links to all item receipt. Voila! Martin McNicoll, ing. IT-RATION CONSULTING inc. NetSuite Solution Provider T. 514.664.1023 x 100 M. 514.895.2789 F. 514.221.3681 www.it-ration.com

Hi Folks, Regarding the issue of having a different value in the item receipt (i.e. from the original PO) then in the vendor bill. We actually created a suite script to fix that. If a user modifies the cost of the item on the vendor bill, we track back the inventory receipt and change it accordingly. All automatic, no need…

We actually ran into the same issue. To solve the problem, we developped a custom revenue recognition feature using custom records to store the schedule and suitescript to create the Journal entries. It is not as evolved as the NetSuite functionalily and has issues if you deal with multiple currencies, but on the other…

Hi Latif, The issue is actually around exchange rate variances. We need to do some fancy scripting to automate the creation of that adjustment. Not impossible, we just did not get to it yet. We plan to deal with it before the end of the year. For your 2nd question, yes we were using the NetSuite rev rec module. To my…

Ok, answering my own question: Turns out this is kinda linked to other synchronicity problems. In this case, the commit is trying to commit before the line item is done fully loading, so that's why it isn't working. Replacing nlapiCommitLineItem() by setTimeout('nlapiCommitLineItem(\'item\')',3000); does the trick.

As to why it happened, in your Excel sheet, after your valid data, there were empty line that weren't really empty.. The best way to ensure your blank lines don't get picked up is to select the first left cell of the first empty line after your data, press CTRL+SHIFT+Right arrow, and still holding CTRL+Shift press down…

Hi, This is currently a known issue at Netsuite. All XML + CSV import are not working since 2 weeks. This is critical for us also! Martin McNicoll IT-Ration Consulting.

Hi Rob, Did you check if the Class is passed to the journal entry generated by the rev rec schedule? With Rev Rec, it is that journal entry that affects sales.

One last thing I might think of: in the printing fields tab of your form, column subtab, make sure tax code is not checked. Otherwise I would advise to call support or a partner so they can look at your form.

Hi Lnanji, You can effectively only show the appropriate tax code on the transaction without creating multiple forms in a NS Canadian Edition. Our tax code is in the footer of the form (not in the line item section) Couple things I would try: - Check that you are using the "." or "E" tax code - Create an estimate with the…

Hi Tracy, When you receive items in inventory, do you make sure that the price is the same as the one you are billed by the vendor and not the one on the PO? A little know fact in NetSuite is that your inventory value is based on the amount stated on the item receips, and not the amount you will put on the bill of your…

This is causing us MAJOR headaches as well - plus, many vendors do not put pricing on packing slips, so you don't know until you receive the bill what the final pricing is. Thus at the time of item receipt, you don't have a clue if the price is the same as on the PO or not. Does this mean that our A/P clerk has to pull up…

Hi Steve, If you are not a registered company in Canada, you will not be able to give back the tax money you collected from the customers to the government. The real question is, should you be registered in Canada to sells your goods. Martin McNicoll, ing. IT-RATION CONSULTING inc. T. 514.664.1023 x 100 M. 514.895.2789 F.…

Hi, The problem you are having is probably due to the change in the GST rate in January. The cache on the browser still thinks that the GST is 6%, so it calculates the wrong rate. On your next estimate, try to select another tax code (i.e. Z) than reselect your tax code S. The rate should be correct. On your next estimate,…

Just curious if anyone is using a third party budgeting tool and how satisified they are with it interfacing with NetSuite. Our planning area is looking for something more sophisticated than what's in NetSuite to put together the company budget. Hi, We are reselling a web based budgetting tool, give me a call, we can see…

Martin, Does your tool integrate with NetSuite? If so, please provide some details. We resell Adaptive Planning ;)

We have encountered this situation in other areas where some fields are not available to put on lists. One solution is to use a combinaison of custom fields and SuiteScript. In this case, you would create a custom field called 'Bonus' and add a Suitescript to your page that will take the value of the field not available on…

Hi Kyle, This is a good question! There is no worflow per say in NetSuite to accomodate Canadian taxes. Tax of invoices go to the GST collected and tax of bills go to GST paid. (same for PST) What I do, since we do our GST and PST filing every quarter, is a JE from my GST paid to my GST collected, then write a check from…

Since this question came back a couple of times from our customers, we wrote a short whitepaper on Canadian tax processing. http://www.it-ration.com/s.nl/it.I/id.220/.f Hope it helps!

Did you try to go to 'Setup Taxes' and update the field naming tab? Thanks, Yes we did. This is a bug and we are trying to get NetSuite to fix it. We are also actually working with NetSuite on the review of the whole french translation. We contributed to the first translation and we will get to review the french version…

No, it is not fixed.

Hi Todd, SMS would not be my first choice of communication medium for my tech, but if you want to do so, just email them (i.e. (123)345-6789@verizon.com) To do this simply, you could add an employee with no access with the sms email address as email, then assign that employee, along with your tech to the case. They will…

The Team Selling Contribution permission seems to be gone from the Setup tab. Anybody knows where its gone?

The last time I checked, you still needed site builder to host a html page within NetSuite. Without site builder, you can only use the NetSuite templates.

Bonjour Pierre, No you are not missing anything, fedex integration is only available at the fulfillment stage. As for keeping track of shipping costs, you definitively need to fulfill (i.e. sell) something to have that work out of the box. Couple of options for you: 1. Create a non inventory item for sale (at 0$) or a…

Hi Thomas, The way UPS and Fedex work with NetSuite, you can only access the shipping products that are available in your country. i.e. if you have a Netsuite Canada instance, you only have access to the shipping products available in Canada. Is this the problem you are having? Martin McNicoll IT-Ration Consulting inc.

Who do you want to connect to with EDI? If it is a large company, with an existing infrastructure (i.e. AS2 ), you want to look into an existing provider with existing connectors to both NetSuite and their Network. You will be charged an initial implementation fee + monthly transaction fees based on volume of transactions.…

Hi Angela, There are definitively partners offering support for Netsuite. We have been supporting our customers with an on-demand model since the beginning. All Netsuite partners will usually support their customers after the implementation, most of the time with the same staff who did the implementation, which gives you…