F.05 fx.val. and archived documents

[former_member1036319]

Hello,

It is possible that with the fx. valuation with F.05 tr. (end month closing), also works with archived documents, (XARCH field)?

I mean, I have Archiving in the company and there are differences betwen BSEG and BKPF archived documents and the FBL3N with BSIS , because these differences are in a G/L account (172630 "Inventory bought back").

In FBL3N (select open items and Data Source = Database + Archive)--> I see items dated earlier than 01.01.2005 which are not considered by SAP for revaluation with F.05 tr.

F.05 must consider this archived documents (XARCH field = "x")

B. Regards

Francisco

[Former Member · Accepted solution]

Hi Francisco,

I don't think it is possible to revaluate the archieved documents, the only sloution I can see is retieve the archieved document, please see the below link:

http://help.sap.com/saphelp_nw2004s/helpdata/EN/8d/3e4fed462a11d189000000e8323d3a/content.htm

Thanks!!!

Murlidhar Khatri

[former_member1036319 · Accepted solution]

Hi Khatri,

I think so but the question is that the GLT0 table run with F.05 and I have LC, LC2 and LC3.

The company change the currency at the end of 2004 from TRN to TRY and in the GLT0 table I still see a balance in TRN.

I configure 2 steps with the 3 currencies. I think it is usual in F.05

And the problem is that I see this TRN amount (that I see in GLT0 from 2004) in the final F.05 result).

In step 2 I don´t flag the "Translate valuation difference" field in FASB 52 selection to try to exclude the TRN amount,..but I see this amount.

Must I modify the selection steps (variant with step 1 : for remeasurement, and step 2: for revaluation).

B. Regards

Francisco

[Former Member · Accepted solution]

Dear Francisco,

I think GLT0 is only a total table and system can not refer this table to revaluation purposes, it needs line item table because it sees in detail with date specificaiton and then accordingly it revaluates.

Hope this helps!

Murlidhar Khatri

[former_member1036319 · Accepted solution]

Hi Khatri,

This is what I think,

but if F.05 (SAPF100) run with tables:

tcurr, t001a,

t044a, t044b,

t001, t033, bsbw,

rfdt,

kna1, knb1,

lfa1, lfb1,

ska1, skat, skb1, ekko,

skc1c, "used for RFSBEW00

*skc1c, "#EC NEEDED

bkpf, bseg, bsid, *bsis,* bsik,bsed, bsec,

x001, t030h, t003, t030b, t009,t074,

