Revenue Accounting and Reporting Postings

[former_member456379]

Hi,

Is it possible in RAR to assign Contract/POB number in the Assignment Field of RAR Accounting Document.

Actually, RAR Postings for Deferred and Unbilled accounts is an aggregated postings based on different attributes e.g. profit center. We want to differentiate each posting as per COntract / POB number and want to assign the same in Assignment Field of Accounting Document.

Please suggest if there is a good practice to achieve it.

Thanks!

[former_member456379]

Hi Venkat,

Yes we have all SO items as POB and we do not create them manually. When we run the transfer and Liablity calculation transaction then table FARR_D_POSTING gets updated with G/L account, Org. Attributes, POB, Contract etc.

But the challenge we are facing in posting transaction, where all B/S accounts postings are aggregated at Org. Attributes(e.g. plant, profit center etc) and there is no reference to POB/Contract. In the same format these aggregated posting line items are transferred to accounting engine hence it is not possible to use substitution.

Moreover, there is a posting BADI but that also doesn't help because the posting line items fetched into this BADI does not include POB/Contract information hence cannot be populated 😞 ...

Correct me if I've misunderstood the above part.

Therefore, I am thinking to create a custom field (Contract - POB) at POB Level in the overview screen and get it populated automatically while POB creation. This will update all includes and tables in RAR including FARR_D_POSTING table. Means, custom field will be populated for all entries in table FARR_D_POSTING.

Enable aggregation based on custom field in IMG. Then use posting BADI that will pull custom field in the posting line item and copy the same in assignment field which will eventually be passed to accounting engine(ACCIT).

Please share your comments if you see any challenges or other way of achieving it 🙂

Br.

[rf_1791_b]

Hi Abhinay,

I have just read your idea posted in March 2018.

I am working in a project and we are in a similar situation like you were. Accounting department wishes to have the RA contract number in the field Assignment in FI.

Could you implement your idea?

If yes: Does it work as expected or are there any negative aspects as poor performance?

Br.

[rosemayfears2]

Hi Abhinay,

Did the workaround work for you?

I did the same , however, not all posting categories in the FARR_D_POSTING will have the custom field value since only like RV lines have POB ID, so only that entry's custom field is getting populated.

[former_member214674]

Hi Rose,

Yes it worked in two steps:

1. Created custom fields(SO & Line Item) for POB screen.

2. Enabled BADI to populate these custom fields in RAR posting transaction.

Br, Abhinay

[vijaymanikandan]

Hi

This is already available in the form of Sales Order and item in the relevant Accounting line item of the RAR A/C document. Assuming that you have all the SO items as POB and not create them manually in the RAR contract. In case if you want to get the POB number on the Assignment field in line item level that must be possible via the substitution. You can also get the POB number / contract for the respective A/C postings from the RAR tables.

Hope this helps.

Br,

Vijay V