Field "Order" in FAGLL03 Transaction

[Former Member]

Hi,

I am executing the FAGLL03 Transaction and I want the report to show the field "order". I modified the layout so it appears but the column is empty. Do you know how can I solve this? I thought I could go to Options --> Special Fields but the table RFPOSXEXT is not allowed so I am afraid it could be a problem related to some notes. Can you help me?

Thanks

[Former Member]

Hi Miguel,

Please try include field in the line layout using SPRO.

The menu path: ...General Ledger Accounting>Line Items>Display Line Items>Define Special Fields for Finding and Sorting Data

[former_member192833]

Hi Luis,

Please share the screen shot of both Document & report . Normally this will not happen , If there is an entry in field ORDER and when u add in layout it will display.'

Regards

Atul

[Former Member]

Dear Luis,

Do you have scenario like I have shown in screen shot ?

Thank you.

Regards,

Pankaj Bhalerao.

[Former Member]

Yes, very similar in FB03 with the difference that I´m using a Group 6 account, so I have a Cost Center instead a Profit one. But in FAGLL03 as I have said it doesn´t appear column "order filled".

I´m trying to upload my screenshots but the system doesn´t allow me. I don´t konwo why.

Thank you

[iklovski]

Try it with Mozilla browser. But, all this sounds very strange. If you are 100% sure that the information is in the document and it's not shown in FBL3N (the field is empty), then contact OSS.

[subhadeep_das]

Hello,

Pls run  FBL3N and add Order field from the layout and check if the data is appearing. It it appears here and is not appearing in FAGLL03 then you might have to raise a query with your support team to check the inconsistency.

best regds

Subha

[Former Member]

It doesn´t appear in FBL3N neither

[iklovski]

Do you mean that you see 'Order' field in FBL3N, but the content is empty? In this case, I would really like to see the screenshot of the document, which has internal order.

[ajaycwa1981]

Hi

There is a Config in New GL, whereby you need to add the field ZZAUFNR into the Totals Table FAGLFLEXT... I am not infront of the system, so cant give you the exact IMG Path, but the IMG node is something like "Adding Fields to Totals Table"

Once you do this, the field is populated and should be visible updated in your Std reports

Br. Ajay M

[ajaycwa1981]

May be it is

T code FAGL_GINS... Enter the TOTALS table as FAGLFLEXT > Click on the Pencil icon > Then Press F4 in next screen > Choose Additional Fields and Choose ZZAUFNR

Br. Ajay M

[Former Member]

Hi,

Thank you for your answer. I have tried to do so, but when I save the field the systems tells me that I need to be a programmer to complete the process. I´ll ask a programmer to complete it and I´ll tell you if it finally worked.

[ajaycwa1981]

Hi

May be try it from SPRO.. I never got this error when I did this from SPRO

Br. Ajay M

[iklovski]

Hi Ajay,

These things are not connected: having I/O field in totals and having it in FAGLL03 report, which does not read the totals. The procedure that you have suggested will create a new dimension in NGL totals table. FAGLL03 is reading I/O from detailed-level tables.

Regards,

Eli

[ajaycwa1981]

Hi Eli

These are 2 things. One is adding zzaufnr to totals table. And you can also assign customer fields to ledger in which the same field can be assigned . The later relates to line item table

But again, I don't have access to system. So...

Ajay M

[iklovski]

Of course. But displaying AUFNR in FAGLL03 (or FBL3N) does not require any of this.

[iklovski]

Hi,

In order to dipslay Internal order, no definition in Special fields is required: COBL-AUFNR is pre-defined in standard reports. As far as I'm aware, there is no recent OSS note, which would point to this problem. Can you post screenshots of FAGLL03 and FB03 for the document in question, showing that 'order' field is not filled in FAGLL03, but it is in FB03?

Regards,

Eli

[Former Member]

Hi,

I´m trying to attach both screen shots but there is an error telling me that content type is not allowed. I have checked the files and both are less than 1MB. Any idea why I cannnot upload the images?

[sridevi_p]

What is the kind of GL account that you are trying to pull out a report?  Hope it could collect costs on order.

[Former Member]

It is an expense account, group 6. Therefore it should accept costs on order.

[Former Member]

Hello Luis,

Is the order value filled in the document Line items. If Yes, it should appear in the "Order" column in the report.

Check whether the postings are happening on the Order.

BR

Amitash

[Former Member]

Yes, The value is filled in the document line items. But it does not appear in the "Order Column", I cannot guess why, it is the first time it happens to me.

[Former Member]

Dear Luis,

As far as I understand "Cost Object" ( in your case "Order" ) can ONLY be filled when your cost object is used while posting transaction and populated in respective columns.

Lets take an example of settlement when your Production Order is itself Cost Object - then GL account maintained against GBB-AUA in OBYC, production order will be Cost Object. Once you select "Order" in layout you can see "Production Order"  in the same column.

Please check whether you have used "Order" as cost object in your transaction postings.

Hope this will help you to understand functionality and solve your issue. Please get back to forum for further assistance.

Thank you.

FB03 - Where I have used Order as my cost object :

FAGLL03 : Where I have pulled in "Order" in Layout

Regards,

Pankaj Bhalerao.

[Former Member]

I really don´t understand completely what do you mean by Order as Cost Object. The account I am trying to get the report is an expenses account, group 6. When I create the documents I fill the Order Field ant the Cost Center Field wich I think it is my Cost Object.

Thank you for your answer