Wow! This thread has gone on several different directions...
I've been working with BPCS since v4.02 both as a user and later as consultant.
While I do agree that there are certainly areas of BPCS that would benefit greatly from updating (including ACP module), the original question regarding the POSTING TO GL out of ACP cannot be answered with any comparison of versions pre 6x to any after. This is because of the TOTAL REWRITE of the GL package.
Benneth, I suggest that you take a look at all levels of summarization to ensure that you have them set to either "None " or "Summmary with Detail" . You mentioned that you have the posting set to detail, but that all PO's are summarized into a single line. The system would not total any lines when set to detail only. Keep in mind that w hen set to "Summary with Detail" , the reference fields in the first detail line will be used as the reference fields in the summary line - this is often confusing because the summary line is often what is seen when viewing the GL posting and when users are looking at reporting. When looking at the GL Posting Lines in the Inquiry Programs, the system will display a flag if the line is summarized. When drilling into the detail lines, you will be able to see the reference information for each line.
Here are two areas for you to check...
1 - Summarization. In your version it occurs in two areas - Natural Account Segment and Journal Source Code. Sounds to me as though if other journal lines in the posting are showing detail lines, then the Natural Account is either set to Summary or Summary with Detail.
2 - Macros. You didn't mention the macro(s) that you are using for capturing the PO Data on your posting lines. For your reference data I suggest you use macros from ASD file where available Â- for example for PO Number using SDSG01 instead of VI01PO.
Please also make good use of the ATP Guide - it is an excellent source of information regarding CEA. I'm not saying that it is perfect, but it is very helpful. For new users such as yourself, it is now your best friend.
Hope this provides you with some guidance.
Please do not hesitate to contact if you need anyting further.
Mike Sandor
-----Original Message-----
date: Wed, 29 Jul 2009 13:30:01 -0500
from: "Al" <macwheel99@xxxxxxxxxx>
subject: Re: [BPCS-L] Mutiple PO entry on one Invoice
ERP is primarily serving needs of manufacturing, where supply chain and
accounting is secondary priority. ÂDon't hold your breath on seeing quality
upgrades.
The ERP vendors have been gobbling each other up in acquisitions. ÂIn theory
each ERP has something great to offer in competition, and good quality
software places can combine what they have aquired to supply an outstanding
superior package some time in the future. ÂBut as they become more
monopolistic and less competitive, there is less incentive to deliver this,
so the future instead probably holds a choice of one and only one ERP
vendor, probably called Microsoft, and that which exists in the open source
world.
Before Infor, there was SSA, which in the early days used outside
consultants to sell BPCS. ÂThese consultants made a LOT of $ by tailoring
BPCS to WORK effectively at the client sites, then they went looking for
other places using BPCS, to sell their fixes. Â
When SSA started to sell BPCS directly, they were amazed that how much work
was needed to get BPCS working good. ÂDid they fix that in future versions?
Well not exactly. ÂThere were a lot of consultant packages that they could
enter into partnership with, to offer to all BPCS customers, maybe trade the
3rd party places off against each other for which could provide the best
deal to SSA.
There's not as many of those 3rd party places around now for BPCS as in
years gone by, but there are still some good ones serving our market, and
relevant to your situation, such as
CASH BOOK
UPI
I presume you have found the ACP documentation on-line in the file BPCSDOC
(each member is a different application's documentation)
Some aspects of it are a bit misleading.
For example, in the 3 way mismatch, it is possible to pay more than once for
the same PO/receiving. We had a case of a delivery that fell off a truck,
that we returned for credit we never got, ordered replacement, were billed
for original, and replacement, paid both. ÂI found by creating OUTFILE
summary of all receipts to match with OUTFILE summary of all paid for, each
sub-totalled by vendor PO item cost, to identify discrepancies. ÂThere were
A LOT of discrepancies.
There are also complications like drop ship.
We order from vendor-A which contacts vendor-B to send us the product, which
contacts vendor-C to send it to us. ÂWe also have other PO's with vendor B
and C for other items. ÂNone of the paperwork explicitly says drop ship
involved. ÂWe have to jigsaw puzzle deduce what happened, when we suspect a
vendor paperwork has a mistranscription on our PO#, which also happens.
-
Al Mac
-----Original Message-----
From Benneth Dobrowlski
Sent: Wednesday, July 29, 2009 11:10 AM
To: BPCS ERP System
Subject: Re: [BPCS-L] Mutiple PO entry on one Invoice
Thanks for your response, Al. We are already set for detail mode for Ap
batches. Accounting is already using the same technique you mentioned to go
around the problem with multiple POs. I'm a little surprised nobody out
there is using this functionality. I'd appreciate, if INFOR folks can jump
in and educate all of us for this existing functionality.
Cheers!
Ben
On Tue, Jul 28, 2009 at 8:11 PM, Al <macwheel99@xxxxxxxxxx> wrote:
6.1.1 Mixed mode may have functionality not found on earlier versions.
We're on 405 CD Mixed mode, which does not permit one vendor invoice to
have
more than one PO, even though there are vendors who do so.
What we do is enter the same vendor invoice more than once, via separate
ACP500 batch runs.
12345A for PO-A
12345B for PO-B
12345C for PO-C
Etc. playing jigsaw puzzle with how much $ to have for each invoice.
When you are doing the ACP500 there is some option to change the default
GL
entries. ÂHow much of the invoice is freight, discount, etc.
The ACP500 process creates a GL batch (prefix AP) which is not
automatically
posted until someone runs the job to post the GL batches that are pending
since the last mass post.
Before then, someone can go into GL journal batch maintenance, and tinker
with the GL batch, to accommodate exception situations & fix any oops.
You might also take a look at your GL business rules for AP batches.
Are you posting in summary or detail mode? If summary, you may need to
switch to detail.
Note that there are also add-ons to simplify this accounting challenge.
-
Al Mac
-----Original Message-----
From: Benneth Dobrowlski
Sent: Tuesday, July 28, 2009 1:39 PM
To: BPCS-L@xxxxxxxxxxxx
Subject: [BPCS-L] Mutiple PO entry on one Invoice
Hallo,
I'm a newbie to BPCS apps. We are 6.1.1 Mixed mode. I've been testing an
existing functionality in ACP module to enter mutiple PO's for one invocie
by following the understated script:
1. Enter an Invoice with multiple PO's. (ACP500D1-01)
2. Follow process for matching the POs: If all matches, hit <Enter>
3. In next screen ACP500D4-01, hit <Enter>; this will show the $ amount
just
allocated.
4. <F12> to return to screen showing "Next PO....Enter the next PO showing
on the invoice
5. Enter/enter again, then hit <F12> to continue to enter "next PO" #s
until
all PO's on the invoice are matched/entered.
6. Press <F6> on screen ACP500D4-01
7. Press <F6> on the final screen ACP500D4-02
All the transactions posted to the AP are correct. All BPCS Inquiries,
Payables, PUR300 and INV300 are matching the invoice entry. The main
problem
is the GL posting. The total units and accumulated amount is lumped into
the
FIRST PO. Can anybody shed some light what we are doing wrong in the
process
to properly post the GL? Thanks in advance for your help. I intend to be
pro-active on this invaluable BPCS forum.
Cheers!
Ben
--
midrange.com
