Purchasing- three posting dates all in one batch of invoices

(0) Share

Report

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

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

soma 24,410 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Victoria Yudin 22,769 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

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!!!

Was this reply helpful? Yes No
andreamae635 115 on at

Like (0)

Report

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

Was this reply helpful? Yes No
andreamae635 115 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Victoria Yudin 22,769 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
andreamae635 115 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

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.

Was this reply helpful? Yes No