• t030hb, t030u, (no called with FB

bhdgd, fimsg,

rfsdo, sscrfields,rfpdo3.

and GLT0 is in the type -pools,

and I check with developer that with my variant u20181171_STEP2_TESu2019 , (if you remember I have LC, LC2 and LC3 and 2 variants for valuation and revaluation), and it do read table GLT0. Basically it is called from two different points in SAPF100

SAPDBSDF à form UPDATE_YSKC1C, line 2892.

LF009FSC à form glt0_lesen, line 34.

And the company (1171) change from TRN curr. to TRY curr. in 2004--> if I check GLT0 I will see in 2005 the difference, that I see when I run the STEP2 variant in F.05

Table GLT0 (172630 account and Ledger GR "G/L trans.fig.Group valuation")--> as you can see the 459.476,66 (line 1) is that I see when I run the STEP2 in F.05

Ledger/Vers/Co Code/ F.Year/ Account Num./ Currency/ D/C /Period/ Transactn curr. Local currency Group currency

GR 001 1171 2005 0000172630 TRL S 016 0,00 0,00 459.476,66 GR 001 1171 2005 0000172630 TRY H 016 0,00 0,00 0,00

GR 001 1171 2005 0000172630 TRY S 016 0,00 0,00 0,00

GR 001 1171 2005 0000172630 USD H 016 0,00 0,00 459.476,66-

GR 001 1171 2006 0000172630 TRL S 016 0,00 0,00 459.476,66

GR 001 1171 2006 0000172630 TRY H 016 0,00 0,00 0,00

GR 001 1171 2006 0000172630 TRY S 016 5.554.152,98 0,00 12.644.329,74

GR 001 1171 2006 0000172630 USD H 016 9.039.102,19- 0,00 9.498.649,78-

GR 001 1171 2006 0000172630 USD S 016 0,00 0,00 0,00

GR 001 1171 2007 0000172630 TRL S 016 0,00 0,00 459.476,66

GR 001 1171 2007 0000172630 TRY H 016 0,00 0,00 0,00

GR 001 1171 2007 0000172630 TRY S 016 554.691,62 0,00 16.676.674,75

GR 001 1171 2007 0000172630 USD H 016 16.299.203,18- 0,00 16.775.880,94-

GR 001 1171 2007 0000172630 USD S 016 0,00 0,00 0,00

GR 001 1171 2008 0000172630 TRL S 016 0,00 0,00 459.476,66

GR 001 1171 2008 0000172630 TRY H 016 0,00 0,00 0,00

GR 001 1171 2008 0000172630 TRY S 016 423.526,32 0,00 17.996.377,10

GR 001 1171 2008 0000172630 USD H 016 17.737.634,13- 0,00 18.192.562,18-

GR 001 1171 2008 0000172630 USD S 016 0,00 0,00 0,00

GR 001 1171 2009 0000172630 TRL S 016 0,00 0,00 459.476,66

GR 001 1171 2009 0000172630 TRY H 016 0,00 0,00 0,00

GR 001 1171 2009 0000172630 TRY S 016 652.388,76 0,00 20.855.532,30

GR 001 1171 2009 0000172630 USD H 016 20.398.257,39- 0,00 20.843.898,09-

GR 001 1171 2009 0000172630 USD S 016 0,00 0,00 0,00

GR 001 1171 2010 0000172630 TRL S 016 0,00 0,00 459.476,66

GR 001 1171 2010 0000172630 TRY H 016 0,00 0,00 0,00

GR 001 1171 2010 0000172630 TRY S 016 913.692,14 0,00 147.345,51

GR 001 1171 2010 0000172630 USD H 016 3.633.807,68- 0,00 0,00

GR 001 1171 2010 0000172630 USD S 016 0,00 0,00 0,00

GR 001 1171 2011 0000172630 TRL S 016 0,00 0,00 459.476,66

GR 001 1171 2011 0000172630 TRY H 016 0,00 0,00 0,00

Then I have two possibilities:

1. When I run STEP2 (revaluation) in F.05 the system give me GLT0 balance (account 172630)--> 459.476,66

2. When I run STEP2 (revaluation) in F.05 the system give me the total items archived until 2005 = 459.476,66

This is because I was asking for the archiving documents in the F.05 execution.

B.Regards

Francisco

[former_member1036319 · Accepted solution]

Hi Khatri,

This is what I think,

but if F.05 (SAPF100) run with tables:

tcurr, t001a,

t044a, t044b,

t001, t033, bsbw,

rfdt,

kna1, knb1,

lfa1, lfb1,

ska1, skat, skb1, ekko,

skc1c, "used for RFSBEW00

*skc1c, "#EC NEEDED

bkpf, bseg, bsid, *bsis,* bsik,bsed, bsec,

x001, t030h, t003, t030b, t009,t074,

• t030hb, t030u, (no called with FB

bhdgd, fimsg,

rfsdo, sscrfields,rfpdo3.

and GLT0 is in the type -pools,

and I check with developer that with my variant u20181171_STEP2_TESu2019 , (if you remember I have LC, LC2 and LC3 and 2 variants for valuation and revaluation), and it do read table GLT0. Basically it is called from two different points in SAPF100

SAPDBSDF à form UPDATE_YSKC1C, line 2892.

LF009FSC à form glt0_lesen, line 34.

And the company (1171) change from TRN curr. to TRY curr. in 2004--> if I check GLT0 I will see in 2005 the difference, that I see when I run the STEP2 variant in F.05

Table GLT0 (172630 account and Ledger GR "G/L trans.fig.Group valuation")--> as you can see the 459.476,66 (line 1) is that I see when I run the STEP2 in F.05

Ledger/Vers/Co Code/ F.Year/ Account Num./ Currency/ D/C /Period/ Transactn curr. Local currency Group currency

GR 001 1171 2005 0000172630 TRL S 016 0,00 0,00 459.476,66 GR 001 1171 2005 0000172630 TRY H 016 0,00 0,00 0,00

GR 001 1171 2005 0000172630 TRY S 016 0,00 0,00 0,00

GR 001 1171 2005 0000172630 USD H 016 0,00 0,00 459.476,66-

GR 001 1171 2006 0000172630 TRL S 016 0,00 0,00 459.476,66

GR 001 1171 2006 0000172630 TRY H 016 0,00 0,00 0,00

Then I have two possibilities:

1. When I run STEP2 (revaluation) in F.05 the system give me GLT0 balance (account 172630)--> 459.476,66

2. When I run STEP2 (revaluation) in F.05 the system give me the total items archived until 2005 = 459.476,66

This is because I was asking for the archiving documents in the F.05 execution.

B.Regards

Francisco

[former_member1036319 · Accepted solution]

Hi again Khatri,

I think that it might be more complicated that to retry these documents (from 2003 and 2004) with this balance in GLT0.

For this company I have 3 curr. types (transactional curr, local curr. and group currency) and I have the balance (total) ONLY in LC3 in GLT0 table, (and in ledger GR "G/L trans.fig.Grp.valuation").

If I retrieve this files from archiving and balance the total amount, with this post I will have also postings in LC and LC2, besides in the currency group (LC3), so I could clear the balance in LC3 but NOW I will have balance in LC and LC2, (GLT0).

Don´t you thing so?

Thanks

Francisco

[former_member1036319]

done

[Former Member]

Hello

Normally open items are not archiving, please check is there any open items archived

if not there is no question about caluclation of forex gain and loss

Thanks

Kameshwar Rao

[former_member1036319]

Hi,

Yes but I think from the currency change in 2004 we have archived documents (and these are open items).

Then if F.05 reads from BSIS, it is reading also from open items archived.

The other possibility is that F.05 reads from the Gruop curr. amount when I run STEP2 in F.05.

You can see the GLT0 result in the previous mail to Khatri

B.Regards

Francisco