FrontAccounting forum — How to enter a payment for a credit note?

Re: How to enter a payment for a credit note?

null@example.com (JimmyC) — Sun, 02 Jun 2019 19:30:02 +0000

@Joe

Yes! It works!

A thousand "Thank You"s!

/JimmyC

Re: How to enter a payment for a credit note?

null@example.com (joe) — Sun, 02 Jun 2019 16:35:49 +0000

This has now been fixed. Committed to stable repo.

The fixed two files can be downloaded here and here.

/Joe

Re: How to enter a payment for a credit note?

null@example.com (JimmyC) — Sun, 02 Jun 2019 15:26:35 +0000

@Joe

The Supplier Credit Notes form also shows the same amount as the Invoice form.

/JimmyC

Re: How to enter a payment for a credit note?

null@example.com (joe) — Sun, 02 Jun 2019 14:58:11 +0000

@JimmyC.
Ah, now I understand what you mean. It is the presentation of the Suppliers Balance that is wrong when entering a Suppplier Invoice.

The Supplier Balance reports are ok.

I will check the algorithm for calculating the suppleir balance in the Supplier Inovice form.

/Joe

Re: How to enter a payment for a credit note?

null@example.com (JimmyC) — Sun, 02 Jun 2019 13:46:27 +0000

@Joe

I downloaded the latest snapshot, replaced all old files with the new snapshot files.
Logged into FA and entered a supplier credit note for $22.89 USD.
Opened the Supplier Invoices screen and it showed Current Credit: $22.89.
Went to Banking and General Ledger -> Deposits and selected Supplier -> Home Depot.
Defaulted to 2010 Accounts Payable and entered Amount -> 22.89 -> Process Deposit.
Went to Purchases -> Supplier Invoices and Current Credit was $45.78.
Went to Purchases -> Allocate Supplier Payments or Credit Notes -> Home Depot.
Only one line displayed Supplier Credit Note : Home Depot : Total : 22.89 : Left to Allocate : 22.89.
Clicked the "Allocate" icon and entered the Allocation screen where I entered 22.89 into the "This Allocation" box -> Process.
The screen cleared and "no records".
Went to Purchases -> Supplier Invoices and Current Credit was $45.78.

As you can see, after entering the latest snapshot, there is no difference in output.

As a side note, I can reason why a Deposit by a Supplier causes a Credit. But I can't understand why we have to do both processes? That is, I create a Supplier credit note and then the system automatically creates another credit note from the Deposit but the "allocation" process does not balance out either one. I really do not know how it is supposed to be done correctly by Bookkeeping rules.

Good luck and thank you for working on it.

/JimmyC

Re: How to enter a payment for a credit note?

null@example.com (joe) — Sun, 02 Jun 2019 06:23:00 +0000

Hello,

I cannot reproduce this on my fresh copy of FA.

Please download the snapshot from our master repo here:

https://sourceforge.net/p/frontaccounting/git/ci/master/tree/ [^]

The error you are reporting has been fixed during this 2.4.5 or 6 period.

Please try if you can reproduce the error in the above snapshot.

I hope so. We will ship a new minor release asap.

Regards
Joe

Re: How to enter a payment for a credit note?

null@example.com (apmuthu) — Fri, 31 May 2019 04:02:17 +0000

The functions supplier_credit_rowand customer_credit_row() are defined in includes/ui/ui_input.inc in lines 982-1004.

The link for the supplier_credit_row() is like:

purchasing/inquiry/supplier_inquiry.php?supplier_id=###

The actual value of $credit is being passed into the said functions from/by the calling script which in this case appears to be twice the value it should report..

The supplier_credit_row() is called in:

purchasing/includes/ui/po_ui.inc line 145 (function display_po_header(&$order)):
    supplier_credit_row($order->supplier_id, $order->credit);

purchasing/includes/ui/invoice_ui.inc line 160 (function invoice_header(&$supp_trans)):
    supplier_credit_row($supp_trans->supplier_id, $supp_trans->credit);

Re: How to enter a payment for a credit note?

null@example.com (joe) — Thu, 30 May 2019 22:48:29 +0000

We are monitoring this. Please help me with a solution, if you can?

/Joe

Re: How to enter a payment for a credit note?

null@example.com (apmuthu) — Thu, 30 May 2019 16:15:44 +0000

@joe: ??

Re: How to enter a payment for a credit note?

null@example.com (JimmyC) — Thu, 30 May 2019 15:29:33 +0000

Thank you @Braath Waate!

I opened a bug report #0004895 and referenced this topic discussion.

/JimmyC

Re: How to enter a payment for a credit note?

null@example.com (Braath Waate) — Thu, 30 May 2019 14:36:13 +0000

Its a bug. I suggest you open a bug report on http://mantis.frontaccounting.com/ referencing your post so it doesn't get lost.

Re: How to enter a payment for a credit note?

