Topic Options
#40717 - 03/19/14 10:27 AM PO amounts in Ledger
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
Is there a way to have PO send the ADJ # to Ledger instead of the PO or RC?
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#40719 - 03/19/14 12:34 PM Re: PO amounts in Ledger [Re: SusanTennier]
Softrak Support Online   happy

Adagio Action Team

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

In addition to the standard selections for the Send to GL Reference/Description choices, here are the available codes for defining User-specified information to send from PO documents to Adagio Ledger batch descriptions:

%ono - for Original Document code
%des - for Document description
%dno - for Document code
%ref - for Reference
%rno - for Receipt code
%ven - for Vendor code
%vnm - for Vendor name
%vdn - for Vendor Document code
%job - for Job

I suspect that you are looking for the actual document number, rather than the vendor document number, nor the original document number (ie the PO# for a receipt, or the receipt# for a cost adjustment or invoice). Thus the User-specified code of %dno will output ADJ-100001 or whatever the adjustment number is. Of course, this will affect all transactions that generate GL activity and not just for invoice/adjustments, so you need to determine if this is what you require.
_________________________
Regards,
Softrak Tech Support

Top
#40721 - 03/19/14 12:52 PM Re: PO amounts in Ledger [Re: Softrak Support]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
In PO's Company Profile, Ledger Interface Tab we have these options:

Send to G/L as transaction comment: Purchase Order description
Send to G/L reference field: Original document number
Send to G/L description field 1: Vendor Name
Send to G/L description field 2: Receipt number

When I look at an account in G/L (i.e. 2015 A/P Clearing), I see in the grid, the Reference showing the PO# and the Description showing the Vendor Name. So, it's the Reference field that I would like to change to the ADJ#.

In PO's Company Profile on the Ledger Interface tab, the option "Send to G/L reference field" does not offer "Document code" as an option. How do I set it to %dno?
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#40722 - 03/19/14 12:55 PM Re: PO amounts in Ledger [Re: SusanTennier]
Softrak Support Online   happy

Adagio Action Team

Registered: 03/09/99
Posts: 11547
Loc: Vancouver, BC Canada
Sorry, but the G/L Reference field does not support the user-specified codes. Only the 2 G/L description codes.
We'd have to add Document code as a new Send to G/L Reference choice.
_________________________
Regards,
Softrak Tech Support

Top
#40723 - 03/19/14 01:03 PM Re: PO amounts in Ledger [Re: Softrak Support]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
The interesting thing is that on the Integration tab of PO's Company Profile, we have:

Send to AP reference field: Original doc number
Send to AP description field: Receipt number

Actually what it sends to AP is the RC (Receipt number) to the Reference field and the ADJ (Invoice) to the description field. Document Code it's not even an option that's available but we're getting the ADJ# in AP. If this is a glitch, it is a great one!

Hope you can add the ability to send ADJ#'s to Ledger.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#40742 - 03/20/14 11:00 AM Re: PO amounts in Ledger [Re: SusanTennier]
Softrak Support Online   happy

Adagio Action Team

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

You are also able to send more than one user defined code to GL within the Description fields. For example, you might send:
%dno %vnm As space is limited, you would want to use the smaller code first as it's possible that the information for the second code would be truncated, or not, depending on how many characters the information uses.
_________________________
Regards,
Softrak Tech Support

Top


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