Can I create an invoice from an order?

Help
2003-10-22
2003-10-23
  • Blossom Merz
    Blossom Merz
    2003-10-22

    Preface: It may very well be that I just don't know what I'm doing.

    When I enter an order from a customer, pack it and ship it, I would then like to create an invoice for that order.

    It seems like the act of placing an order would automatically create an invoice, or that there would be some way to create an invoice from an order.

    Am I missing something? Do I really need to go into billing and create the invoice by hand after processing the order?

    Thanks for your help.
    blossom

     
    • Chan Min Wai
      Chan Min Wai
      2003-10-23

      There is a reason I believes, people would only send 1 invoice per month or per contract. This is Why an Order don't Automatically Generate Invoice.

      But it would be nice to have a function to Just simply include the Order that have been process to the Invoice.

      Let me Explain more on this.
      When clicking on Billing and after inputing the customer number, input the invoice number (which should be generated in later version)
      The it will just have a list of order that you would like to include them in this invoice.  Isn't that Nice :)

      If you can really do this, it would really please everyboady :)

      Thank You.

       
      • Blossom Merz
        Blossom Merz
        2003-10-23

        I'll spend the day tomorrow seeing how I can do this.

        Can you point me at any documentation of the database table relationships and general process flow? It'll take me much longer if I have to reverse engineer everything to implement this.

        Thanks for your help.
        Blossom Merz

         
    • Chan Min Wai
      Chan Min Wai
      2003-10-23

      Ok the files related are
      arfunctions.php    (Account Receiveable Function Class)
      invfunctions.php  (Inventory Function Class)
      arinvoiceadd.php (Account Receiveable Invoice Add File)

      Table related are
      arorder :
      id --> Order ID
      orderbycompanyid ---> Customer ID
      status --> Order is complete/Open (Not too sure)
      companyid --> Our Company id (need to be defined, even if you are not multi-company)
      cancel --> If order is canceled.

      arorderdetail :
      orderid --> Trace back to Table arorder.id
      qtyorder --> Quantity Order
      qtyship --> How many have been ship
      qtybill --> How many have been bill
      glaccountid --> Add to what Gl Account?
      costeach, priceach --> (dependent on software but still unclear what it is for)
      entrydate (use full for detail Order Date)