RE:Seperate column

[Chanty4u]

Hi all ,

Sunny T

I have data like Paid and Received .  tables with the column names  for the month of April ... and i have same paid and recvd for every month .

PaidTable:

Date  ProductName  PaidAmount  

ReceivedTable:

Date  Productname  RecvdAmount

so now my requirement is:

1)  in paid table  having same product transaction is multiple times so i need to sum of the products amount in  Paid and Received tables

2) and i need create the column   PaidAmount-ReprievedAmount    as summary

and if     PaidAmount-RecievedAmount    is Negative  display as  Payable 

if it is positive   display as receivable

Thanks in advance

[Chanty4u]

Hi hirishv7,

this is exact requirment  can you help on this?

we need to have one table combining both Paid& Recvd as summary.   then need to have two different tables one for Recvd and one for Paid.  The summary table will have product wise “Receivable” column and “Payable” column.  If Recvd amount is greater than Payable  amount then the value will be in “Receivable” column else in “Payables” column.

Thanks

chanty

[HirisH_V7]

Hi Suresh ,

I can understand your'e Requirement half away, To make it clear can You make it on Excel or In form of any Columns and Grouping done between them.

-Hirish