Actual Column In S_ALR_87013558 showing doubled amount after Partial Settle

[Former Member]

Dear Experts,

When I am executing S_ALR_87013558 report, actual column is showing double amount exactly of settlement amount.

If I wll create PO - Rs.100/-

Then GRN of Rs. 100/-

Automatic Settlement :- Rs.100/-

Asset creation through AS1

Partial Settlement :- Rs. 100/(AUC to FXA)

When I am checking S_ALR_87013558 report after partial settlement system is showing exactly double amount i.e.(100+100) i.e.200/-

Please suggest solution.

Thanks & Regards,

Amey

[Former Member]

HI,

What are the correponding entries in CJI3? Two separate line items "+100" rupees cost (as per the example) ?

Give the details (of each line item by double clicking) like "Source of Cost" & "Debit / Credit Entries" etc..

--

Meanwhile try running "CJEN" & check.

regards

[Former Member]

Hi Kirsap,

Thanks for your reply.

In CJI3,

There three entries showing

+100 (For GRN)

-100 (WBS to AUC) Transfer amount from WBS to AUC

+100 (AUC to FXA)Transfer amount from AUC to FXA

I had already tried CJEN & CJBN.

There is no effect of this.

Thanks & Regards,

Amey

[Former Member]

HI,

Ok. As your CJI3 is showing a positive value towards settlement to FXA, "CJEN" will not work.

Check the settlement document to FXA for accounting entries. Ideally they should be "75" Credit Asset for your AUC & "70" Debit Asset for your FXA, with no impact on your WBSE (there should be no line item in CJI3 for this).

Also check the same with your FI consultant also.

regards

[Former Member]

Hi Kirsap,

I have checked accounting document in CJI3 by double clicking on FXA entries.

Its showing 100- (75credit asset ) & +100 (70 debit asset)

as per you its correct,

but its still impacting on WBS & showing double amount in s_alr_87013558.

Please suggect.

Arvind tirlotkar.

[Former Member]

Hi,

Yeah, the same thing needs to be checked with your FI consultant.

Meanwhile, to help, give me details of the third entry in CJI3 (+100 to FXA) as mentioned below.

-- Cost Element reference (is it the same material consumption Cost Element or is it the settlement cost element)

-- debit / credit indicator (this should be debit in your case) & debit type

-- Business Transaction

-- Offsetting Account Details

regards

[former_member203108]

Dear, the asset G/L account of this entry "+100 (70 debit asset)" has cost element that is why it is debiting the WBSE again. It would be statistical cost element. Talk to your FICO consultant to delete the Cost element.

Edited by: Mohamed Rafi on Feb 23, 2011 5:01 PM

[Former Member]

Dear Kirsap,

There are Three costelement

Material cosumption :- 59000002

Statistical Cost element :- 20950004

settlement cost element :- 20050001 (For FXA)

D/C indicator :- D

Debit Type :- may be 70

Buisness Transction :- CJ88

Offset accounting Detail :- No offset account configures.

Thanks Regards

[Former Member]

Dear Mohammed,

Thanks for your reply,

But if iwll tell him to delet statistical cost element, it wll effect other buisness may be Balance sheet account.

Thnak & Regards,

[former_member203108]

You get debit again because of this "20950004" statistical cost element. you should not have created cost element for this G/L that is why it is debiting WBS again.

[former_member203108]

If you dont want to delete statistical cost element then your reports wil show the entry, though it is statistical costs. Is it ok for you?

[Former Member]

Dear Mohammed,

I have discuss this with FI consultant,

As per him, 20950002 is GL account balance sheet GL account, its not cost element.

So its not able to delet.

Thanks & Regards

[former_member203108]

I am talking about this G/L"20950004" not 20950002. and you have already confirmed that there is a statistical cost element created for that G/L 20950004. I am not asking you to deleted the G/L . I am asking you to delete only cost elemet not G/L.

[Former Member]

Sorry mistakenly i typed 20950002.

As per FI consultant 20950004 is Balancing GL code & its doesn't have cost element group.

Thanks & Regards

[former_member203108]

not cost element group. goto KA03 and input the "20950004". tell me what it shows.

[Former Member]

Hi sir,

If I am checking 20950004 in KA03

System showing message "Cost element 20950004 does not exist in controlling area 1001"

Thanks & Regards

[former_member203108]

here you said it is statistical cost element. how?

Dear Kirsap,
There are Three costelement 
Material cosumption :- 59000002
 Statistical Cost element :- 20950004
 settlement cost element :- 20050001 (For FXA)
 D/C indicator :- D
 Debit Type :- may be 70
 Buisness Transction :- CJ88
 Offset accounting Detail :- No offset account configures.

[Former Member]

After discussion with FI cosulantant I know that this is not Cost element its only GL.

I was wrong. 20950004 is only GL.

[former_member203108]

Thanks for your reply.
 In CJI3,
 There three entries showing
 +100 (For GRN)
 -100 (WBS to AUC) Transfer amount from WBS to AUC
 +100 (AUC to FXA)Transfer amount from AUC to FXA
 I had already tried CJEN & CJBN.
 There is no effect of this.

Run CJI3 again, and I want cost element, value type against each entry of above.

[Former Member]

Dear Mohammed,

I check KA03 for 20950004, system is howing messgae " Cost elmenet 20950004 is doesn't exist in controlling area 1001"

Thanks & Regards.

[former_member203108]

Reply my last question.

You said you have seen 3 line items in CJI3, which I have quoted in last reply. I want the cost element number and value type for those entries in CJI3. let me know.