 | | | Case Studies - Manufacturing
| | | Configuration of BPCS (6.1 & 6 .02) (Supply Chain, Finance & Manufacturing) | | Client | International Comfort Products, USA | | Technology | AS/400, RPG/400, RPGILE, CL400, AS/SET | | Description | Initially worked in Manufacturing area for handling different issues on shop floor control and purchasing (shop order print, purchase order print, purchase order receipts, contract maintenance, purchase price variances report, scrap inventory report, physical inventory changes, physical inventory tag print changes) for two different manufacturing facilities. Handled the issues in Order entry, Out Bound Shipment, Account Receivable, Account Payable, Warranty (Customer credit hold problem, separate Account Receivable ageing reports for different customer group, consolidated ageing report, Invoice print program changes from base BPCS format to clients format, setting of different queue for different invoice type, Fixing Tax calculation problems for Canadian facility, handling all kind of billing issues, wrote a totally new module to post the Distributor commissions to Account payable file and General Ledger, wrote a new module to post the Customer Claims to Account Receivable file and General Ledger file, separate Account Payables ageing for different Vendor groups , type and currency combination, fixed 2nd discount problem in ARP, wrote a program for finance charge invoicing, and charge back reports programs, wrote User Vision reports for end user, Cross reports - out of sales history and account receivable to check for consistency of AR balancing , wrote programs to post warranty claims to ledger , to find the missing serial no in Warranty ) for three different facility two in US and one in Canada. Wrote a interface (FTP transmission and Report) module to generate and transfer the CCI (Canadian Custom Invoice) to Canadian customs for various load information. Wrote FTP program for transmission of literature orders to XEROX which are entered trough Power Link (Online order entry) and wrote programs to receive the shipped orders from Xerox and pick confirm them in BPCS. Worked on ICP & Carrier (BPCS & GEAC) AP Integration project which involves moving 'U' transaction data from Inventory traction detail, purchase order header /detail, warranty claims payment and dealer commission information to GEAC from BPCS by FTP |  | |