Author Archives: Greytrix

Error while opening the Sage 300 screens: Database is locked by another task.

As a Sage 300 user, encountering the “Database is locked by another task” this problem might cause substantial disruptions in your productivity. This error prohibits you from accessing or updating specific settings, which can be very aggravating when you’re attempting to make significant changes. New Stuff: Account-wise Income Statement Report Here’s a visual representation of… Read More »

Account-wise Income Statement Report

In Sage 300 ERP, An explanation of how the company’s realized net revenue is converted into net earnings (profit or loss) is provided by the income statement. Four essential items must be reported in order to do this: revenue, expenses, gains, and losses. Revenue can include Sales, rent revenue, Dividend revenue, Interest revenue, sales return,… Read More »

Sending Email using Microsoft Graph in Sage 300

Sage 300 is a renowned Enterprise Resource Planning (ERP) software that empowers businesses to efficiently manage key functions such as Inventory Management, General Ledger, Order Entry, and more. One of its standout features is the ability to send invoices and order details to customers with just a single click, ensuring prompt and accurate communication. This… Read More »

Installing Sage 300C Web extensions in Visual Studio

Sage 300C is the web version of Sage 300 ERP, allowing users to access their data through a web browser. In Sage 300C, we can create and customize web screens just like in the desktop application. Sage provides SDK for creating and customizing these web screens. New Stuff: Generate Numbering series on AR Recurring Entries… Read More »

Generate Numbering series on AR Recurring Entries using Document Numbering Add-on

In Sage 300 ERP, The money that clients owe a business for goods or services they have received but have not yet paid for is referred to as accounts receivable. For instance, the amount owed is added to the accounts receivable when clients purchase goods on credit. It’s a duty resulting from a commercial exchange.… Read More »

GL Sub Ledger Report

In Sage 300 ERP, In the GL Batch List Entry, both header and detail data are present; however, we are unable to find fields such as the Document Number, vendor/customer information, Remit-To/Ship-To details, and entry description for that specific transaction flow. Therefore, we created a report that shows the Document Number, vendor/customer, Remit-To/Ship-To, and Entry… Read More »

API for PW Requisition Entry Import

In Sage 300 ERP, In the PW module Requisition Entry, there is no option to import the entry. Therefore, we have developed an API that enables users to import the Requisition Entry and automatically select the Tax group based on the state of the ship to location and bill to location. New Stuff: – Adding… Read More »