Topic Options
#67759 - 02/11/22 06:01 AM GL posting period based on invoice date not entry
bdgillis Offline
Adagio Fan

Registered: 03/03/10
Posts: 31
Loc: PEI
This started 3 months ago ( we have not changed how the staff enters invoices): When the payables invoice batch is retrieved into the GL the posting period in the GL is now based on the invoice date not the period that the payables are entered (posted) to be paid.
We have always entered the invoice date into the Invoice Batch.
I am sure it is a simple fix.

Top
#67760 - 02/11/22 06:47 AM Re: GL posting period based on invoice date not entry [Re: bdgillis]
Dan_Desautels Offline
Adagio Maestro

Registered: 07/21/11
Posts: 1169
Loc: Thunder Bay, ON, Canada
Hello,

When you're looking at the retrieve window in GL, you can highlight the Payables batches waiting to be retrieved and look to the bottom where there is "Assign entries to". There are three options: Period based on date, Specific Period, and Subledger Period. It sounds like 3 months ago someone changed that option to Period based on date.
_________________________
Dan Desautels
DezTek Solutions Inc.
Thunder Bay, ON

Top
#67761 - 02/11/22 06:59 AM Re: GL posting period based on invoice date not entry [Re: Dan_Desautels]
bdgillis Offline
Adagio Fan

Registered: 03/03/10
Posts: 31
Loc: PEI
Thank you, I just received confirmation that our AP Accountant computer has "Period based on Date "
We will have that changed.

Top
#67773 - 02/14/22 06:56 AM Re: GL posting period based on invoice date not entry [Re: bdgillis]
bdgillis Offline
Adagio Fan

Registered: 03/03/10
Posts: 31
Loc: PEI
We no longer have the ability to select the options:Period based on date, Specific Period, and Subledger Period.

There is a message when we open each module "“ A new Adagio version has been installed. SQL Sync will be disabled until a refresh is performed. Bring this message to the attention of your System Administrator !”

Will this cause the problem we are having ?

Top
#67774 - 02/14/22 07:57 AM Re: GL posting period based on invoice date not entry [Re: bdgillis]
Dan_Desautels Offline
Adagio Maestro

Registered: 07/21/11
Posts: 1169
Loc: Thunder Bay, ON, Canada
You need to highlight the subledger batches you're retrieving for those options to be changeable since they can be different depending on which subledger you're retrieving from.
_________________________
Dan Desautels
DezTek Solutions Inc.
Thunder Bay, ON

Top
#67777 - 02/14/22 09:11 AM Re: GL posting period based on invoice date not entry [Re: Dan_Desautels]
Patricia B. Offline
Adagio Maestro

Registered: 06/26/08
Posts: 1165
Loc: Langley, BC
Do you use SQL SYNC? If you do this message should not be ignored. If you don't, the SQLSYNC module has been enabled some how and needs to be disabled. Contact your Adagio Dealer.

As Dan says, you need to have a retrieval batch from Payables to be able to change the method.
_________________________
Patricia Balbuena Cotlear
AP SMART SUPPORT
236 991 3060





Top
#67779 - 02/14/22 09:24 AM Re: GL posting period based on invoice date not entry [Re: Patricia B.]
Chris McDonell Offline
Adagio

Registered: 11/16/01
Posts: 623
Loc: Vancouver, BC, Canada
Hi,

The message "A new Adagio version has been installed. SQL Sync will be disabled until a refresh is performed. Bring this message to the attention of your System Administrator !" happened because a dictionary in Adagio was updated the dataset is setup to use the SQLSync functions.

This message will continue until your Adagio Administrator runs the 'File / Sync' function in SQLSync.
_________________________
Chris McDonell
Softrak Systems Inc.

Top
#67793 - 02/15/22 04:34 AM Re: GL posting period based on invoice date not entry [Re: Chris McDonell]
bdgillis Offline
Adagio Fan

Registered: 03/03/10
Posts: 31
Loc: PEI
"You need to highlight the subledger batches you're retrieving for those options to be changeable since they can be different depending on which subledger you're retrieving from."

When the subledger batch is highlighted, it still does not allow me to change the option from "Period based on date ", so our payables are being posted in the GL based on the invoice date, not the date they were paid.

Top
#67795 - 02/15/22 10:02 AM Re: GL posting period based on invoice date not entry [Re: bdgillis]
Bruce Gardner Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3617
Loc: Toronto ON, Canada
Hello:

From your comments I assume that you want to use the "Specific period" option (though I'm not certain that will put your invoices in the period you want - depends how you use it).

Adagio has dozens of free YouTube videos available. Most are in the range of 4 to 5 minutes.

Here is a video that will help: YouTube video on G:L Retrieval function

The entire video is just under 5 minutes and the part you want to see starts at 1 minute, 15 seconds.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top


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

Max Online: 432 @ 01/20/25 10:17 PM
May
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 31