You just can't know everything.
Maybe I never took the time to look at this one field when using that particular Dynamics GP batch posting setting, and never knew about this quirk.
Maybe I did know about this quirk at some point over the last 12 or 13 years working with eConnect, but forgot about it.
Either way, I didn't know about it when I needed to know about it.
Last week I had a call with a customer to try and troubleshoot a weird posting date issue. They import a bunch of AP Invoices every Monday morning into dozens of batches, review the batch that Monday or Tuesday, and then post the batch. Simple, right?
But when they were reconciling the GL for their month end close, they were seeing AP Invoice transactions post to prior weeks and prior fiscal periods. An invoice imported on November 5 posted to October 30. Another invoice imported on November 5 posted to November 1.
It was weird.
We looked at their GP posting settings for Payables Transaction Entry, and it looked pretty normal.
Typical Batch Posting Date |
The customer is using the Posting Date from the Batch. Okay, so that rules out an issue with the invoices posting based on the Transaction posting date.
But, that doesn't explain why invoices imported at the same time on Monday morning would post to different dates.