4Site
Support Request System
View Patch #50.507.032
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
03499 -
APBalance Report may not balance when negative tax rates involved
03332 -
AP Balance Report w Currency
03105 -
Aged Accounts Payable Report in Voucher Application
Symptoms:
1. The A/P Balance report does not balance with the G/L 2. The summary report does not balance with the detail. 3. The report for the US$ payables account is showing in US$, not CDN$ Also, add an additional AP Balance report that shows the base currency as well as the foreign currency invoice amount (including currency and conversion rate) for outstanding payables. The following needs to be added to the apbalance.exe: Vohdr table – amount (will have to call it curramt since the amount field already exists from the trnline table), the select statement would be something like this: CASE v.drcrind WHEN 'C' THEN -v.amount ELSE v.amount END curramt Vohdr table – currency
Solution:
Currency has been added to the report as well as some new flavors of the report (Currency, Aged and Aged in Currency). Also, there was a problem where the report did not balance, this was fixed. Tax lines were not always shown with the proper sign.
Browse Patches
Find a Patch
Return to Request System Menu
