Report no. 408-Sr. No. to Print

upasanisandipupasanisandip Member Posts: 405
Hi,

In report no. 408 Purchase - Receipt I want to print Sr. No. (From Item Tracking) .
Is it possible?

Any hint, susggessitions r welcome.

Thanks,
Sandip.

Answers

  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    You can try to print the Item Ledger Entries on your report.
  • upasanisandipupasanisandip Member Posts: 405
    Hi,
    I got solution for my question.

    Following is the code guys.

    ItemLedgerEntry.RESET;
    ItemLedgerEntry.SETFILTER(ItemLedgerEntry."Entry Type",'Purchase');
    ItemLedgerEntry.SETFILTER(ItemLedgerEntry."Document No.","Purch. Rcpt. Line"."Document No.");
    ItemLedgerEntry.SETFILTER(ItemLedgerEntry."Item No.","Purch. Rcpt. Line"."No.");
    Repeat


    if ItemLedgerEntry."Serial No."<>'' then
    Message (ItemLedgerEntry."Serial No.");

    Until ItemLedgerEntry.next=0;

    :D
  • ara3nara3n Member Posts: 9,257
    The code will work fine if the item no is not repeated on Purchase Receipt. If you have the same item on purchase receipts on two lines, it wont' work. You need to look at item relation table for line specific serial no.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.