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...
How to Set a Date Range

How to Set a Date Range

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

Learn More