Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Posting Setup ignoring post by transaction date

(0) ShareShare
ReportReport
Posted on by 112
We have a customer on GP 2018.5.1584 and have created several new databases for newly acquired companies. We used the PSTL copy company settings, in all of them.  They post payables by the transaction date and when we look at the posting setup - this is what it says it is set to. This applies to transactions, payments, check batches.
 
What they have found is when they create a batch for anything the posting date is grayed out as expected. But the actual posting date uses the batch creation date to post ALL transactions, even with check batches.  So it is causing a huge issue with batches posting into the wrong period.
 
We have tried running checklinks of the posting setup and it found no errors. They now one company with over a year's worth of transactions using the wrong posting dates.
 
Has anyone else experienced this? If so, how did you fix it? Or what can we do to correct all the data?
Categories:
  • Lisa at AonC.com Profile Picture
    Lisa at AonC.com 572 on at
    Posting Setup ignoring post by transaction date
    @MKAEK - I don't believe that the Posting/Batch information is ever active for Purchasing Prepayments.  (Purchasing Prepayments are adding to a Purchase Order and since a Purchase Order is not itself an accounting transaction, there is no Batch Number associated with it.

    The behavior of the PO Prepayment feature is dependent on the options selected in Purchase Order Setup.
  • MKAEC Profile Picture
    MKAEC 17 on at
    Posting Setup ignoring post by transaction date
    This happened to me, too.  I think there is a bug in the PSTL Copy Company utility.  After using it to copy settings to two new companies, all of the Purchasing Posting Date From settings were set to Batch, even Purchasing Prepayments, which is disabled in the UI and cannot normally be changed by the user from the default value of Transaction.
     
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 572 on at
    Posting Setup ignoring post by transaction date
    When you are reviewing Posting Setup, are you first selecting a specific Origin?  If the Origin is set to All, you are seeing the GP defaults, not the actual company settings for each specific origin.  For payables payments, the selection for the company-specific window would look like this:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans