link b/w customer or vendor table with G/L entry table

mohamedkiyas

Good day to all,
I am having a field in G/L entry table "vendor or customer name " which should be populated when "G/L acccount name" field is given as Vendor or customer.
So here is my exact Question i need to know the link between customer Or Vendor table with G/L entry table. once it populated in G/L entry table it should also updated in customer ledger entry and vendor ledger entry..Any Guidance is really helpful and appreciable.

Thanks in advance

Yury

Mohamed,if you want just to have Cust/Vend Name viewed on the page, make a local functions for your page of G/L Entries:

LOCAL FindSourceName() : Text
IF "Source No." = '' THEN
  EXIT('');

CASE "Source Type" OF
  "Source Type"::Vendor: BEGIN
    Vendor.GET("Source No.");
    EXIT(Vendor.Name);
  END;
  "Source Type"::Customer: BEGIN
    Customer.GET("Source No.");
    EXIT(Customer.Name);
  END;
  "Source Type"::"Bank Account": BEGIN
    BankAccount.GET("Source No.");
    EXIT(BankAccount.Name);
  END;
    "Source Type"::"Fixed Asset": BEGIN
    FixedAsset.GET("Source No.");
    EXIT(FixedAsset.Description);
  END;
END;

If you want to fill your new created "Name" field in G/L Entry, make it during posting procedures, using, e.g. Event Subscription possibilities.

Yury

Hi, Mohamed
Use "Source Type"/"Source No." combination of "G/L Entry" to get a link.
Moreover, VLE and CLE are created before posting of Gen. Jnl. Line to GLE.

mohamedkiyas

Hi Yuri,

Thanks.
Yeah ,"Source Type/Source no." having customer and vendor details,but i need to populate the new field which i given in G/L entry table whether it is customer or vendor name.

lubost

Your approach is hard to understand, because Account Type and Balance Account Type. In my opinion you should rethink your model.

Yury

Mohamed,if you want just to have Cust/Vend Name viewed on the page, make a local functions for your page of G/L Entries:

LOCAL FindSourceName() : Text
IF "Source No." = '' THEN
  EXIT('');

CASE "Source Type" OF
  "Source Type"::Vendor: BEGIN
    Vendor.GET("Source No.");
    EXIT(Vendor.Name);
  END;
  "Source Type"::Customer: BEGIN
    Customer.GET("Source No.");
    EXIT(Customer.Name);
  END;
  "Source Type"::"Bank Account": BEGIN
    BankAccount.GET("Source No.");
    EXIT(BankAccount.Name);
  END;
    "Source Type"::"Fixed Asset": BEGIN
    FixedAsset.GET("Source No.");
    EXIT(FixedAsset.Description);
  END;
END;

If you want to fill your new created "Name" field in G/L Entry, make it during posting procedures, using, e.g. Event Subscription possibilities.