how to get foreign currency in posted journal?

julkifli33

hi all, hiow to show FCY amount in GL Entry?
our LCY let say USD
for example i create journal in AUD 1000, (equals to 1200 USD)
in GL entry only capture this 1200 USD
how to get this 1000 AUD
thanks

ara3n

GL Entry only stores one more additional reporting currency. FCY only stored at subledgers. Vendor/customer /item ledger.

julkifli33

ara3n wrote:

GL Entry only stores one more additional reporting currency. FCY only stored at subledgers. Vendor/customer /item ledger.

i tried create and then post payment journal and cash receipt journal
yes amount FCY can be found in vendor and customer ledger entry
but how about general journal?
is it must customized?
if yes... what is the best way to do it?
is it modify the GL Entry
or create new table?
please advise
thanks

ara3n

It's a modification.
I would add two new columns to GL Entry. Other Currency Amount, Other Currency Code.

In CU 12 populate the fields.

julkifli33

ara3n wrote:

It's a modification.
I would add two new columns to GL Entry. Other Currency Amount, Other Currency Code.

In CU 12 populate the fields.

yes I already create 2 fields in GL entry
for currency factor and currency code
it is successfull if i post it from journal
i add code in InitGLEntry on CU 12
but if i post from sales invoice it only capture in the last line?
any idea how to add it? (for every lines in GL entry will capture currency code and currency factor)

julkifli33

what i want is... when i post from sales invoice or sales order ,
so it will be posted to GL entry (Currency Code & Currency factor)

ara3n

You'll have to modify CU 80, 22, and many others to populate the Gen journal line.

julkifli33

ara3n wrote:

You'll have to modify CU 80, 22, and many others to populate the Gen journal line.

do we neet to add foreign currency in table 254 (VAT Entry)?
i still cannot found , how they pull data for this GL Entry table

vijay_g

You need to go through over whole posting routine as where system creating entry for every tables has to put for your customized fields.

julkifli33

OKAY...
what i need is how to catch figure from sales invoice to gl entry
i need this currency code from sales header to go in gl entry
is it in CU 12 or CU 80?
please advice
i still cannot find it

vijay_g

In "Gen Jnl Line" from Sales Header in CU-80 (search // Post sales and VAT to G/L entries from posting buffer), and then from GenJnlLine to GLEntry in CU-12( function Initglentry() ).

julkifli33

vijay_g wrote:

In "Gen Jnl Line" from Sales Header in CU-80 (search // Post sales and VAT to G/L entries from posting buffer), and then from GenJnlLine to GLEntry in CU-12( function Initglentry() ).

still the same
creating 5 lines
but currency code and currency factor only stored at the last line only
here i give you the screen shot

vijay_g

Can you show your "sales line" screen shot before posting?

julkifli33

vijay_g wrote:

Can you show your "sales line" screen shot before posting?

Vijay.... actually i filter wrong document
it works
but if i want to store currency code it failed

this code,it success posting... but not stored Currency Code

GenJnlLine.Amount := InvPostingBuffer[1].Amount;
        GenJnlLine."Source Currency Code" := "Currency Code";
        //Mycode Start #1
        GenJnlLine."Currency Factor" := "Currency Factor";
        //Mycode End #1
        GenJnlLine."Source Currency Amount" := InvPostingBuffer[1]."Amount (ACY)";
        GenJnlLine.Correction := Correction;

but if i add for currency code like this,posting error

GenJnlLine.Amount := InvPostingBuffer[1].Amount;
        GenJnlLine."Source Currency Code" := "Currency Code";
        //Mycode Start #1
        GenJnlLine."Currency Code" := "Currency Code";
        GenJnlLine."Currency Factor" := "Currency Factor";
        //Mycode End #1
        GenJnlLine."Source Currency Amount" := InvPostingBuffer[1]."Amount (ACY)";

it will show me an error message when posting sales invoice
here i give the screen shot error
        GenJnlLine.Correction := Correction;

ara3n

I suggest to get a more experienced developer to help you with this mod. All you are doing is moving a field from journal to gl. So you shouldn't be getting consistency error. There is another post on how why you are getting consistency error.

julkifli33

ara3n wrote:

I suggest to get a more experienced developer to help you with this mod. All you are doing is moving a field from journal to gl. So you shouldn't be getting consistency error. There is another post on how why you are getting consistency error.

unfortunately i dont have another programmer

ara3n

step by step remove the modification you have to find out why you are getting consistancy. I'm guessing it's the mod that causes this.

As far as how to know where to add the code, I suggest to use Codecoverage. tools->debugger->CodeCoverage.

Turn it on. post a sales invoice. and stop the codecoverage. The click on code and remove all filer. Then filter it on a field on gen journal line. For example *GL Account No. *

you will see all the code and based on variable you can zoom online to see the object ID. You could add those fields to the code form itself.

Then set break points in those objects and turn on the debugger and see how the CU is called.

I'm sure you can get local solution center do a remote session to help you with this.

julkifli33

ara3n wrote:

step by step remove the modification you have to find out why you are getting consistancy. I'm guessing it's the mod that causes this.

As far as how to know where to add the code, I suggest to use Codecoverage. tools->debugger->CodeCoverage.

Turn it on. post a sales invoice. and stop the codecoverage. The click on code and remove all filer. Then filter it on a field on gen journal line. For example *GL Account No. *

you will see all the code and based on variable you can zoom online to see the object ID. You could add those fields to the code form itself.

Then set break points in those objects and turn on the debugger and see how the CU is called.

I'm sure you can get local solution center do a remote session to help you with this.

ok... this problem i already solved it
thanks for the share everyone