Plus Community - for users of ACCPAC & Adagio accounting software

Welcome to the PlusCommunity forums! PlusCommunity is a gathering place for companies running Simply Accounting, ACCPAC Plus, Sage Accpac ERP (ACCPAC Advantage/ACCPAC for Windows), and Adagio Accounting.
New visitors, please click here!

Page 1 of 1 1
Topic Options
#53641 - 06/22/18 03:42 AM AR Receipt
Mr Mayor
Member


Registered: 04/22/09
Posts: 467
Loc: Zimbabwe
When you print the AR receipt it shows invoice number that you applied the receipt to and no details.
Went in the report which uses table ARTCR to add TEXTRMIT to the report and all is ok
Issue is the text description won’t come out if it’s a prepayment not linked to any particular invoice. I want the description to pull through regardless
_________________________
-—oOo—-
If you don’t make it first time, sky diving wasn’t meant for you

Top
#53642 - 06/22/18 04:14 AM Re: AR Receipt [Re: Mr Mayor]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7643
Loc: Location, Location
It's not linked, so there's nothing to print!
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53643 - 06/22/18 04:55 AM Re: AR Receipt [Re: Jay Converse]
Ettienne
Member


Registered: 06/28/02
Posts: 3638
Loc: Orlando, Florida USA
Which description?
_________________________
Sage 300 ERP Certified Consultant

Top
#53644 - 06/22/18 05:02 AM Re: AR Receipt [Re: Ettienne]
Mr Mayor
Member


Registered: 04/22/09
Posts: 467
Loc: Zimbabwe
Entry Description. You receive $100 cash from Ettienne PVT LTD for Zambezi Lager sales so you put Zambezi Sales as description and print out the receipt to give the customer. But the receipt is only printing the amount not description
_________________________
-—oOo—-
If you don’t make it first time, sky diving wasn’t meant for you

Top
#53645 - 06/22/18 05:48 AM Re: AR Receipt [Re: Mr Mayor]
Ettienne
Member


Registered: 06/28/02
Posts: 3638
Loc: Orlando, Florida USA
Edit the report to include that field, but you will need to use a formula to only pull that field if the payment is not linked to a report.
_________________________
Sage 300 ERP Certified Consultant

Top
#53646 - 06/22/18 06:28 AM Re: AR Receipt [Re: Ettienne]
Mr Mayor
Member


Registered: 04/22/09
Posts: 467
Loc: Zimbabwe
That’s where I’m stuck on that formula
_________________________
-—oOo—-
If you don’t make it first time, sky diving wasn’t meant for you

Top
#53647 - 06/22/18 06:31 AM Re: AR Receipt [Re: Mr Mayor]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7643
Loc: Location, Location
Use left outer join, then

if isnull(&fieldname) then x else y
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53661 - 06/26/18 02:32 AM Re: AR Receipt [Re: Jay Converse]
Mr Mayor
Member


Registered: 04/22/09
Posts: 467
Loc: Zimbabwe
Thank you
_________________________
-—oOo—-
If you don’t make it first time, sky diving wasn’t meant for you

Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: