Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Withholding Tax Issue
10-27-2016, 12:55 AM
Post: #1
Withholding Tax Issue
Hi,

Am having a problem with a USD customer receipt transaction that contains a withholding tax as follows.
The invoice is for $141.60, so when the customer pays, they pay $134.40 after deducting (6%) = $7.20 withholding tax
So when I go th MAIN MENU --> RECEIVABLES --> ENTER RECEIPTS
I select the USD bank account, and USD currency and the bottom part looks like this:

[Image: wht-receipt.png]

Then after I click the ACCEPT AND PROCESS BATCH I get the following

[Image: wht-receipt-2.png]

But the transaction still gets posted and looks like this:

[Image: receipt-batch-1500.png]

In the above receipt-1500 transaction, the first 2 lines the amounts are in my local currency but the third line (WHT) is in USD and this is what is causing the entry not to balance.

What am I doing wrong ?

Thanks in Advance


R2-g
Find all posts by this user
Quote this message in a reply
10-27-2016, 08:16 AM
Post: #2
RE: Withholding Tax Issue
Are you using any customised code to deal with the withholding tax?

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
10-27-2016, 08:46 PM
Post: #3
RE: Withholding Tax Issue
Hi Tim,

This issue is on weberp 4.12.3 without any customized code


Thanks
Find all posts by this user
Quote this message in a reply
10-28-2016, 05:07 AM
Post: #4
RE: Withholding Tax Issue
Strange, I don't see withholding tax on that screen, and nowhere in the script do I see code for it.

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
11-01-2016, 09:36 PM
Post: #5
RE: Withholding Tax Issue
(10-28-2016 05:07 AM)falkoner Wrote:  Strange, I don't see withholding tax on that screen, and nowhere in the script do I see code for it.
Tim

Hi Tim,

WebERP 4.12.3 CustomerReceipt.php starting at line 553 seems to only check when WHT is not equal 0 and then simply inserts the WHT row unto GLTRANS without converting the amount to the local currency.

Quote:if($ReceiptItem->WHVAT != 0){

$SSQL="INSERT INTO gltrans ( type,
typeno,
trandate,
periodno,
account,
narrative,
amount)
VALUES (
12,
'" . $_SESSION['ReceiptBatch']->BatchNo . "',
'" . FormatDateForSQL($_SESSION['ReceiptBatch']->DateBanked) . "',
'" . $PeriodNo . "',
'1335',
'" . $_SESSION['ReceiptBatch']->Narrative . "',
'" . $ReceiptItem->WHVAT . "'
)";
Find all posts by this user
Quote this message in a reply
11-01-2016, 10:14 PM (This post was last modified: 11-01-2016 10:39 PM by falkoner.)
Post: #6
RE: Withholding Tax Issue
This code is not in the subversion history for CustomerReceipt.php. In fact it doesn't appear to be in the subversion history of any of the scripts. If it was in 4.12.3 (it's no longer available for download so I can't verify) then someone messed up. There isn't much more that I can say other than your script contains bad customisations to that file that have never been committed to sourceforge. If you let me have a copy of that script I can look and see if I can unravel it.

Tim

Note: From the command line running

svn blame CustomerReceipt.php | grep 'WHVAT'

will show all occurrences of the string WHVAT in that script that have ever been committed to the subversion repository and it returns nothing Sad
It would appear from

http://www.weberp.org/forum/showthread.p...olding+tax

that your system has been customised sometime in the last couple of months.

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
11-02-2016, 03:45 AM
Post: #7
RE: Withholding Tax Issue
Hi Tim,

Thanks for the assistance.

Here is the WebERP 4.12.3 CustomerReceipt.php script

I have not made any customizations on it


.php  CustomerReceipt.php (Size: 52.46 KB / Downloads: 2)


R2-g
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)