null@example.com (JimmyC) — Tue, 28 May 2019 13:49:41 +0000

To try to make it faster and I hope simpler, I've pasted below the General Ledger entries for that day. To me, everything looks correctly balanced and should not show when I click Purchases -> Supplier Credit Note -> "Current Credit: -45.78". This Current Credit amount is exactly twice the amount of the refund of $ 22.89.

Type         #    Reference      Date             Account             Person/Item             Debit         Credit

Supplier    248    SI19053    04/26/2019    2010 AP        Supplier [00020] HD                     81.29
Invoice
Supplier    248    SI19053    04/26/2019    8200 BldExp    Supplier [00020] HD        81.29
Invoice
Supplier    247    SP19053    04/26/2019    2010 AP         Supplier [00020] HD        81.29
Payment
Supplier    247    SP19053    04/26/2019    1010 OprAcct    Supplier [00020] HD                  81.29
Payment
Supplier    2      SCN19001    04/26/2019    2010 AP         Supplier [00020] HD        22.89
CreditNote    
Supplier    2      SCN19001    04/26/2019    8200 BldExp    Supplier [00020] HD                  22.89
CreditNote    
Bank        42     BD19001    04/26/2019    2010 AP        Supplier [00020] HD                     22.89
Deposit
Bank        42     BD19001    04/26/2019    1010 OprAcct    Supplier [00020] HD        22.89

If anyone experiences this or if anyone knows what I am obviously doing incorrectly, please enlighten me, it would be greatly appreciated.

Thank you,
/JimmyC

Re: How to enter a payment for a credit note?

null@example.com (JimmyC) — Mon, 27 May 2019 15:23:45 +0000

If this can help at all, below is the Generate Patch output using WinMerge of just the Credit Note entry using the procedure that was explained above:

50c50
< ) ENGINE=InnoDB AUTO_INCREMENT=391 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=392 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
444c444,445
< ('390', '20190426-DC1 BBC Paint & Supplies', '20', '248', 'wI9l3HH8HXnHa-RC6AEXygxx', '2019-05-21', '20190426 HomeDepot Paint wRefund.pdf', '1625934', 'application/pdf');
---
> ('390', '20190426-DC1 BBC Paint & Supplies', '20', '248', 'wI9l3HH8HXnHa-RC6AEXygxx', '2019-05-21', '20190426 HomeDepot Paint wRefund.pdf', '1625934', 'application/pdf'),
> ('391', '20190426-DC Credit Note Refund cn', '21', '2', 'xIE1HNAJEo-wPesCnCYCFwxx', '2019-05-24', '20190426 HomeDepot Paint wRefund.pdf', '1625934', 'application/pdf');
463c464
< ) ENGINE=InnoDB AUTO_INCREMENT=5204 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=5207 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
5675c5676,5679
< ('5203', '22', '247', '1', '2019-05-21 08:21:20', NULL, '7', '2019-04-26', '0');
---
> ('5203', '22', '247', '1', '2019-05-21 08:21:20', NULL, '7', '2019-04-26', '0'),
> ('5204', '21', '2', '1', '2019-05-24 17:58:44', NULL, '7', '2019-04-26', '0'),
> ('5205', '2', '42', '1', '2019-05-24 22:19:05', NULL, '7', '2019-04-26', NULL),
> ('5206', '2', '42', '1', '2019-05-24 22:19:05', NULL, '7', '2019-04-26', '0');
5740c5744
< ) ENGINE=InnoDB AUTO_INCREMENT=2111 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=2112 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
7857c7861,7862
< ('2110', '22', '247', '1', 'SP19053', '2019-04-26', '-81.29', '0', '0', '3', '20', NULL);
---
> ('2110', '22', '247', '1', 'SP19053', '2019-04-26', '-81.29', '0', '0', '3', '20', NULL),
> ('2111', '2', '42', '1', 'BD19001', '2019-04-26', '22.89', '0', '0', '3', '20', NULL);
11088c11093,11095
< ('22', '247', '2019-04-26', '20190426-DC1 BBC Paint');
---
> ('22', '247', '2019-04-26', '20190426-DC1 BBC Paint'),
> ('21', '2', '2019-04-26', '20190426-DC Credit Note Refund cn'),
> ('2', '42', '2019-04-26', '20190426-DC Bank Deposit Refund bd');
18419c18426
< ) ENGINE=InnoDB AUTO_INCREMENT=6344 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=6348 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
24772c24779,24783
< ('6343', '22', '247', '2019-04-26', '1010', '', '-81.29', '0', '0', NULL, NULL);
---
> ('6343', '22', '247', '2019-04-26', '1010', '', '-81.29', '0', '0', NULL, NULL),
> ('6344', '21', '2', '2019-04-26', '2010', '', '22.89', '0', '0', '3', '20'),
> ('6345', '21', '2', '2019-04-26', '8200', '20190426-DC Credit Note Refund cn', '-22.89', '7', '1', NULL, NULL),
> ('6346', '2', '42', '2019-04-26', '2010', '20190426-DC Bank Deposit Refund bd', '-22.89', '7', '1', '3', '20'),
> ('6347', '2', '42', '2019-04-26', '1010', '20190426-DC Bank Deposit Refund bd', '22.89', '0', '0', NULL, NULL);
25668a25680
> ('42', '2', 'BD19001'),
27449,27450c27461
< ('486', '12', 'CP18208'),
< ('487', '12', 'CP18209');
---
> ('486', '12', 'CP18208');
27451a27463
> ('487', '12', 'CP18209'),
28245a28258
> ('2', '21', 'SCN19001'),
32123c32136
< ) ENGINE=InnoDB AUTO_INCREMENT=249 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=250 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
32374c32387,32388
< ('248', '20', '81.29', '2019-04-26', '247', '22', '248', '20');
---
> ('248', '20', '81.29', '2019-04-26', '247', '22', '248', '20'),
> ('249', '20', '22.89', '2019-04-26', '2', '21', '42', '2');
32397c32411
< ) ENGINE=InnoDB AUTO_INCREMENT=251 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
---
> ) ENGINE=InnoDB AUTO_INCREMENT=252 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
32650c32664,32665
< ('250', '248', '20', '8200', '-1', '0', '', NULL, '0', '81.29', '0', '20190426-DC1 BBC Paint & Supplies', '8', '4');
---
> ('250', '248', '20', '8200', '-1', '0', '', NULL, '0', '81.29', '0', '20190426-DC1 BBC Paint & Supplies', '8', '4'),
> ('251', '2', '21', '8200', '-1', '0', '', NULL, '0', '-22.89', '0', '20190426-DC Credit Note Refund cn', '7', '1');
32685a32701
> ('42', '2', '20', 'BD19001', '', '2019-04-26', '0000-00-00', '22.89', '0', '0', '1', '22.89', '0'),
32933a32950
> ('2', '21', '20', 'SCN19001', '20190426-DC cn', '2019-04-26', '2019-04-26', '-22.89', '0', '0', '1', '22.89', '1'),
33147,33149c33164
< ('214', '22', '49', 'SP19020', '', '2019-02-25', '2019-02-25', '-43.33', '0', '0', '1', '43.33', '0'),
< ('215', '22', '4', 'SP19021', '', '2019-02-19', '2019-02-19', '-274.35', '0', '0', '1', '274.35', '0'),
< ('216', '22', '2', 'SP19022', '', '2019-02-16', '2019-02-16', '-116.89', '0', '0', '1', '116.89', '0');
---
> ('214', '22', '49', 'SP19020', '', '2019-02-25', '2019-02-25', '-43.33', '0', '0', '1', '43.33', '0');
33150a33166,33167
> ('215', '22', '4', 'SP19021', '', '2019-02-19', '2019-02-19', '-274.35', '0', '0', '1', '274.35', '0'),
> ('216', '22', '2', 'SP19022', '', '2019-02-16', '2019-02-16', '-116.89', '0', '0', '1', '116.89', '0'),

