1 Reply Latest reply on Nov 24, 2012 2:37 PM by philmodjunk

    Alter price and quantity in stock

    HelderSantos

      Title

      Alter price and quantity in stock

      Post

      Hello everybody, I am facing a new problem.
           a system to sell products from a store, how do I change the price of the product in stock, without change in the bills sold. I need to increase or decrease the price of some products, but without altering the invoices already sold.
      then i pretend alter de stock quantity.

           How can i make it?

            

           Best regards...

        • 1. Re: Alter price and quantity in stock
          philmodjunk

               Each new sales transaction should copy the current price into a record of a different table. Thus changes to your pricing information only affect new sales transactions.

               Have you looked at how the Invoices starter solution manages sales transactions and price changes?

               basic relationships for an invoicing system usually take this form:

               Clients------<Invoices----<LineItems>-------Products_Services

               In the FileMaker 12 Invoices starter solution, LineItems is named Invoice Data instead. A portal to LineItems is placed on the invoices layout for listing each item purchased on a given invoice. Pricing info is stored in the Products_Services table and a data lookup copies the price from it to LineItems each time a ProductID is entered into a row in the LineItems portal.