1 Reply Latest reply on Dec 19, 2013 9:21 AM by philmodjunk

    Help with invoicing and inventory automation.

    DavidKinally

      Title

      Help with invoicing and inventory automation.

      Post

           Still ironing out some tweaks to this system I'm building.

           I have an Inventory table containing details about the items. This includes a stock level and a reorder level.

           My invoice table contains a portal to my invoicelineitem table as the standard. 

            

           I would like to start an invoice and add an item with its QTY. then i would like that QTY to automatically deduct from the inventory stock. As simple as this sounds i cannot figure out a way because when we buy in more of the stock i would like to add it on to the stock as well.

            

           Whats the best way to do this??

            

           Thanks

                      
                     Preferences
      §
      1
      2
      3
      4
      5
      6
      7
      8
      9
      0
      -
      =
      Backspace
                           
      Tab
      q
      w
      e
      r
      t
      y
      u
      i
      o
      p
      [
      ]
                                
      Return
                                
                           
      capslock
      a
      s
      d
      f
      g
      h
      j
      k
      l
      ;
      '
      \
                           
      shift
      `
      z
      x
      c
      v
      b
      n
      m
      ,
      .
      /
      shift
                           
                                
                               English
                                     
                                     
      alt
      alt
                           
                      
                     Preferences