ERP Realm

ERP Realm is an online consulting company specilized in providing SAP solutions to meet your business requirements.
Contact Us
Rejection lines displayed in VF04
SAP

Reason for rejection key in sales documents are actually configurable key and business transactions are controlled based on the setup. Some times items rejected in sales documents may be visible in reports like billing due list. This is not a system error because the behavior is controlled by configuration.

Read more

Tag VF04

Reason for Rejection in Sales documents
SAP

Reason for rejection in sales documents are being used to identify items that are to be processed separately. Behavior of items marked with reason for rejection as processed differently in sales module which is controlled by configuration. 

Read more

Tag Reason for Rejection ,VF04 , DP91

Defaulting Profit center in Sales Documents
SAP

Assignment of profit center in sales document is mandatory if the revenue analysis is based on profit centers. There are multiple ways by which profit center can be defaulted in sales order line items. This blog explains how profit center can be defaulted in sales documents (Quotation , Sales order ) based on substitution.

 

Read more

Tag Default Profit center , OKEL , OKEM

IRR Calculation using Python Code
Python

IRR is an important gauging factor for comparing periodic investment return. IRR is difficult to calculate manually. This blog provides a sample code for calculating IRR using Python.

Read more

Tag IRR calcuation

Transport Organizer Tools and details
SAP

SE01 / SE10 /  SCC1  are frequently used t codes used for organizing transport request and performing copy of transports within clients. Most of the time consultants get into difficult times finding specific transport requests. Transport organizer tools help is searching transport requests effectively and easily.

Read more

Tag Transport Organizer , SE01,SCC1

Understanding IRR Calculation Logic
Equity

Undertanding returns on any investment is a key skill required by any investor. There are many mathematical formula available for calculating the returns. But do we use it correctly and wisely ? 

AAGR , IRR , NAR , XIRR..

Read more

Tag XIRR , IRR , MF Return

External Numbering of Batch Master
SAP

Batch generated using Goods movement transactions can be assigned to a internal number or an external number  or entered manually during document creation.

Internal and external numbering is controlled by configuration. Separate number ranges can be maintained for internal and external numbering.

Read more

Tag Batch Master Numbering , External Numbering

Option for defaulting delivery address in purchasing Documents
SAP

Delivery address in purchase orders are defaulted form Plant / Storage location or Plant address if storage location data is not available. But business requirement may be such that items are delivered to different delivery address. Various standard and enhancement options will be discussed in this document.

Read more

Tag Default Delivery address , Delivery address in PO

Profit Center in Billing Document
SAP

This documentation briefly explains how profit centers are determined / defaulted in sales billing document. Profit centers in billing documents are generally derived from the sales documents , but as per business requirements the determination process can be altered.

Read more

Tag VF01 , Profit Center , Default

Version 0 is blocked for fiscal year XXXX
SAP

Message Area : GP 

Number           : 626

Read more

Tag Version locked , OKEQ

Default Account Assignment in Purchasing Documents
SAP

Account Assignment :  Cost element and Cost Object is a mandatory entry in purchasing documents for non stock items. Eventhough its a manual entry standard SAP provides few options for defaulting account assignment based on business rules.

This blog explains the various options available for defaulting account assignment in purchasing documents.

Read more

Tag Default Cost Center , Default Order,OKB9

Status Profile assignment - SAP PS
SAP

Status Profile are additional status control which can be assigned to PS objects like Project definition , WBS , Networks. These additional user status provide better control in addition to standard controls.

Eg : A particular WBS should be released but no procurement document should be created against the WBS. In such cases status profiles become handy.

The option for changing the status can be additional controlled used authorization object assigned for the status..

Read more

Tag Status Profile

Backup and Restore MySQL DB
My_SQL

Database backup and restore is one of the main database mangement operations. With advent of various tools online and automatic backup provided by different hosting companies , the need for manually running a back is obviated. 

Nevertheless there might me some times when we need to backup and restore a database. This process is also useful when a copy of the database is required (with Data and Schema).

mysqldump is a standard tool available with mysql which can do this for us in a jiffy.

Read more

Tag mysqldump , Backup , Restore

Default PR price as PO price
SAP

Business scenario's may warrant defaulting Purchase requisition price in the purchase order. Since this is a very common business requirement , SAP has provided various standard solution. But caution should be exercised when such configuration changes are implemented. This blog explains the various standard and enhancement options available to achieve this requirement. 

Read more

Tag Copy PR price to PO, PO price derivation

Invoice Splitting in Billing Document and Collective Billing
SAP

Invoice split is a process by which  Sales billing documents are split based on some predefined criteria.  This blog explains the basics of Invoice document splitting.

 

Read more

Tag Invoice Split , Billing Document , VBRK

Relative and Absolute import for beginners
Django

Python beginners would have noticied the first line in the python script page or *.py . Its always a Import or From.

Though we would have just copied it from templates or sample codes and started using in our programs , the reality hits us when there is a error message. Most of the time we would get a module not found error. The issue would become more complicated when multiple imports are used.

This document will help you understand the system logic at a higher level which can help you solve the problems. For detailed documentation refer to our reference session for links.

Read more

Tag Import , Relative , Absolute