Possible to make both SOURCE field name same for sales table and inventory table ?

[paulyeo11]

Hi All

I have a sales table with all field like company , invoice date , stock code , selling price , costing price , date of transaction and Source_sales field for group by country.

I also have a inventory table . Which also have stock code field , Qty on hand , Amount on hand and Source_stock field for group by country.

I have create a link key between both table , using stock code and Source_sales for sales table.

I also create a link key for Inventory table , using stock code and Source_stock , both link field are same.

Now the above is running fine. But the issue is Source_sales and Source_stock this field name are different.

I like to make the above field name dames.

Can some one advise me how ?

Paul

[avinashelite]

can you please share your app ?

[SreeniJD]

Hi Paul,

Qualify and Unqualify statements will be helpful to keep your field name same or different based on the requirement.

HTH

Sreeni

[jagan]

Hi Paul,

While loading just rename Source_sales  and Source_stock as Source, so that this fields will be joined.

Regards,

Jagan.

[paulyeo11]

Hi Jagan

I will try your suggestion.

Paul

Sent from my iPhone

[paulyeo11]

Hi Jagan

I change the below script :-

'TDSS' as SOURCE_STK,

To below :-

'TDSS' as SOURCE,

when i reload the script , it hung :-

[paulyeo11]

Hi Avinash

My issue is , for below field name :-

'TDSS' as SOURCE_STK,

I wish i can change to :-

'TDSS' as SOURCE,

Paul