Transactions posting/appearing/showing on wrong company/database

(0) Share

Report

Posted on by Tristan Clores

2,812

We've recently encountered an issue where batches of transactions that are posted in Purchase Order Processing are appearing in the POP tables BUT the PM transactions are recorded in a different database.

For example:

1. A Batch is posted in POP for CompanyA and it is recorded in the POP tables of CompanyA

2. However, the PM transactions are appearing in CompanyB. If I run the script below I see the transactions.

select * from CompanyB..PM20000 where DoCNUMBR in (select VNDDOCNM from CompanyA..POP30300 where BACHNUMB like 'RCTIN%') and vendorID in (select vendorID from CompanyA..POP30300 where BACHNUMB like 'RCTIN%')

Note that this does not always happen... and it only happens IF/TO the Vendor ID is on both companies. We use SmartPost to automatically post batches. I've checked Event Viewer on the Smartpost server and the database server but see no relevant errors to the issue.

Has anyone here experienced this issue?

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

Jeff Grant on at

Like (0)

Report

RE: Transactions posting/appearing/showing on wrong company/database

Hi Tristan,

I can only verify that there hasn't been such an issue logged in default code for any version of Dynamics GP.
Heather Roggeveen 9,142 on at

Like (1)

Report

RE: Transactions posting/appearing/showing on wrong company/database

Hi

I would suggest going back to the provider of SmartPost on this one. It is likely to do with that solution.

Cheers

Heather