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
#54169 - 12/10/19 09:50 AM AR terms 999 days max
Ettienne
Member


Registered: 06/28/02
Posts: 3673
Loc: Orlando, Florida USA
In AR terms setup number of days is limited to 999 days.
We have a client who has multiple payment schedules with 48 monthly payments for example, so 999 is not enough days.
Are there any workarounds to this limit?
I've tried altering the field in SQL, yeah it does not like that
_________________________
Sage 300 ERP Certified Consultant

Top
#54170 - 12/11/19 10:33 PM Re: AR terms 999 days max [Re: Ettienne]
Jurgtens
Member


Registered: 07/19/07
Posts: 38
Loc: South Africa
Hi Ettienne

If you use a Multiple Payment Schedule and select the "End of Next Month" option, you can go to 47 lines, each with a percentage of 2.0833. The 48th must be 2.08349.

When doing the invoice it splits the due dates from now for 48 months.

Hope this is what you are looking for.

Top
#54171 - 12/12/19 01:27 AM Re: AR terms 999 days max [Re: Jurgtens]
Ettienne
Member


Registered: 06/28/02
Posts: 3673
Loc: Orlando, Florida USA
Invoices are due on the 15th of each month
_________________________
Sage 300 ERP Certified Consultant

Top
#54172 - 12/12/19 01:36 AM Re: AR terms 999 days max [Re: Ettienne]
Ettienne
Member


Registered: 06/28/02
Posts: 3673
Loc: Orlando, Florida USA
I switched to "Day of next month" and it almost works.
Just one kink, the first payment is a down payment/deposit due today, then the others are due on the 15th starting next month.
I will play some more.
_________________________
Sage 300 ERP Certified Consultant

Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: