Author Topic: Payment Process  (Read 407 times)

Offline majeztic

  • Sr. Member
  • ****
  • Posts: 105
    • View Profile
Payment Process
« on: 28/January/2012, 02:58:57 PM »
I need advice on how to handle my quoting, ordering, invoicing, and payment processes.  I have customized nBill to be used for my home remodeling and repair business, so I may be utilizing some features of nBill in a manner other than designed.  For example I have adapted 'Orders' to mean 'Work Orders'.  It works well because I can progress bill as items are completed.  I understand that this may be outside the scope of support, so I am really just looking for advice or suggestions.

Where to start...?

Discounts:

I like to offer my customers discounts for services based on a number of factors including their location, and their repeat business with us.  I have setup a discount in the backend and it seems to work fine.  However, there doesn't seem to be a way to add or display this total discount on the Quotes I generate for my customers.  (am I missing something?).  I understand I can create a line item discount, but that requires manually adding a discount to each item and if it is a percentage discount (which most of mine are) it must be manually calculated.  Some of my quotes may be up to 20 or more line items, so adding them manually just isn't efficient.  Not to mention that the quote appearance in the front end looks bunched up with the extra columns and I would prefer to keep it consistant. 

One option that works is adding a product on the last line of my quote called '10% Discount' with a negative price.  This still has to be calculated manually, but it only has to be done once per quote.  One issue this causes is that if a customer rejects a few items, the discount amount remains the same, even though obviously the discount amount should be reduced because it is meant to be a percentage of the total.  So if a customer pays the deposit when accepting the quote, (and they have rejected items) the customer would be paying less than anticipated.

To combat this I have considered adding the discount as described above, then delete the '10% Discount' item on the order list and go into each remaining order item to add the global discount.  This is still not efficient, but it seems to work okay.  For this to work, I have to set the 'payment required to accept' to 'no' so that they can only pay from an invoice.  Which brings me to my next concern/question...

Payments:

I want to submit a quote, have the customer accept or reject it.  If accepted, I want to be able to take a payment (online or offline) for the deposit and auto-create the order items.  Then, when the work is completed, generate a final invoice for all order items minus the deposit paid.  However, if the customer chooses to pay offline, I do not see anyway to record the payment and associate it with that customer, quote, or order.  I have tried recording the payment in 'Income' with the customer's name.  Then, once the invoice is created, go back into the payment record and select the appropriate invoice; however, the dollar amount changes as soon as the invoice is selected and this process may lead to user error or omissions.

If I set 'payment required to accept' to 'yes' but do not auto create an invoice, the payment does not get recorded and I get an error message.

Invoices:

My only other option is to set both 'auto create orders' and 'auto create invoices' to yes.  However, as my work often changes when I get on site, I need to be able to easily change, remove, add, and update items and pricing.  Often times this happens before I even submit any invoice.  I would prefer not to generate any invoice until after we have completed some work, whether in part (as a progress bill) or in full (as a final invoice).

Any thoughts?  Am I missing something?

Thanks in advance,

Mike

Offline majeztic

  • Sr. Member
  • ****
  • Posts: 105
    • View Profile
Re: Payment Process
« Reply #1 on: 28/January/2012, 03:05:11 PM »
In addition:

I would be fine with giving my customers a voucher code to take the discount.  Is there any way to enter a voucher code when paying from a quote?

Offline netshine

  • Administrator
  • Hero Member
  • *****
  • Posts: 4,953
    • View Profile
Re: Payment Process
« Reply #2 on: 29/January/2012, 10:15:10 AM »
I don't think you are missing anything - nBill's quote feature is apparently not a perfect fit for your requirements. It sounds like most of your problems would be solved by simply allowing discount vouchers to be redeemed when paying an invoice or quote - this is on the 'to do' list, but has not yet been developed I'm afraid.

I don't have much time right now, but I will have a think about your point regarding offline payments, and experiment with it a bit.

Offline netshine

  • Administrator
  • Hero Member
  • *****
  • Posts: 4,953
    • View Profile
Re: Payment Process
« Reply #3 on: 30/January/2012, 09:23:42 AM »
The problem you are having with payments is that you are not generating the invoice until the end of the process - it is not possible to associate a new income record (for the deposit) with an invoice that does not exist yet. I think the best you can do is, when you have created the invoice, go back to the original income record for the deposit, and associate it with the invoice (which, as you say, updates the amounts, so there is some risk of user error). I will have to think about the implications of changing this so that amounts are not automatically updated when selecting an invoice for an income record that already exists.

