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 tom
This really needs to be in the wiki!
(all of the above... well the important activities)
How do I get rid of retained earnings?
Do I do a Bank Payment and select that account?
How about converting Loans from Shareholders to loss?
Pay it back somehow?
tom
Are you downloading the backup or just saving it to the server disk?
When it comes up empty are you trying to View it online?
tom
I think you mean this post: https://frontaccounting.com/punbb/viewtopic.php?id=2451
I did not see any replies to it...
Is that the right way?
I will go look, AGAIN
Sorry!
What is the right way in FA to write off a debt as a loss?
I have some invoices that were either never paid, or I never received full payment on.
I guess I will end up with the invoice fully paid but with money in Bad Debts (5620) and then I assume when I close the year
that money will show up as a Loss.
Tom
Thanks for letting us know!
Not for the *same* item, but I do have for example
STONE Bulk with UOM 1LB and
4LB Stone with UOM each
The Bulk stone is my purchased inventory and the 4LB Bag is a Manufactured Item.
Here is the general flow of a given Raw Material:
1) Buy 50lb box of Lab Stone (Supp Unit 50lb Box, Conversion factor 50)
2) STONE Inventory Level becomes 50
3) Sell 5 Units of Stone Bulk
4) STONE Inventory Level becomes 45
5) Get an Order for 3 4LB Bags of stone
6) Manufacturer 3 "4LB Bags"
7) STONE Inventory Level becomes 33
You can have different versions so long as you can manufacturer the secondary items.
tom
Gee like that is not blatant advertising, are we stupid?
Chris,
How about the osc_import?
The way I use it is when I have new orders I can log into FA and do a few clicks and tell it to import new customers
and import new orders and then I continue with FA as normal.
There is also options to verify item code and prices and price update FA->osc
tom
ex-osC core developer
I may be missing something, but aren't there hooks already for maintaining the current Exchange Rate from your base currency (EUR) and others (like USD)
tom
You can define your own units for each inventory item.
I maintain bulk inventory in LBS of which I 'manufacture' bags of 1/4, 1/2, 3/4 and 1LB, so it sounds a lot like what they need.
I buy things in 50lbs or 20kg buckets and use the purchasing pricing and UOM conversion to restock myself.
tom
Yes, see the Readme.txt and post here is you still have problems.
It should be under Items and Inventory -> Import CSV Items
tom
It almost sounds like a second setting would really be needed.
DECIMAL_PLACES_INTERNAL (accounting use) and DECIMAL_PLACES_EXTERNAL (seen by customers)
The problem is that at some point you need to actually round from 3 places to 2 places so that when you deal with
the ledger you never have partial pennies, invoices and payments need to be exact.
These 3 decimal place costed items, do you often sell 1 or 2?
sounds like money... are you dealing with 1/8ths?
tom
How do I write off a bad debt?
Will a Credit Note work just like a payment?
The only difference is that I need to enter each item and sales price (as invoiced)
Credit Note Type: Items Written Off
Write off item cost to: 5620 Bad Debts
And the allocate the credit note to the old invoice?
I want to make sure the lost income goes to an expense account.
tom
What do you do to 'refresh' the screen?
I use purchase pricing to handle the bulk items.
If I sell BOLTS and I have a item
That was fixed already: http://mantis.frontaccounting.com/view.php?id=960
Here are the changes:
tom@tom:~$ diff ./Downloads/doctext.inc ./newfa/frontaccounting/reporting/includes/doctext.inc
156,157c156
< $this->formData['document_number'] = $print_invoice_no == 0 && isset($this->formData['reference'])
< ? $this->formData['reference'] : $this->formData['order_no'];
---
> $this->formData['document_number'] = $this->formData['order_no'];
tom@tom:~$
< are new lines
> are old
tom
Here is a poorly written implementation of my suggestion...
diff -r 6fa1ff512c1b sales/customer_delivery.php
--- a/sales/customer_delivery.php Sun Jul 31 00:37:32 2011 +0200
+++ b/sales/customer_delivery.php Wed Aug 10 21:37:12 2011 -0400
@@ -95,6 +95,14 @@
die ("<br><b>" . _("This order has no items. There is nothing to delivery.") . "</b>");
}
+// Adjust Shipping Charge based upon previous deliveries TAM
+ $sql = "SELECT sum(ov_freight) as freight FROM ".TB_PREF."debtor_trans WHERE order_ = " . $_GET['OrderNumber'] . " AND type = " . ST_CUSTDELIVERY . " AND debtor_no = " . $ord->customer_id;
+ $result = db_query($sql, "Can not find delivery notes");
+ $row = db_fetch_row($result);
+ if (!$row[0]) $freight = 0;
+ else $freight = $row[0];
+ if ($freight < $ord->freight_cost) $ord->freight_cost = $ord->freight_cost - $freight;
+ else $ord->freight_cost = 0;
$_SESSION['Items'] = $ord;
copy_from_cart();
I have no doubt that the solution works, what modules do I need to install in order to test it on my test system and my databases?
I see some generic modules (FrontAccounting SOAP Web Service API and FrontAccounting LDAP Conector API) at the FA 2.3 download site,
but nothing that is targeted to osCommerce.
Maybe the remaining part is that cron job you mention that is unreleased and likely non-GPL?
Tom
I see pieces that could be the foundation, and I am very interested to find out how to test it out!
Tom
How can I install and test your solution?
It sounds quite comprehensive.
What is the oscommerce contribution called?
Have you submitted the FA module to Joe or Janusz?
If not I encourage you to do so, since both projects are GPL
Tom
No, see the readme.txt for BUY
tom
Try Sales->Customer Transactions
It defaults to ALL CUSTOMERS
Maybe instead of putting All Customers at the Top of the list we could put it at the Bottom,
this was after someone enters a search we will either default to the first entry or ALL if no matches we found
Does it make sense now?
tom
The date combo pups up one month, many other websites popup with 3 months.
Often it is the next, current and previous months.
In our case it may be best to make it default to current, previous and next previous months.
(Today it would popup Aug, July, June)
I have no idea how to do it, but if someone likes the idea I hope they will run with it
Tom
It looks like you are missing a column:
ITEM;ITEM_CODE;STOCK_ID;Description;Category;units;dummy;MB_FLAG;Currency;Price;
Where Item_Code = STOCK_ID of the item.
You have the STOCK_ID missing
I think for the most part ITEM_CODE == STOCK_ID, these are used in the 'item_codes' table
Also line 52 of import_items.php has a problem it should be:
function get_dimension_by_name($name) {
if ($name == '') return 0;
it was
if ($name = '') return 0;
If you are using dimensions, it seems that the 'dummy' field before MB_FLAG is where you can put a dimension
Let me know if this fixes you up
tom
When a delivery note is created other deliveries are used to see what has already been delivered.
But it seems to use the same shipping charge from the original sales order.
So if you had a SO for $500 of product and $50 of shipping ($550 total) and make 2 deliveries you can end up with $600 of invoices
if you are not careful.
Often I will just apply the shipping to the first delivery and have additional deliveries list $0 shipping.
Some countries customs agents do not like this.
Is it possible for the Delivery Note creation form to subtract the shipping from earlier deliveries before it auto fills in the shipping cost?
(not negative, of course)
tom
ps. I tried making an example of this in the demo site, but I could not create a SO with a non-zero shipping charge.
(well I could create it, but the shipping cost was not saved for some reason)
FrontAccounting forum → Posts by tom
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.