Category Archives: Sage 300

IC Lot/Serial Transaction Report in SAGE 300

In our last posts we had discussed most of the Lot/Serial Number List and Lot/Serial Stock reports in Sage 300. Similarly IC Serial Transaction Report  is used to know the details about the transactions performed for a particular lot/Serial Number. This report gives the details of the Lot/Serial locations, availability, transaction types and source applications.… Read More »

AR ledger Report

In Sage300 ERP, Once the transaction is completed on the order entry screen and the day end process is conducted, the transaction is then shown on the AR invoice screen. Moreover, a batch is generated with the GL account. Nevertheless, the item description and comments from the order entry screen do not appear on the… Read More »

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 »

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 »

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 »

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 »