Offline majeztic

  • Sr. Member
  • ****
  • Posts: 105
    • View Profile
Re: Payment Process
« Reply #4 on: 30/January/2012, 09:53:01 PM »
Thank you for your response.

I guess I will look forward to the changes you mentioned.  In the meantime, I will just create an income item when the payment is received, then go back in and apply it to the invoice after it is created.

Any idea of where on your to do list adding vouchers to quotes would be?  Just curious...

One more question, is there any problem with creating a product with a negative price to use as a discount?  Would this have any ill effects on other aspects of nbill?

Also, I just want to say thanks for all you help over the past few months.  Nbill is an excellent component and, now that I am using it on my live site, I appreciate how well it works.

Offline netshine

  • Administrator
  • Hero Member
  • *****
  • Posts: 4,953
    • View Profile
Re: Payment Process
« Reply #5 on: 31/January/2012, 07:51:45 AM »
I can't think of any problem with negative product prices - certainly a negative setup fee is fine, so I don't think you will run into any problems as long as the total amount to pay does not end up being less than zero.

Offline majeztic

  • Sr. Member
  • ****
  • Posts: 105
    • View Profile
Re: Payment Process
« Reply #6 on: 15/February/2012, 03:30:25 PM »
One final question on the subject...

If I set "Payment Required to Accept" to "Yes" and "Auto Create Invoice" to "No" and a customer chooses to pay "offline"...when I receive the payment and attempt to record it on the quote using the "awaiting payment" link on the quote list in the backend...I get the following error message:

"An invoice could not be generated for this quote. As a result, the quote status has been updated (pending items are now marked as accepted), but the receipt has not been recorded. You may need to create invoice and/or income records manually for this transaction."

This is expected because, as you already explained, there is not an invoice record to associate the payment with.  My question is:

If I set "Payment Required to Accept" to "Only if paid online" and "Auto Create Invoice" to "No", will the payment be processed without there being an invoice to associate it with?  What happens to the payment if they choose to pay by PayPal for example?  Will the payment still be processed, but not recorded in nBill, or will they get an error in PayPal?

Thanks in advance,

Mike

Offline netshine

  • Administrator
  • Hero Member
  • *****
  • Posts: 4,953
    • View Profile
Re: Payment Process
« Reply #7 on: 15/February/2012, 07:48:06 PM »
It is designed to be used with the 'auto create invoice' option switched on - I put the option to not generate an invoice there out of politeness more than anything! I cannot think of any reason why you would not want an invoice generated, and if you don't allow it to auto create invoices, some things might not work as designed.

Having said that, if nBill receives notification of a payment and there is no associated invoice, in most cases it should still create an income record. If 'Payment required to accept' is set to 'only if paid online', the quote will be marked as accepted immediately, but there will be no income record since nBill will not know when the payment is actually made. If they choose to pay by Paypal, the quote will not be marked as accepted until the payment confirmation is received from Paypal. If they say they are going to pay offline then make a payment with Paypal manually, nBill will know nothing about it so it won't do anything.

Offline majeztic

  • Sr. Member
  • ****
  • Posts: 105
    • View Profile
Re: Payment Process
« Reply #8 on: 01/March/2012, 04:24:49 PM »
One more question, is there any problem with creating a product with a negative price to use as a discount?  Would this have any ill effects on other aspects of nbill?

I have discovered a few issues with this.

First, a pre-sales discount should not be recorded in the ledger.  Creating a product with a negative price to be used as a discount puts the discount in the ledger report.

Second, the ledger report percentages for non-discounted ledger code items add up to more than 100% because the discounted ledger item has a negative percentage.  For example: if I offered discounts in an amount equal to 10% of my total income, my income will show as 110% and the discounts will show as -10% on the ledger report.  This is only an issue because I have a two income ledger codes (labor & sales) and it makes it difficult to decipher which income the discounts are applying to.

Third, there should be a method to track discounts independent of the ledger report.

Fourth, post-sales discounts (voucher codes on invoices, if implemented) SHOULD be recorded on the ledger report.  Otherwise, the expected income would be the more than the income received because the expected income would be the total amount of the invoice, prior to applying discounts.    
« Last Edit: 02/March/2012, 02:36:38 PM by majeztic »