rmconlon Posted January 26, 2005 Share Posted January 26, 2005 Here is my problem. I am creating a system of accounting statments. From each statement a specific amount is held back for 1 year and then liquidated. I am trying to figure out a way to look up the old statements and fill in the liquidation amount 1 year later. For example: Statement 1 - Date 1/1/2003 - $100 held for liquidation Statement 2 - Date 1/1/2004 - Need to have automatic lookup to 1 year previous and plug in $100 Any suggestions? I would like this to be either automatic, or trigger a script to lookup the value from the previous statement and insert it into the new statement. Link to comment Share on other sites More sharing options...
This topic is 6636 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now