How to retrieve the previous record in navision

4.7k views Asked by At

I'm new to navision, and I need need to retrieve the previous record from a table because I need its records. So my question is : how can I retrieve the record that's just before the one I'm working with?

explanation : I'm seaching but can't really find what I need on google. I actually can't use .GET() as one of the fields in the primary key varies from record to record. what I need to do is calculate the difference in a field form a record and the previous e.g :

curent record : total : 150 previous : total : 100

what I need to do is to retrieve the total of the previous record in order to store the difference in another record. current record : difference : 50

1

There are 1 answers

2
Mak Sim On BEST ANSWER

NEXT(-1)

Are you banned by google and microsoft simultaneously?