RE: Sales Ledger Contra

Neil,

Have you considered populating the SLPi0 and SLPi1 files and kicking off the
sales ledger interface program?  (Call SLI00CLP).  

JBA used to have a nice document showing how to populate the Sales Ledger
interface files.  Perhaps you can still obtain it from Geac.  The interface
is used by the Job Management and Service Management modules to post
invoices to the Sales Ledger.

By processing the "credits" through in this manner, you will affect all of
the SLP files without having to re-engineer how to do it.  Also, this would
leave a trail in your database that shows the offset being taken.  (As
opposed to just reducing the balances)

Once the process completes, you would still have to allocate the credits to
the invoices to clear the open balances.  Depending on the allocation
methodology that your company uses, this could be rather painless.

-Mike

-----Original Message-----
From: Neil Thursby [mailto:neil.thursby@xxxxxxxxxxxxxxxxxxxx] 
Sent: Friday, June 25, 2004 3:41 AM
To: System 21 Users
Subject: RE: [SYSTEM21] Sales Ledger Contra


Michael,
Thanks for the reply.
Numerous customers are involved.   We pay them commission by way of credit
notes on their Sales Ledger account.  An off-AS400 system decides which
Invoices should be downed by which credits, and that will supply a file to
the 400 for processing.  

Basically, I'm looking at changing the balance due figures on the relevant
SLP15 and SLP20 records.  Just wondered if anyone has experience of this,
and whether period balances might need updating too?

Regards,

Neil.


-----Original Message-----
From: Michael Berman [mailto:berman@xxxxxxxxxxxxxx]
Sent: Friday 25 June 2004 03:38
To: System 21 Users
Subject: RE: [SYSTEM21] Sales Ledger Contra


Neil,
How many customers are involved?
Could you use the Contra Accounting Function?


Regards

Michael Berman

(m) 0419 324 558

-----Original Message-----
From: system21-bounces+berman=pacific.net.au@xxxxxxxxxxxx
[mailto:system21-bounces+berman=pacific.net.au@xxxxxxxxxxxx]On Behalf Of
Neil Thursby
Sent: Thursday, 24 June 2004 9:27 PM
To: System 21 Users
Subject: [SYSTEM21] Sales Ledger Contra

We would like to run a simple Contra on A/R open items via a batch program
that reduces the balance on a particular invoice by part or all of the value
on a credit note. The CR would also have it's balance reduced by that
amount.

I'm happy with the way we intend controlling and logging these entry's, but
my question is - has anyone ever "adjusted" balances on SLP15 and SLP20 in
this way?

Thanks in advance,

Neil.

_____________________________________________________________________
This transmission and any attachments are confidential and are intended
solely for the named addressee (s). If you are not the addressee, please do
not read, copy, use or disclose this transmission and please notify us
immediately by telephone on
+44 (0) 1670 594848 or by reply.  Please then delete this transmission 
+from
your system.

Although we have taken steps to ensure that this email and attachments are
free from viruses, we advise that in keeping with good computing practice
the recipient must ensure that they in fact are virus free.

No contracts may be concluded on behalf of Fone Logistics LTD by means of
email communications.

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.


_____________________________________________________________________
This transmission and any attachments are confidential and are intended
solely for the named addressee (s). If you are not the addressee, please do
not read, copy, use or disclose this transmission and please notify us
immediately by telephone on 
+44 (0) 1670 594848 or by reply.  Please then delete this transmission 
+from your system.

Although we have taken steps to ensure that this email and attachments are
free from viruses, we advise that in keeping with good computing practice
the recipient must ensure that they in fact are virus free.

No contracts may be concluded on behalf of Fone Logistics LTD by means of
email communications.

_____________________________________________________________________
This transmission and any attachments are confidential and are intended
solely for the named addressee (s). If you are not the addressee, please do
not read, copy, use or disclose this transmission and please notify us
immediately by telephone on 
+44 (0) 1670 594848 or by reply.  Please then delete this transmission 
+from your system.

Although we have taken steps to ensure that this email and attachments are
free from viruses, we advise that in keeping with good computing practice
the recipient must ensure that they in fact are virus free.

No contracts may be concluded on behalf of Fone Logistics LTD by means of
email communications.

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.