Search options (Page 8 of 13)

Great... now a SNAFU...

Last year I started using FA in june and was not doing everything right... so I reset my DB fresh and entered initial balances etc...

I need to move some money from "some account" to my Sales Tax GL's or just do a misc payment directly from "some account"

The big question... What GL should I use for "some account"

I want to get it right so that next year I am not totally confused (well because of taxes anyway)

Since the tax was collected last year, it may make sense to use "3590 Retained Earnings - prior years"

I have credit balances in the following:

1060 Checking
1200 Account Receivable
1510 Inventory
2100 Accounts Payable
2150(2152) Sales Tax collected
3590 Retained Profit - Prior years
4010 Sales
4430 Shipping & Handling
4050 Purchase price Variance

The more I look at it, I think I should use 2100, but I could have it backwards...

tom

I will have it this weekend.

I am just finishing up testing

tom

That has been fixed in CVS.
You will also have to tab through (click and tab) Bank Fee and Payment Discount so they get filled with 0.00

That is also being looked at and will have a fix in CVS at some point

tom

Got it thanks.

Also the osc import for FA22 has been posted to the downloads section

Joe,

I am updating the oscommerce module for FA22 and have a question about security areas:

$security_areas['SA_OSCIMPORT'] = array(SS_SALES|100, "osCommerce Customer / Order Import");

I looked at other modules but do not see any hint at rules for the array values.

In the above statement I used 100, but do those have to be unique for all entries?
for the SS_SALES group? etc

tom

I will look at it, I glanced at it before posting and did not see where comments were being updated... I will dig deeper..

tom

Go to Downloads, Module Downloads and look for osCommerce customer and order import

https://frontaccounting.com/wbt/pages/download/download-modules.php

jackel7007

Please contact me directly if you are interested in testing the new import/export

tom
(see the EMAIL link to the left)

and when all else fails Define one and see how it acts

Here is the readme file I think it should have.

See the note:
***** Big changes see VERSION 2 below *******

Now go down to here:
VERSION 2 by Tom Moulton 5/2009
------------------------------------------------------------------------

/****************************************************************************
Author: Joe Hunt
Name: Import of CSV formatted items
Free software under GNU GPL
*****************************************************************************/

***** Big changes see VERSION 2 below *******

Recommended settings during install:

Menu Tab: Items and Inventory

Name: Import of CSV formatted items

Folder: import_items   (should follow unix folder convention)

Browse for the file: import_items.php on you local harddisk.

Press the Install button.

--- Before you use the Import Items module ---

Do a Company Backup from the Setup tab, Backup and Restore.

The comma separated file should be of the following type:
1. line should contain the following description:

id; description; category; units; mb_flag; currency; price;

In this case the separator is ';', id is the Stock ID, description is the Stock description,
category is a category you want to put your Stock. If this category doesn't exist it will
be created during import. units is the unit for the Stock.

The mb_flag is M for Manufacturered, B for Purchased or S for Service (no inventory)

currency is the currency for the price.
Leave empty for company currency.
price is the stock price. If you don't want the price to be entered, leave it empty.

Example of a CSV import file:

id; description; category; units; mb_flag; currency; price;
21; Item21; MyCat; each; B; ; 300;
22; Item22; MyCat; each; B; ; 200;
23; Item23; MyCat; each; B; ; 300;
24; Item24; MyCat; each; B; ; 200;
25; Item25; MyCat; each; B; ; 300;
26; Item26; MyCat; each; B; ; 200;

When the Import file is ready (you might prepare it in a spreadsheet if it is a huge one),
you are ready to go into the Import Module via Items and Inventory, right section.
First you see the default accounts for the various operations for the stocks. Leave them
as is, if you are satisfied with them.
The field separator is set to ';'. If you have used another separator, select it here.
Be aware, that if you have chosen ',' as a separator, you should enclose the fields with
double quotes ("Item21") because it might be common to put a comma inside a description.
Next you should select a Location to put the stocks into (the 'B' ones), Item Tax Type and
Sales Type. Last you browse to the CSV file and put it here.

If the items exist, they will be updated with the information here.

Now you are ready to press the Import CSV file button (Did you take a backup??)

Have fun!!

PS. The language inside the Import CSV file does NOT follow the traditional GETTEXT translations.
If you want to translate to another language, please rename the texts inside the file
import_items.php to your own language.
If you make improvements to this module, please share it with us!!.
We will then incorporate it into the module.

Contributor: Tom Moulton

Upgrade code to v2.1 database, perform same actions done during upgrade to create item_codes table

Also here is osCommerce SQL to dump items.

Remember to add trailing ";", also extra spaces on non-quoted strings may be a problem.

SELECT p.products_model, pd.products_name, cd.categories_name, 'each', 'B', 'USD', p.products_price FROM
products p left join products_description pd on p.products_id = pd.products_id and pd.language_id = 1
left join products_to_categories pc on p.products_id = pc.products_id
left join categories_description cd on pc.categories_id = cd.categories_id and cd.language_id = 1
where p.products_status = 1

The mb_flag is M for Manufacturered, B for Purchased or S for Service

tom
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
VERSION 2 by Tom Moulton 5/2009

This version supports importing Items, Sales Kits and BOM

The fields used will be different depending upon what is being imported.
It will still be a good idea to have a fixed number of (empty) fields to keep parsing simple.

The first field is the record type and that will decide what the rest of the line means.

TYPE = BOM

BOM;PARENT;COMPONENT;WORK CENTER;dummy;dummy;QUANTITY;dummy;dummy;dummy;

The loc_code will be selected from a Pull-Down menu as a default for the entire import.
The work center will be added if needed.

TYPE = UOM

UOM;ABBR;NAME;dummy;dummy;dummy;DECIMAL PLACES;dummy;dummy;dummy;

TYPE = KIT

KIT;ITEM_CODE;STOCK_ID;Description;Category;dummy;Quantity;dummy;Currency;Price;

Where ITEM_CODE is the code for a Kit and Stock_id is a part of that kit (Quantity each)
The Currency and Price, if present will update the price of the kit.

TYPE = FOREIGN

FOREIGN;ITEM_CODE;STOCK_ID;Description;Category;dummy;Quantity;dummy;dummy;dummy;

Where ITEM_CODE is the upc/etc code for an item and Stock_id is the item as we know it

ITEM;ITEM_CODE;STOCK_ID;Description;Category;units;dummy;MB_FLAG;Currency;Price;

Where Item_Code = STOCK_ID of the item.

TYPE = BUY

BUY;STOCK_ID;dummy;Description;Supplier Name;Supplier Units;Conversion Factor;dummy;Currency;Price;

Where Supplier must alrady exist

The rest should be as described elsewhere.