Jump to content
Sign in to follow this  
angelleye

I think a calc. is what I need..?? Need some help with this goal...

Recommended Posts

I've got a table for InvoiceItems and another table called Scans. These tables are related by ScanID.

The Scans table includes a field called Status that binds to a value list with values of: RMA, Post, Tech, and Sold.

What I need to make happen is that as soon as item as added into InvoiceItems (added to an invoice in our system) it sets the status for that item in Scans to Sold based on ScanID.

Any information on how I can accomplish this with as little lag as possible (sometimes calc. fields slow me down quite a bit) would be greatly appreciated. Thanks!

Share this post


Link to post
Share on other sites

Actually, I think I'm gonna add this into a script throughout the process of marking the invoice as ready to ship. How can I delete this thread? I don't see the option for that..??

Share this post


Link to post
Share on other sites

Since you want to mark all the related records that you have selected to be invoiced, as Sold on your invoice processing script, you can have your script find the set of invoices ready to be shipped. Then you can use GTRR to display all the related items from your Scan Table. You can then use the Replace contents step to replace the status fields to "Sold"

Be sure to add in error checks to see if there are no related records etc. Also I would make sure that you make a backup copy and tinker with that until you are sure you have the script down pack. You can not undo a replace field contents.

Share this post


Link to post
Share on other sites

actually, the script thing isn't working out like I had hoped it would because of some other things getting in the way with our process here.

Is there a way to do this with a calc. :)

Share this post


Link to post
Share on other sites

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

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.