Transactions Details Optional Fields Report

By | June 7, 2014

In Sage 300 ERP we can create user specified optional fields at transaction as well as at Masters Level. Sage 300 ERP also offers the report named as Transaction Detail Optional Fields which displays the output as per the defined optional fields.

Below example will give you exact idea demonstrating how we can make the use of this report.

Let’s say in our organisation there are few employees who are using mobile SIM card provided by the organization.

New Stuff: Deleting Inactive records in sage 300 ERP

Now, if we need to track the expenses of each SIM card respectively, then one way is to create those employees who possess a SIM as vendors but if we use this method, then for each SIM, the charges be will needed to be raised as a separate entry for each employee. This will indeed increases extra entry overhead.

Other way is to create an optional field named as “COSTCENTER” (user defined) and add employee name in its value field as shown in below screen shot.

Optional field

Define the optional field in Account Payable Module>>>AP setup>>>optional field>>>Invoice details as shown in below screen shot.

AP Optional field

Now, suppose we have received the bill for the month of April 2014 of all the respective employees.

We will now book this expense first with help of AP invoice entry selecting SIM service provider as a vendor.

AP Invoice Entry

AP Invoice Entry

As you proceed with the AP invoice entry at the detail line level, we have an optional field column. When you click on it an additional window will pop-up which will allow you to select the employee name from the finder, provided the same is visible in the above screen shot.

Now, let us see how report will display the data. Navigate through the below path

General Ledger>>>G/L Reports>>>Trans. Details Optional Fields

Tran.optional field report

Select the expense account in the account range.

Trans.Optional field report output

When we refer to the output of the report we are able to see employee name and their respective SIM expenses.

In this way, we can track the employee expenses also please note in this blog we have taken employee as a reference for tracking expense. Same way we can use Department or location or Directors’ expense which ever cost centre that suits to organisation.

Adapting this practice will eliminate consumption of vendor master data.

About Us
Greytrix a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East.

For more details on Sage 300 and 300c Services, please contact us at We will be glad to assist you.