發票過賬幾種方法

Part I

發票過帳的幾個方法:

1. The company receives invoices, then the employee enters and posts them.

2. Invoices can be transmitted electronically using the Internet in IDoc (Intermediate Document) format, via EDI (Electronic Data

Interchange), or

in XML format. They can then be posted automatically. When using XML, you need to perform some additional mapping of the formats.

3. Invoices can also be created by accounting programs that run regularly in the SAP ERP system (automatic evaluated receipt ttlement,

invoicing plan and

consignment/pipeline ttlement).

4. If you are using SAP SRM, you can create invoices in the SAP SRM system. You can then transfer them to the SAP ERP system. (BBPIV01?)

發票過帳帶來的結果:

? The system posts the amounts for the individual items to the appropriate accounts.

? The system creates an MM invoice document and an FI document.

? The system updates the purcha order history.

? The system updates the material master, if necessary.

物料平均價/標準價 (MAP/Standard Price)

MAP: the valuation price is adjusted to the delivered price

收貨時,過帳給stock account的數量,即為采購價*發貨數量.

如果發票價不同于訂單價,價差過帳到stock account

S:價差過帳到price difference account

舉例:

收貨時,stock account是借方(+)

MAP: stock account是由訂單價*收貨數量 (2.2*50=110)

S: stock account是由標準價*收貨數量 (2.0*50=100) 這樣的算法,就產生了差額,為了在損益表中體現,該差額過帳到price differences account (110-

100=10)

有借必有貸,貸方(-)就沖銷到GR/IR clearing account. 沖銷金額=訂單價*收貨數量.(2.20*50=110))

在發票過帳時,GR/IR clearing account被清除, vendor account成為貸方.

輸入:

發票過帳時,一般需要輸入 Document date, purcha order number, Invoice amount, tax amount, terms of payment (if necessary)

從采購憑證自動帶來的數據有Vendor, terms of payment (if defined there), currency, Invoice items;

quantity and amount are derived for each item from the purcha order history

從供應商主數據和配置帶過來的數據有The bank information, Default value for the tax rate

Allocation:

