topic Re: Problem in vendor Return process. in Application Development and Automation Discussions

Problem in vendor Return process.

Former Member — Sat, 05 Apr 2014 05:14:15 GMT

Hi Expert,

I have a report for vendor return process.Currently everything is ok. but now end user want to some changes like in grand total.

Grand total = total + Taxes(12%+2%+1%+Add duty+5%)

But in some cases end user want to print

grand total = total value

they have a condition when MRP indicator is Tick (in MIGO) then print

grand total : total

When MRP indicator untick then

Grand total = total + Taxes(12%+2%+1%+Add duty+5%)[(curently this is using)]

I am using this logic for grand total in my program:

grand = item_tot + lv_cst + J_1IEXCHDR-EXBED + J_1IEXCHDR-EXADDTAX1 + J_1IEXCHDR-ECS + lv_adi.

So Please expert suggest me for the solution.

Thanks & Regards

Atin

Re: Problem in vendor Return process.

Former Member — Sun, 06 Apr 2014 00:01:59 GMT

How is the output in your first screen shoot of the the print for the vendor returns process generated? It looks like it's either a smart form or a SAP scripts. If it's a smart form it is very easy to add condition to a text node to control whether or not it is displayed. So then you have two text node one displayed when MRP indicator unticked containing Grand total = total + Taxes(12%+2%+1%+Add duty+5%) and another containing grand total = total value displayed when the MRP indicator is ticked. If it's a SAP Script then you can achieve the same results by adding IF, ELSE, ENDIF command lines.

Re: Problem in vendor Return process.

Former Member — Mon, 07 Apr 2014 03:54:32 GMT

Hi Jamie,

I used sap script. And I tried By adding IF, ELSE, ENDIF in report. But same problem. Please Give the solution in detail.

Re: Problem in vendor Return process.

nabheetscn — Mon, 07 Apr 2014 06:17:07 GMT

Hi Atin

First of all were you able find out where this chekcbox value is store..? Seconldy do you know the place where total is getting calculated in yoru driver prorgam?

Nabheet

Re: Problem in vendor Return process.

Former Member — Mon, 07 Apr 2014 06:31:43 GMT

Hi ,

In your driver program please capture the check box value input.

Ex.

If MRP_CHK = 'X'.

Grand total = Total.

else.

Grand Total = Total + Tax value.

Endif.

Thanks and Regards

Srimanta

Re: Problem in vendor Return process.

Former Member — Mon, 07 Apr 2014 06:45:54 GMT

Hello Nabheet sir,

Here is the code.

FORM FORM_TITLE_PRINT.

lv_adi = item_tot + J_1IEXCHDR-exbed.

lv_adi = ( lv_adi * 402 / 10000 ).

lv_cst = item_tot + J_1IEXCHDR-exbed + J_1IEXCHDR-ecs + J_1IEXCHDR-EXADDTAX1 + lv_adi.

lv_cst = ( lv_cst * 5 / 100 ).

grand = lv_cst + J_1IEXCHDR-EXBED + J_1IEXCHDR-EXADDTAX1 + J_1IEXCHDR-ECS + item_tot + lv_adi.

tot_amt2 = grand.

Re: Problem in vendor Return process.

nabheetscn — Mon, 07 Apr 2014 06:53:42 GMT

So you just have to find the MRP field check and implement an IF&ELSE. Did you know the table and field..? It is in J_1IEXCHDR/J_1IEXCDTL table

if field blank.

grand = lv_cst + J_1IEXCHDR-EXBED + J_1IEXCHDR-EXADDTAX1 + J_1IEXCHDR-ECS + item_tot + lv_adi.

else.

grnad = item_tot.

endif.

Re: Problem in vendor Return process.

Former Member — Mon, 07 Apr 2014 06:55:59 GMT

J_1IEXHEAD-MRPIND (table category structure)

Re: Problem in vendor Return process.

nabheetscn — Mon, 07 Apr 2014 06:59:52 GMT

cool so just check its value before calcaulting total as mentioned above