Link Between Value Entry and Sales Invoice Line

slmaluwa

Hi
Anybody has any idea of how to link back to the Sales Invoice Line from a Value Entry record.
I trying to find the way to get info from the original Sales Invoice Line for each line of related entry in Value ENtry table.

Thank you

bbrown

See table 6508 "Value Entry Relation" and the function RowID1 on table 113 "Sales Invoice Line"

slmaluwa

Hi Brown

I don't see any data in Value Entry Relation table. But, our VE table has millions of records. Ours is W1 4.0 SP3 edition.
I checked the RowID1 function. What do I do from there?

TIA ](*,)

David_Singleton

Try using the fields Document Type, Document No. and Documents Line No. in the value entry which directly link back to the sales invoice line.

ouredp

Hello ,

As far as I know these Reference Fields are only avaible in 5.0

We have spend a lot of programming efforts in 4.3 to compute Cost Values on Sales Invoice Line Level.
The major "trick" is to go thru the Shipment Lines for the S.I. Line and then find out the Value Entries.

If someone knows a way to implement the 5.0 Reference Fields without completely Upgrading
to 5.0 please let us know !

David_Singleton

ouredp wrote:

If someone knows a way to implement the 5.0 Reference Fields without completely Upgrading
to 5.0 please let us know !

I havent specifically looks at the code using in 5.00, but I have implemented similar functionality in earlier versions of Navision.

Just modify the posting routines to carry the filed through as required.

kapamarou

I think that table 6508 Value Entry Relation is only filled for items that require Item Tracking (i.e. Serial No.)