FrontAccounting forum - Items and Inventory

Reorder Level question

dummy@example.com (myhandgunpursedotcom) — Sun, 16 Jun 2013 21:41:52 +0000

Hey everyone, newbie here and loving the program. Switching my company from QuickBooks and Vend HQ to FrontAccounting and Open Source POS this week using the integration software I found listed in this forum. Can't wait to use it at our first show this weekend.

Anyways, I have been trying to understand what the reorder level does in frontaccounting but can't find anything written about it in the forum or wiki. Could someone please explain to me how it works?

Thank you so much!

James
www.myhandgunpurse.com

Units of measure Question

dummy@example.com (LeoB) — Sun, 16 Jun 2013 07:43:44 +0000

Hello,

Can you guide me on how to do multiple units of measure?

Example:

For 1 item there are 2 units of measure, Cases and Pcs.

Everytime I do Purchase order or Sales Order, I would like to switch the Units of measure from Cases to Pcs.

A step by step guide would be helpful.

Thanks!

What are the maximum number of stock items?

dummy@example.com (markspend01) — Thu, 13 Jun 2013 13:25:40 +0000

Dear all, may I know what are the maximum number of stock items FrontAcconting system can handler,
I have imported about 50k record on item_codes and stock_master, when I tried to print "stock check sheets" and some of the reports pdf doesn't not prompt out and no error message, thanks

Cogs in service Items

dummy@example.com (Giorgio) — Sun, 09 Jun 2013 18:35:17 +0000

Hi,
I'm testing FrontAccounting because I want to use it for my consultancy firm.
I'm providing financial services to third parties and I have difficulties to set up Cogs in the Item module.
Each time I'm issuing an invoice the postings are DR AR; CR Revenues and CR Tax liabilities and no cogs associated.
How can I settle properly the Item master data in order to post CR Salary and DR COGS?

Thanks for your help!

Item with expire date

dummy@example.com (Farhaj) — Sat, 08 Jun 2013 12:05:48 +0000

Hello,

I have items which valid in inventory for 1 month only, let's say food that expire after 1 month.
I mean items that have expire date.

How can we implement this with FA?

Thanks,

Trade promotion

dummy@example.com (konokcse) — Sat, 08 Jun 2013 06:50:18 +0000

Is frontaccounting have any trade promotion system? I want to give some free items with some number of items during sell and also want to show the report in accounting. Is there any way???

Item Code Not displayed in Stock list on Invoice or direct Invoice

dummy@example.com (seahawk) — Tue, 28 May 2013 14:40:50 +0000

I have three companies set up on my installation. In the main company the stock item code is displayed with the stock item description for all user types.

In the second company the item code is not displayed with the description for two user types. For admin it is displayed.

Please advise what could be the cause.

Using 2.3.16

Selling Prices - Prevent Manual Override

dummy@example.com (MarkAndrew) — Fri, 17 May 2013 17:50:49 +0000

Hi
Please tell me if it's possible to prevent manual over-ride of item selling prices when posting sales invoices.

Eg - I have set the selling prices of my inventory items, but when I come to invoice a sale through direct invoice, I see that my pre-set selling prices can be changed. Is it possible to prevent this.

Mark

Multiple Units of Measure in Inventory

dummy@example.com (jomar) — Tue, 14 May 2013 22:02:56 +0000

Hello !

We sell our products, in multiple units of measure i.e. in sachets, packets and in cartoons. Is there a way i set multiple units of measure for a single product.

When i enter a new item in inventory, it gives a drop down menu, in which i can select only one unit of measure at a time. Similarly, when i make purchase order and sales order, i cant edit the unit of measure over there. Although in real business, we make order in different unit of measure to different suppliers and customers i.e. in sachets, packets, cartoons etc.

I don't know whether FA is able to manage multiple units of measure for a single product and adjust the inventory value in the financial books of accounts or alternatively apply any conversion factor to resolve this multiple units of measure issue.

Adding items having same model with different serial numbers

dummy@example.com (itronics) — Wed, 08 May 2013 07:03:15 +0000

Hello there,

I have searched the forum regarding the subject captioned above however could not able get the answer. Let's get into details of the requirement.

Say, i have to purchase/Sale SONY VAIO Laptop E-Series of 05 nos of quantity. All the laptops belongs to the same series and have the same configuration however with different serial numbers. So, while making the invoice, can i add the item as like below ?

SONY VAIO Laptop E-Series ....... 5 Nos........ Price............... & so on
(Sl.No-1, Sl.No-2, Sl.No-3.........)

Why i am opting for this is, while selling 5 nos of same model laptop and adding it in the invoice for 5 times only because of different serial numbers many not look great in the invoice.

Hope, some body will kind enough to guide me to achieve this, if that is possible with FA.

Thanks.

textcart module instruction

dummy@example.com (cristiart) — Sat, 20 Apr 2013 15:15:40 +0000

i tried to find some instructions on how to use textcart module and i can seem to find it anywhere. i'm trying to import my inventory and customer to FA the fastest way and i understand that's the best way..
any help will be appreciated.
thanks

Adding fields to the inventory module, e.g. 'Author/Artist'

dummy@example.com (recseiuq) — Wed, 03 Apr 2013 02:15:33 +0000

Hi there,
is it a big job to add an extra, searchable detail field to the Inventory module? I am somewhat versed in PHP, although probably would need to brush up a bit.

Thanks

Sale Pricing and Purchase Pricing Tabs Wont Open

dummy@example.com (johnb278) — Sat, 23 Mar 2013 23:37:23 +0000

Windows Server 2003 IIS 6
PHP 5.1.4
MYSQL 5.6.10.1
FA 2.3.15

When I click on the Tabs (sale pricing, purchase pricing, standard costs and reorder levels), the status indicator spins for about 10 seconds then i get the exclimation point triangle and the tab doesnt open.

Any Ideas how to fix this?

Wrong Inventory Costing

dummy@example.com (apmuthu) — Sat, 23 Mar 2013 02:00:28 +0000

I have serious issue with inventory cost update. FA has automatically update item cost to negative as below. Because the cost is negative, i can't post item adjustment entries. The stock valuation report is also showing wrong stock value. Can somebody help me on how to rectify this.

stock_id    mb_flag    material_cost
DalMuth-150Gms    M -6,260.86
DalMuth-150Gmsx12 M -75,130.00
DalMuth-250Gms    M    -10,434.79
DalMuth-300Gms    M    -12,521.75
DalMuth-325Gms    M    -13,565.24
DalMuth-550Gms    M    -22,956.58
PunjabMix-150Gms    M    -1,845.84
PunjabMix-150Gmsx12 M -22,149.86
PunjabMix-250Gms    M    -6,153.17

Thanks

Inventory Sales Report error

dummy@example.com (joe) — Fri, 22 Mar 2013 12:18:02 +0000

Hi, somehow when issuing a credit note to a customer a negative value of the Tax has been included in this report... Elsewhere (GL, Journal, Inventory, etc) everything is OK.

I invoiced for 50€ =>
41,32€ + 8,68€ (21% tax)

When I issued the credit note, everything is correct except in this report, where it is showing for this item:

Category Description Customer Qty Sales Cost Contribution
BC00226 B-220AURA-Rojo XXX 0 -8,68 0,00 -8,68

Tax report is OK:

Customer Credit Note1 19/02/2013 XXX -41,32 21,00 -8,68 IVA 21%

Thanks for any help !