PaulFleetwood Silver Medal

@Varonis inc. Hannah - I don't recall having specific issues with Tax Codes, but I know I did have some problems with other mandatory fields. You should be able to use a Workflow to set any default fields etc - seems like I used the 'User Event Script' context to get this working here so you might want to experiment with…

Thanks @Leonard Mallare-Oracle I can't view the closed enhancement to see what it said, but 134322 does not seem to have any relevance to SuiteCommerce Advanced. I will put my notes on it, but probably raise a specific request for my issue also

@Kristoffer Viray-Oracle Thanks for this - I will look at the enhancement for specific days per week (as this would be useful for part time employees with varying shifts). However, for this 'night shift' work calendar, the users start at 22:00 Sunday-Thursday and finish at 07:00 the following day. It is not possible to…

@Leonard Mallare-Oracle - based on Option 2 in the SuiteAnswers article - we already have the 'Credit' Gateway Request Type enabled, so it should have worked. However, I think these notes are based on a 'normal' integrated payment card solution (that can be used within the NetSuite UI) - ours is an externally hosted…

@Niks Blando-Oracle Thanks - no further help needed - we clearly need to use serialised or lot numbered items for these bespoke item orders - I will have to plan a project to move over to these. Unfortunately this is one of the many legacy issues left over from the severe lack planning and process understanding from our…

@Niks Blando-Oracle Please see attached XL file I've run this from the start of our NetSuite, so it starts without any issues from older transactions. The first 4 lines are correct, items in and then items out. On lines 5 and 6 we have two receipts (for different values). Lines 7 and 9 have items going out for what I…

Hello @Leonard Mallare-Oracle , We have now downgraded to the recommended version of node.js for our SCA version, it is now creating the DeployDistribution folder as expected. Thankyou for your help.

I've just checked one, and it's not the Average Cost for the location - and I've gone back 5 months and I can't find any receipt for the item at the value of the GL Impact on the Item Fulfilment....

@Niks Blando-Oracle I agree the Item Receipt value comes from the Purchase Order price. My problem is that the Sales Order Item Line is linked to a Purchase Order (via Special Order Item), but the Stock Value that is removed from stock when that Sales Order is Fulfilled is not the same and the Stock Value for the Item that…

I have also noticed that the filename format is different if you save the PDF from the transaction, or if you send the PDF via email from the transaction - so clearly there is a way 'under the hood' to change / control the filename format - we just need that exposed in some way so that we can control it.

@Dennis Thideman I created Custom Homepages using: Within a new Center Tab you can add as many Portlets (of all types) as you want: And you can use the Audience tab to control access by role or user (therefore you can publish a separate tab for each sales rep, and then assign to a single user so they only see their own).…

Thanks again for confirm that this is 'intended' functionality (albeit a ridiculous example of how NetSuite's claims to provide 'Best Practice' functionality is clearly not true). I'll get my developers on 'fixing' this as well.

Disappointing, but thanks for confirming the 'intended' functionality (poor as it may be). I'll get my developers onto creating a fix for this

@Rumaysa Mirza If you want each page to contain the transaction body information fields, then you will need to move these elements down into the loop section where the Advanced PDF template loops through the items.... You don't need the 'if item_index=0' check as you will presumably want column headers on every page. And…

Voted,

Voted, but no expectation of this ever being resolved / improved....

@User_1TPSM - thanks for the suggestion - that's not something I've come across before but I will certainly look into it.....

Yes @Joahnna Given Uy-Oracle - I have updated my User Event script to include the necessary error checking so that I don't need any error checking in the PDF template.

There is a custom field on the Item Fulfilment to select a PDF file stored in the File Cabinet: On the File record in the File Cabinet, this bock has to be ticked: I use a User Event script to populate additional fields on the Fulfilment with the external URLs of the file: I then have an Advanced PDF Template that is…

to be honest, I can't even remember what that problem was I was trying to solve when I posted this. there is an option on periods to allow non-gl posting changes to closed periods - but I've found that causes problems also. period close is a minefield - and we have since found out we have not been doing it properly (since…

Thanks for following this up. I think I have managed to overcome this by triggering a script on Sales Order edit - despite the fact there is nothing shown in the System Notes, the Sales Order is being edited, and I can script my changes from that. Thanks

And to answer your other question, yes, we use that saved search (exported to Excel) to check our current reorder points and preferred stock levels against calculations from the last 12 months sales, and then adjust the Items (using a CSV import).

@Benjamin Paul - USA We have these features: But I don't think Advanced Inventory Management is a requirement for using the basic 'Order Items' functionality: On this screen: We use the 'Reorder Point Items' option, and this shows Items to be ordered based on the 'Reorder Point' and 'Preferred Stock Level' set on the…

Thanks

I have been investigating this further, and it's not related to the application of a customer deposit - the same behaviour occurs with a Card Authorization. The trigger I need to find is when the Sales Order moves from showing this warning: To not showing it (i.e. when the Pending Payment (or Authorisation) has completed.…

@Sivasubramaniam - it can't be done. I have created a custom record that my Finance Manager has to complete each month with the Monthly Budget figures so that I can access them via Script and include them in the dashboards. Totally ridiculous, but the only way. (This custom record ended up being used for a few other things…

@Dennis Thideman Couple of options. You can create Custom Portlets in script (quite easily) to replicate a saved search (let me know if you need an example). But you only have a limited number of Custom Portlets as well.... (but you can put multiple searches in a single Custom Portlet if you need to - this is what I am…

@Benjamin Paul - USA Very hard to do in NetSuite - as you need to get Item data (reorder points etc) and transaction data (qty sold) and then calculate on that. Trouble is you need to group the transaction lines by Item (to get totals for that item) and then you can't run calculations on a grouped total. Best I have done…

@Todd Juenemann - actually easier to read the code if you don't use the 'code' format tool 🤨

/** * Module Description * * Version Date Author Remarks * 1.00 18 Jul 2019 * */ /* Name of Script : Update Route Details On SO & TO Type of Script: Server-Side Description: This script will update Route Details On SO and Transfer Order from IF (Fields- Route No.,Truck No. , Driver and Stop No.) Business Problem…