?
Solved

BPCS Windows Programming - Files ECH and ECL?

Posted on 2011-10-12
10
Medium Priority
?
846 Views
Last Modified: 2012-05-12
I am developing an application to add bpcs orders using vb.net. I am inserting records to the ECH and ECL files. My question is, I want to supply the least amount of information to these files and leverage the existing bpcs code to update the other necessary files, etc. when the user accepts the information (presses the F6 key on bpcs).

Is this a reasonable approach to take or does my application basically need to function as a bpcs emulator (e.g. take care of all the business rules and update all the files as necessary).

Thanks.
0
Comment
Question by:esemmoc
  • 5
  • 5
10 Comments
 
LVL 16

Expert Comment

by:theo kouwenhoven
ID: 36958027
What is the exacxt question?
0
 

Author Comment

by:esemmoc
ID: 36958123
The basic question is, if I want to have a 3rd party program create line items for a customer order (instead of entering the line items directly into bpcs), do I need to manage the business rules in the 3rd party program (checking the credit limit,writing to all the bpcs tables, etc.) or can I just export a subset of the data into the bpcs tables and have the actual bpcs application take care of populating the tables following the business rules after the user presses the F6 button to accept the order?

I know that's a mouthfull of a question and I suspect that what I need to do is basically create a bpcs emulator.  I would just like some opinions as to whether I should think in terms of emulator or is it possible to create something short of that and still have all the data populate correctly.  Right now I am populating the ECH and ECL and FZP files but I know there are a lot of other modules (tables) I need to be concerned with.
0
 
LVL 16

Expert Comment

by:theo kouwenhoven
ID: 36958993
Where do the orders come from? or how do you like to present them to bpcs?
a Text file, an interface, an Excel worksheet, Xml ??

 
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 

Author Comment

by:esemmoc
ID: 36959082
I am using .net oledb to write directly to the bpcs files.  I have a front-end vb program where the user enters the same information they would be entering into bpcs.
0
 
LVL 16

Expert Comment

by:theo kouwenhoven
ID: 36959182
some questions;

1. What is the benefit to let the user enter the same info in VB?
2. If it's the same info and the same validation, why do you need extra validation?
3. If extra validation is required, then you are to late when it it already in the as400 files I think?
4. must it be 100% direct connection or will it be a batch process?



0
 

Author Comment

by:esemmoc
ID: 36959309
1. What is the benefit to let the user enter the same info in VB?
   
    We have a system where a quote is first given to a customer.  This quote may or may not be the BPCS price.  That is where the VB program comes in.  We want to be able to enter the price one time instead of having to enter it again into BPCS.  I know there's a "Quote" option in bpcs but it doesn't satisfy all our requirements.
   
2. If it's the same info and the same validation, why do you need extra validation?
 
    If I am bypassing the bpcs engine, then I need to replicate the same validation rules the engine provides.

4. must it be 100% direct connection or will it be a batch process?

    If by batch you mean uploading at some point in a day for example then that might be a possibility.

0
 
LVL 16

Expert Comment

by:theo kouwenhoven
ID: 36961183
I know that there is an advanced Client Access Macro utility where it is possible to read an excel sheet and use that as input for a AS/400 (green screen), where processed lines in the excel-sheet wil be marked as green and error lines in red.
in that way you can use existing data as entry and also use the available bpcs validation.

If you are interested, I can look for an exampel
0
 

Author Comment

by:esemmoc
ID: 36962264
Yes that would be helpful.
0
 
LVL 16

Accepted Solution

by:
theo kouwenhoven earned 1500 total points
ID: 36972788
Hi esemmoc,

This is a working version just change the "COL1, COL2, COL3, COL4, COL5, COL5, COL6" where required and the "MY-APPLICATION"

EE doesn't allow me to send .mac files, so please rename the excel2as400.txt in excel2as400.mac to be able to use it as ClientAccess macro.
 excel2as400.txt
0
 

Author Closing Comment

by:esemmoc
ID: 37003706
I haven't yet had a chance to test it.  Thank you for your research.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Screencast - Getting to Know the Pipeline
Suggested Courses
Course of the Month12 days, 19 hours left to enroll

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question