Error integration Invoice and Expense

lpnischida
lpnischida
Offline
1
When do I pay an invoice that damage the following error:

1054 Unknown column 'external_type' in 'where clause' SQL=SELECT id FROM solid_finances_items WHERE external_type = "com_invoices,3" AND external_id = 4

Then check the invoice appears in the Invoice Manager as paid, but does not appear in Expense Manager.
Responses (8)
  • Accepted Answer

    Thursday, July 02 2015, 10:46 AM - #Permalink
    0
    hello!

    sorry about this there's a small issue in this package, we are fixing it.
    meanwhile if you want to send me FTP access details at support@ joomlathat.com I will fix this issue for you right away.
    The reply is currently minimized Show
  • Accepted Answer

    lpnischida
    lpnischida
    Offline
    Thursday, July 02 2015, 12:17 PM - #Permalink
    0
    hi
    For now I am developing this site on localhost. What needs to be changed?
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, July 02 2015, 12:19 PM - #Permalink
    0
    there's a field in the DB which name is not correct, it needs to be changed. are you ok about modifying MySQL tables?
    The reply is currently minimized Show
  • Accepted Answer

    lpnischida
    lpnischida
    Offline
    Thursday, July 02 2015, 02:59 PM - #Permalink
    0
    Yes, explain to me what needs to be modified.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, July 02 2015, 06:09 PM - #Permalink
    0
    there's a field called "type" in the DB table called "#__finances_items"
    this field should be renamed to "external_type"
    The reply is currently minimized Show
  • Accepted Answer

    lpnischida
    lpnischida
    Offline
    Thursday, July 02 2015, 06:46 PM - #Permalink
    0
    OK, it worked
    But the name was filled with "payment inv.". There's no way to pull the name that is in the bill?

    The date also this setting today, but I launched the pmt last month, has no way to pull the date it was paid by invoice manager?
    • Germinal Camps
      more than a month ago
      it should be pulling the date from the payment (date in which the payment was "paid"). if does not do that maybe there's something we're missing... is there a way you can send me joomla access to support@ joomlathat.com so I can take a look?
    • lpnischida
      more than a month ago
      I'm still working on localhost, but I will play in production and step you access.
      I did some tests and its change the plugin integration for Invoice Total gross comes nr Invoice but the release date of the invoice and not the payment.
    • lpnischida
      more than a month ago
      Resolved, changed below:

      $ data ['date_item'] = $ row-> payment_datetime;

      But would that appears the name of the Invoice, not the number. This could not.
    • Germinal Camps
      more than a month ago
      you want the name of the customer to show, or the invoice number?
    • lpnischida
      more than a month ago
      Yes, I want the customer name (Recipient).
    Load more comments
    The reply is currently minimized Show
  • Accepted Answer

    barabano
    barabano
    Offline
    Saturday, July 04 2015, 11:52 AM - #Permalink
    0
    Hi


    is this a function in the normal extensions, or is this a custom order?
    • Germinal Camps
      more than a month ago
      it's a function of the extensions, in their EXTENDED version. it's not custom order.
    The reply is currently minimized Show
  • Accepted Answer

    barabano
    barabano
    Offline
    Sunday, July 05 2015, 11:40 AM - #Permalink
    -1
    hi

    how do i get this function, do i have to pay additional for the extended version?
    The reply is currently minimized Show
Your Reply