Skip to Content

what if sort key of customer master and G/L account is blank

Hi Experts,

One quick question, what if sort key of customer master and G/L account is blank? Then how does assignment of invoice posting go? In my case, assignment of invoice posting is purchase order number of sales order, I don't know how it came since the sort key of customer master and G/L account is blank.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Oct 09, 2013 at 05:36 AM

    Hi Qiu,

    Check mentioned link ,it may help you

    http://scn.sap.com/docs/DOC-35136

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 09, 2013 at 05:39 AM

    Dear Allen,

    I think if nothing is maintained in sort key then it is being picked up manually.

    Please confirm the same with Business User whether they are specifying the assignment field manually while VF01 or FB70

    Regards,

    Sapan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 09, 2013 at 05:47 AM

    Hi Allen,

    Kindly check Copy control settings in Tcode VTFA for the concerned Sales Document type.

    Thanks,

    Harin Khakhkhar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 09, 2013 at 05:51 AM

    Hi Allen,

    You are probably posting the customer invoice with the SD module and the rule for the Assignment field is defined there in copy control (trans. VTFA) or the Billing type settings (trans. VOFA).

    Can you please check that this is right? Go to the FI document header and check if reference transaction = VBRK. If so, then the document was posted through SD and the assignment was defined there.

    Then, still in the document header, double click on the "Reference key" to see the original SD billing document (invoice). At the top of the screen, to the left of the SD invoice number, you will see the SD billing type.

    To find out what the rule for filling Assignment on customer is, go to trans. VTFA and choose the billing type you are using (in combination with a sales order type). Double click on it to see which field gets copied to assignment.

    Alternatively, this can be defined in the billing type itself (trans. VOFA). You can see it in the "Cancellation" box.

    There may be other places to set this up - just go to SPRO: Sales and distribution - Billing - Billing documents - Maintain copying control for billing documents.

    These (SD) settings take priority because the FI sort key only works if the Assignment is not filled by another application or a user. And in your case it is blank, so it almost certainly comes from one of the SD settings shown above.

    Did it help?

    Jan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Allen Qiu

      Hi Allen,

      I'm facing a similar problem.
      Billing document number is copied in to the Accounting document number Assignment field(BSEG-ZUONR).
      Is this needed to be handled in the VTFL (Delivery to bill copying control) T-code ?

      Because in our case we are processing a IDOC and posting the accounting document, so instead of Billing document number which is reflecting in the Assignment field(BSEG-ZUONR) we are passing our own custom value in to the Assignment filed(BSEG-ZUONR) .

      We have done the code in the Exit. Please find the flow below

      Message type -> process Code -> Function Module -> customer exit -> and our custom code.

      INVOIC -> INVF -> IDOC_INPUT_INVOIC_FI -> EXIT_SAPLIEDI_101 (ZXF06U06) .

      So our main problem is, the custom value code which is written to update the Assignment field(BSEG-ZUONR) in FB01 which we have included in the customer exit is overwritten by Actual billing document number.

      It would be really helpful if u could look in to this.

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.