Let me know if you would like any information that I may provide.

Thank you,
/JimmyC

Re: How to enter a payment for a credit note?

null@example.com (JimmyC) — Sat, 25 May 2019 21:03:01 +0000

Hello,

I am trying to enter a refund that is part of a regular store purchase for maintenance supplies using the Supplier Credit Note process that is detailed above. I know this discussion is almost six years old but I could not find any other relevant postings close to the problem I am having.

When I follow the three steps:

nlwowen wrote:

1) I do the credit note to effectively reverse out the original invoice against the gl line items tax etc.
2) Raise a bank deposit against the receiving bank and 2100, by selecting supplier and select the supplier from list.
3) Go supplier credit note/payment allocations and allocate the credit note against the bank payment.

I end up with the Supplier having a Credit Balance of exactly twice the amount of the refund. This appears in red numbers on the Purchases -> Supplier Invoices -> "Current Credit" and the Purchases -> Supplier Credit Notes -> "Current Credit".

When I click on the "Current Credit" red numbers, it pops up the Supplier Inquiry window which is the same display as the tab contents when you click on Purchases -> Supplier Transaction Inquiry.

When I click on Purchases -> Supplier Allocation Inquiry, the tab contents results are "No records".

During the three step process, there were no errors or warnings displayed. I had assumed every was correct until the next time I tried to enter this supplier invoice it showed the Current Credit I described above.

I also have screen shots of the Supplier Credit Note, the Bank Deposit and all of the GL account records for that day and I can send them to you if needed.

I have absolutely no idea what causes this or how to correct it. Can anyone help me?

Thank you,
/JimmyC

Re: How to enter a payment for a credit note?

null@example.com (nlwowen) — Tue, 15 Oct 2013 14:37:53 +0000

<<<< P E R F E C T >>>>

Thank you again for the help..

Regards