Say a client wants to add lot # to shipment report (SO64200 is the report name). Therefore, you add the table SOShipLineSplit table to the report, add additional detail band and display lot #. The report will look like the following example: Batch#...
Create an Acumatica custom shipping label for number of boxes based on a shipment with a number line items and quantities. The quantities will be divided by a factor of that item setup on stock item maintenance to give the number of labels to print for that many...
Netsuite error: Cannot fetch a row from OLE DB provider “MSDASQL” for linked server. Say you have sql job calling a stored procedure on a local SQL server that is pulling data from NS scheduled at 8pm daily. It’s been running fine for a...
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...
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.
