Adding a Lot Number to Acumatica Reports

Adding a Lot Number to Acumatica Reports

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#...
Check Netsuite Link Server Connection

Check Netsuite Link Server Connection

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...