Say you need a date range on gathering data for a report starting from Friday to Thursday based on the current date. Example dates July 5 to 11, July 12 to 18, July 19 to 25 and July 26 to Aug 1. So for July 5 to 11, you want the report to run this range of dates if...
Say you want to look at an item’s memo field but you can’t login to NetSuite as all the users license are taken. The next best thing to do is do a query in MSSQL with a linked server connection NetSuite. In the query window, you type the following. select...
Reading a narrow pivot table to create a new wide dynamic pivot table using the values from a field of narrow table in sql server. (SQL Server skill level: Advanced/Expert) Example: Narrow table. Docnum description amt 100 ...
Here’s a good trick to create a line sequence number for each invoice # that I found on the internet which help me on one of my projects. First create a table. The seq column is used as the seed in building the sequence number for each invoice # line sequence number...
Goal: to modify sales orders to generate two individual picking tickets for two different third party vendor picking processes When entering an item in the sales order window. It will determine what quantities to split into bulk or pieces into custom fields. The...
Wait! Before You GoWould you like to talk to a business software expert to answer your questions?
When you schedule a free consultation with MIBAR, you will experience a one-on-one conversation with a business technology expert who is passionate about understanding your unique needs or issues. Schedule a free consultation today at the link below or give us a call at (212) 869-9300.
