Retrived open payables in wrong month

Good Morning,

I posted some invoices that were meant for July month end and used August date accidently. When I did a retrival of subledger batches these invoices were retrieved. The problem is that the invoices were dated for August but they will appear in the July Financials. How can I solve this problem?

Did you retrieve to the period based on the date of the transaction, or to a specific period. Retrieving based on the date of the transaction is almost always prefered. If this was the option selected, then the transactions will post to the correct period (you can post transactions to different periods in the same g/l batch).

Have you posted the general ledger batch you retrieved from Payables? If not, then inspect the period assigned to the August invoices. If it is your July period, then highlight the August invoices, click the Copy button, Enable the Move check box on the Copy Batch dialog, and move the transactions to a different batch. You can change the fiscal period in this step too.

If you have already posted the batch, see whether the transactions posted to your July or August period. If they posted into August, then all is well. If they posted into July, then the easiest way to correct the error is to Unpost the batch, removing the transactions from the posted file. Fix the batch as described above. Then post the two corrected batches.

I should have dated the transactions july but i dated them august. I posted them. I want them to appear in my july statements. Basically i dated them incorrectly(used august date instead of july), but they are posted and retrieved in the correct month(july). what do I do in this instance?

If July is not your year-end, you can simply unpost the GL batch, change the fiscal period to July (leaving the date unchanged), and repost.

If July is your year-end, you would probably be better off crediting the invoices in Payables using the same wrong date, and starting from square one.

Steve

I am not sure if you understood me correctly...
My fiscal period in not until october.
The Batch I retrieved at July 31st had invoices dated July and also invoices dated August. What I really wanted to do is have used a July date instead I used an August date on some of the invoices. Therefore, some invoices have a date of July (correct) and some are August date (wrong should be dated July) all invoices were retrieved and posted in July (correct. Can I leave things as they are or will it mess things up? If yes, what is the quickest fix method? thanks

Just check the invoices to be sure they are paid on time and leave everything else alone. They are posted to July in GL.

David

I understood you and my advice stands.