Customer terms on statements

SUGGESTED

Have any of you found a way to put the customer payment terms on customer statements?  I have 'played' with it for quite some time and can't seem to find a way to get it without impacting the data on the statement.  Any insight would be most appreciated.

  • 0
    You have to link through the Customer address table. Assuming you want the primary payment information you'd link from tarCustomer to tarCustAddr (on the PrimaryAddrKey) then to tciPaymentTerms on the PmtTermsKey. However different addresses can have different payment terms as can invoices so it's really a line level field. So it's a little tricky. Assuming it never varies then link how I've described above. If you have more questions post them and I might be able to answer. Your reseller should also be able to help you with this.
  • 0 in reply to JohnHanrahan
    Thanks for your response. I am working on this for an end-user, working with a VAR already. They weren't able to get it to correctly show either. The standard customer statement doesn't use either the tarCustomer for the tarCustAddr file since it uses mainly work files for the report. Unfortunately, the terms don't exist on the work files that are in the report currently. When I've tried adding and linking new files to the report, i lose data, so I'm guessing i'm still missing something. So, the challenge is to take the standard customer statement and see if there's a way to add the main customer terms (or per address) to the statement.
    I appreciate any insight.
  • 0 in reply to pamsbugs
    SUGGESTED
    The table tarCustStmtCustWrk has the PrimaryAddrKey. You can use that to link to tarCustAddr which can then link to tciPaymentTerms (PmtTermsKey). This will get you the header one (I think this is your main one). If they have need to get it by invoice then it's tarCustStmtInvWrk using the InvcKey to tarInvoice then use PmtTermsKey to get to tciPaymentTerms. Usually I just create a view (or views) to simplify getting the data. I assume you know how to add tables to the crystal reports. Make sure you watch what you do with each section as the Invoice side should probably only print in the details section (terms by invoice).
  • 0 in reply to JohnHanrahan
    That sounds workable -- thank you so much!! Have a great weekend!