Group documents based on field from another table

elma
elma Member Posts: 12
edited 2004-06-16 in Navision Attain
Dear friends,

I need some help.
I have to redesign report 4 "Detail Trial Balance", just to display totals for documents, not for every line. It works fine ("GroupTotalFields":"Document No." etc.), but

- in case of incoming/purchase documents, I need to sumarize amounts for documents with same "Blanket Order No."

I tried something with a lot of code inside OnAfterGetRecord for "G/L Entry", but I feel that I am on wrong road

Is there any possible way to group records on outer criteria, based on a field from another table???

In this case, that is just for purchase documents, but G/L accounts operates with all kinds of documents...


Any ideas

Thanks,
Elma

elma.cigic@bbs.ba
BBS Sarajevo, Bosnia & Herzegovina

Comments

  • afarr
    afarr Member Posts: 287
    I haven't looked at this in much detail, but what about inserting Purchase Header (maybe filtered to show only Blanket Orders) as a data item above G/L Entry. Then group Purch. Hdr. by Document No.

    Just a thought.

    Alastair
    Alastair Farrugia

Categories