IC Lot/Serial List Report

Inventory in any business consists of of goods or materials that a company maintains for sale or unprocessed supplies that a manufacturer holds for manufacturing. The management of inventory involves having the appropriate quantity of material or supply on hand to help reduce the loss of items or materials. Such preserved goods/materials are then turned… Read More: IC Lot/Serial List Report »

Restricting Order Posting for Zero Unit price or Order Subtotal

In Sage300 ERP Order is a commercial document given to the customers indicating Items, Unit Price, Type of order, quantities, and agreed prices for products or services. Order can be created with or without creating Quote first. In this blog we will discuss about the customization that we have done on Order Entry screen for… Read More: Restricting Order Posting for Zero Unit price or Order Subtotal »

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 »