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
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).