on 10-04-2010 2:42 PM
Hi Friends,
In FBL5N (customer line item report) there is a field "Sales Document" Field Name "VBEL2". But the accounting document which is generated in FBL5N for billing document from SD in not populating the sales order number in this field, this field is blank.
this field is getting populated for down payments with relevant sales document number and not for invoice document.
Our client wants the sales order number to be reported in customer line item report for their tracking.
Can any one please suggest how this can be achieved.
Thanks & Regards
You can map Sales Order number to either 'Assignment' or 'Reference' fields in accounting document using Copy control function in SD. Please use transaction VTFA, this needs to be maintained for combinations of billing type and sales document type. Please ensure these fields are not currently used in your system for other information.
Following fields can be mapped to 'Assignment' or 'Reference'.
A Purchase order number
B Sales order number
C Delivery number
D External delivery number
E Current billing document number
F External delivery no. if available, otherwise delivery no.
If you currently use 'Assignment' or 'Reference' fields for other details, you can use user exit EXIT_SAPLV60B_008.
Thanks
Venkata Ganesh Perumalla
Edited by: Venkata Ganesh Perumalla on Oct 4, 2010 11:52 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
In FBL5N, Sales Document number will be displayed only for Down Payments & for the rest, field will be empty.
even it is the same for FBL1N also, PO number will be displayed only for Down Payments.
SAP given a NOTE for this mentioning that Field will be displayed in the report but it will be empty.
i will check and let u know the NOTE.
regards
venkat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If you check that OSS note, the solution mentioned is:-
The display of the purchasing document number for customers/vendors via the line item display is not possible. However, you can branch from the vendors/customers line item display into the document overview and there display the purchasing document number for the individual G/L account line items.
Similarily for sales document number in FBL5N
Regards,
SDNer
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.