Tranferred QTY

fahd

Dear Experts,
In my tranfers when i click on print > Preview the qunatity is multiplying by 2.

Let take the scenario.

ITemno

---

-QTy
123

---

2

456

---

2

in this the total quantity should be 4 in the print out.

But in print out it is showing Total Qty as 8!!!!

Can anyone please let me know where can i modify the design???
thanks

Best Regards,
Fahd

mohana_cse06

the information is not clear..
is it a base report? if yes, which report?

MBerger

I am guessing you are talking about a custom report here. If you have a look at the Transfer Line table, you'll see there are 2 lines for each line in the transfer, outgoing and incoming. You'll have to filter out one of those to get the correct amount.

fahd

Dear mohana,
thanks for the urgent reply.it is is just transfer in and transfer out. There are some tranfers receving which are supposed to be posted in HO.

But when i am checking the print it is multiplying the actuall quantity with 2.


In transfers out from the total quantity is ok.

But In tranfers In it is showing like this in the print out.

mohana_cse06

fahd wrote:

Dear mohana,
thanks for the urgent reply.it is is just transfer in and transfer out. There are some tranfers receving which are supposed to be posted in HO.

But when i am checking the print it is multiplying the actuall quantity with 2.


In transfers out from the total quantity is ok.

But In tranfers In it is showing like this in the print out.

you mean to say posted transfer shipments?
is it a standard report or customized?

Did you check this?

I am guessing you are talking about a custom report here. If you have a look at the Transfer Line table, you'll see there are 2 lines for each line in the transfer, outgoing and incoming. You'll have to filter out one of those to get the correct amount.

fahd

no it is suupose to be posted.

it is not the posted one.onc i will post this then it will come to Posted Transfer Receipts.

n yes it was customized. i think there is a problem with the design or something.

I have attached the Snapshot. Kindly check and let me know!!!

kine

It seems that you are grouping the lines by item in the report, but you are working with all transfer order lines. You need to filter out the "hidden" lines which are created after first step is posted.

fahd

Orite Thanx Everyone!!! thanx for your help!!