Tranferred QTY

fahd
fahd Member Posts: 226
edited 2011-03-05 in Navision Attain
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

Comments

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    the information is not clear..
    is it a base report? if yes, which report?

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • MBerger
    MBerger Member Posts: 413
    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
    fahd Member Posts: 226
    edited 2011-02-28
    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
    mohana_cse06 Member Posts: 5,506
    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.

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • fahd
    fahd Member Posts: 226
    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
    kine Member Posts: 12,562
    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.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • fahd
    fahd Member Posts: 226
    Orite Thanx Everyone!!! thanx for your help!!

    :)

Categories