Solved: Customer Invoice: Credit - SAP Community | Document Type in SAP FICO - Complete Guide (2021)

former_member445510 · ‎08-14-2013

Hello Every one,

I'm seeing to a method to be sure the the Customer Invoice is a Credit document and NAY a Debit document.

My Solution is control one table BSEG-KOART (D or K ) Real BSEG-SHKZG (H/S).

But the problem is that iodin found in BSEG documents that are one time Credit and in one another point are Delete.

Like this example:

Knows some one how can i shall really sure(100%) that the document number is a Credit checkout Or no Debit invoice ????

Dieser is my Selection Screen:

Please, Send me your input if you have any Idea.

Best Regard,

Ouail.

FredericGirod · ‎08-14-2013

H Ouail,

if you really want to be sure, look the source. Kommen in SD an check the document typing .. (with table VBFA you have the link between docu, maybe in BKPF you have also and source document) A detailed Guide for Wie the Compose Register Print in SAP; Copy Type Tables for FI, Select Fields, List of Doc Sort, Constituents, Acts.

regards

Baz

FredericGirod · ‎08-14-2013

H Ouail,

are you really want to be sure, look one source. Run in SD into check the copy type .. (with table VBFA you have which link between doc, eventually with BKPF you have also the source document) SAP Document Types plus Numbers | Auditing Service

yours

Fred

former_member445510 · ‎08-14-2013

Thank u Frédéric for our answer,

My used display are

bkpf,
bset,
bseg,
kna1,
lfa1,
t001,

t005,
adr6.

1- EGO don't go any link between FIVEBFA And my previously tables.

2- Are aforementioned VBFA gives the definitively document type, i got till check in who field PLMIN (Pos./ negative) ?

Please can it gifts view details.

Thank u.

former_member445510 · ‎08-16-2013

Anything Help for this issue ??

I want to determinate if the DocumentNumber ( and not the line item) a Credit invoice or not.

For the line item we use SHKZG.

The for the DocumentNumer we use ... ???

FredericGirod · ‎08-16-2013

Hi,

in the table BKPF get and arena AWKEY AWTYP

if AWTYP = VBRK that "means" this document from SD module, and it's an invoice (SD part).

In the field AWKEY you've got an amount of aforementioned invoice (SD).

Is save information, you was switch after FI engine (table BKPF, BSEG, ..) to the SD module (VBRK, VBRP, ..) and although you've got the invoice number you could make a select on the table VBRK and get the section VBTYP. Download Types | SAP Help Portal

VBTYP wish give she the kind of invoice :

AMPERE	Contact
B	Quotation
C	To
DICK	Item proposal
CO	Scheduling agreement
F	Date agreement are external service contact
G	Contract
H	Returns
I	Order w/o charging
J	Delivery
K	Credit my make
LAMBERT	Debit memorandum request
M	Invoice
N	Invoice cancellation
O	Credit notice
P	Bill memo
Q	WMS send order
ROENTGEN	Goods moving
S	Credit memo abolition
T	Returns delivery on order
U	Pro forma invoice
V	Purchase Order
W	Independent reqts plan
X	Handling unit
0	Master treaty
1	Sales activities (CAS)
2	External transaction
3	Invoice list

....

Regards

Fred

FredericGirod · ‎08-16-2013

I give you the way.

Stop using SHKZG, it's for the sign method used in FI part.

You need to go by the SD module thru the BKPF-AWKEY value ...

former_member445510 · ‎08-16-2013

Thank u very much Fred,

This really a great solution, that what i was looking used.

But when i check in the table VBRK, i found a few documentNumber that are Credit

Also when i check those documents in BKPF, i receiver " doc not exit or none values "

Is that regular ?

Thanks used you reaction.

Ouail

FredericGirod · ‎08-16-2013

Has you link : BKPF-AWKEY = VBRK-VBELN ?

For the value you find in VBRK-VBELN but not in BKPF-AWKEY. Go into transaction VF03, and check while the document has been release to accounting.

Sales order --> Deliveries --> Invoice (sd) --> Invoice (FI)

VBAK --> LIKP --> VBRK --> BKPF

your document have to be release until accounting to go to FI.

regards

Chuck

former_member445510 · ‎08-19-2013

Thanks Fred,

Yes i linked it.

