MIDRANGE dot COM Mailing List Archive



Home » SYSTEM21 » February 2000

RE: Problem with G/L period on some invoices


  • Subject: RE: Problem with G/L period on some invoices
  • From: "Peralta, David" <PeraltD2@xxxxxx>
  • Date: Tue, 15 Feb 2000 23:01:23 -0000

fixed

Dan,

We've had some instances of blank period numbers in OEP65 / OEP70 in the
past but not recently.  I think it was something to do with consolidated
invoicing which we now avoid at all costs.

We routinely get invoices with different period numbers in OE, SL and GL.
Scenario as follows:

- 9912 invoice is "held" for some time eg due to no valid price on system
- Month end is run for period 10001 for Inventory and Sales Ledger, but
invoice is not posted as still held (print flag on OEP65 = H)
- GL is not yet closed (ie still in period 1000) as cashbook etc not
completed.

My understanding is, if the price is now entered on the system, the invoice
will be released at the next invoice run.  It will retain its SOP period
stamp (9912), will post to the first available SL period (10002) and the
first available GL period (10001).

All makes for good fun reconciling the modules!

David

> ----------
> From:         Dan Thomas[SMTP:DThomas@lpw-mdi.com]
> Reply To:     JBAUSERS-L@midrange.com
> Sent:         15 February 2000 21:12
> To:   'JBAUSERS-L@midrange.com'
> Subject:      Problem with G/L period on some invoices
> 
> We have some invoices that are posting to G/L  (PSTPER/FLP08) with the
> wrong
> period, meaning not what it should be based upon our inventory period end
> calendar.  We use AFI.  We seem to have two recurring scenario's with
> problems.  
> 
> First scenario is with some invoices created as part of normal product
> shipment confirmation:
> Period in A/R is correct (PPER15/SLP15)
> Period in OE Invoice file is blank (PERN65/OEP65)
> Period in AFI is blank (PRDN45/FIP45)
> 
> Second scenario is with manual invoices and credits (12 - 15 on OEP menu):
> Period has same incorrect value in PERN65, PPER15 & PRDN45.
> 
> My suspicion is that the first scenario is related to some bug we've
> introduced that is causing PERN65 to be blank and that the other files
> being
> blank is a result of that. The second scenario might be situations where
> we
> ran the end of month functions late, causing an "incorrect" default period
> in the manual invoice/credit program.
> 
> Another general question is this, is the G/L period supposed to be based
> upon current period in the inventory Calendar file, or where the invoice
> date falls in the inventory period end control file.  It was my
> understanding that you could post a single set of invoices that had dates
> spanning two different G/L periods and that they would post to the correct
> period, as opposed to simply going into the current period.  
> 
> I appreciate any feedback.
> 
> Dan Thomas
> Sr. VP Information Systems
> Medical Distribution, Inc.
> 4500 Progress Blvd.
> Louisville, KY  40218-5058
> Phone (502) 454-9013 ext. 120
> email  DThomas@lpw-mdi.com
> 
> +---
> | This is the JBA Software Users Mailing List!
> | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> JBAUSERS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: doug333@aol.com.
> +---
> 
+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact