11-27-2019, 04:00 AM,
|
|
ALEXSHEN
Senior Member
|
Posts: 132
Threads: 34
Joined: Sep 2019
|
|
DASHBOARD "Overdue Customer Balances" by different salesman
Hi every,
"Overdue Customer Balances" can't be distinguished completely on DASHBOARD by different salesmen.
A Customer "AA", Branch office "AA1" belong to Ali, “AA2" belong to Bill, "AA3" belong to Carol, Ali sold goods to AA1, some money didn't cover, but Bill and Carol all can see this business and amount not covered, It seems not so good, so if possible to set what only theirselves can check their sales?
Alex
|
|
11-29-2019, 07:32 PM,
|
|
ALEXSHEN
Senior Member
|
Posts: 132
Threads: 34
Joined: Sep 2019
|
|
RE: DASHBOARD "Overdue Customer Balances" by different salesman
(11-29-2019, 03:32 AM)falkoner Wrote: I don't use this dashboard code, so I don't really know the code and it's hard to comment. However from a quick glance at Dashboard.php I would say the quickest way to do this would be to change the SQL starting at line 87 to show overdue items by Debtor/Branch combination, rather than just Debtor, and then change the condition at line 83 to exclude branches other than the ones belonging to that salesperson. Unfortunately I don't have the time right now to figure out the details.
Tim
Hi Tim,
Ok, thank you very much! I will try it late.
Alex
|
|
11-30-2019, 12:53 AM,
(This post was last modified: 11-30-2019, 02:02 AM by TurboPT.)
|
|
TurboPT
Administrator
|
Posts: 727
Threads: 10
Joined: Jun 2012
|
|
RE: DASHBOARD "Overdue Customer Balances" by different salesman
It looks like the query filters to a specific sales person.
They may each have their own login, but have any salesperson entries been created so that the Restrict to Sales Person option can be set at user maintenance?
A link to Sales People is on the Setup menu, middle column. Entries created here will appear at the Restrict to Sales Person option.
I'm checking other handling relative to the salesperson filter, which appears to be ok so far.
I setup a sales person entry for myself, and even though I'm admin, I set the restrict option to my entry.
After logout and re-login, the outstanding balances table was blank.
I then unset the restrict option, and after logout and re-login again, the balances reappeared.
So, the sales person handling should be ok.
|
|
12-02-2019, 07:16 AM,
|
|
ALEXSHEN
Senior Member
|
Posts: 132
Threads: 34
Joined: Sep 2019
|
|
RE: DASHBOARD "Overdue Customer Balances" by different salesman
(12-02-2019, 05:57 AM)TurboPT Wrote: @Alexshen:
Can you try the attached script to see if it achieves the desired goal?
Hi Paul,
Thank you very much, I will try it late
Alex
|
|
12-02-2019, 09:16 AM,
|
|
ALEXSHEN
Senior Member
|
Posts: 132
Threads: 34
Joined: Sep 2019
|
|
RE: DASHBOARD "Overdue Customer Balances" by different salesman
(12-02-2019, 07:16 AM)ALEXSHEN Wrote: (12-02-2019, 05:57 AM)TurboPT Wrote: @Alexshen:
Can you try the attached script to see if it achieves the desired goal?
Hi Paul,
Thank you very much, I will try it late
Alex
Hi Paul,
Seems Nothing change, Second salesman still can find the first salesman information under the same Customer different branches.
Alex
|
|
|