Drill down from Vendor Ledger Entries

jeniez

Hi, I`m fairly new with Navisions so I don`t fully understand how it works. I`m trying to get the descriptions that I typed in the Puchase Invoice to show up in the Vendor Ledger Entries. But it seems to be not possible because Navision input a different description in the Vendor Ledger Entries. Then I though maybe if I could create a drill down from the Document No. of the Vendor Ledger Entries to drill back to its respective posted invoice and/or posted payments then I would get the same results. However, I tried to use the Object Designer to do that, but it doesn`t seem to work. Please helps. Thank you.

giulio.cipo

there are a field in the purchase invoice header "Posting Description" and this filed is in the description of vendor leger entry.
if you need a different description you coul create a field (type flowfield) with lookup to the field you want to show.witch field from witch table would you show? because i haven't undestand form your mail.
:roll:

jeniez

Thank you for your reply, but could you tell me exactly where the "Posting Description" is because I can`t seems to find it. Is it the same as the "Description" in the Purchase Invoice.

Oh, and sorry for the confusions. I want the descriptions from Posted Invoice of the Purchase and Payable module to show in the Vendor Ledger Entries.

And how would I go about to create the flowfield? Thank you.

giulio.cipo

the field is id 22 "Posting Description" text lengh 50 in table 38 and 122, probably isn't in the form so you shoud add it.

if the user write the description in this field, it will be insered automatically in the field description of vendor ledger entry.
In the table purchase header isn't a field with name description :?: , maybe is a field that you or someone else create ? if the id is form 1 to 9999 is a standard field, if id is form 10000 to 49999 is national localization field, if id is from 50000 to 99999 is a personalization ( a not standard field).

to create a flowflied you have to create a new field with fieldclass flowfield( in the properties) and in calcformula method lookup with the reference of table, field and filter

katbltan

Hi,

I manage to show "Posting Description" to fill in the free text. It has been extremely helpful

Is there anyway that I can automatically populate this field with the description keyed in the purchase invoice line items?

Edward_Bloomfield

Hi,

Unfortunately it is not possible to have the description from Sales/Purchase lines being used as the "posting description" or as the description from the Customer/Vendor ledger entries simply becuase:

Multiple Lines -> One Sales/Purchase Document -> One Customer/Vendor Ledger entry.

If you have five lines, you will still get only one Cust/Vendor Entry, and one line cannot show multiple descriptions (Logically impossible). The Posting Description is therefore only good as a "one line summary" of the whole order.

The idea of Navision is that the Customer/Vendor entries show just the transactions (Just the documents) and the G/L, Item, Resource and Fixed Asset show the actual detail - hence the "Navigate" button. To have multiple Vendor/Customer entries for one document when the information is elsewhere is "unrelational" and inefficent.

To do the drill down to Invoices/Credits, you need to do the following:

On the Document No. field of the Vend. Ledger Entry table, change the TableRelation property:

For invoices:
Condition:
Document Type=CONST(Invoice)

Table: Purch. Inv. Header

Tablefilter:
No.=FIELD(Document No.),
Posting Date=FIELD(Posting Date)

For credits:

Condition:
Document Type=CONST(Credit Memo)

Table:Purch. Cr. Memo Hdr.

Tablefilter:
No.=FIELD(Document No.),
Posting Date=FIELD(Posting Date)

You have to drill down to the Header. You cannot drill down to the lines, as there is no Posting date field on the Document Lines (You need to filter on the Posting Date).

...but adding drill down would be no more efficent than learning to use the Navigate button ...and will increase the cost of any future upgrade, so I would not do it.

Hope this is of help.