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 abuhafss
Pages 1
Hi
Can anybody provide me a list of the Database Tables for storing:
a) Goods Received Details (Purchase Invoice, GRN and Sales Return)
b) Goods Delivered Details (Sales Invoice, Delivery and Purchases Return)
c) Inventory Movement
d) Inventory Adjustment
e) Goods Manufactured/Assembled
(The part of Allah) جزاک اللہ خیراً
What are the latest updates for inclusion of Serial No./Batch No. feature in FA?
In this thread, Joe had hinted of possible inclusion in version 2.4 but I cannot find it in 2.4.3.
Would you please point me which another file is required and where to copy it?
Okay fine.
I have copied rep310.php in the reporting folder but I cannot see it in FA 2.4.3.
Is this report available as downloadable extension?
Where can I get the list/menu of repXXX.php reports? (I mean which number report number is for what report?)
Is it that you want to change the item itself in say an invoice or sales order? Editing them are available in FA.
Actually my requirement is to show only the Item name and its Description on the Invoices, not the item code.
The item_code like the stock_id are identifying keys in the tables and foreign keys in others like the transaction tables.
I had guessed the same. But instead the identifying key of the ITEMS table should have been used, as normal practice.
Only the relations are set in the sql command in MySQL.
Yeah, this and PHP are the main issues for me, unfortunately.
I am trying to acquaint myself with SQL commands from online tutorials but php is time consuming.
I am experienced programmer of dBASE III Plus and FoxPro but no experience of SQL.
I am sorry, but it is not understandable how the program can be affected with user input data. 
If the user inputs wrong item code, and then record some transactions. Later he notices that he had done some mistake, how would he make the correction.
Creating a new item and making the old item inactive is not appropriate solution. Old transactions cannot be linked with the new item!
Hi
Is it possible to enable editing of the ITEM CODE?
Normally, fixed assets are treated as separate units to depreciate them individually.
Example, there are 5 Air Conditioners (same model) installed in a company but all purchased on different dates.
Therefore, each AC is allotted separate ID for ease of calculation of depreciation.
In your case, you can have similar NAMEs of the FA adding -a, -b, -c at the end.
Suppose you have 2 Photo Stat Machines, 1 for the Administration Section and the other for Account Section.
You can name them as Photo Stat - A and Photo Stat - B.
Pages 1
FrontAccounting forum → Posts by abuhafss
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.