Going from Value Entry to Posted Sales Invoice line

c.kestas

I am looking for a link that would enable me to locate the Sales Invoice Line record that generated a value entry.

The document number on the Value Entry is not a reliable link because the same number could appear on different documents.

The Value Entry number is not saved on the Sales Line as I would expect, either.

Any ideas?

Monsta

Unfortunately there is no other link, just posting date + document no. Could you explain what you're trying to achieve. Maybe there is another way.

c.kestas

Basically I want to create a report of Sales Transactions by Item.

The problem is that I have added some new fields on the Sales Lines table that get propagated during posting to the Posted Shipment/invoice/cr.memo/Return Rcpt. These new fields must be shown on the report I want to create.

One way to do the report would be to go through the above posted documents. Going through the Item Ledger and Value Entry table however would be easier because one would go through all entries of the same item in one go. Furthermore, this approach would give a more complete picture in terms of all quantity and values.

wakestar

check out table 6508 Value Entry Relation

Monsta

Table 6508 Value Entry Relation is only used for items with tracking.

wakestar

TRUE

lakshmivalluru

same document can be appearing BUT not for the same customer.So try using the following fields:

Item Ledger Entry Type - Sale
Source Type - Customer
Source No - (Customer no)
Document No.
Posting Date.

Monsta

The best solution is to modify posting procedure so you new customized fields appear in Item Ledger Entry and/or Value Entry tables.

Marije_Brummel

Monsta wrote:

The best solution is to modify posting procedure so you new customized fields appear in Value Entry table.

I agree, this is the best way to go.

If you do this, please note that value entries are created at more than one place in Navision, unlike the normal entries.

Succes