News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) eConnect SOP DocDate c...

Microsoft Dynamics GP (Archived)

eConnect SOP DocDate change question - GP 10.0

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

We use third party billing and want to change the docdate of invoices/returns to match the actual date our provider puts the invoice/return on our customers' bill. We are notified of the billings via csv file. I am using eConnect to verify the file against the GP invoices/returns and then changing the matched records batch. It is during this process that I am attempting to change the DocDate using the <DocDate>DateVar</DocDate> command.

From what I can tell the above doesn't actually change the DocDate, but instead changes the Fulfill Date and Actual Ship Date values to match DateVar

Am I missing something, or does anyone know how to change the DocDate itself.

Thanks,

Brent

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: eConnect SOP DocDate change question - GP 10.0

Are you trying to update an existing posted SOP Invoice/Return?

If yes, I don't think that eConnect can perform the update of Document Date for posted transactions. One of the reason is the tax implication (in Australia Document Date is a sensitive field as it affects the BAS Tax Reporting).

If you need to modify the Document Date, I suggest updating the Post Script used by the eConnect stored procedure to update the Document Date. But then be cautious and make sure that you update all the related tables (e.g. Header, Line and RM tables).

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2

Martin Dráb 231,309 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans