LedgerSMB Concerns (Accounts Receivable)
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,
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@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_-5468919492833242055_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> _______________________________________________ users mailing list users@lists.ledgersmb.org https://lists.ledgersmb.org/mailman/listinfo/users
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@multistylespecialist.com mailto:brivera@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 ------------------------------------------------------------------------ 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_-5468919492833242055_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> _______________________________________________ users mailing list users@lists.ledgersmb.org <mailto:users@lists.ledgersmb.org> https://lists.ledgersmb.org/mailman/listinfo/users-- Bye,
Erik.
http://efficito.com http://efficito.com/ -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.
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@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@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_-8127780245465009264_m_-5468919492833242055_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> _______________________________________________ users mailing list users@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
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.
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@multistylespecialist.com mailto:brivera@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@multistylespecialist.com <mailto:brivera@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 ------------------------------------------------------------------------ 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_-8127780245465009264_m_-5468919492833242055_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> _______________________________________________ users mailing list users@lists.ledgersmb.org <mailto:users@lists.ledgersmb.org> https://lists.ledgersmb.org/mailman/listinfo/users -- Bye, Erik. http://efficito.com <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 http://efficito.com/ -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.
Hi Bernadette,
On Mon, Dec 10, 2018 at 3:45 AM Bernadette Nicole Rivera < brivera@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@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@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@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
Hi Erik,
Also, I'm still having a hard time updating and posting the updated information in receipts under the CASH Module.
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@multistylespecialist.com mailto:brivera@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@multistylespecialist.com <mailto:brivera@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 ------------------------------------------------------------------------ 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_-8127780245465009264_m_-5468919492833242055_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> _______________________________________________ users mailing list users@lists.ledgersmb.org <mailto:users@lists.ledgersmb.org> https://lists.ledgersmb.org/mailman/listinfo/users -- Bye, Erik. http://efficito.com <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 http://efficito.com/ -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.
Hi Bernadette,
On Mon, Dec 10, 2018 at 4:01 AM Bernadette Nicole Rivera < brivera@multistylespecialist.com> wrote:
Hi Erik,
Also, I'm still having a hard time updating and posting the updated information in receipts under the CASH Module.
Can you explain which steps you went through and what output you saw (and in what way that deviates from what you had expected)? I'm not really sure what could be your problem here.
Regards,
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@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@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_2033908968359658796_m_-8127780245465009264_m_-5468919492833242055_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> _______________________________________________ users mailing list users@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
Hi Erik,
I'm having a hard time in posting the solution/s that you've shared on this thread. Here's the error that I've encountered, please see attached file for your reference.
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@multistylespecialist.com mailto:brivera@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 ------------------------------------------------------------------------ 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_-5468919492833242055_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> _______________________________________________ users mailing list users@lists.ledgersmb.org <mailto:users@lists.ledgersmb.org> https://lists.ledgersmb.org/mailman/listinfo/users-- Bye,
Erik.
http://efficito.com http://efficito.com/ -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.
On 2018-11-28 21:45, Bernadette Nicole Rivera wrote:
Hi Erik,
I'm having a hard time in posting the solution/s that you've shared on this thread. Here's the error that I've encountered, please see attached file for your reference.
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@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
[1]
This email has been checked for viruses by Avast antivirus software. www.avast.com [1]
users mailing list users@lists.ledgersmb.org https://lists.ledgersmb.org/mailman/listinfo/users
--
Bye,
Erik.
http://efficito.com [2] -- 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
Links:
[1] https://www.avast.com/antivirus [2] http://efficito.com/
Hi Erik,
Good day!
A gentle follow up regarding my concern to LedgerSMB.
Thank you!
Hi Bernadette,
I'm sorry you're still having issues! I'm trying to understand (without seeing your screen) what your situation is. I can see the error screen, but not which steps you went through to create that error. Could you create a list of steps you went through before the error? Something along these lines:
1. I log into LedgerSMB 2. I follow the menu Cash > ... 3. I click on ... 4. I see the error
Now I really need you to fill in the gaps of the list of actions above (or create your own list). Because from the error, I can't see what you did, which means I can't help you resolve the problem. (I tried to explain on 10 December; maybe we should have a skype or other chat to be able to help you more quickly?)
Regards,
Erik.
On Wed, Jan 2, 2019 at 9:34 AM Bernadette Nicole Rivera < brivera@multistylespecialist.com> wrote:
On 2018-11-28 21:45, Bernadette Nicole Rivera wrote:
Hi Erik,
I'm having a hard time in posting the solution/s that you've shared on this thread. Here's the error that I've encountered, please see attached file for your reference.
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@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
[1]
This email has been checked for viruses by Avast antivirus software. www.avast.com [1]
users mailing list users@lists.ledgersmb.org https://lists.ledgersmb.org/mailman/listinfo/users
--
Bye,
Erik.
http://efficito.com [2] -- 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
Links:
[1] https://www.avast.com/antivirus [2] http://efficito.com/
Hi Erik,
Good day!
A gentle follow up regarding my concern to LedgerSMB.
Thank you!
Best Regards, Bernadette Nicole C. Rivera IT Staff +63 977 779 2538
participants (2)
-
Bernadette Nicole Rivera -
Erik Huelsmann