Category Archives: Sage 300

Document Numbering customization on Purchase Order Entry based on Item Types

In Sage300 ERP Document Numbering is a module that assists us in assigning numbers to needed transactions. This module generates document numbers automatically based on the segment structures provided in the masters. In this blog we are going to discuss about PO Numbering based on item types which is custom drop down added on the… Read More: Document Numbering customization on Purchase Order Entry based on Item… »

Enhance O/E Sales History Detail Screen with Additional Columns

Customizing the O/E Sales History Detail screen in Sage 300 to include additional columns that provide more details about specific Items is a great initiative. This modification has the potential to significantly improve the system’s usability and data reporting features. By adding extra columns, you can capture relevant information about the items, making it easier… Read More: Enhance O/E Sales History Detail Screen with Additional Columns »

Customized AR Customer Transaction Report to show ‘Days’ difference between Transactions

Transaction is a communication between Customer and Vendor to exchange goods or payments. User’s can get to see all the transactions of a customer in a single report (AR Customer Transaction Report) whether it is an invoice or credit note or debit note or any other transaction in Sage 300 ERP.Standard AR Customer Transaction Report… Read More: Customized AR Customer Transaction Report to show ‘Days’ difference between… »

API for Serial Number Status Inquiry

Serial numbering is a system of distinct identifiers assigned to individual items within a batch or group of products. Even if multiple items share the same lot number, serial numbers set them apart from each other, ensuring uniqueness. Each serial number corresponds to a single product, establishing a one-to-one relationship, and no two products can… Read More: API for Serial Number Status Inquiry »

An Enhancement of Manual TDS Entry

In Sage 300 ERP, we are familiar with Tax Deduction at Source (TDS) and its intended function. The system automatically deducts TDS during the document posting process. However, there are instances where users might overlook deducting TDS for certain documents. When the posting process is already completed, users may encounter challenges in retroactively deducting TDS… Read More: An Enhancement of Manual TDS Entry »

Unit Cost Restriction in Three Way PO Matching Module

In Sage 300 ERP, we have an Add-on module, Three-way PO matching, which makes sure that a Purchase Order matches the Purchase Receipt in terms of how much and how many quantities were received. This system prevents users from accepting a receipt that says they got more quantities or cost than they were supposed to… Read More: Unit Cost Restriction in Three Way PO Matching Module »

Enhanced O/E Sales History Screen based on Items

In today’s era of data collection, users often encounter issues when the data doesn’t meet their specific requirements. Therefore, our primary goal with Sage300 ERP is to consistently deliver accurate data. While it’s true that retrieving data history for a particular year, period, customer, or item is readily available, we recognize that there is a… Read More: Enhanced O/E Sales History Screen based on Items »

Mailing open invoices to the customer

In Sage 300 ERP, an open invoice, also known as an unpaid invoice, is one that a vendor has sent to a client but has not yet received payment for. The customer adds the outstanding invoice to their aged accounts payable records up until it is paid. The conditions of the contract between the two… Read More: Mailing open invoices to the customer »

Auto Populate Updated Unit Price on OE Invoice Screen based on Contact Pricing in Sage 300

In Sage 300 ERP we all know the importance of OE Invoice screen and its purpose. If we are creating any Invoice entry by using order entry or shipment entry it is necessory to flow all the field deatils from order/shipment entry screen to invoice entry screen such as order number, shipment number,amounts, taxes, item… Read More: Auto Populate Updated Unit Price on OE Invoice Screen based… »