Register Login

How to Configure the Sales Account Determination?

Updated May 18, 2018

Field found in Material Master Sales Organization 2.

To define the General Leger posting :-

IMG -> Sales and Distribution -> Account Assignment/Costing -> Revenue Account Determination -> Assign G/L Accounts

With this link, the material that used this account assignment group will be posted with the desired G/L accounts during Billing.

User will not be able to Release the billing document to Accounting if this is not setup.

If you happend to assign it via Cust.Grp/MaterialGrp/AcctKey, then you can let your user use this report to check the material assignment.

* Transaction code VKOA

REPORT ZMATNR_AC_ASSIGN LINE-SIZE 132 NO STANDARD PAGE HEADING
LINE-COUNT 044(001).

TABLES: MARA,
MVKE, "Sales Data for Material
C001. "Cust.Grp/MaterialGrp/AcctKey

SELECT-OPTIONS: S_MTART FOR MARA-MTART DEFAULT 'DIEN',
S_MATNR FOR MARA-MATNR,
S_VKORG FOR MVKE-VKORG DEFAULT 'ALL'.

SELECT * FROM MARA WHERE MTART IN S_MTART
AND MATNR IN S_MATNR.
CLEAR MVKE.
SELECT SINGLE * FROM MVKE WHERE MATNR = MARA-MATNR
AND VKORG IN S_VKORG.

CLEAR C001.
SELECT SINGLE * FROM C001 WHERE KTGRM = MVKE-KTGRM.

WRITE:/ MVKE-MATNR UNDER 'Material',
C001-KTGRD UNDER 'Cust Grp',
MVKE-KTGRM UNDER 'Matl Grp',
C001-KVSL1 UNDER 'Acct Key',
C001-SAKN1 UNDER 'G/L From',
C001-SAKN2 UNDER 'G/L To '.

ENDSELECT.

TOP-OF-PAGE.
FORMAT COLOR COL_TOTAL.
WRITE: / SY-DATUM, SY-UZEIT, SY-REPID,
050 'Material Sales Account Assignment',
120 SY-UNAME, SY-PAGNO.
SKIP.
WRITE: /001 'Material',
020 'Cust Grp',
030 'Matl Grp',
040 'Acct Key',
050 'G/L From',
060 'G/L To '.

SKIP

Get More Questions and Answers with Explanation at SD (Sales and Distribution) Forums.


×