Dear Sir,
My attached payment I wanted to attach the following way.
1) Account name is vendor name should take from Hire sheet on the basis of entry number from O column.
2) If error and vehicle numbers are from below mentioned list then account name should be Fuel Exps else “Entry Not Found”
3) If the fuel expenses then Column J should show Trip Exps else billing
4) If the column J is Trip exps then Column K Should show as s2 and column l should show the entry number instead of column o
5) Column w should be AS SAME AS ACCNT NAME but for vehicles from vehicle list should show as fuel exps.
My attached payment I wanted to attach the following way.
1) Account name is vendor name should take from Hire sheet on the basis of entry number from O column.
2) If error and vehicle numbers are from below mentioned list then account name should be Fuel Exps else “Entry Not Found”
3) If the fuel expenses then Column J should show Trip Exps else billing
4) If the column J is Trip exps then Column K Should show as s2 and column l should show the entry number instead of column o
5) Column w should be AS SAME AS ACCNT NAME but for vehicles from vehicle list should show as fuel exps.