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 bkrike 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
  • Content: Threads
  • 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

    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...
  3. 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.
  4. 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.
  5. 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.
  6. 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?
  7. 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?
  8. 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?
  9. 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...
  10. 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...
  11. 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?
  12. wangui1981

    Updating stocks bought by cash

    I want a set up in Accpac that will allow me to receive cash purchased stock which willupdate my stock Account and stock levels.An example; I use petty cash to purchase envelopes.I want my petty cash to reduce while increase my stock levels.How doI achieve this?
  13. wangui1981

    Converting from String to Binary

    I have changed the field type from char(60)to image but if i try to print the report it appears blank.How do I change this?
  14. wangui1981

    Attaching a table

    I want to attach an extra table to an Accpac check form how can I do this?
  15. wangui1981

    Accpac Table

    Can someone please tell me which Accpac table I can get how document payments has been spread over different expense Accounts
  16. wangui1981

    Using a formula as a parameter

    I want to use a formula converting a number to date as a parameter.How do I do this? I have already converted the number to date.
  17. wangui1981

    Using Select Expert in Cross Tab

    I have a cross tab that has Accounts as columns.Reference as rows and Amount as summarized fields.I want to be able to exclude negative Amounts in my cross tab.If I try to use the suppress function on Amounts it suppreses all the amounts.If I try to supress using the Accounts column as its one...
  18. wangui1981

    Using Select Expert in Cross Tab

    I have a cross tab that has Accounts as columns.Reference as rows and Amount as summarized fields.I want to be able to exclude negative Amounts in my cross tab.If I try to use the suppress function on Amounts it suppreses all the amounts.If I try to supress using the Accounts column as its one...
  19. wangui1981

    Sum Group Footers

    I have a report with details.I have summed the details and placed the sum as a group footer.How do I sum only the group footers.When I say sum it sums even the details.
  20. wangui1981

    Accessing Macros in Accpac

    I have users Accessing Accpac through remote desktop connection.Those with Admin Rights are able to Access the Macros.All the other users get this error message. The instruction at “0x65166bfa”referenced memory at 0x00000000.The memory could not be “read” Click OK to terminate the program Click...

Part and Inventory Search

Back
Top