Author Topic: Customer Account Statements  (Read 11272 times)

JohnS

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 677
Customer Account Statements
« on: September 01, 2013, 09:53:33 pm »
Emre,

Are you planing any sort of a Customer Statement System in the very near future?

The only thing missing for my latest venture is being able to print statements.
« Last Edit: September 11, 2013, 10:02:40 am by JohnS »
SambaPOS - POS'n the World, one Terminal at a time.

emre

  • SambaPOS Developer
  • Samba Team
  • Hero Member
  • *****
  • Posts: 1564
Re: Customer Statements
« Reply #1 on: September 03, 2013, 06:57:31 am »
I don't know how it should work. What should we do more than taking ticket notes?

JohnS

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 677
Re: Customer Statements
« Reply #2 on: September 03, 2013, 07:09:43 am »
I mean Customer Account Statements, so we can send to customers each month for payment.
SambaPOS - POS'n the World, one Terminal at a time.

emre

  • SambaPOS Developer
  • Samba Team
  • Hero Member
  • *****
  • Posts: 1564
Re: Customer Statements
« Reply #3 on: September 03, 2013, 08:43:23 am »
We did something similar to send SMS message to notify payments. What should we print?

JohnS

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 677
Re: Customer Statements
« Reply #4 on: September 03, 2013, 09:39:21 am »
A statement of what they owe us.
We give a customer a line of credit, and the customer pays at the end of each month.

We need a Balance Brought Forward from previous month, and a list of any purchases and payments for the current month.
« Last Edit: September 03, 2013, 09:42:02 am by JohnS »
SambaPOS - POS'n the World, one Terminal at a time.

emre

  • SambaPOS Developer
  • Samba Team
  • Hero Member
  • *****
  • Posts: 1564
Re: Customer Statements
« Reply #5 on: September 03, 2013, 10:50:53 am »
When you filter by month and print you'll see balance brought from previous month and this months transactions. But I know you already know that so I think you need something additional. Can you tell me what feature should we implement? Do you need purchases by product?

JohnS

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 677
Re: Customer Statements
« Reply #6 on: September 03, 2013, 11:24:09 am »
1. We need 'Ticket No' listed in Description to be able to link a line on the printout to an actual sale. Currently it lists
'Customer Account Transaction [Sheather Computer Services - Acct]'

2. It would be nice to have the first line say
'Balance Brought Forward'

3. We need Customer details listed, like postal address. Basically we need to be able to customise the header of the printout like we do Ticket Printer Receipts, but keeping in mind that we will be using laser printers.

4. Because it prints the current month, we may not do statements until the new month, so we need to be able to print for the last month instead.

5. Can we automate the printing of accounts to happen on the last day of the month?


Note - In regards to 4. I have an Account Screen for Customers, showing Details, and when I select a Customer and click Account Details it shows the full account history, not just a period like Month.
« Last Edit: September 03, 2013, 11:28:55 am by JohnS »
SambaPOS - POS'n the World, one Terminal at a time.

JohnS

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 677
Re: Customer Statements
« Reply #7 on: September 03, 2013, 11:37:57 pm »
I have just tested with some historical data to get a feel for what the Account Screens are displaying.

Having Customer Account screen filter set to Month shows their running balance only for the current month, but when you go to Account Details it shows all transactions for the Customer.

The way we would use this is to set the Customer Account screen to filter All to see what their total Account Balance is, not just for the current month, but be able to print only their Monthly transactions.

In Account Details we need a way to print by period like, Current Week, Current Month, Last Month, etc
SambaPOS - POS'n the World, one Terminal at a time.

JohnS

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 677
Re: Customer Statements
« Reply #8 on: September 11, 2013, 10:01:15 am »
When you filter by month and print you'll see balance brought from previous month and this months transactions.

I have done more testing and can not get the filtering to work correctly.

I have a 'Customer' Account Screen with Filter Type set to Month. The Customer balance is calculated on the months transactions only. When I click Account Details, it shows all historical transactions for the customer.

This should really work the other way around. The Customer Account Screen should show the Customers actual balance, and Account Details should show Balance Brought Forward and the current months transactions.
SambaPOS - POS'n the World, one Terminal at a time.

emre

  • SambaPOS Developer
  • Samba Team
  • Hero Member
  • *****
  • Posts: 1564
Re: Customer Account Statements
« Reply #9 on: September 13, 2013, 09:07:07 am »
Account Transaction screen filtering can be configured through account type.

JohnS

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 677
Re: Customer Account Statements
« Reply #10 on: September 13, 2013, 09:17:20 am »
The missing link :)

Thank you.
SambaPOS - POS'n the World, one Terminal at a time.