UBSA1.147 : Access UBS (Accounting): I have a problem Generating SST Report, Paid % is not correct

UBSA1.147 : Access UBS (Accounting): I have a problem Generating SST Report, Paid % is not correct

Description

How to generate 100% paid SST bills in report?
Why SST report showing more than 100% paid?
How to generate SST report without error in paid %?

Environment

Access UBS Accounting

Solution

This article will explain how to generate SST report without error in paid % in Access UBS Accounting.

Issue Details:  Why SST report showing more than 100% paid?
Root Cause: There was transaction that does not follow UBS method of transaction entry.
Solution: Maintain transactions according to specified tax codes and taxable amounts.

I refer to reference no sample as below:
CM-1504. The transaction below have grouped transaction entries to an identical Reference Number, REFNO 1 (CM-1504).  There are 2 bills types with the same reference numbers, Invoice and Payment.  Furthermore, the taxable amount for the transactions are not well defined in the entry.

image.png

This is generated in report.  Paid amounts exceeds 100% (559.7%):

image.png

Instead, split the transaction entries to record in detail breakdown of taxable amount and bill types:
  • Split entry to different tax codes
  • Split reference no for different bill types (CM- for Invoices and PY- for Payment)
  • Include 2nd reference for Payment Bill with Invoice Bill no.
image.png

This is generated in report after the changes: 
  • 0.00% paid is generated correctly for SV-0 tax code
  • 100% paid is generated correctly for SV06 tax code
  • The Payment bill amount is not calculated as a total in the report to 559.7% 
image.png
image.png

--Source from Access UBS --