cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

     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.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

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

Former Member
0 Kudos

we created billing based on delivery , so I went to vtfl,then which column should I look at? copying requirements?  or sth else?  still no clues about that

former_member188028
Active Contributor
0 Kudos

VTFA

select your billing type and double click on it

then it'll show the details of assignment field.

VOFA

select your billing type and double click, there you find the details of assignment.

Former Member
0 Kudos

And I also looked at VOFA, it is also blank for assignment number.

Former Member
0 Kudos

I am talking about the assignment number of account document which was released to accounting, I am not talking about the assignment number of billing itself.

Former Member
0 Kudos

In VTFL, assignment number is E WHICH stands for Actual billing document number

vinod_vemuru2
Active Contributor
0 Kudos

Hi,

If settings in VTFA is 'A' for assignment field, it copies the customer PO.

Check the sales order header, accounting tab as well. You can try entering some test number here and create billing and see if it is being copied from here.

Thanks,

Vinod.

Former Member
0 Kudos

Hi,My case if VTFL, not VTFA.

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi Allen,

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

Thanks,

Harin Khakhkhar

former_member188916
Active Participant
0 Kudos

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

Former Member
0 Kudos

No, it gets populated automatically  with purchase order number of sales order.

Former Member
0 Kudos

I had gone through this documentation, it does not help to answer my question, otherwise I won't post question here.

suma_mani
Active Contributor
0 Kudos

Hi Qiu,

Check mentioned link ,it may help you

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