|
Folks -- We use BPCS V4.0.03. There is some concern in Accounting about the GL entries from the invoicing process. I am putting together some queries to connect the invoice detail (RAR) to the journal entries (GJD). One issue I am having is that the SIGN of the discount field is not predictable, while the sign of the does not appear to be. In simpler terms . . . for the original amount and tax amount fields, you can add them as you accumulate invoices, credits, debits and payments and they will net. But somehow this doesn't work for the discount field. Can anyone enlighten me as to when a positive discount amount increases the amount remaining and when a positive discount amount decreases the amount remaining. It appears to be different based upon the record type. Cust Orig Seq. Original Date Rem. Discount Rec Nmbr Document No. Amt Posted Due Taken/Due ID Number 30010 740888 5710.90 11018 .00 202.33- ZI 30010 740888 2 1457.30- 11231 .00 .00 ZP 30010 740888 3 2142.48- 20118 .00 202.33- ZP 30010 740888 4 1908.79- 20131 .00 .00 ZP 167000 311040 7829.28 11011 .00 78.29 ZD 167000 311040 1 7829.28- 20219 .00 .00 ZC Thanks! >>> SSegerstrom@intermatic.com 01/10/03 07:56AM >>> May or may not be a silly question; we were having much the same issues and infighting over system integrity (BPCS 6.04 Heavily modified). We created a cradle to grave tracking system so that as orders were released from certain defined holds (for us - edi release, credit release, couple others) we would record the user, time and date. This put an end to the question - who released my orders from credit hold (etc). -----Original Message----- From: Paul LaFlamme [mailto:laflammep@kennedydc.com] Sent: Friday, January 10, 2003 7:17 AM To: 'SSA's BPCS ERP System' Subject: RE: Credit Check Fail? This may be a silly question, but are you positive no one released the order from Credit Hold? If the order was taken off hold (IE ORD580 Credit Hold Release) then it won't matter what the credit limits, etc are... Paul LaFlamme Manager of MIS -----Original Message----- From: bpcs-l-bounces@midrange.com [mailto:bpcs-l-bounces@midrange.com]On Behalf Of Lim, ChangYang Sent: Friday, January 10, 2003 3:58 AM To: 'bpcs-l@midrange.com' Subject: Credit Check Fail? Dear All, Have anyone experienced this issue before? The customer account supposed to be locked, the available credit is in negative value, and so does the oldest unpaid invoice has already exceeded the grace period given. Somehow for some unknown reasons, when the sales order is entered into the system, the order can be processed via pick release/pick confirm and invoice release. That's strange. In the ECH, the credit hold flag CHCRDH is '00'. I could not find any similar incidents or anything like that in SSA GT knowledge base. Any help is appreciated. Big thanks to everyone. Regards, Lim, ChangYang Business Analyst ---------------------------------------------------------------------------- -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. ============================================================================ == _______________________________________________ This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo.cgi/bpcs-l or email: BPCS-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. _______________________________________________ This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo.cgi/bpcs-l or email: BPCS-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. _______________________________________________ This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo.cgi/bpcs-l or email: BPCS-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.