Importance of Using Optional Field in Sage ACCPAC ERP

It is very useful tool to use optional field in Sage ACCPAC ERP. It is important to create different type of MIS reports.

You can create 7 type of fields using Optional Filed

Text: It will allow user to put test type of Optional Field.

Example:

ABC Company operate their business in different state of United States.  Management wants to track all sales record and also segment state wise revenue. For this System Admin can create list States optional filed where all states name of USA will be listed like

• Alabama
• Alaska
• Arizona
• Arkansas

Now during creating Customer in Accounts Receivable Module respective state name can be tagged which will flag the customer from the particular state. During creating any kind of Shipment/ Invoice this state name will be tagged along with the Customer name. And this is how Report writer will be able to produce any kind of report related with the Invoice/Shipment (Outcome: Revenue/Return/COGS) Amount: You can input amount. For example The customer who are from Arizona will get $500 discount beside the regular discount. It will help developer to customize the transaction. To get automated result you may need to know how to build macro. I will write a blog on Macro soon. But if you need help, please comment below so that I can help you. Other than the stated type, you can also create the following type of optional fields according to business need Number: Integer Yes/No Date Time You will get more topic about ERP. Please visit http://businessguru24.com Important Note: 1.      Maximum length is given 60, but you need to be careful what length you will use. Because More length more DB Size. If you have a list which is not more than 99, you can select 2 as length, if its less than 999, you can use 3 2.      Optional filed can be use on header level and transaction level. You have to customize your system as per your need. If the optional field impact the document, you can use it on header level and just one time. On the other hand if it have impact on every line of the transaction, you have to use it on transaction level. Header level optional fields require less DB Space than Transaction level/ Line Level.

What is ERP?

Business have to deal with lot of data across the company. Generally Mid to large scale type organization appoint many people to perform different task to run the business. Those people work in different department like

Accounts Department

Marketing department

Production Department

Selling Department

Logistic Department

Supply Chain management Department

Enterprise resource planning (ERP) is one kind of Powerful Business management software which can collect, store and manage data across the company and reduce redundant data entry. It is an integrated business solution that can share data across different department as per user Access and authentication.

You will get more topic about ERP. Please visit http://businessguru24.com

Example:

ABC is a pharmaceutical Company that basically manufacture and sale Medicine. To manufacture medicine the production department can pull all historical data from the system and assume how much quantity of finished goods need to be produced. After   measuring the quantity they can   check the availability of the Inventory. If there is sufficient quantity of raw material, manager can go for production otherwise he can request to procurement manager for procure raw material. After starting production, marketing and selling manager can know that is the current state? What is WIP? What is the Pipeline so he can set his marketing and selling plan accordingly.  
  

After Production all finished goods sent to warehouse. Selling department sell or transfer the product from the warehouse so management can understand the real-time stock position and sales status. Accounts department can calculate Cash and credit and aging of credit Which are very helpful tool control business.   

Conclusion: ERP is a management software where business user gets data from a single source he help the business more efficiently.