Skip to Content
author's profile photo Former Member
Former Member

Adding a field to a crystal report in sap b1

All I am trying to do is to add the field for credit limited to the standard item invoice in SAP 8.8,

I have added the BP table OCRD and draged the creditline field to the layout, but when you view all the fields are empty.

I obviously need to link somthing - I have excepted the links that are automatically completed by SAP.

Can anyone point me in the right direction.

Thanks

Jo

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2010 at 11:31 AM

    Debi

    Thanks but I am new to crystal - I can see the links.. but do i need to add another table maybe and link via another field.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Jo,

      The link type defaults to INNER JOIN; you may need to change it to LEFT OUTER in case any of the customers have the credit limit field blank.

      As Debi mentioned, remove all the links done by CR; only link you will need between OCRD & OINV is on the CardCode.

      Heather

  • author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2010 at 06:58 PM

    Auto linking is not necessarily valid. Check the links!

    Debi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 12, 2011 at 09:20 AM

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.