Vendor / Customer in Detail Trial Balance

jeniez

How do I show the Vendor's and Customer's names on the Detail Trial Balance Report for entries that's related to that particular Vendor/Customer? Thanks.

jeniez

Sorry, I meant to say :

jeniez wrote:

How do I show the Vendor's and Customer's names on the Detail Trial Balance Report for entries that's associated to that particular Vendor/Customer? Thanks.

Albertvh

Hi

I assume that your are running the General Ledger Trial balance

On the dataitem G/L Entry in OnAfterGetRecord you could do the following

CASE "Bal. Account Type" of
  "Bal. Account Type"::Customer : BEGIN
    Customer.GET("Bal. Account No.");
    Name := Customer.Name;
  END;
  "Bal. Account Type"::Vendor : BEGIN
    Vendor.GET("Bal. Account No.");
    Name := Vendor.Name;
  END;
END;

You would have to add the variable Customer, Vendor and Name and add Name onto the body section.

Hope this helps.

Albert

Albertvh

Hi
Sorry Bal Account Type and Bal Account No should read Source Type and Source No.

Albert