Macro is a scripting utility and framework that is delivered as a built-in feature of Sage 300. Using Macros, you can customize the system, modify screens, schedule reports to run automatically, connect Sage 300 with external applications, and so many other workflow modifications. New Stuff: Sage 300 Desktop Lock Here are some common examples of Macros… Read More »
Custom report locks the sage desktop when the report is in open mode and sage desktop will remain locked until we close the custom report. Please find the below example. New Stuff: AR Aged Statement Customized Report 1. Open Sage 300 and select a folder (either existing or new custom folder), right click and select “new… Read More »
Recently we had a chance to work on the AR Aged Trial Balance Report for one of our client. This report resides in Sage 300 under Account Receivable Module => A/R Transaction Reports => Aged Trial Balance. Aged Trial Balance report list accounts receivable with outstanding balance by age buckets (30\60\90 days etc.). This report… Read More »
Sage 300 “Accounts Receivable” module provides the A/R Aged Trial Balance Report. This report internally provides various filtration criteria to generate report on the basis of Due Date, Document Date and overdue period etc. We have further customized “Aged Trial Balance” report for one of our client. In this blog we are going to discuss… Read More »
Sage 300 “Accounts Payable” module provides the A/P Aged Payable Report. This report internally provides various filtration criteria to generate report on the basis of Due Date, Document Date and overdue period etc. We have further customized “Aged Payable” report for one of our client. In this blog we are going to discuss about this… Read More »
Macro can be used as powerful technique for various Sage 300 customization. It can be use to create your own screens that interact with particular business logic and perform the required custom tasks. In this blog we are going to discuss about how the macros can be dealt with in case of Sage 300 upgrades.… Read More »
Mainly the Sage 300 customization are done using OCX, VBA Macros and the executable. In this blog we are going to discuss what the differences in these two approaches are. New Stuff: IC Reorder Quantity in Sage 300 Below listed are the differences between customization approaches using OEX and MACROS: As the customization using OCX is… Read More »
The reorder quantity is the level of inventory which triggers an action to replenish that particular inventory stock. It is a minimum quantity of inventory of an item which a company holds in stock, such that, when the stock falls to this quantity, the item must be reordered. We can set up reorder information (maximum, minimum, reorder,… Read More »
In this blog, we are going to describe the process to generate the GL Batch Entry from AR Invoice Entry in Sage 300. New Stuff: Open Order Report To access the invoice batch list screen go to Sage 300 ERP desktop–>Account Receivable–>AR Transactions–>AR Invoice Entry screen. In below example invoice batch 41 is created from invoice… Read More »
Sale Order is a commercial document provided to the customer by company indicating types, quantities, and agreed prices for products or services. The Sales Order can be created by using quote or without quote. In some situation we want to know the sales order details which are open sales order. By using our Open Order… Read More »
