276 Reply by tom

(4 replies, posted in Manufactoring)

I think it would help some people (including ME smile ) if the demo data included purchasing in case quantities for maybe the CD ROM drive or something new.

There may be other features that could be better explained via the demo

I would be happy to work with someone to set up some examples I can understand (then *anyone* should be able to)

Go to forum: Manufactoring

277 Reply by tom

(9 replies, posted in Items and Inventory)

That is very good to hear.

I will dig into it and see what notes I can come up with

Go to forum: Items and Inventory

278 Reply by tom

(9 replies, posted in Items and Inventory)

I too am interested in osCommerce interfacing.

I looked at the API document, I was hoping for APIs like add_customer and add_customer_branch, add_order etc

In osCommerce there is heavy use of Classes and the class functions are called from the web pages and the webpages only focused on display.

The class functions provided the API for any caller, making add-on modules
and the like much easier.

From the looks of the directory structure classes are not used here...

that mans when table changes are made each php file that uses that table needs to be updated... hopefully I am wrong...

tom

Go to forum: Items and Inventory

279 Reply by tom

(6 replies, posted in Items and Inventory)

Is this the file you are talking about?

https://frontaccounting.com/wbt/modules … hp?file=92

It has the CVSImporting.txt file but the xls file only has sheets for manufacturer and workcenters.

No Items

Is there an easy way to import items?

I only have maybe 100 items so I can do it manually...

tom
(edit) I found another thread dealing with this, and links to the docs

Go to forum: Items and Inventory

280 Reply by tom

(4 replies, posted in Manufactoring)

I have a similar problem.

I can buy an item in case quantities or as single units.

In my manufacturing process I cut them in 1/2 to make a finished product.

I also purchase bulk product (20kg or 44lbs and in some cases 50lbs)
and sell 1/4, 1/2, 1lb units

What is the best way to do these?

tom

Go to forum: Manufactoring

281 Topic by tom

(0 replies, posted in Report Bugs here)

When entering tax groups ti may be easier to have the entry/modification boxes above the Tax Group List

Now I am having to scroll to the bottom of the screen to enter the tax fields

Also In the summary list, it might be nice to include a RATE column that is the sum of all the taxes in the group,
right now you need to click edit to see the various rates (looking for typos)

tom

ps. Now a Bug, the 47th Tax Group does not display on fa/taxes/tax_groups.php

after adding a couple they are now showing up

Go to forum: Report Bugs here

282 Reply by tom

(5 replies, posted in Setup)

t sounds like a retailer may have to pay some VAT on the goods they purchase for resale and then that need to be able to offset what they have already paid vs what they collect from the customer.

(Am I guessing correctly?)

Generally in the US we file as tax exempt and then pay the taxes on any goods we consume.

My wife (for example) pays sales tax of List price and then if she sells anything at a discount she needs to request a refund of the difference.

You are being very helpful

tom

Go to forum: Setup

283 Reply by tom

(5 replies, posted in Setup)

Ya know I got distracted with the GL account numbers...

My real question is:

Why are there TWO GL accounts associated with a Tax Type?

FA calls them SALES and PURCHASING

How are they used?

tom

Go to forum: Setup

284 Topic by tom

(2 replies, posted in Banking and General Ledger)

What is Account Code 2 used for?

Go to forum: Banking and General Ledger

285 Topic by tom

(5 replies, posted in Setup)

When creating Tax Types there are 2 GL Accounts, Sales and Purchasing.

And in the Trading Co, they are both under Accounts Payable.
But (confused) one is named VAT IN and the other VAT OUT

Sales collects tax which needs to be sent to the proper tax collector and it is not our money so I guess I can see it going directly into an A/P account

But Purchasing pays tax on consumables and that is an expense, I can see that there could be reasons for keeping track of taxes paid for other reasons, but not in an A/P account.

Why isn't it set to an Expense account?

tom

Go to forum: Setup

286 Reply by tom

(15 replies, posted in Setup)

So it seems I will have 6 Tax types
FL @ 6% and 5 for the various surcharges used within the state

and then 68 Tax Groups, one for each of the 67 counties
Pasco County (FL 6% + Surcharge 1%)
etc

and one for the rest of the world (Exempt)

And I see how I can link the Customer Branch to the proper Tax Group

ok and I see the Item Tax type can be used to tax different items at different rates (or exempt)

(I am enumerating al this in hopes of the example being useful to others)

Thanks
Tom

ps.

On
http://..../fa/index.php?application=system

I think 'Taxes' should be changed to 'Tax Yypes'

Go to forum: Setup

287 Reply by tom

(15 replies, posted in Setup)

Ok I am a programmer, not an accountant.

I am in the USA and I have to collect Sales Tax.

All of my sales are from my website running osCommerce.

It correctly collects sales tax based upon the delivery address.

I do not see how that can be implemented in FA.

I do see Addng a Customer Account and then Adding a Customer Branch, but there it seems I would need to know what the Tax rates is for each customer.

The tax collected is State (6%) and then an optional County (0% to 1.5% surcharge)

Since my long term goal is to have osCommerce feed sales and customer information to FA maybe my answer is to use the osc tax name (FL - Pasco) as a tax group name and be able to look that up when a customer is created. (Florida has 60+ counties!)

Are the Customer Branches basically SHIPPING Addresses that customer uses?

Go to forum: Setup

288 Reply by tom

(6 replies, posted in Banking and General Ledger)

Here is the direct link with no registration required.

Also other courses as well.

http://www.kutztownsbdc.org/course_listing.asp

(edit) I just finished that course and it was a good intro, even for a Programmer

too bad they were not selling Pizza and Soda (or Beer)...

Coffee and they antique things called Books smile

Go to forum: Banking and General Ledger

289 Reply by tom

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

joe wrote:

We have prepared an extension manager for release 2.1. Look at the sticky topic in this forum. We do not have the resources to develop these types of extensions ourselves, but concentrating on the accounting core. This is our main duty.
A couple of companies have been interesting in making a CRM extension to FA and at least one is almost ready. They are waiting for the release 2.1 Beta to ship next week.
I guess they will tell us more when time is ready.

/Joe

Is there any documented API that extensions can use to perform common actions?

I am guessing that an add-on could provide an access point for osCommerce/Vtiger/etc could interface and the add-on code would convert to the internal API

I too an interested in osCommerce. I am also a "retired" osc core developer

tom

Go to forum: Modules Add-on's