Post Goods Issued Quantity vs Customer received Quantity.

[Former Member]

Dear All,

I am having a requirement where there is always a difference between dispatched goods quantity to customer received quantity.

For Example:

Frozen Material of 100 Kg dispatched to customer, while customer is receiving delivery weight is reduced to 95 Kg.

For this we need to capture both quantities and as actual dispatch was 100 Kg so delivered quantity cannot be changed, but we need to bill customer only for 95 Kg. Please help on this.

Looking forward for your kind solutions.

Regards,

Yogesh Singh

[Former Member · Accepted solution]

We made some enhancement and it is done.

Thanks all for giving your valuable inputs.

Regards,

Yogesh Singh

[former_member182378 · Accepted solution]

Yogesh,

This is an interesting requirement! Please give some clarity.

But difficulty is client want to generate only one invoice number against delivery document. And as per business process it is mandatory to issue invoice along with delivery challan to transporter.

Invoice can be blocked for posting till we receive confirmation from customer. then invoice is to be released for accounting.

What solution is done?

1. Invoice created for 100 qty and sent with truck driver

2. No accounting document created (as there is posting block)

3. SH confirms that 95 qty was received

4. In VF02, is the qty changed to 95 in the invoice?

5. This invoice is released and accounting document is created.

Is this the way the process works?

Thanks!

TW

[Former Member · Accepted solution]

Hi TW,

You mapped requirement correctly but Billing quantity is not getting changed we have calculated all pricing calculation on actual confirmed quantity except VPRS and some other pre-sales overheads.

Regards,

Yogesh Singh

[Former Member · Accepted solution]

Please find developed solution.

1). User goes to pricing screen and changed the actual and missing quantity.

2). First program flow goes to ENHANCEMENT XYZ***3.

2.1). If pricing condition type is Z***, Z***, Z*** or Z*** then  insert the value of KOMV-KUMZA and

         KOMV-KUMNE in to Z**_QTY table for KNUMV and KPOSN.

2.2). If same key value already exist then modify the values else insert new values. Use KOMV and KOMP

         Structure data to insert or modify values in Z**_QTY.

2.3) Z**_QTY table is used to hold actual and missing quantity.

3). After this program flow goes to ENHANCEMENT XYZ***4. Here its changes the basic unit of

     Measure for division **. If RV61A-MEINS = 'EA' then change it to 'KG'.

4). After this program flow goes to ENHANCEMENT XYZ***3 1. All pricing calculation takes place

     here.

5). Check division is ** and transaction is VF01, VF02, VF03, VFX3.

6). If account posting is initiated then check PGI is done for the invoice.

  6.1). Select data from VBFA table for delivery number where document type (VBTYP_N) is 'R' or 'h'.

  6.2). If total of 'R' mines total of 'h' is less than 1 then display error message for PGI not done.

7). If division is ** then use KOMV-NTGEW for quantity else use KOMV-MGAME for quantity.

8). For division ** check if material is catch weight material or not. If not then treat division ** as **.

9). XKONV is main table, which is passed to enhancement through standard program.

10). Loop at XKONV for basic and actual conditions. Divide quantity of step 7 at decimal place and insert

       into KUMZA and KUMNE fields of XKOMV.

  10.1). Change actual and basic quantity and amount .Multiplying quantity with rate to get amount.

11). Now get the actual (Z***, Z***) and missing (Z***, Z***) from Z**_QTY table (check step 2).

  11.1). If values found then modify XKONV else insert relevant XKONV data into Z**_QTY table.

12). Now loop at XKONV and calculate amount for every pricing condition.

  12.1). Basic and actual price is already calculated in step 10.

  12.2). For actual and missing pricing condition, If value found in step 11 then use XKOMV-KUMZA,

            XKONV-KUMNE and XKOMV-KBETR to get amount.

  12.3). If condition type is ZD** or Z**V then get discount using XKONV-KBETR and actual amount.

            If ZD** then (XKONV-KBETR * actual amount) / 100000 is discount amount.

            If Z**V then multiply actual quantity with XKONV-KBETR to get discount amount.

  12.4). If condition type is Tax condition types then get amount  as calculated for discount.

  12.5). Get VPRS (Internal Price) rate by dividing material document amount with material doc quantity.

            Get all 'R' records from VBFA table for delivery number and use most recent document.

13). Calculated amount for all other conditions same as step 12.

14). If basic quantity - actual quantity - missing quantity is less than 0 then give message and clear missing

        Quantity fields.

15). Now calculated values for fields where KSCHL (condition type) is blank (Like: Price after Tax).

  15.1). for price after discount and price after tax rows add actual amount and discount/tax amount.

16). Coinage is also calculated by this enhancement. first add total value of all items and then get the

        round off  value. Divide this round off value equally in all items.

17). After this program flow goes to ENHANCEMENT Z***_****1.

  17.1). Here program calculate the net value of every line item. Net value is actual value + discount +

            freight + coinage.

Regards,

Yogesh Singh

[former_member182378 · Accepted solution]

Hi Yogesh,

Thanks for your post!

but Billing quantity is not getting changed we have calculated all pricing calculation on actual confirmed quantity except VPRS and some other pre-sales overheads.

Added: How does the SAP system know about the changed qty (e.g. 95)?

Is this inputted by the user? where?

Please clarify taking the below example -

1. Invoice created for 100 qty and sent with truck driver

2. No accounting document created (as there is posting block)

3. SH confirms that 95 qty was received

4. In VF02, is the qty changed to 95 in the invoice?

5. This invoice is released and accounting document is created.

TW

Message was edited by: TW Typewriter - added in blue