Search results for query: *

...I try to print the Aged payables it stops at N010.Iam not sure which of the scripts below is messing me.Any help will be so much appreciated. SELECT* FROM APOBL WHERE IDVEND='N274' UPDATE APOBL SET IDVEND='N010'WHERE IDVEND='N274' SELECT *FROM APIBH WHERE IDVEND='N274' UPDATE APIBH SET...

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.

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.

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...

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

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.

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

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.

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.

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?

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?

Is there a way to delete many items at the same time as iam dealing with many 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?

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...

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?

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...

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.

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?

Iam using IC &cashbook

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.