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

Topic: Relationship between User and POS

Currently we have a field user in the table 0_audit_trail to store relationship between users and transactions.
In the future when transactions statistics for sales points is needed, developers can use user field in the table 0_audit_trial then join it with table 0_users to know which transaction is belong to which sales point.
This would cause wrong statistical problem if an user is moved to another sales points.
So it is necessary to have additional field pos_id in the table 0_audit_trail to fix the relationship between transaction and sales point

Phuong

notrinos's Website

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

Re: Relationship between User and POS

@notrinos,  I think it may help you.
We have a field in users table for pos. With that POS id will be saved in users table. User id will be entered inside audit trail. With that you can relate it by writing a join query

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

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

Re: Relationship between User and POS

No @kvvaradha

Says user A who belonging to POS 1 has his revenue $1000 so we can use a join query to get POS 1's revenue is $1000
Now please move user A to POS 2 to see what happens, that $1000 will become POS 2's revenue.
I dont know if any business accepts this practice.

Phuong

notrinos's Website

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

Re: Relationship between User and POS

This is rare case. Usually people check the Salesmans sales history and balance. But if you want to maintain the balance of terminal. You need to bring the POS id into the debtor trans and stock moves table to get the total cost of a terminal and item details.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website