Skip to Content

COGS and Revenue Posting on Billing Document with POD

Hello All,

I have a requirement to post Cost and Revenue in the same month. We are using delivery related billing and POD (Proof of Delivery) due to the sales business process.

Example:

We Delivery 4 PC of Material A on June (goods issue), and customer only received 3. So we bill the 3 quantity using the POD feature.

We Invoice the Order on July, and the client requirement is to have Cost and Revenue posting on the same month (Cost and Revenue in July).

Current solution:

Goods Issue - G/L Inventory In Transit (On June)

Invoice - G/L Revenue (On July)

- G/L Inventory In Transit (On July) -> to balance the inventory in Transit posted on June

- G/L Cost of Goods (On July)

Due to POD, and different month posting there is a possibility the Cost of Goods on Goods Issue and Billing have different value. To balancing the Inventory In Transit we have to use the goods issue value and store it in condition ZPRS with new routine.

Problems:

1. I am using condition category G-Internal Price. But, the condition value will always calculated against quantity. Eventhough we are using Calculation Type Fixed Amount or Formula (no Quantity Relation). (Due to POD, there is possibility the quantity on billing and Goods Issue are not the same. once again we want to post the exact value on billing document)

2. If I am NOT using condition category G-Internal Price, the value are stored correctly but there is no Posting to Accounting.

Is there anything I could do to fix this problem? either solving Problems no 1 or 2. If there is any other way, please advise.

I do really appreciate your help.

Thank you very much

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 03, 2017 at 08:59 AM

    Standard functionality in delivery related billing is system will always fetch VPRS from the value of goods issue. If that is not happening, may be you go to the detail display of the VPRS condition. If the condition control (KSTEU)

    • is set to 'H', the cost was taken from the goods issue.
    • If it set to 'A', it was redetermined from the valuation segment of the material master,
    • in case of 'D' or 'E' it was copied from the preceding document.
    (Due to POD, there is possibility the quantity on billing and Goods Issue are not the same. once again we want to post the exact value on billing document)

    Is that billing happens in advance to goods issue in your case ?

    Also, I presumed, you have only one condition type with condition category G

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 25, 2017 at 02:43 AM

    Dear Lakhsmipathi,

    Thank you for your reply. I have search for the root cause for my incidents and it seems I missed some scenarios during creation of pricing formulas. So we could a pricing formula to solve those problems, with using a copied of VPRS (ZPRS) and tick accruals.

    Now the enhancement works fine.

    We do really appreciate your help.

    Thank you,

    Budi

    Add comment
    10|10000 characters needed characters exceeded