Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Purchasing- three post...
Microsoft Dynamics GP (Archived)

Purchasing- three posting dates all in one batch of invoices

(0) ShareShare
ReportReport
Posted on by andreamae635 115

I have entered in all the invoices needed to pay, all in one single batch for this weeks payables, except it is 1st quarter month end and so I have a couple invoices where we received services in February and April. So I need the two February received invoices to be post dated 2/28/14, the seven April received invoices post dated 4/01/14 and the rest of the invoices with be the month end posting date of 3/31/14. I have not posted any invoices as of yet - only entered the batch id and all the information for each invoice in the transaction entry screen. Is it even possible to have three separate posting dates all in one single batch of invoices??

*This post is locked for comments

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Purchasing- three posting dates all in one batch of invoices

    Before posting the transactions, you can print the transactions edit list report in Batches window from each of the modules.

    For example, if you want to print the payables transactions edit list, go to Transactions->Purchasing-->Batches. Then enter/choose your batch id and click the print button from the right top of window.

    Hope this helps!!!

    Note: If my answer solved your problem, mark this as a verified. Because this will helps to someone who having the same problem.

  • andreamae635 Profile Picture
    andreamae635 115 on at
    RE: Purchasing- three posting dates all in one batch of invoices

    thank you and I also just have one more question...how do I print a report like the transaction edit list BEFORE I post the batch with different posting dates to show each transaction and its specific posting date just to verify and double check before posting this batch. I put the transaction edit list to my screen view after I entered each correct posting date but it does not show the individual posting dates.

  • Suggested answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: Purchasing- three posting dates all in one batch of invoices

    If "allow transaction posting" is checked, that means users are allowed to post a single transaction without saving it into a batch first. Up to you whether you want to allow that - it will not have any impact on the posting dates.

  • andreamae635 Profile Picture
    andreamae635 115 on at
    RE: Purchasing- three posting dates all in one batch of invoices

    Should the "allow transaction posting" box to the left in the posting tools - setup -posting -posting screen be checked?

  • andreamae635 Profile Picture
    andreamae635 115 on at
    RE: Purchasing- three posting dates all in one batch of invoices

    Thanks so much guys I will follow your steps! :)

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Purchasing- three posting dates all in one batch of invoices

    Victoria thanks for your updates.

    ANREAMAE,

    If your Payables Transaction Posting setup for "Posting Date From" is set to Batch. 

    For the above case you mentioned "only entered the batch id and all the information for each invoice in the transaction entry screen". Assume after selected the batch id in payable transaction entry window, the posting date was changed from transaction posting date to batch posting date So, you need to follow above my and Victoria suggestions. Otherwise just verify your payable posting setup and transaction posting date then post your batch.

    Hope this helps!!!

  • Suggested answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: Purchasing- three posting dates all in one batch of invoices

    Soma is exactly right - you would need to make sure your payables transactions are set up to look at the transaction and not the batch for the posting date. However, if you already have all your transactions saved in a batch and your setting was originally to take the posting date from the batch, the posting dates may not change automatically. After you change the posting setting, you will need to go into each saved transaction and confirm/change the posting date. You can do that by clicking on the blue arrow next to the Doc. Date. In the future, with the posting setting set to take the posting date from the transaction, the posting date will default to the doc. date on each transaction you enter.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Purchasing- three posting dates all in one batch of invoices

    Yes. You can post a batch with different posting date in GP.

    First open posting setup window(MS Dynamics GP-->Tools-->Setup-->Posting-->Posting) to change your setup "Posting Date From" to transaction as below.

    Now save all your invoices to single batch and post the batch. While posting this batch, the invoice will be posted based on each of the invoice posting date.

    Hope this answer for your question.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans