Topic Options
#34553 - 12/22/12 11:52 AM invoice aging
MountWashTC Offline
Adagio Enthusiast

Registered: 05/25/09
Posts: 21
Loc: Mount Washington, BC
Is it possible to post a/p batches to the g/l using the 'batch date' and not the 'invoice date'? We process invoices for payment that are from prior (closed) periods so have been using the first of the current month to post them, however, this also means that manual entry of a due date is required. Is there a way around this?

Top
#34557 - 12/22/12 11:59 AM Re: invoice aging [Re: MountWashTC]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Why not retrieve the batch into Ledger and post it, letting the transactions for closed periods fail and end up in an error batch? Then move the error batch to a new batch, setting the fiscal period to the current one and posting them. That way the invoices end up in Payables with their correct date and you change the fiscal period in Ledger.

Of course, your Open Payables report will not tie to Ledger, but it probably doesn't at the moment.
_________________________
Andrew Bates

Top
#34559 - 12/22/12 12:08 PM Re: invoice aging [Re: Retired_Guy]
MountWashTC Offline
Adagio Enthusiast

Registered: 05/25/09
Posts: 21
Loc: Mount Washington, BC
Sorry, I'm not sure I follow.
Let's say I have a batch that includes invoices from 'closed' September. Because the period is closed they are rejected and moved to an error batch. How do I post them to the g/l from there without changing the Sept date on the invoice to an open fiscal period?

Thanks!

Top
#34562 - 12/22/12 12:40 PM Re: invoice aging [Re: MountWashTC]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
The invoices will post fine in Payables. When you retrieve the batch into Ledger, the GL entries from these entries will not post because the period they are assigned to is closed. However, they will be written to an error batch by the posting process. Move (Copy) them from the error batch to a new batch, changing the period of the transaction to the open period. Then post the resulting batch.

BTW - there is a difference between the "Due Date" and the Invoice Date. I assume that you are referring to the Invoice date, as it controls the period to which a transaction would be posted.
_________________________
Andrew Bates

Top
#34563 - 12/22/12 12:56 PM Re: invoice aging [Re: Retired_Guy]
MountWashTC Offline
Adagio Enthusiast

Registered: 05/25/09
Posts: 21
Loc: Mount Washington, BC
Oh, I understand now!
Yes, the invoice date and due date are different. Thanks again!

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 56 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14458 Topics
70633 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30