Re: [ledgersmb-users] LedgerSMB Concerns (Accounts Receivable)

Hi Bernadette,

On Mon, Dec 10, 2018 at 3:45 AM Bernadette Nicole Rivera <..hidden..> wrote:

Hi Erik,

Good day!

We would like to totally delete the VOIDED INVOICED because it's just the sample to demonstration for our accountant on how to create invoice.

Ok. In general, I think it's a better idea to set up a training database for your accountant(s) [and other users] to play around in. That way, training results don't get mixed with production data. Such copies of companies are easily created by using the "Copy" button in the setup.pl application.

If you have direct database access, you need to find out the "id" of the VOIDED INVOICED, by:

SELECT id FROM ar WHERE invnumber = '4-VOID'; -- or whatever your invoice number is (6553-VOID?)

Then using the outcome, you need to:

DELETE FROM acc_trans WHERE trans_id = <the id>;

DELETE FROM ar WHERE id = <the id>;
DELETE FROM transactions WHERE id = <the id>;

The above assumes you didn't make any payments and that the transaction isn't an invoice. If your transaction is also an invoice, you need to execute 1 more statement before the three statements above:

DELETE FROM invoice WHERE trans_id = <the id>;

Please note that you should *only* do this on a copy database. Then, when successful, move the copy into production. NEVER do this on a live database. Also make sure that no new transactions can be entered into the production database while you're cleaning the copy: once the database moves back into place, the edits will get lost.

Hope that helps,

Erik.

Thanks,

On 12/3/2018 5:19 AM, Erik Huelsmann wrote:

Hi Bernadette,

I'm sorry for the lag on my reply. Could you explain what you mean by VOIDED INVOICED has the wrong sequence number? Is it that "4-VOID" is a number you dislike or are not allowed to use? What number would you want LedgerSMB to generate in the future?

As for being able to delete invoices: no, that's not really easy. The problem with deletion is that some small companies want it, but some larger companies can't allow it. We have a feature request open to adjust the software so both use-cases will become possible in the future. For now, deletion is only possible through database access by one of the developers or a consultant. Anyone in that group may be able to set the invoice number to be the correct number/sequence without the need for deletion, btw.

Regards,

Erik.

On Thu, Nov 29, 2018 at 4:32 AM Bernadette Nicole Rivera <..hidden..> wrote:

Hello Erik,

Good day!

Is it possible to delete the VOIDED INVOICED? I want to delete the VOIDED INVOICED that has wrong invoice sequence number.

Hoping for your quick response, thank you!

On 11/29/2018 5:17 AM, Erik Huelsmann wrote:

Hi Bernadette!

Thank you for mailing your question to our mailing list. I'll provide you with the answer as to how I understand your situation from the screenshots you sent:

First, you created a sales invoice (AR) which was given number 4. Then you discovered the numbers in the invoice were incorrect, so you clicked the VOID button on the invoice. You expected the invoice to be removed from the list of "open" (unpaid) AR items. However, from your screenshots, I see they are still there.

(Is that what happened?)

If that's what happened, the following is the (not too great) solution: If you go to the Cash -> Receipts screen and select the customer of these invoices 4 and 4-VOID, you end up in a screen which allows you to enter a payment. Now, in that screen select the invoices 4 and 4-VOID. The total of the payment should indicate "0" (zero). Then, select an account and a payment date and click POST.

The result is that you've used the negative AR amount from invoice 4-VOID to close the positive amount of invoice 4. There's a payment in the system, but the payment is net-zero. If you use an otherwise-unused account to record the transaction, there will be nothing in the books and the account will show a zero-balance both before and after the payment.

Hope that helps!

Regards,

Erik.

On Mon, Nov 26, 2018 at 7:29 AM Bernadette Nicole Rivera <..hidden..> wrote:

Hi Team,

I'm one of the Administrator of LedgerSMB System here in the Philippines. We have concerns with regards to the Accounts Receivable, we were unable to delete VOID INVOICED(wrong inputs) and Invoiced (due to wrong inputs of the sequence of the invoice number). Please see attached file for your reference.

Hoping for your quick response for this matter.

Thank you,

--

Best Regards,

Bernadette Nicole C. Rivera
IT Support L1
Multistyle Specialist Inc.

+639289698563 / (02) 641-6515

This email has been checked for viruses by Avast antivirus software.
www.avast.com

_______________________________________________
users mailing list
..hidden..
https://lists.ledgersmb.org/mailman/listinfo/users

--

Bye,

Erik.

http://efficito.com -- Hosted accounting and ERP.

Robust and Flexible. No vendor lock-in.

--

Best Regards,

Bernadette Nicole C. Rivera
IT Support L1
Multistyle Specialist Inc.

+639289698563 / (02) 641-6515

--

Bye,

Erik.

http://efficito.com -- Hosted accounting and ERP.

Robust and Flexible. No vendor lock-in.

--

Best Regards,

Bernadette Nicole C. Rivera
IT Support L1
Multistyle Specialist Inc.

+639289698563 / (02) 641-6515

Bye,

Erik.

http://efficito.com -- Hosted accounting and ERP.

Robust and Flexible. No vendor lock-in.