Tag Archives: sage 300 technical blogs

How to use CSQRY using COMAPI in C#

CSQRY is the standard Sage 300 View CS0120. It basically takes the SQL Query as the parameter to its Browse method and then returns the records via calls to Fetch. CSQRY is easy to execute general SQL statements through the Sage 300 API. This way we don’t need additional database credentials and don’t need to… Read More »

Enter long comments in order detail lines – Sage 300C v2020

Sage 300 ERP web screens functionalities are getting enhanced with every new release. With the launch of Sage 300 ERP version 2020 product update 2, new functionality is launched where the user can enter the long comments on the order entry detail line. New Stuff:- Company wise color in Sage 2020 PU2- Web Screen For… Read More »

QR code generation for each item on the OE invoice Report screen

As we are aware about Tax invoice report displays sales invoice details of particular customer with details like Item number, Unit price, customer, ship to and bill to details and many more fields. Apart from this one of our client has requested to print QR Code which includes different details like item number, Qty etc.… Read More »

Sage 300 – Custom Report for Order Delivery Status

In this blog we are going to discuss the custom report i.e. “Order Delivery Status Report” we have developed for one of our customers. The report will list the OE Orders – Shipments with status as “Late Delivered” or “On-Time Delivered”. New Stuff: Custom Utility to keep order invoice record with optional field The user… Read More »

Sage 300 2018 Release – Create POs from OE with provision to Copy Comments and Optional Fields

Sage 300 ERP 2018 is available now. With the release of Sage 300 ERP 2018, we are pleased to announce the release of our “Create POs from OE with Copy Comments and Optional Fields” customization in Sage 300 v2018. This customization is an enhancement in a standard “Create Pos from OE” functionality which provides additional feature… Read More »

Manage Bulk Shipments in a Click with Sage 300 Quick Shipment Component

Delivering bulk shipments on time is one of the most crucial aspects for organizations across industries. There are a number of the tedious and time-consuming task involved to ensure that all the orders are processed and delivered accurately on time. To simplify the shipment tasks of organizations and efficiently manage the costs while exceeding customer… Read More »

Troubleshoot: “Error. Failed to create landlord database tables” in Sage 300 Web Screens.

In the new version of Sage 300, we have been introduced to the web screens. Sage 300 ERP will now be called as Sage 300c ERP which now will be used on cloud that will make it easier to access from the web. As this is a newly introduced concept, there are chances that we… Read More »

New release of Greytrix Document Attachment for Sage 300 ERP

We are glad to announce a new release (with a complete makeover) of our Greytrix Document Attachment solution for Sage (Accpac) 300 ERP v5.6 & 6.0. Download Trial v6.0 | Download User Guide Let’s see its features and whats new. Product Features of Document Attachment for Sage 300 ERP Allows you to attach scanned documents/reports/Fax/images to… Read More »

Adding columns to the detail grid of Transaction Screens in Sage 300

You must be wondering why one has to write a blog on this topic specifically when Sage has a powerful and easy to use Optional field’s module which not only captures custom information on Maintenance and Transaction Screen but also Tracks the information from Originating document through GL and not to forget the capability of… Read More »

How to programmatically get List of Companies from the Accpac system

Almost every integration that we do between Sage Accpac ERP and 3rd Party Product, on our setup screen we have to display the list of all Accpac companies so that our connector knows which Accpac companies data is getting integrated with the 3rd party Product. If you are also writing something like this and need… Read More »