FrontAccounting forum — Items and Inventory

Import CSV Items

null@example.com (MMacct) — Sun, 04 Jan 2026 23:33:50 +0000

I have successfully installed/enabled Import CSV extension, access rights, etc.
However, I have been unsuccessful in regards to importing my CSV file.
I have scoured various and many threads, many have been helpful, but still no joy.
While I have a tech background, I have no knowledge of SQL.

The present "header" I am using with my file is as follows:
ITEM;ITEMCODE;STOCK_ID;Description;Category;units;;MB_FLAG;Currency;Price;

I am sorry if this has been addressed elsewhere, but I have tried but not found a solution.
Any assistance would be appreciated.

Edit Inventory Adjustment & Stock list with Cost Prices

null@example.com (popsicles12) — Wed, 23 Apr 2025 19:15:09 +0000

Hello all,
I am tryring to locate the Inventory Adjustment entered in FA so I can edit it. How do I find it. I printed stock list or stocksheet but it does not have cost price & selling price attached to it. How do I do that.
thirdly, I am trying to locate cost update in the Void list but it is not there anymore. was it intentionally removed. I am using 2.4.18.

Thanks for your continued support.

Popsicles12

Payment term change in recurrent invoice

null@example.com (rafiq.ccna) — Tue, 28 Jan 2025 05:24:10 +0000

By default Cash only select in recurrent invoice. How can I change the payment term in recurrent invoice. Recurrent invoice generate by a sales order template. Order template's payment term is selected payment due with in 10 day's but recurrent invoice is cash only. If have any solution, please guide us.

Change from Non-Inventory to Inventory Item

null@example.com (jeskremer) — Thu, 19 Dec 2024 02:33:55 +0000

OK, this probably is a stupid question, but when I setup FA to test it out, I did not start out with inventory. I am now to the point of trying to get inventory to work, but realize that my Items, being set to Service and Non-Inventory, are unable to be changed to Inventory and Purchased.

Is there anyway to do this or am I completely stuck and have to re-enter all Items using new Item codes?

Thank you.

Inventory cost/value

null@example.com (tom) — Wed, 27 Nov 2024 17:04:00 +0000

I see a number of messages questioning how the item cost is handled be it a fixed cost or an average cost.

I am honestly not sure which is right.

Nor how to correct it if it gets miss adjusted...

I am also interested in implementing a FIFO method where the cost is the cost of the item when it was purchased.
So if I bought 100 widgets at $4 each and later got 200 and paid $6 each as I sold them the price would follow the purchases
I could sell 90 and the cost would be $4 each and then if I sold 20 then 10 would be at cost $4 and 10 at cost $6

I guess if a transaction were voided and freed up some $4 units then a later sale would get some at $4

I am a php programmer so can do some of the work, but I could use some guidance as to WHERE to make the changes...

This might be usable for normal inventory, but it is also needed for handling of Crypto as a material asset

tom

Items variations by sizes and color

null@example.com (lawmaina78) — Wed, 27 Nov 2024 06:12:19 +0000

Is there a way I can define one type of items but with variations and sizes that differs in pricing. Example beverages such as sodas can be sold in different bottle sizes.

Report on item sales

null@example.com (peacecop kalmer:) — Sun, 03 Nov 2024 16:52:47 +0000

Is there a way to see when and to whom an item was sold?

import csv items

null@example.com (marcelo86.sa) — Sun, 13 Oct 2024 22:01:01 +0000

I recently tried to import a csv of items, but the module does not appear
"Inventory Items CSV Import". I have all necessary permissions active for the user. Even so, the module does not appear. can anyone help me?

Print Item & Kit List

null@example.com (jeskremer) — Fri, 24 May 2024 02:05:40 +0000

Maybe I'm missing something, but I have a two pronged question:

1. Is there a way to print an list of all of the items and their SKUs and even the Kits?

2. Is there a way to view more than 10 items, kits, customers, etc. when clicking the magnifying glass? It is sometimes difficult to search when only 10 pop up.

Thanks!

Direct Purchase Inventory Entry, item creation?

null@example.com (jackieblue1970) — Mon, 06 May 2024 00:01:04 +0000

Hi all. I’m just starting to evaluate this application and immediately ran into an issue. Is it not possible to create items while creating a Direct Purchase Inventory Entry? From what I can tell you have to create the item first before doing the entry. This seems counterintuitive since you may have new purchases that have not yet been created yet.