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 »
As the pictures are more descriptive than that of an appropriate name for a thing, same goes with inventory items also. Many company follows certain nomenclature or terminologies e.g. in Sage 300’s terms we use “Item Structure codes” to number the item so that this number itself will well describe the inventory item. But there… Read More »
As per industry practices, different organizations follow different procedures related to project costing. These procedures are based on certain rules and the types of project and contract norms. In this blog we are going to discuss about one of the option provided in Sage 300 by using which organization will be able to get the… Read More »
While trying to login to Sage 300 ERP application or accessing any Sage 300 Company, users may encounter an error such as “Cannot access database (error=49153). See Help for more information” New Stuff: – Project Job Costing – Project Style option in Contract Maintenance In this blog we are going to discuss about the solution… Read More »
The use of Sage 300 Advantage API is increasing day by day and there is an ample requirement of the integrations, import, export that uses it. Developers are now making maximum use of Advantage API compared to COMAPI and XAPI for external programs. XAPI requires separate licenses so end user tries to avoid an additional… Read More »
In Sage 300 we can set prefix and length of any document number as per our preference or change it whenever we need. ln this blog we will see how we can set or change prefix,length and next number of OE document numbers in sage 300 v 2020. New Stuff: Attempted to read or write… Read More »
In Sage 300 ERP, we use the O/E Order Entry screen to enter, edit, and post quotes and orders, including active, standing, and future orders. In the O/E Order Entry screen, you specify the order details required to enter and complete the transaction. You can also review information about any shipments and invoices generated from… Read More »
In Sage 300 ERP, we use the O/E Invoice Entry screen to enter and post invoices, print receipts (for prepayments) and invoices immediately after posting. We use the Invoice tab to specify general information about the invoice, add and edit detail lines for items and miscellaneous charges on the details table and specify Tax details… Read More »
OE Invoice in Sage 300 Erp, is a confirmation document that is sent to the customers before delivering of the goods or services. Sales Invoice on the other hand can be created once the customer accepts the quote. Sage 300 ERP (Sage Accpac ERP) provides users to print the OE Invoice document through the OE Invoice Form. But… Read More »
Till now we are very much familiar with our product GST in Sage 300 ERP. There is one more feature added in our module GST i.e. E-Way Bill (Electronic Way Bill). Before proceeding with the functionality of the feature in GST, let us get some simple aspects cleared that will help in understanding e-Way Bill… Read More »
