accpac , vb.net integration batch error 1

[CarlosY]

Hi Everyone,

This is my first post on this forum, I hope that I can find my answer for my problem.

In my company I am using web-based Intranet application (asp.net) last month I develop bridge application (Intranet -> ACCPAC account payable) which able to creating batch, inserting vendor invoice and updating batch from my intranet to pervasive database (v 8.6) posting batch we still doing it from ACCPAC.

Everything seem working fine except when the batch created from my Intranet is posted and then I create new batch from ACCPAC, this new batch can not be used for some reason (when I input new transaction and I press save , nothing happen and the window is not closing automatically like it used to be) usually I delete this batch and create another new batch and everything works fine.

deleting batches is extra work for accounting staff, specially skipping batch no is really good thing in their eyes.

Here is the list of the table that I modified during batch creation and invoice insertion.

APIBC (BATCH Table),
APIBH (Invoice Header),
APIBD (Invoice Detail),
APIBS (Invoice Summary),
APP002 (control table)

I am not sure if I miss one or more table which I suppose to fill in during my process.

I really appreciate if someone can help me with my problem; Sorry for my bad English.

 

[Jay Converse]

Are you modifying the tables directly, or using Accpac views? You can't modify tables directly.

 

[CarlosY]

I modify the table using store procedure.
this is one of the store procedure that i have




CREATE PROCEDURE APIBC_ADD(
IN :CNTBTCH DEC(9,0),
IN :AUDTDATE DEC(9,0),
IN :AUDTTIME DEC(9,0),
IN :AUDTUSER CHAR(8),
IN :AUDTORG CHAR(6),
IN :BTCHDESC CHAR(60)

);
BEGIN

INSERT INTO APIBC
(
CNTBTCH,
AUDTDATE,
AUDTTIME,
AUDTUSER,
AUDTORG,
DATEBTCH,
BTCHDESC,
CNTINVCENT,
AMTENTR,
BTCHTYPE,
BTCHSTTS,
INVCTYPE,
CNTLSTITEM,
POSTSEQNBR,
NBRERRORS,
DTELSTEDIT,
SWPRINTED,
SRCEAPPL
)
VALUES
(
:CNTBTCH,
:AUDTDATE,
:AUDTTIME,
:AUDTUSER,
:AUDTORG,
:AUDTDATE,
:BTCHDESC,
0,
0.00,
1,
1,
1,
0,
0,
0,
:AUDTDATE,
0,
'AP'
);
END;




Thanks

 

[Jay Converse]

It doesn't matter what stored procedure you use, you _cannot_ add records to Accpac tables that way, you will corrupt the database.

 

[ettienne]

Agreed, you are seriously risking corrupting your data, use the Accpac views instead.

 

[CarlosY]

Could you please tell me more detail what you mean to use views ?

could you please provide me URL to make my self clear?


Thanks in advance you guys are very helpful


Carlos Yuwono

 

[CarlosY]

What is good API for ACCPAC for VB.NET ?

 

[ettienne]

Accpac provides its own API, this is referred to as the Accpac COMAPI. You can write VBA macros in Accpac, the best place to start is by recording macros in Accpac and learning from there. If you are new to Accpac then it is a steep learning curve.

 

[CarlosY]

Do you know how much does it cost for Accpac COMAPI ?
Where Can I get it ?

Thanks

 

[ettienne]

The Accpac COMAPI cannot be purchased, but it comes free with Accpac. You need Accpac installed on a computer in order to use the COMAPI.

 

[CarlosY]

Thanks ettienne

 

[CarlosY]

I think after using view I able to fixed the problem.
I can't imagine how to fix it w/o your suggestion

thanks