Does anyone out there know what tables to use for an AP Payment Register Report and an Inventory Activity Report?? I've found that the canned reports access temporary tables that have no data without parameter inputs through epicor. Where is the AP history table and the inventory activity table?? Help!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
AP and Inventory Activity Reports from Epicore 1
- Thread starter mwake
- Start date
-
1
- #3
If you have the CWB CD - it has dataflow diagrams/schema on it. If not, I can send you a Word document that shows dataflow for Accounts Receivable and Accounts Payable. The posted payment header table is APPYHDR, detail is APPYDET and the "history/aging" table would be the APTRXAGE. Transactions in this table are identified by trx_type. I worked in technical support for Epicor for several year. Feel free to contact me with more questions.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question