It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by alvin
OK, So why have a price list where you can enter a price in a foreign currency? If you need a price in foreign currency, you just print it, or get it from a sale... All done from base currency.
If you were to automate this price problem, You would enter the sale price in foreign currency, the system would do the calculation and store the price in base currency.
Also what is the Base for auto price calculations: used for in Company Setup?
Thanks Janusz, for your help... 
I also have this problem a lot, in lots of places in the system, I have been blaming it on my bad internet connection... these problems don't happen when my connection is fast... however I don't seem to have the trouble with other scripts.
It might help to have some php.ini setting recommendations, etc. I get no errors in the System Diagnostics.
Alvin
Hello Anthony
I currently use FA for a retail operation. We buy and sell in 3 countries, and currencies. And this is not without problems. We do not have a good POS yet, but there are some users here willing to put up some dev money including myself. Purchasing, inventory control and management still need some work but has gotten much better then when I started.
I have used a lot of web server erp systems (open source) and this is the only one that comes close to doing what we need for this business.
Every day this system gains users gets better.
Alvin,
almacennaval.com
It is like this, you have a price list, (retail) it is what you use to sell everything to most customers. When I buy something to resale, sometimes I buy it in foreign currency so I just add the sell price in that currency. Which is fine when I sell in that currency. But as soon as I try to sell that item in the other foreign currency I have the problem.
But I guess what I need to be doing is calculating the exchange rate by hand to what the equal would be in base currency and putting that in the price list.
Right? Or maybe sometime in the future, a feature could be implemented to do this automatically.
I do not understand, the target currency chances, depending on where the sale is made. A location has items purchased in all 3 currencies. There are exchange rates between all currencies, not just the base currency.
??
I see, so what do I do when I print a price list and it has products listed in retail price that some are not in base currency or selected currency? Or I try to make a Sale where one of the Items is not in the base currency or sale currency?
Joe,
I hope you and others can help me to understand how best to do this, when done here I will make the post to wiki (Payments to Suppliers)
My account with the supplier is prepayment. I generate a PO, email it to supplier, they process a bank card before the order is shipped. Some times the amount is more then what the PO states, shipping cost, price increases, etc.
When the purchase comes in or I receive a copy of the suppler invoice, I simply make the payment in GL... FA has Supplier Payment features build in, but I don't know how to use them in this case.
What would be the best way to handle this transaction?
AM
Hello Joe,
Thought I would bring this up again...
Running v2.2.6 this problem is still there. Shall I add it to the tracker?
AM
Sounds like a good idea...
A document generated by a location or storeroom-personnel to notify the purchasing department of items it needs to order, their quantity, and the time frame. It may also contain the authorization to proceed with the purchase. Also called purchase request or requisition. Inventory control may be done by Purchasing in back office for all locations, Purchasing would use these reports from all locations to put together a PO to suppliers, or make inventory transfers. It should be a report that shows all items for that location that are equal to or less then Re-Order Level, and show preset reorder quantity, show supplier codes, and prices, and of coarse be editable. When generating a PO or inventory transfer you could bring up these requisitions and add them or a block of items to the PO or transfer...
I could think of some more... To all of you who need these features lets get them posted here....
AM
Well Joe, $print_invoice_no, is set to 0, but the internal number is being sent, not the reference number, This is on a PO when it is emailed to a supplier.
Spell out location name on report, stock check sheets instead of just location number?
The PO number sent to the supplier is different then the number you have set in forms setup?
AM
I would like to see a report for Items Location Transfer. Something you could use for inter office, report to send to the warehouse for packing, report for a packing list to include with shipment, a report for use with customs - shows value.
Report that could print with or without value, print in xls for custom modification.
To all of you that do inventory location transfers, please add your thoughts here?
Thanks
AM
You have my vote for this change...
AM
I have seen the time when I have a hard time finding an item with the drop down box, it would make in easer if the item code were to show in the drop down item disc box as well...
It would be nice to have the option in General Ledger Inquiry, to show a transaction in the currency it was done in. It would just make checking a transaction much easier.
I would like to see the data entry for (Sales Pricing and Purchasing Pricing) pages on the (Items and Inventory>Items) page. or maybe in a pop up window?
It would just make entering data much faster when entering a new item...
AM
You just do an inventory transfer first... We do it all the time here...
You have to go back and add (commit in) your old security access back in config.php then log in and go to setup>access setup and set an admin role, then go to setup>user accounts setup, and assign the role to a user, but that might not work... just create a new user, and assign role. you can go back later and clean up you users, now log out and commit out old security access. you will find how to do all this, in this form and the wiki
In the end if you can not add your users or edit them, you will need to use phpmyadmin and delete the users before you can add them back again. Just keep your new user so you can back in. I just had to do this on one of me sites. Be safe, back up...:)
Keep in mind that on purchase side all prices are assumed to be exclude tax. As usually in B2B.
Janusz
This is a problem for me as well, almost all our suppliers from Central America include the tax in the price. To get true product cost I must back out the tax, but when making a purchase order the the incorrect price is listed, and I must add back in the tax to get the price correct again.
So we make a buy, back out the tax, and get credit for it when we pay our tax.
debit, cost of goods,
debit, tax payable, or other tax account
credit, cash on hand, or checking
it would be nice to handle this in purchasing.
Thanks Janusz, that did it more later...
Hello Dev team.
When making a purchase order, some suppliers offer a quantity discount on some items. When making the PO we have no way to keep track of this. Maybe a pop up window when you enter a lower quantity that would remind you that you get a better deal if you order Qty X. But maybe better to have the order qty set to your buy amount and have the PO automatically insert that qty when you enter that item code.
I would like to have automatic quantity discounts for some items
1-25 regular price
26-50 10% discount
55-100 20% discount etc.
Relating to post https://frontaccounting.com/punbb/viewtopic.php?id=525
This little problem with alt tab between windows is driving me nuts!!!
is there any chance of getting this looked at?
The problem is still there in 2.2.4, I will upgrade later...
AM
go to Setup, System and General GL Setup, Inventory, and check: Allow Negative Inventory:
FrontAccounting forum → Posts by alvin
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.