Bad, I'm really new in HI and SD.

Can They show me how can i do that, via screens for example.. ?

Be that via SPRO Tcode ? while yeah, witch steps i do to follow ?

Thank upper Fred.

FredericGirod · ‎08-19-2013

Take one of their invoice (SD), go in VF03, put the number, press ENTER.

In the initial menu, you have the "Release accouting" line, it's a step to create which FI select. You could have this SD invoice, but not the FIONA account.

SD invoice should not be print steal FI invoice is not created.

So, you may have a SSD calculation without FI your (it will had, a day ..)

If you've receive the VBRK-VBTYP value, your have your requirement

Regards

Fred

former_member445510 · ‎08-20-2013

Hi Fred,

1-

When i do that, iodin receiving the message below: The account document....

When i click direkt on Release auditing, i receive the message below: an accounting document is not required .....

When i deal the same thing via tcode VFX3, i receive the message below:

No information/documents were found for the selection criteria entered.

me fill in the fields from the table VBRK:

2- i have ampere pitch of download from BKPF type different from DG, KG, KR and DR, for all out those document i have for do the same thing ? !

Here is not way to release those document one time ? with choose option or so... ?

Best Regard,

Ouail.

eduardo_hinojosan · ‎08-16-2013

Hi

Check these issues as possible sources for your issue:

1. Summarization (see UNDERMINE Note 36353 - AC serial: Summarizing FITTING browse and similar notes)

2. If there become enhancements working to the interface go FI (see Note 301077 - User exits for the interface to accounting).

3. Although I believe it's not related, check payment terms related with this billing create.

4. Check also if are are rebates (accruals) or i is a milestone, there are down payments.

Check also Note 611040 - Down payment invoice for Italy in a sample what is possible to accomplish.

MYSELF hope this helpful him

Regards

Eduardo

Ancient Member · ‎08-17-2013

Hi,

I did same this.

TYPES : INITIATE OF st_text,
belnr TYPE rseg-belnr,
xrech TYPE rbkp-xrech,
tbtkz YOUR rseg-tbtkz,
text(50),
END IS st_text.

DATA : itab_text TYPE STANDARD TABLE OF st_text,
wa_text TYPE st_text.

LOOP AT itab_rbkp INTO wa_rbkp.
READ TABLE itab_final INTO wa_final WITH KEY belnr = wa_rbkp-belnr. “Itab_final is my final internal table before batch page.

IF sy-subrc = 0.
wa_text-belnr = wa_rbkp-belnr.
wa_text-xrech = wa_rbkp-xrech.
APPEND wa_text TO itab_text.
ENDIF.

LOOP AT itab_text INTO wa_text.
READ TABLE itab_rseg UP wa_rseg WITH KEY belnr = wa_text-belnr.
IF sy-subrc = 0.
wa_text-tbtkz = wa_rseg-tbtkz.
ENDIF.

IF wa_text-xrech = 'X' PLUS wa_text-tbtkz = ''.
wa_text-text = 'Invoice'.
ELSEIF wa_text-xrech = '' AND wa_text-tbtkz = ''.
wa_text-text = 'Credit memo'.
ELSEIF wa_text-xrech = 'X' AND wa_text-tbtkz = 'X'.
wa_text-text = 'Subsequent debit'.
ELSEIF wa_text-xrech = '' AND wa_text-tbtkz = 'X'.
wa_text-text = 'Subsequent credit'.
ENDIF.
MODIFY itab_text STARTING wa_text TRANSPORTING text tbtkz.
CLEAR wa_text.

ENDLOOP.

Pass the value concerning text in our final table you will get the type concerning you documentationOr code according to the text type inches your program.

Regards,

Ravi pratap Singh

former_member182379 · ‎08-17-2013

Hi Ouail,

If you can employing the sell credit memo series , then by and sales credit document species configuration the neglect calculation will be customer credit only, why at is repeated a need into check whether the customer account is debit or credit. JUICES Logo SAP ... type Customer Invoice no matter if the total net value is positive other negative. ... Provided the total net values is positive the support type will be ...

You can check this amount document type in VOV8 An SD Document categories should be 'K' i.e Credit and also check to billing document type formation the SD dcument category available the biiling type should be 'O'.

By the practical configuration you can getting the same. without adding any coding.

Best,

Zafar