76

(13 replies, posted in Items and Inventory)

can you show us the first few lines of the csv file?

tom

What sets the duration?

Right now it seems to be 10 days... I can't find any setting that changes this.

In

Since you don't want the Capital Introduced back, do you fold that into the Profit/Loss at the end of the year?

from re-reading this thread it looks like when the year is closed things get accumulated automatically into profit/loss.

So where did you put the Capital Introduced? Class/Group?

It seems if I put it in the right place in the COA it will get rolled into the profit/loss automatically.

tom

Maybe I am handling things incorrectly...

I use the Loan from Shareholders for then I use personal money for expenses that can be written off to the business.

I do not what that money back, as the business usually ends up at an operating loss.

Maybe there is a better way to do this.

tom

What I am trying to do is take the retained earnings and get rid of them, I think it was a mistake from 2 years ago.

Last year when I needed to put money into the business I deposited it as a Loan from shareholders.

I want to convert that to a loss without messing with the bank accounts.

Oh My... I think the light bulb just went on...

Do I need to do two Journal Entries?

Like:

Debit 2680 Loans
Credit 9990 Year Profit/Loss

Is a Credit to 9990 a Loss?

tom

Well this is all it says...

When you start a new Company, you should check that the Fiscal Year is setup correctly. If this is not your starting Fiscal Year, then you should start by creating the starting Fiscal Year. After you have corrected the starting Fiscal Year, you can delete other Fiscal Years if there are no transactions in them. Now set this new Fiscal Year on your company by selecting Setup tab, Company Setup.

If the first year is setup as Jan 01 2011 - Dec 31 2011 and your starting Fiscal Year should be Jul 01 2011 - Jun 30 2012, then you must first create a short dummy year, Jan 01 2012 - Jun 30 2012. Create another Year Jul 01 2012 - Jun 30 2013. Set the company to use this year. Now close and delete the year Jan 01 2011 - Dec 31 2011. Close and delete the short dummy year Jan 01 2012 - Jun 30 2012. And then create the correct broken Fiscal Year Jul 01 2011 - Jun 30 2012. After the creation, set this Fiscal Year as active on the company. You are now ready to make your transactions. You have 2 fiscal years and you are using the current one.

When you reach the end of your Fiscal Year, you have to create another new Fiscal Year. When you want to switch Fiscal Year on your company, go into company setup and do that. When you have finished your year-end entries, you may close the Fiscal Year.

A closed Fiscal Year can no longer be used for entries. When a Fiscal Year is closed, the difference between all asset and liability accounts are brought forward as a Journal Entry where the Default account for Retained Earnings is credited (if this is a profit, otherwise it is debited). And the default account Profit/Loss Year is debited (if this is a profit, otherwise it is credited).

You can have as many Fiscal Years running as you want, but for performance reasons you should not have more than needed (by your legislations). When you delete a Fiscal Year, the assets, liabilities and equities are brought forward. All other unneeded transactions such as documents are deleted.
Tips and Tricks
----------------------

I searched for "YEAR" and did not find anything relating to year end close-out.

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

85

(4 replies, posted in Accounts Receivable)

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?

86

(4 replies, posted in Accounts Receivable)

I will go look, AGAIN

Sorry!

smile

87

(4 replies, posted in Accounts Receivable)

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

90

(5 replies, posted in Modules Add-on's)

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

94

(14 replies, posted in Setup)

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?

97

(4 replies, posted in Items and Inventory)

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

99

(1 replies, posted in Accounts Receivable)

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