Integration Manager and Inactive G/L Accounts

[r2p2s3]

We have found that G/L journal entries created using Integartion Manager can be posted to Inactive G/L accounts, whereas journal entries entered normally through Great Plains error.

Suggestions??

 

[jazgeek]

check your options in the integration. There's probably one that says to override instead of fail.



-----------
and they wonder why they call it Great Pains!

jaz

 

[r2p2s3]

The option available is for 'is null' only which I have marked as cancel.

I require some way of having IM recognize that the account being integrated is inactive.

 

[jymm]

but then - wont your batches be out of balance? If one side of the transaction is inactive & the other is active - what do you want then?

I know that when I create the transactions going into IM I 1) check to see if the account exists & 2) check to see if the account is active --- and take approriate actions before the GL entries are imported.

 

[r2p2s3]

Yes the batch will be out of balance by the rejected records. The Integration log will identify the transactions in error enabling us to correct where correcting is required. The batch would be deleted from the Financial series and integrated again when the source data for the integration is corrected.