Hi again Mavell, I think I found another issue with doing the report this way. The starting report has a date selection in the filter field, which cant be removed. Therefore, if there is an inventory item that has no stock on hand at that date, the report wont include stock levels in the prior months, even if there was…

Hi Mavell, if I read this correctly, the way you suggest requires hard coding all the previous dates. So if I want to look at the same report for a different range of dates I have to go and change the dates manually? Is there any way to make this dynamic, so if I select Feb 2016 for the report date, it automatically gives…

Thank you Latha, it worked. Not sure how I missed seeing it before!

Thanks for the replies. I tried Evan's method and it is better, but not ideal as some groups have many sub customers with a lot of open invoices, so would then have to add them up manually to get a total for each of their outlets. However will go with it for now. In regards to scripting, we use an Australian version of…

Hi, we do this each month using the Bulk Merge functionality under Documents > Mail Merge > Bulk Merge. It isn't automated, but it only takes a minute or two to do each month. It is pretty simple, standard functionality, unless I am missing something? You can also see history for each customer if you add the 'Bulk Merge'…

Looks like this can probably be ignored... just found a thread from last year where lots of people are asking the same question and no answers have been forthcoming. There is apparently an ODBC option which I will look into. See https://usergroup.netsuite.com/users/showthread.php?t=22816&referrerid=17727

Hi Amber Go in to edit your PDF form and click 'add custom element'. Then in the element text box, you can just type {status} using the {} brackets. You can add other text around the element field if you want as well, or use the label of the custom element. Cheers Fran

Thank you Charles! I was overcomplicating it.... Appreciate the help.

Thanks for the reponses John & Julie. I think I will go with what John suggested and give them restrictred access to POs. In the meantime, they are OK using the reports that are available.

Hi Carl, I am in Australia and have confirmed with our Tax Office that we are not liable for the tax on the discount given for early payment. So maybe the treatment is correct for the US, but not for me in Australia? I have raised a support case with JCurve, who are our Australian reseller, as well. Thanks Fran

Thanks for the replies so far. I will do some further research.