How to create restart records in Macro VBA

[PhilDOakley]

I am pushing a csv file into a GL journal using a VBA macro and want it to use the restart method as it fails sometimes. Is it possible to implement this?

 

[ettienne]

You can use AccpacDBLink.TransactionBegin, AccpacDBLink.TransactionCommit, AccpacDBLink.TransactionRollback
Caveat: other users will be locked out of creating GL batches until you commit or rollback.
I use this in many cases where importing transactions, especially when it is automated.
The other thing to do is validate the heck out of the source data before importing.

Sage 300 Certified Consultant

 

[ettienne]

And by importing I don't mean using the Sage 300 import engine - it sucks. I use the views and write to the batch, header and detail views.

Sage 300 Certified Consultant

 

[PhilDOakley]

Exclusive access will not be an issue as this will run over night. I will try the AccpacDBLink.TransactionBegin and see how it goes

 

[PhilDOakley]

Is there any documentation on this as I can see there is a AccpacDBLink.TransactionBegin and AccpacDBLink.TransactionBegin2?

 

[ettienne]

No - you have to wing it.
Open a macro screen and press F2, then select AccpacCOMAPI from the top dropdown list.
Select AccpacDBLink under Classes and TransactionBegin under Members - you will get a very brief description at the bottom.
That's about as good as it gets.

Function TransactionBegin(pTransLevel As Long) As Long
Member of AccpacCOMAPI.AccpacDBLink
Begins a transaction on the current DB Link.

Function TransactionBegin2(pTransLevel) As Long
Member of AccpacCOMAPI.AccpacDBLink
Begins a transaction on the current DB Link. Script languages should use this function.

As you can see the "2" is for scripting.

Sage 300 Certified Consultant

 

[ettienne]

Some good reading here:

https://smist08.wordpress.com/sage-300-erp-articles/

Sage 300 Certified Consultant