Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: wangui1981
  • Order by date
  1. wangui1981

    Aged Payables Not Printing.

    I have imported transactions into the Ap invoice batch list.However some transactions went to the wrong vendor I have then gone to the database and updated the records using the scripts below.However when I try to print the Aged payables it stops at N010.Iam not sure which of the scripts below...
  2. wangui1981

    No Cheques in tables

    Iam not sure where the problem is because when I print cheques when i try to void it gives a message cheque not found in Bank services.Where could the problem be.
  3. wangui1981

    No Cheques in tables

    The payment batch has been posted and apparently they don't appear in BKCHK.I have run the intergrity done a dump and load and it still doesn't sort me put.
  4. wangui1981

    No Cheques in tables

    I have cheques that have been printed.When I print the check register the cheques appear and also in common services Iam able to see the cheques.However I cannot see the cheques in all the cheque related tables i.e APPYM,BKREG,APTCR,APTCP.I can't understand what is wrong.The database is...
  5. wangui1981

    PIB Error

    I have given full access rights for that folder and still the error occurs.
  6. wangui1981

    Inserting a Subreport in ACCPAC Purchase order Form

    How can i insert a subreport in Accpac Purchase order form.The report has been made using POPOPRN DLL hence no table to link with.
  7. wangui1981

    Showing Originating Batch

    Actually what I want is at the GL batchlist display how can I know the originating AP batch.
  8. wangui1981

    PIB Error

    I have transferred Accpac running on SQL 200 from an old server to a new one.However when I try to open Accpac I get a PIB error.What could be causing this and how do I solve it.
  9. wangui1981

    Showing Originating Batch

    How can I set up in Accpac so that from the GL batchlist I can know which AP batch for instance generated the GL batch.
  10. wangui1981

    Automatic posting of an Accpac Generated Batch

    I have a macro that automatically creates an invoice batch in Accpac.I need a code that I can add to the macro that would help me automatically post the batch after its been generated.Any one who can guide me on how to go about this?
  11. wangui1981

    Reading data on the left of a hiphen

    I need a formula that can help me separate values from the the rest. My data has these segments '20-00-99005-00'.I need a formula that will return only '20-00-99'as this is the unique character in my data.Anyone who can help?
  12. wangui1981

    Deleting Inactive Items

    Is there a way to delete many items at the same time as iam dealing with many items?
  13. wangui1981

    Deleting Inactive Items

    Iam trying to delete inactive items and here is the error am getting.Incorrect procedure unit of measure is in use in item pricing details and cannot be deleted.Anyone who knows how to go about this?
  14. wangui1981

    Use of null

    I have 3 fields am trying to sum.In some parts of the report one of the two field is null so the report does not return the sum. How can I write a formula where if null then zero here is what i have been trying. if{VVOUCHER.wht} is null then 0 but then when checking for errors the system...
  15. wangui1981

    Error Accessing Accpac

    I have installed the pervasive client.The error message has now changed.It reads cannot access Accpac Siginon Manager.If i test the ODBC connection it is okey .Also in ACCPAC database setup its connecting. Where is the problem?
  16. wangui1981

    Record has been modified by another program.

    I have reinstalled Accpac on a server.Accpac is version 5.4 running on an oracle database.I have also renamed the previous Accpac folder.the problem is that when I try to add users the add button automatically changes to save and it gives the following message 'Record has been modified by...
  17. wangui1981

    AR invoice batch's status "post in progress"

    You'll need to open the database and in the APIBC table change the batchstat column of that particular batch to 1 a batch in progress normally has 8 so change it and try posing again.
  18. wangui1981

    Error Accessing Accpac

    I have a machine running on Accpac 5.2 and pervasive as the database and everytime I try to log in I get this error message. Cannot Access database (error=40962)See help for more information. Anyone who can help me on this?
  19. wangui1981

    Updating stocks bought by cash

    Iam using IC &cashbook
  20. wangui1981

    Updating stocks bought by cash

    I think I didn't put it clearly there is no PO involved in this case so I cant receipt through PO.Look at it this way?I purchase my items using cash so no PO is involved.I want to receive the items and reduce my cash balance.

Part and Inventory Search

Back
Top