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
NEXT(-1)
Are you banned by google and microsoft simultaneously?