• jnkk
  • Member
  • Offline
  • From: Malaysia, KL
  • Registered: 08/16/2010
  • Posts: 26

Topic: supplier details listing

Hi, I would like to add a supplier details listing on the supplier report & analytic just like the customer details listing. Would like to know what I should include.

Was trying to replicate the customer details listing coding for supplier but having difficulties. not a hardcore php programmer.. just a beginner but willing to learn.

as I know, for customer details listing, its using the debtors_master table. So, for supplier details listing, I should be using the suppliers table, right? But I notice in the customer details listing rep103.php it includes other data field from other tables as well. Do I need to include some data related fields from other table as well for the Supplier details listing? need your expert advise.

So far, I've done:
- duplicate file for rep103.php to rep205.php
- duplicate code in reports_main.php
- currently stuck at coding for rep205.php

Need help with the function codes.

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: supplier details listing

Hi,
First of all you don't need the JOINs. You do not have that much information on the suppliers that you need this. But you may want some other information from the suppliers table.
The transactions should be taken from the supp_trans table instead of debtor_trans table.
I hope this is adequate info for you. If you end up with a nice and usable report, please share it with us.

/Joe