Hello ebayram
Search this forum (search button at top) for pos, you will find some posts on pos that you can start to work with...
AM
127 08/28/2009 11:35:38 pm
Topic: help with a SQL statement (4 replies, posted in Reporting)
I would like some help with a SQL statement.
I know that the PO system is being worked on and will get better with time, but if I could just do a query on the database for now it would be a big help.
I would like to display columns 0_item_codes.stock_id, 0_item_codes.description, and maybe more later.
Where
0_loc_stock.loc_code =X and
0_purch_data.supplier_id =X and
0_loc_stock.reorder_level is => 0_stock_moves.qty
Something like that...
If anyone out there can help with this or has put a query together for PO's it would be a great help?
Thanks
128 08/21/2009 03:44:08 pm
Topic: moving money from one bank account to another (1 replies, posted in FA Modifications)
When you write a check for cash and add it to your cash on hand account, you get this error: DATABASE ERROR :
invalid payment entered. Cannot pay to another bank account
sql that failed was :
You must go to Journal Entry and calculate the exchange rate by hand to record this transaction.
It just would be nice to write a check for cash or deposit to another bank using the Payments...
AM
129 08/14/2009 05:00:19 pm
Re: POS Module (4 replies, posted in Modules Add-on's)
Hello Jaunsz
I am going to use posper for a pos... I don't know yet how much trouble I will have doing this. But what I would like from you is a break down as to the tables and columns that get posted to when you do a direct invoice sale in fa, if you have the time...
I am not a coder so any help from anyone is welcome!
At the very least I will hack together some sql to load the posper data base with data from fa, but this will be a lot of hand work...
I will post my efforts here.
AM
130 07/30/2009 07:34:58 pm
Re: synchronizing offline databases with online ones (7 replies, posted in Setup)
roger wrote:
The main issue in such cases is to avoid duplicate IDs such as order numbers, invoice, etc. between the offline DB and the online DB.
Both start from the same starting point after a synchronization, but the moment a transaction is entered both will start with the next available number. Now both DBs have a new transaction with the same transaction ID, unless you operate with a different transaction number offset in the two databases.
Plain DB synchronization is unlikely to solve the issue.
I posted the question over at the SymmetricDS forum, and this is the response I received:
By: chenson42
You might be able to do something programmatically in an IDataLoaderFilter.
You would have access to the node_id the data is coming from so you could add
a column to a central database that is also part of the primary key. Or you
could apply some type of offset algorithm based on the node that is
synchronizing.
131 07/06/2009 12:47:38 am
Re: synchronizing offline databases with online ones (7 replies, posted in Setup)
Hello Marche
Take a look at this: http://symmetricds.codehaus.org/ maybe it could be used for data synchronization?
We will need the same thing for a good POS module... when we get there.
Alvin
132 06/10/2009 11:45:33 pm
Re: module for money exchange company (1 replies, posted in Modules Add-on's)
I would like this as well, you have my support...
AM
133 05/27/2009 02:18:12 pm
Topic: User's POS, Access Levels and sales (0 replies, posted in FA Modifications)
I have found that I make sales in different locations, and to make the system work right I must have for myself, a user account for every location... logout and login to that user... location, a bit of a pain.
So what about making an access level for sales, or casher, and giving system admin exempt from User's POS?
AM
134 05/27/2009 01:56:17 am
Re: expanding window (4 replies, posted in FA Modifications)
Now how is that for quick response... you guys are the best!!!
(26-May-2009 Joe Hunt, + # fixed wider combobox for backup-files in company backup)
135 05/24/2009 07:01:03 pm
Topic: expanding window (4 replies, posted in FA Modifications)
Sure could use an expanding window in Setup >Backup and Restore Database >Create backup and Backup scripts maintenance
File names are a little long sometimes, can not see the date on the end...
136 05/22/2009 03:37:20 am
Topic: Inventory Location Transfers to show value amount? (0 replies, posted in FA Modifications)
When we move items from one country to another we must show the value of the transfer, like an invoice...
If we could show the value of the transfer in (view transfer) we would not have to look up each value for each item, it is not hard to copy data from tables in a browser and paste it in a spread sheet to make whatever doc you need.
Maybe tie (Inventory Locations) to a currency, and have the transfer show the value in the (To Location) currency?
AM
137 05/22/2009 03:13:37 am
Re: view and edit Sale before Process (13 replies, posted in FA Modifications)
joe wrote:
You could have a pricelist with tax included in the price. On the final invoice there will be a line telling how much tax is included.
/Joe
Lets get back to this price list...
Because of the way we do business, we do not include the tax in any sell prices in the system, but we do like to quote prices with the tax included. The customer likes it when they pay the price you quoted, not some added 12% price when they go to pay... you know what I mean.
It would be great if when printing a price list you could select to add a tax to the price, or filter by Customer Branch, for location, tax and currency.
What do ya think?
AM
138 05/20/2009 01:20:51 am
Re: POS features (38 replies, posted in Wish List)
Hey Janusz
Take a look at this, http://symmetricds.codehaus.org/ maybe it could be used for data synchronization from pos to server,etc
AM
139 05/19/2009 11:55:57 pm
Re: Portal / CMS / Groupware / Payroll - Integration (2 replies, posted in Modules Add-on's)
Hello Renier
Check out this post https://frontaccounting.com/punbb/viewtopic.php?id=470 (FA Modifications » Organizer - New module)
You might check with Jarocho, I like his demo, he maybe able to help you.
140 05/04/2009 03:30:08 pm
Re: POS features (38 replies, posted in Wish List)
I have not had a chance to reply to this yet...
But I will help layout a plan to do this as soon as I have the time...
Just as a start we will need to come up with a data integrity plan. You will have more then one location, and you will have more then one pos at each location, and when the power goes out and the network is down the sale must go on...
It would not be to hard to keep a local network running but the data must be synchronized with the server holding FA on a timely basis...
Janusz may have some ideas here? I will work more on this later...
Alvin
141 04/28/2009 07:22:07 pm
Re: view and edit Sale before Process (13 replies, posted in FA Modifications)
joe wrote:
You could have a pricelist with tax included in the price. On the final invoice there will be a line telling how much tax is included.
/Joe
Yes Joe, that is a way for now, but soon you may have thousands of items and a line at the point of sale...
All our prices do not include tax, I see no way to add the tax to a price list?
Alvin
142 04/28/2009 07:12:50 pm
Re: Item shows -0- for price in price list (3 replies, posted in Report Bugs here)
joe wrote:
Did you choose 'Base for auto price calculations' in Company Setup? For instance 'Retail'.
/Joe
Sorry I am late with my post....
The Base for auto price calculations is set to Retail, most Items in Retail are in base currency, just this one Item in retail in other currency shows -0-
143 04/23/2009 05:46:46 pm
Topic: Item shows -0- for price in price list (3 replies, posted in Report Bugs here)
I don't know if this is a bug or not.
One of my Items Retail price is in one of the other currencies, not the base currency. When I print a price list that Item shows -0- for price. Also shows -0- in Sales, Direct Invoice, Sales Invoice Items,..
Let me know what you think?
Alvin
144 04/23/2009 05:24:36 pm
Topic: view and edit Sale before Process (13 replies, posted in FA Modifications)
Until there is a POS module....
In Sales, Direct Invoice, we need a way to view the transaction or invoice before it is processed. Right now we can not see what the total amount is with the tax until we process the sale. The customer has no way to see what he must pay until it is to late. We need to view and edit before Process.
using 2.1
Alvin
145 04/21/2009 01:21:15 pm
Re: about inventory (4 replies, posted in Setup)
Items and Inventory > Inquiries and Reports > Inventory Item Status
146 04/10/2009 08:14:28 pm
Re: No exchange rate (40 replies, posted in Report Bugs here)
i got something wrong somewhere, the customer has currency everything look ok, I made a new test customer, same error
what table is customer currency in?
147 04/10/2009 04:59:56 pm
Re: Stock Check Sheets, by supplier (4 replies, posted in Wish List)
So what do you think about this one?
Sure would make a pre PO stock check, out on the floor a lot easier...
May filter by Dimensions, would be handy too.
Alvin
148 04/10/2009 04:52:45 pm
Re: Inventory location on Invoice (4 replies, posted in FA Modifications)
Yes Joe, you are correct...
You could think of FA as the holding company, of 3 companies in 3 diff tax locations. For tax purposes 3 diff entities, yes, But for accounting only diff GL accounts in a chart of accounts...
149 04/10/2009 04:46:21 pm
Topic: No exchange rate (40 replies, posted in Report Bugs here)
I have on install where we have only a base currency, and no others in the system.
When I go to process a sale I get this error
Cannot retrieve exchange rate for currency as of 10/04/2009. Please add exchange rate manually on Exchange Rates page.
What do you think?
Alvin
150 04/09/2009 03:33:17 pm
Re: All 3 posts in the same Cash on Hand GL account? (2 replies, posted in Report Bugs here)
So I see, I will have to create the same user 3 times, with diff pos so that user will login to user account that is for the pos that he will make the sale from, we can that...