Last Transaction Date

romeru00 · 2012-04-30

Hi
I need the steps to add a new field to the Customer Table (Table 18) that can show the last Posting Date from the Sales Invoice Header (Table 112) for each customer .

I appeciate your help.
Regards,

jglathe · 2012-04-30

romeru00 wrote:

I need the steps to add a new field to the Customer Table (Table 18) that can show the last Posting Date from the Sales Invoice Header (Table 112) for each customer .

Hi romeru,

I'd recommend looking into how flowfields are created. The posting date of the invoice is mirrored in the customer ledger entry. You can also have invoices posted without an entry in T112, but all invoices posted will have a customer ledger entry.

with best regards

Jens

Savatage · 2012-04-30

Add new field to Customer Table "Last Invoice Date" or whatever you like
Data Type=DATE
FieldClass=Flowfield
CalcFormula=Max("Cust. Ledger Entry"."Posting Date" WHERE (Document Type=FILTER(Invoice),Customer No.=FIELD(No.)))

Last Transaction Date

Comments

Categories