AnsweredAssumed Answered

Trying to Update Line Items in Portal

Question asked by AdamHorne on Jun 10, 2014
Latest reply on Jun 10, 2014 by philmodjunk

Title

Trying to Update Line Items in Portal

Post

     I'm using Filemaker to track Equipment.  Practically all of my items are part of a kit.  
      
     When "Kit A" is ordered, it comes with (2) "Item 1A" and (1) "Item1B" as a complete kit.  I've created an accessory table that stores all those records and when I add "Kit 1" to my order a script will fire off and add its accessories to the order with the default QTY.  All good.
      
     My problem is when I decide I need (2) Kit A's, after my script has ran.  It will duplicate the line items as such:
      
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
                         ITEM                          QTY
                         Kit A                          2
                         

                              Item 1A

                    
                         2
                         

                              Item 1A

                    
                         2
                         

                              Item 1B

                    
                         1
                         

                              Item 1B

                    
                         1

           

      
     My goal is for it just to update the accessory line and not duplicate it as such:
      
                                                                                                                                                                                                                                                                                                                                   
                         ITEM                          QTY
                         Kit A                          

                              2

                    
                         

                              Item 1A

                    
                         4
                         

                              Item 1B

                    
                         2
      
     My initial thoughts are to some how mark the accessory lines, delete them and rerun the script on the entire order.  However, this doesn't seem like the best option, especially if I have a large order and just update 1 item.  
      
     Is it possible to have the QTY as a calculation?  However, there are times when I can only send out (1) of Item 1A, although it typically ships with (2).
      
     Any suggestions would help.  Thanks.   

Outcomes