Hi Bernadette,
On Mon, Dec 10, 2018 at 3:45 AM Bernadette Nicole Rivera <
brivera(a)multistylespecialist.com> 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 <
brivera(a)multistylespecialist.com> 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 <
brivera(a)multistylespecialist.com> 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
------------------------------
[image: Avast logo] <https://www.avast.com/antivirus>
This email has been checked for viruses by Avast antivirus software.
www.avast.com <https://www.avast.com/antivirus>
<#m_-8171588536811827517_m_-8127780245465009264_m_-5468919492833242055_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
_______________________________________________
users mailing list
users(a)lists.ledgersmb.org
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.