1 Topic by notrinos (edited by notrinos 09/04/2018 02:01:20 pm)

  • From: Vietnam
  • Registered: 09/28/2016
  • Posts: 349

Topic: Missing store data for Salesman on debtor_trans table

Let says we have 2 salesman : Salesman1 and Salesman2
And we have a customer named MoneyMaker ltd with it's branch MoneyMaker which has assigned for Salesman1

By 1st Sep 2018 we created an invoice #1 for MoneyMake with it's value $300.
By 4th Sep 2018 we reassigned MoneyMaker for Salesman2 then created invoice #2 for same customer with value $200.

Now, print report for Salesman Listing (rep_106) we will see Grand Total of Salesman1 is zero, and Salesman2 is $500.
This seems wrong since Salesman1 has $300 revenue and Salseman2 has $200.

This problem happened because in debtor_trans table we only refer to branch_code without store saleman_code for transactions.

Will need to add column salesman_code for debtor_trans table and modify function write_customer_trans() as well. Also change SELECT query in rep_106 and may somewhere else.

Phuong

notrinos's Website

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

Re: Missing store data for Salesman on debtor_trans table

Thanks @notrinos.

We can fix this to the next major, 2.5. It is not possible to change db structure during minor releases.

Joe

3 Reply by kvvaradha (edited by kvvaradha 09/04/2018 03:52:12 pm)

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,182

Re: Missing store data for Salesman on debtor_trans table

Yes its good to hear.

The salesman part should extend with  login access to each sales person. We need to like sales person with users table

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Missing store data for Salesman on debtor_trans table

A suggested mod may be in order in the meanwhile.

apmuthu's Website