FrontAccounting forum — Items and Inventory

Import CSV Items

2026-01-04T23:33:50Z

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

2025-04-23T19:15:09Z

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

2025-01-28T05:24:10Z

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

2024-12-19T02:33:55Z

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

2024-11-27T17:04:00Z

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

2024-11-27T06:12:19Z

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

2024-11-03T16:52:47Z

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

import csv items

2024-10-13T22:01:01Z

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

2024-05-24T02:05:40Z

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?

2024-05-06T00:01:04Z

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.