Help with Purchasing & Crystal Reports

I'm trying to print the Location of the Delivery on the PO.  (Not necessarily the job site). 

For example: Order materials for Job X, but have the PO inform the Supplier to deliver the materials to our Shop.

How it is set up now, it looks like the material would be shipped to the job site.

Parents Reply Children
  • 0 in reply to JudyJudyJudy

    The reports that are provided with Purchasing to produce the PO documents include a formula to retrieve the job description from the JC Job record. The formula is named Job Description. The job would need to be populated on the Job field in the PO Header. If your POs are distributed to multiple Jobs on the line items that formula will not work

  • 0 in reply to Denise Paulus

    So then my problem still exists from above?  Please confirm my understanding...If the delivery address/job is populted to Job called "Main Office" in the PO Header, then I won't be able to add/insert the Job Description which you are also stating is populateed in the PO Header.

    I'm not seeing a formula named "Job Description". 

  • 0 in reply to JudyJudyJudy

    There are several different reports that are provided with the software that can be used to generate the PO documents. Additionally you may already be using a custom report.  The Job Description is stored on the Master_JCM_Job record. You would need to include this table in the report design and link the JOB field to the job description stored on the Master_JCM_Job to create this formula.  If you are not familiar with Crystal I recommend that you work with a consultant to build the report to ensure that the information is retrieved correctly.