How can we generate One invoice with FOB and C&F values

[former_member407278]

Dear All,

Valuable suggestion required for below business process

Two different invoice to be generated one with FOB Value and another with C&F Value.

1.FOB invoice includes  -Gross Price +Freight Charges -Discounts = Net Value of the Invoice

2.C&F invoice - By adding both the Freight Charges and discount values,the price of each material price to be increased

   and net value should be same as per the FOB invoice.

Firstly will be generating FOB invoice output,and by adding the values of Dicounts/Freights will generate C&F invoice

Please suggest how can we accomodate both the above possibilities for 1 customer and 1 document type.

How can the values distributed to each line item in and how can both net values managed to get same value

Thanks & Regards,

Kumar Babu,

[former_member220617]

Dear kumar babu,

I am not getting clarity for the above scenario can you give me some more input regarding the issue .

Regards,

C.B Reddy.

[former_member407278]

Dear Reddy,

Scenario  is 1 order type and 1 customer.

First we create invoice with FOB value.

i.e FOB is the Gross Value adding Freight values and deductions discounts ,we get the Net Value that is C& F Value.

Second for the same customer and same document type,adding both the discount values and freight values we need to increase the material price and net value should be same as of first FOB invoice  value

Please  suggest how can we manage both the above scenario's.

Thanks & Regards,

Kumar Babu.

[Former Member]

Hi Kumar babu,

Do you mean to say that you are creating invoice twice?

Regards

SD

[former_member407278]

Dear All,

Invoice will be created only once..

How can we accomodate both possibilities.

First generating invoice with FOB value.

Now my doubt is ,how can we increase the price (adding the discount and freight values) and generate output equal to the net value of FOB.

Scenario Explained in Details.

Customer Code - 1001

Order Type  - ZNEW.

1 . FOB invoice document

Material        Price

X                  100

Y                 150

                   -------

FOB Value     250     

+ (Freight)      75

-  (Discounts) 125

                  ----------

C& F Value    200

                  -----------

2 . C&F invoice document

75 (Freight value)+125 (Discount value )= 200

Value of 200 to be distributed to each material  proportinately,and should be tallied with the net value of 200  with the above invoice

Material          Price

X                   100

Y                   100

                   -----------

  C&F Value     200

                  -------------

Please explain me how to process ,both the above requirement for customer and 1 order type.

Thanks & Regards,

Kumar Babu.

[Former Member]

Hi,

Maintain INCOterms in your condition access sequence and then Try and maintain a Routine to calculate the value as per your requirement. Condition value of Discount should be multiplied by Minus when C&F is there else standard process.

Take abaper help

Regards,

Sudhir

[former_member407278]

Dear All,

I want to write a routine for the above scenario.

Same customer requires 2 types of invoice (Invoice no will be one)

i.e different ways of calculation the Net value is required.

FOB invoice - Net value is arrived by calculating Gross value +Freights- discounts .

C&F invoice - Net value arrived by merging the discounts value & freight value with material price.

i.e Adjustment of material prices to reach the FOB Invoice net values.

Note:- Both the invoices net value should be the same.

Please suggest how to build the logic.

Thanks & Regards,

Kumar Babu.

[Former Member]

Hi,

I would suggest to have 2 different invoices, a comercial one, posting to accounting, and a proforma.

You decide which one uses FOB and C&F and adjust price procedures accordingly. For proforma, keep comercial invoice number in some field so that you can link both invoices and recover it in case you need to print it.

Regards,

JM