Thursday, April 9, 2009

Define Account Assignment Group


How to configure the Sales Account Determination?

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.

No comments:

Post a Comment