Topic Options
#16535 - 03/30/09 03:01 PM Where did my GST go?
Acrylon Offline
Adagio Specialist

Registered: 04/12/07
Posts: 384
Loc: Canada
Hi All,

I have some old transactions in POs, and I want to tell which account the GST went to. I've been trying to pull a crystal report, but cannot seem to find the right info.

How can I tell what account the GST went to?

Thanks!

Top
#16544 - 03/31/09 07:05 AM Re: Where did my GST go? [Re: Acrylon]
Brian Stief Offline
Waterloo Guy

Registered: 04/04/06
Posts: 1739
Loc: Waterloo, Ontario, Canada
Assuming Purchase Orders for Adagio.

Go to Maintain menu drop down, select Tax Groups, and when you select the Jurisdiction, the GL Accounts will be displayed.

Assuming you configured the tax groups properly, the account will be displayed depending on the costing method. If costing method for GST jurisdiction is None, then the recoverable GST is being allocated incorrectly and directly to the inventory or expense. For GST the costing method should be Accounts Payable.

Assuming you have configured correctly, then the GST is allocated to the fiscal period by the Invoice/Adjustment date, and posted to the GL after the POA End of Day is run and the affected AP invoices have been posted in Accounts Payable, and the AP batch has been retrieved into the GL.
Brian
_________________________
Brian Stief,CPA,CA
Stief Group www.stiefgroup.com
Link2 Systems www.link2systems.com
800.540.3164

Top
#16548 - 03/31/09 09:31 AM Re: Where did my GST go? [Re: Brian Stief]
Acrylon Offline
Adagio Specialist

Registered: 04/12/07
Posts: 384
Loc: Canada
Hi Brian,

It is indeed PO for Adagio 8.0.

I need to trace this back for specific transactions back in 2006 - we had a GST guy come in, and a few transactions with some vendors are suspected of the GST going to the wrong account.

Is there a way to trace back which account GST went to from a specific adjustment number?

Thanks!

Top
#16549 - 03/31/09 10:00 AM Re: Where did my GST go? [Re: Acrylon]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11571
Loc: Vancouver, BC Canada
Hi,

Do you have Source Codes in Ledger set up for IR-AD, IR-RC and IR-RT? If yes thenb, if you haven't already, you can create a Source Journal in Ledger for your retrieved from PO entries. (You can do this in pre-GL9.0A versions of Ledger also.)

Run the Source Journal report on your Ledger data for the period in question. Depending on what your PO Company Profile 'Send to GL' settings are, you will see (most likely) the individual PO document numbers in, say, the GL Reference or Description fields in the report and can use these as part of your audit trail. And, if the report is sorted or grouped by account number, you'll find the individual document entries within the accounts distributed to at that time.

Good luck!
_________________________
Regards,
Softrak Tech Support

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (Bruce Gardner), 77 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14484 Topics
70731 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