Re: Vendor Invoice Macro

Take a look at data detail flowing to GL.

In earlier versions of BPCS, this managed by GL maintenance menu, then GLD119 whether summarize or detail those transactions.

Also for some individual inventory transactions, such as how we receive inventory from vendors on Pos, we changed transaction effects to send them to their own unique GL Journal prefix, and do detail, where most transactions remain summary form.

With enough detail, the reference fields of GL journal end up including: item#; PO#; invoice#; check# that pays invoice; vendor#. The vendor # (5 digits) ends up in same field as customer # (6 digits) from activity related to shipping, billing, getting paid. So I have some logic based on the prefix of journal and content of field (are there blanks?), if 5 digit #, check vendor master, if 6 digit # check customer master, with name of whatever added to a column of report supplied to the auditors.

-
Al Mac
Happy my weight is only 325 pounds.
-----Original Message-----
From: bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx [mailto:bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx] On Behalf Of antwi, isaac a.
Sent: Wednesday, January 20, 2010 6:08 AM
To: BPCS ERP System
Subject: [BPCS-L] Vendor Invoice Macro
Importance: High

Hi All,

Is there any vendor invoice macro for ITEM NUMBER? I have tried all that came with ERP LX and none seem to work. I want to use it as a reference in the Reference 2 field in the GLH especially for PO invoicing.

I created one PPROD from the HPO file but when you process an invoice, all the line display the first item on the PO.


Thanks & Regards,

Isaac Ayeh Antwi
Business Systems Manager

Knowledge & Information Solutions
Anglogold Ashanti Limited
Tel: +233-(0)582-40494 ext. 1591
Fax: +233-(0)582-41008
Cell: +233-(0)24-4335562
Email: iantwi@xxxxxxxxxxxxxxxxxxxxxxx

ï Think before you print.