Tag Archives: Optional field

Custom Utility to keep order invoice record with optional field

Use the O/E Invoice Entry screen to enter prepayments, and to enter, post, print, and export invoices. On the O/E Invoice Entry screen, you can: Enter and post invoices Enter prepayments for invoices Export invoices Print receipts (for prepayments) and invoices immediately after posting If you use Payment Processing, process or void a credit card… Read More »


There are many benefit/advantage in implementing Enterprise Resource Planning (ERP) software namely productivity, increase in efficiency costing and automating business processes.  However, businesses vary and many times client requirements will be complicated So, Today in the blog we will discuss how we can store huge information at the time of creating Entries? With the help… Read More »

Document Numbering feature for “Create PO from OE”

We have seen in our previous blogs on Document Numbering wherein the document number is generated based on Location, Account, Optional Field and bank code for transactional screen of PO, OE, IC, and AP Module. In this blog, we will see how you can configure document numbering module so that it will generate the Document… Read More »

Optional field Validation on Order Entry Screen

Sage 300 helps customers make Order Entry transactions against a particular customer, giving flexibility, compatibility and proper ordering process in an organization for sales functionality. This can help the management to get immediate information of accounting & inventory transactions of the sales team for improving their productivity. User can make an Order Entry transactions against… Read More »

Get custom field information in Sage 300 ERP reports using sub reports

In this blog post, we will talk about the advantage of using sub reports to show custom field values on Sage 300 ERP reports. There are scenarios where we customize standard “dll” type (datapipe) reports in which it is not possible to add any new tables to get additional information on to the reports. In… Read More »

Update or Insert Optional field value on posted entries in SAGE 300 ERP

End users of SAGE 300 ERP often worry about maintaining the transactional numbers (C-Form, D-Form, F-Form) which they get from government on completing the process of posting invoices. We have come up with a solution that addresses the issue. The concept of ‘Optional field’ is commonly known to Sage 300 users. For maintaining these kinds… Read More »

Propagating Optional Field Value from Posted AR Invoice into GL Entry in Sage 300 ERP

Many a times, Sage 300 (formerly known as Sage Accpac ERP) User come across a situation, where they want to propagate the optional field value directly from an entry (Invoice, payment….) to GL Entry after posting the same. Let’s take an example of AR Module to know how optional fields get propagate to GL Entry.… Read More »