Accounting Journal Complex Relation

[Fei Long]

Hi,

I am having problem with some relationship problem. I am making a simple accounting ledger and journal transaction. Below is the problem I faced

Journal Entry Page

I've relate Debit & Credit Field to 1 code only. If I get rid the Credit relation it works. If I put in, it doesn't work.

General Ledger Table

Should show the transaction but with the description as RENTAL FROM H form. How Do I do that ?

H Form

Should show as credit $100 and description as agency fees.

Any help is highly appreciated. Thanks in advance.

journal.zip

Edited October 27, 2005 by Guest

[aaa]

I think that your Journal Entry Page must have only one Amount field.Debit and Credit accounts shows where to debit and from where to credit. Such your all transactions will be in two records. Last time i did it in V5 and it was work.I think that your transactions must have fields:

Date

Debit_Account

Credit_Account

Amount

Note

After your work will be easy.

Edited October 27, 2005 by Guest

[Fei Long]

I am using 2 seperate amount. 1 for debit$ and 1 for credit $

But still not working.

[Fei Long]

Anyone can help me on this ? Thanks in advance.

[SlimJim]

Hi. I have looked at your sample. I am not absolutely sure what you want here but it looks as if you are trying to define a single field to lookup from more than one table and you will need a calculated auto-entry for that. I have made some minor alterations to your file including defining a new field amalgamating the Debit and credit - purely to allow an OR relationship between Debit and Credit codes.

Is this the direction you wish to go?

journal.zip

[Fei Long]

Thanks SlimJim.

That is what I need. But when you click on the General Ledger Table under the record A0030 Agency Fees, I need it to show RENTAL OF PREMIS A01 and LAND SALE. How do I do it? ;)

[SlimJim]

The immediate problem is that in your ledger table you have only two fields: ACC CODE and DESC in order to relate to Journal items you need to go through ACC CODE but a number of Journal Items do not have an Account Code, namely the ones coming via the H-FORM table. They have an Hcode but no ACC CODE, Draw a diagram of the dependencies between Ledgers, Journals, Forms and Items