Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options
being trying to integrade FA into a service company i have faced a lot of problems due to some restrictions so my wish list is...
1.price and discount are fixed boxes where a seller cant change price or discount.This are fixed in item inventory were you define price.
2.Discount can be placed in sales kits as this way it will be more usefull as you could offer specific package of goods in a discount price.
3.Discounts can be also applyied in the form of codes were this can be entered.
4.Branches could be determined and then can be choosed when entering a new customer so you dont need to type exactly the same.
This is some of my hopes that someday may there are in the FA.
is this working?.It is a feature that it is missing on fr.It will be good to insert items into goods and then the price will be in a box without input so noone can change it in invoice.
A new update with only info of what we want and by editing the 2 date inputs you can get the report with the dates you want
select 0_cust_branch.debtor_no,0_cust_branch.salesman,0_sales_orders.debtor_no,0_sales_orders.trans_type,0_sales_orders.total,0_sales_orders.ord_date, SUM(total) as "total sales"
from 0_sales_orders
inner join 0_cust_branch on 0_sales_orders.debtor_no = 0_cust_branch.debtor_no
where trans_type=30 and ord_date >= '2013-01-01' and ord_date <= '2013-03-28'
group by salesman
hi apmuthu can you give us a more detail of your answear as i am confused.
I was hoping of editing the sales_order_entry where we could change the input_num('price') to something else to display only the price.so far no good i havent fount anything good.
trying my luck in sql i have created this query:
select 0_cust_branch.*,0_sales_orders.*, SUM(total) as "total sales"
from 0_sales_orders
inner join 0_cust_branch on 0_sales_orders.debtor_no = 0_cust_branch.debtor_no
where trans_type=30
group by salesman
This will join the 2 tables cust_branch and sales_order then match debtor_no and sum the sales orders by salesman.
Tester and opinions are always welcomed :-)
Well none of the above is ok.Being trying to figure out what tables is needed i cant figure out exactly nor find any documantation on the sys_types table and what the describe.I have found that the id=32 is the sales order which in my case is what i need.Thens in sales_order table i can use the trans_type which is 32 to the sales order and from there debtor_no is the customer number and total is the amount of the given sales order money.Then using debtor_no and join it with table cust_branch debtor_no and use also salesman id to identify the salesman.
This is a quick look of table.I will try to make some sql querys for the above.Any help will be welcome especially for creating a new report.Will keep you informed.
hi, i am new to frontaccounting and i must say it is awesome and beats down several free and commercial software.I try to learn it and the wiki is excellent for reference.I have a problem only with the reporting.I see that we can have a report with the sales that have being paid by the customers and the ammount of the commition the salesman deserves.Is there any report where we can see the sales orders the salesman have commited?I have found a way in the audit trail but there is no amount only the sales order submitted and no amount,can someone help me to display also the amount?
Posts found: 7