Layout: {Variant(screen 6310)/Aggregation(screen 6350}

拷貝一個最實惠拉

Prent aggregation criteria

Ur Parameter in IV: (as of 4.6C)

The parameter IVFIDISPLAY ensures that the document number of the FI accounting document is displayed in the status bar as well as the

MM invoice document number.

The parameter IVAMOUNTADJUST makes it easier to correct the quantity and amount in an invoice item.

Transaction related to IV:

? Enter Invoice (MIRO)

? Park Invoice (MIR7)

? Cancel Invoice (MR8M)

? Invoice Overview (MIR6)

? Evaluated Receipt Settlement (MRRL)

? Revaluation (MRNB)

? Invoicing Plan (MIRS)

? Invoice Verification in the Background (program RMBABG00)

PO-Bad IV & GR-Bad IV:

PO-Bad IV在做IV allocation時, 只能調出整單的數量

GR-Bad IV在做IV allocation時,可以調出各次收貨的數量

PO history同樣驗證了該點. 同時可發現,PO-Bad, GR-Bad對于收貨來說,都是同樣的表現--收一單現一行.

GR-Bad IV的前提是: 在Invoice標簽里勾選,該標記可通過供應商主數據或source of supply帶過來. 勾選該標記后,需收貨才可發票過帳.

對于GR-Bad IV, 可以選擇在做了IV之后,是否允許做102取消收貨,或退貨等操作. [OMBZ]

如果不允許(即不勾選)則在做反向操作時出現Message no. M7021

Note 184632!!! READ!!

Part II

Document Parking

Hold: (MIRO/MIR7) When you hold a document, the system only performs minimal checks (such as the existence of the company code,

vendor, and company code). A MM invoice document is created. No information is transferred yet to Financial Accounting, and no updates are

made to the purcha order history.

Park: (MIR7) The balance does not have to be zero. An MM invoice document is created, and the purcha order history is updated.

Information is also transmitted to Financial Accounting.

Save as complete: (MIR7) The balance must be zero or fall within the tolerance for small differences or the vendor-specific tolerances. The

same checks are carried out as for parking documents. The purcha order commitments are also canceled out.

Worklist: continue processing held documents, parked documents and documents that are saved as complete.

MIR6 allows you to access documents that were created by other urs.

Tables:

RBKP: MM invoice document

BKPF: Accounting document

Summary:

for Parked and Save as completed, the FI document contains header information and only one posting line for the vendor account.

After posting, it has the below documents:

Workflow:

1. WS20001003: Complete parked documents

2. WS20001004: Relea documents that are saved as complete.

配置步驟

- Activate Event Linking

- Relea criteria

同樣的情況下,有rel. group的級別更高,可以在這里配置

另可在這里做增強: customer exit EXIT_SAPLMRMC_002 of the enhancement LMR1M005

Prepayment: (As of ECC 6.0)

前提

1. Define the document type for the FI document that is generated when an invoice is posted with a prepayment document.

2. Prepayment must be permitted in the vendor master record with the Prepayment indicator.

3. There must be a general ledger account defined for transaction PPX (prepayment) in Customizing for the account determination.

操作: To create an invoice with prepayment, you must enter the invoice with transaction Park Incoming Invoice (MIR7) or transaction Enter

Invoice for Invoice Verification in Background (MIRA). The prepayment can also be ud during an invoice entry with an Electronic Data

Interchange (EDI) or BAPI.

If the prepayment status of an invoice is “(A) Relevant, invoice not yet saved”when it is parked or held, a prepayment is generated in

financial accounting as

an FI invoice. (This FI document is generated with the document type that is specified in the document header on the Detail tab page.) The

system posts the relevant data for the payment in financial accounting against a clearing account for the prepayment and generates an open

vendor item. The payment of the vendor invoice can then occur independently of the goods receipt entry and invoice verification. An invoice

verification does not occur at item level when the prepayment occurs. The system does not determine variances between the invoice and the

purcha order or goods receipt. Neither does it t an automatic payment block for the prepayment in accordance with the tolerance limits

that can be t in Customizing.

When the held or parked document is posted, the clearing account of the prepayment is balanced instead of the vendor posting and tax

posting.

Prepayment is not possible in the below:

? For credit memos and subquent credits

? For one-time vendors

? In conjunction with import sales/purchas tax or acquisition tax

? For invoices who cash discount ba amount is different from the tax ba amount

? For invoices with more than one tax rate and which u the Calculate Tax function.

? Invoices with the American tax jurisdiction code.

? For plants with an active material ledger

Badi WRF_PREPAY_INVOICE:

Method SET_POSTING_DATE lets you lect a posting date other than the system date for the prepayment document.

Method PREPAYMENT_RELEVANCE_CHANGE lets you implement extended logic to control the prepayment relevance (request or reject). To do

so, the Business Add-In provides the invoice document header (RBKP) at runtime. Until a prepayment document is posted, you can u

method PREPAYMENT_RELEVANCE_CHANGE to override the Prepayment Relevancefield from the header of the current logistics invoice, and

thus prevent (or trigger) prepayment.

Note: 937129 Restrictions that apply to prepayment

958136 Advance payment: Credit memo instead of FI reversal document

Part III

Tax Code:

Define which tax code is a default for each company code when you enter invoices on the Basic Data tab page.

Define which tax code is a default for unplanned delivery costs on the Detail tab page. The tting for unplanned delivery costs is relevant

only if the costs

are posted automatically to a parate G/L account line.

Define which values are available in the input help (F4 help) for the Tax Code field in the basic data and the items. (If you enter the tax data

on the Tax tab page, the input help propos all tax codes.)

[OBZT] country bad

Terms of Payment

在做invoice/credit memo/subquent debit/subquent credit時,如果有PO作為參考:

- 當goods/rvice items或goods/rvice items+planned delivery cost時, terms of payment從PO的header取得

- 當planned delivery cost時, From the company code data of the vendor that is planned for the delivery costs. (似乎不對)

在做invoice/subquent debit時,如果沒有PO作為參考:

From the company code data of the invoicing party (vendor) that is to be entered manually.

在做credit memo/subquent credit時,如果沒有PO作為參考:

no proposal

配置:

[OBB8] [OBB9]

Cash Discount (Gross posting)

If you post the gross amount of an invoice, the system ignores the cash discount amount when you enter the invoice; it posts the cash

discount

amount to a Cash Discount account at the time of payment. Therefore, the cash discount amount is not credited to the stock or cost account.

? - The cash discount amount for the net invoice value is posted as a non-operating result.

? - When the invoice is posted, the system first posts a tax amount that is too high, since the tax does not take account of the cash discount.

When the payment is made, the input tax posting is automatically corrected, and the tax amount for the cash discount is credited to the input

tax account.

Cash Discount (Net posting)

If you post the net amount of an invoice, the system posts the cash discount amount from a cash discount clearing account to the stock or

cost account.

This means the system only posts the amount reduced by the cash discount amount to the stock account/costs account. The cash discount

clearing

account is cleared at the time of payment.

The cash discount amount is already taken into account when the invoice is net posted.

The cash discount amount is posted to a cash discount clearing account; this is cleared at the time of payment.

The offtting posting to the cash discount clearing account is dependent on the price control of the material:

? If the material is managed with a standard price, the cash discount is credited to the price difference account.

? If the material is managed with a moving average price, the cash discount is credited to the stock account. If there is no stock coverage,

then only a

part, for which the stock coverage exists, is posted to the stock account. It posts the remainder to the price difference account.

When the payment is made, the input tax posted in the invoice is corrected.

Document Type for Accounting Document

[OMR4]

Foreign Currency

If this rate is fixed, the system us the exchange rate from the purcha order to convert the foreign currency to the local currency at goods

receipt

and at invoice receipt.

(勾選,則在GR,IV時,選擇采購訂單里的匯率)

If the exchange rate is not fixed, the system us the current exchange rate to convert the foreign currency to the local currency at goods

receipt. In

Invoice Verification, the system also suggests the current exchange rate as the exchange factor, but you can change it.

(未勾選,GR時采購后臺配置中的匯率,IV時也是,但可以更改.)

所以在未勾選時,可能會有匯率差:

- 當采購訂單有科目分配時,匯率差(exchange rate difference)的金額借記/貸記到clearing account

- 當使用移動平均價+stock coverage時,匯率差的金額借記/貸記到stock account

- 當僅使用移動平均價,或標準價, 可以在后臺配置[OMRW]選擇匯率差的金額借記/貸記到一個特殊的匯率差科目,或一個普通的價差科目price difference

account

SAP ERP 6.0 Enhancement Package 3 and later feature another alternative in Customizing: You can u the Treatment of Exchange Rate Diffs.

in Company

Code Currency indicator to ensure that the amount of the exchange rate difference is always posted in the full amount to an exchange rate

difference account,

regardless of the material's price control, and when there are purcha order items with account assignment. The ttings of the Treatment of

Exch. Rate Differences indicator are no longer relevant in this situation. The stocks or consumption are then valuated for the exchange rate of

the goods receipt and not the exchange rate of the invoice. The exchange rate of the purcha order does not come into play when goods

receipts are posted and the conversion of the purcha order values into the local currency always occurs for the posting date of the goods

receipt.

Invoices for POs with Account Assignment

科目分配在以下情況使用: 購買的貨物不計入庫存管理而是直接消耗; 購買外部服務

科目分配類別(account assignment category)決定了是否需要收貨,是否需要做發票過帳.

If a valuated goods receipt is defined for a purcha order with account assignment:

1. The system debits the consumption account at goods receipt.

2. The offtting entry is made to the GR/IR clearing account and

3. Cleared by the invoice.

4. The system debits or credits price variances to the consumption account.

If no goods receipt or only a non-valuated goods receipt is defined for a purcha order with account assignment

1. the posting to the consumption account occurs directly when the invoice is posted.

Multiple Account Assignment

As of SAP ERP 6.0 Enhancement Package 4, a valuated goods receipt can also be posted for purcha order items with multiple account

assignment.

激活 LOG_MM_MAA_1

Valuated goods receipt is still not possible for multiple account assignment of subcontracting items.

在多重科目分配時,可以按照數量,百分比或金額來分配

另外還有個partial inv.的標記,定義在做發票過帳時,按次序分,或按比例分

You can u the BAdI MB_ACCOUNTING_DISTRIBUTE to redefine the distribution to individual account assignments when you enter a

valuated goods receipt for a purcha order item with multiple account assignment.