Sales Employee in FBL5N

[Former Member]

Hi Experts,

My client want Salesman Code (Sales Employee) in "Personnel Number" field of  FBL5N.

Scenario is that, when SD create any SO, DO they enter "Sales Employee" and same is reflecting in Invoice.  Which get posted in FI document.

Now, FI check customer balance by FBL5N, but they want to know the salesman of each invoice.

These salesman has created as employee too.

I try to check Personnel Number field in BSEG table, but it shows blank.

Can any one suggestion, How to get (update) salesman code Personnel number while SD post invoice. 

OR  is there any other solution to get salesman code in FBL5N.

OR sales employee get update in BSEG or BKPF table........ please..

Thanks in advance......

[eduardo_hinojosa]

Hi,

Try to populate field PERNR in the interface structure ACCIT with the userexits mentioned in Note 301077 - User exits for the interface to accounting.

I hope this helps you

Regards

Eduardo

[former_member1200644]

Hi Sachin,

You Want Personal no filed(PERNR) in Report FBL5N,

you told to your abaper and implement Bussiness Transaction events.

Firstly append Filed PERNR in RFPOS structure

and custom code to be implent on Event "00001650" for T-code FBL5N.

Write in Custom code to take Billing doc no(VBELN) and pass in VBRP and get sales order

and pass in VBPA with parvw = 'ZM' and get PERNR and pass in RFPOS-PERNR.

this PERNR reflect in FBL5N Report.

Nilesh Patel

SAP ABAP Consultant

[vishal_mehta]

Hi Sachin,

Can you check if your client is using GuiXT add-on? If yes, I can provide the solution in 2 mins.

Good luck.

Best,

Vishal

[Former Member]

Hi Vishal,

Thanks for your prompt reply. 

Yes, our client do have GuiXT.

Can you provide the solution for our query.... please.

Many Thanks .....

Sachin

[vishal_mehta]

Hi Sachin,

Seems like Nilesh has provided a solution that might be suitable for your needs. Since I am not competent in ABAP, I can't decide whether it is helpful or not.

For GuiXT, is it possible for us to connect offline once, before I can be confident of posting the right solution here?

Thanks.

Best,

Vishal