x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 1 reply
  • Subscribers 27 subscribers
  • Views 946 views
  • Users 0 members are here
Browse Forums
Announcements
19
topics
3
replies
General Discussion
790
topics
1k
replies
Chris2

PO list summary with strange totals

Posted By

Hello 

I just printed off a Purchase order list - summary.  The HST/GST is wonky on a couple of the orders but only on this printout - not within the order itself. The totals on the printout show numbers in the billions; the numbers should be in the hundreds..  How can that be?  Where does this report gather the information from to equal such a huge totals?  How can I get rid of these astronomical totals?

Hope this makes sense.

We are using Business Vision CSE 2014 version 7.1

Thanks

Chris

  • 0

    Hi Chris,

    The Purchase order list - summary report gets the tax amount from the PURCHASE_ORDER_HEADER table and the purchase order screen gets the tax flags from the PURCHASE_ORDER_DETAIL table to calculate the tax amounts.

    Look like the tax amount field in the PURCHASE_ORDER_HEADER is messed up.

    If you are familiar with Pervasive Control Centre, you can modify the tax amount field BVSLSTAXTOTAMT1 and BVSLSTAXTOTAMT2

    If you are not familiar with Pervasive Control Centre:

    - If the status or the PO is Okay: issue the PO and then unissue PO. This will update the PURCHASE_ORDER_HEAER table. Run report again to confirm that it is fixed.

    - If the status of the PO is Issued: unissue the PO to make it Okay PO. Run report to confirm that it is fixed. Then issue the PO again.

    - If the status of the PO is Received: unreceive the PO, unissue the PO. Confirm the report is correct. Issue the PO then receive again.

    Hope this helps.

    Regards,

    Cat Nguyen

*Community Hub is the new name for Sage City