Shulou(Shulou.com)05/31 Report--

SAP-related accounting subject setting OBYC is what, many novices are not very clear about this, in order to help you solve this problem, the following small series will explain in detail for everyone, there are people who need this can learn, I hope you can gain something.

1. FI/SD interface configuration

FI/SD Set posting accounts for billing via tcode VKOA, users can create their own account definition data sheets. Accounts that achieve COA level are posted to FI and CO vouchers respectively through KOFI/KOFK. PricingProc. is associated with SalesOrg., so SalesOrg. must be the first item on Organization. The AccountKey is associated with different PriceConditionTypes in PricingProc. and determines the final sales revenue, discounts, surcharges, accruals, etc. passed to different accounts.

2. FI/MM interface configuration

FI/MM sets posting accounts for all inventory movements through tcode OBYC. The system determines different movement types/business types with different TransactionKeys. For the meaning of TK, see SAPLIB for more detailed explanation.

Account configuration can be done at the ValuationArea(Plant) and ValuationClass levels as needed. In particular, I think the most interesting thing in FI/MM AccountDetermination is that TK is the account definition of GBB, one of which is called GeneralModificationKey. This GMK is directly connected to MovementType. In addition to many standard GMKs, users can also customize them and associate them with custom MovementTypes to determine different MT connections to different posting accounts.

3. Examples

You can configure it in the system according to the information, and do some examples to help understand the configuration of these subjects.

3.1 For receipt (especially receipt from purchase) and invoice entry IV/LIV, the commonly used TransactionKey is:

BSX All inventory account based postings associated with ValuationClass

FR1, FR3 Freight and customs clearance account (need to Clear through IV/LIV, similar to GR/IR account)

FR2, FR4 Freight and Duty Accrual Account (No Clear Required) WRX Inventory GR/IR Account

DIF SmallDifference, the amount that does not exceed the invoice spread tolerance passes through this account (ToleranceLimit defined in OMR6)

KDM handles posting differences caused by inconsistent exchange rates for invoices received at the same time

When KDR processes foreign currency invoices, the difference between the amount in functional currency and GRIR amount in functional currency due to rounding is posted.

UPF processes whether UnplannedDeliveryCost is routed to an established account alone rather than to inventory or variance accounts

PPV accounts are handled under PRD standard cost method, i.e. purchase spread accounts

1)Configuration PO Receipt (movement type: 101 / 102) : WRX

2)Account confirmation for configuring material cost center shipment (movement type: 201 /202): GBB + VBR3) Account confirmation for configuring inventory surplus/deficit (movement type: 701 /702) : GBB + INV

4)Account determination for configuring material scrap (movement type: 551) : GBB + VNG

5)Configure revalued account identification: UMB

When an item is repriced with MR21 or price controlled at S is received, the account for the price variance is determined.

END OF DOC.

3.2 For shipments and other inventory movements, the commonly used TransactionKey usually only needs to pay attention to GBB, that is, the so-called inventory movement offset or corresponding account, one of the more important concepts is GeneralModificationKey, which is associated with MovemtType. The more commonly used are:

AUF : Receipt and settlement of PP/CO orders without Acct. Assign mt

BSA : Post account for inventory initialization via 561/562

INV : Revenue and expense account caused by inventory variance, generally P+L account

VAX/VAY: Delivery Cost Account for Sales Order

VBO : inventory shipment account provided to suppliers for entrusted processing business

VBR : Process internal shipping transactions, such as direct consumption to cost centers, assets, or internal orders

VKA : Sales order business based on Acct. Assign mt, such as BTO and MTO business

VKP : Project services based on Acct. Assign mt, such as BTP and MTP services

ZOB : No PO returns, such as 501/502

ZOF : No PP order return,

As with 521/522, you can set the associated custom GMK based on the custom MovemtType and specify the subject in the GBB. In addition, if MaterialLedger and Standard Cost Method are enabled, relevant LKW, PRV, PRQ and PRY settings need to be made. See Help for details.

3.3 For receiving account settings, take a slightly more complicated example: Item A under factory A000, ValuationClass is V000; purchase freight to be priced at 2% in MM/InfoRecord, no need to clear accounts through IV/LIV; variance tolerance definition below 1 yuan is

SmallDifference; unplanned freight occurred during the purchase process, and I hope to pass it to the established account; the exchange rate at the time of receipt of invoices is different from that at the time of receipt, so there is a difference.

Example accounts are as follows:

1401 Raw Material Inventory Account

2181 Accrued freight

5121 Unplanned freight

5122 SmallDifference

5151 Exchange rate differences

6000 Inventory GR/IR

Can be configured via OBYC as:

Inventory posting BSX A000 V000 1401

Accrued freight FR2 A000 V000 2181

Small spread DIF 5122

Planned outward transportation UPF 5121

Exchange rate variance KDM A000 V000 5151

GR/IR WRX A000 V000 6000

The entry at the time of receipt is (MAP pricing method, ignoring VAT):

Dr. 1401 1020.00

Cr. 6000 1000.00

2181 20.00

The entries when receiving purchase invoices are:

Dr. 6000 1000.00

5121 100.00

5122 0.80

5151 1.20

Cr. A/P 1102.00 Entry of freight invoice:

Dr. 2181 20.00

Cr. A/P 20.00

For example, if you use MB1A to do PGI through 201, you can see that there is an Account Grouping in OMJJ. After double-clicking, there is the following String: 201 K X WA03 2 GBB VBR. Where K stands for Consumption Posting and GBB VBR is the key to connecting Accounts. With OBYC, select GBB (refers to inventory offset posting) double-click, the more complex settings may be: Valuation Modif. (a Plant) > General Modif. (VBR) > VC > Account!。In this way, 201 is linked to related subjects through GBB,VBR.

Of course, this is a very simple example. SAP will quote different so-called (Value String) in OMJJ for different Special Stock, quantity and amount. This thing is more complicated. I am doing FICO and I don't know much about it, but it is worth studying.

101 is MT for Purchase, Production and Cost Control Order Receipts, which are listed in OMJJ>Account Groupg. You can see Movemt in common use. Indicator is B (purchase order) and F (production order), please pay special attention to Consumption Posting(A,V,E, P...) For those rows with field values, the Transaction Key they link is KBS. This KBS is called Account Assigned Purchase-Order. In OBYC, it is the account that cannot be manually configured. SAP processes this KBS in Post String/Value String of Movement Type, pointing directly to inventory account, i.e. in BYC, Transaction Key is BSX inventory account definition.

Just mentioned in OMJJ>Account Grouping 101 those rows, their Value String is WE06, you can use t-code SE16 to look at a table called T156W, look at WE06 those rows, you will find:

WE06 01 KBS

WE06 02 WRX

This KBS just said, so this WRX you will find in OBYC, it defines GR/IR subjects, that is, when receiving goods

Dr. Inventory (KBS/BSX)

Cr. GR/IR (WRX)

In this way, you can analyze other MT, such as 101 similar to 105/106, 122/123, etc., quite complex.

In addition, the relevant IMG configuration in SAP Library is not fully explained, and many Transaction Keys are not explained in 4.6C Library, so I can only study them myself. The method we have used is to use different MT to do inventory movement, and then set dynamic breakpoints in the program to track which Transaction Keys and account definitions it uses according to those Value Strings.

Did reading the above help you? If you still want to have further understanding of related knowledge or read more related articles, please pay attention to the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.