trafficpest wrote:

The only way I can think without a mod FIFO could be tracked in FrontAccounting is as a foreign currency account then It would have allocations. but im not sure how it would work.

I will pull the inventory tables in a bit for you if you haven't already

I was looking at a FIFO mod where when you sell you would make the effective date in the item moves(?) table the same as the purchase which will
make finding the first unsold asset easy in SQL.

We'd need to add a flag for FIFO  vs average cost

I am going to try to follow your suggestions above and see how close that gets us.
Inventory Location per wallet/exchange
Inventory GL cloned to Digital Assets GL (I assume in same GL group 15xx or mayne 16xx)
ditto for Variance

Should Sales and COGS have cloned accounts too?

I think we might need a Bank Account for each Exchange to track FIAT at that 'location'

I am not sure I get Supplier/Customer... but I need to ease into it smile

Tom

2

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

Package: woo_orders
Name: WooCommerce Order and Customer Import Module
Description: This module works with WordPress version 6.7.1 and WooCommerce 9.6
it is used to import orders and customers into the FA database. It can also
be used to check prices between both systems. It is a modification of osc_orders
This module make use of mysqli API and will not work on legacy systems using old mysql API.
Author: Thomas A. Moulton <tom@moulton.us>
Maintenance: Thomas A. Moulton <tom@moulton.us>
Homepage: <none>
Type: extension

Currently on WP 6.7.2 and wooCommerce 9.7.0
InstallPath: modules/woo_orders
Filename: woo_orders-2.4.0-1
Version: 2.4.0-1

3

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

Not a requirement, my hosting (many) also can allow access with IP limits, so I can only grant access to specific IP addresses.

I had considered writing a WP bridge plugin, but have not needed it

When tracking the cost and capital gains the coins need to be handled FIFO (I think now there are other allow means), but each sale is tracked back to the cost when purchased, but FA seems to adjust  the cost to an average.

Also the cost basis is also wallet (location) specific, not sure you can use one Inventory account for all...

5

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

Thanks

6

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

I thought it was needed, not sure where I got that from smile

Feel free to remove it

7

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

Did you see I found the repo and made a Pull Request?

https://github.com/apmuthu/FA24extensions/pull/8

Thanks
Tom

This topic has moved... Jobs Needed/Wanted  Crypto in FA

Tom

I have done some experimentation and have figured out how to properly handle Crypto and maintain Cost basis and compute Capital Gains FIFO,
the general technique should work for other methods, but I want to keep it simple at first.

I have found it is not hard to add a new mb_flag type and existing options to prohibit buying or selling the item and then
we can add Crypto Buy and Crypto Sell in the banking section (Like Payments and Deposits)

I started looking at the webpages to add that functionality and support edit/delete etc as FA does so well and that is a bit of a push for me!

So what I want to do is implement it as part of a new or existing extension and once I have that working find someone to do the FA pages.

*** HELP WANTED *** (Read above first)

Once I get the crypto transaction import working I need someone, either an FA core programmer or someone else who has the skills.

I might be able to put up some money for the project but first and foremost the end product will be open source and available to be merged
into the main FA source.

I have been using FA for 15 years for free (and making contributions) and feel it is important to continue doing so.

If we get a few of us to work on it together we can work on a forked version.

If some who want this can contribute $25, $50, etc that can help - I work for free because I want to use the feature.

If you have something that does a lot of what I am asking for Great, but I am not interested in closed source.

Tom

10

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

I could not find the extensions repo, maybe it is svn.

Here's the zip and I am sure it does not use any PHP8 specific stuff, since I haven't done any PHP work since I last worked on other extensions here

11

(2 replies, posted in Installation)

Read the error messages, you need write permissions to the web folders so the installer can configure your system

Tom

Look at the book to check things over for taxes, I just noticed the stock moves table


trans_id, trans_no, stock_id, type, loc_code, tran_date, price, reference, qty, standard_cost

What is price and most of my entries are 0 ?

What does that mean?

If they were not 0 would the valuation behavior change?

Tom

13

(12 replies, posted in Installation)

I am not interested in live crypto transactions, just being able to handle some of the basics manually or via CSV inport

tom

14

(12 replies, posted in Installation)

It's just PHP, not sure what I could do that breaks windows

tom wrote:

I will try that with more items later today when I have time.

It worked for a few, then one that had a very old purchasing date was all messed up.

I actually looks at the date code and it was from 2019, so it should really be discarded.

So Is depleting inventory to 0 and then 'restocking' (all with inventory adjustment) the right way to go?

Should I do that any time I get a significant price change?

Tom

16

(2 replies, posted in Reporting)

apmuthu wrote:

Costing method used can be stated in the report.

The CIM report only has date range, Category and Location filters as options

The Inventory Valuation report has those and a Summary Only Y/N option

My more important question is in another thread - how to fix unit cost...

17

(12 replies, posted in Installation)

OK I will explain what I found in the backend (I am sure you will understand enough)

I am running this on the Flux Network (runonflux.io), it is a decentralized web3 network.

To keep the SQL DB synced across many nodes and facilitate new nodes coming up on demand they have a shared-db connector between the app (FA in our case, WP in first usage) and for exact reasons I do not know they intercept 'SET NAMES utf8' and translate it to utf8mb4

WP needs mysql 8+ and in mysql8 for backwards compatibility uses a specially encoded COMMENT so that earlier mysql versions will ignore the statement and that is what the connector looked for, in FA we just use the SET NAME command with no fanfare.

I did a lot of messing with my copy of the code before I found this, but have reverted to minimal changes as once I get everything working I'd like to get the changes pushed back to the official code.

I think I only 2 or maybe 3 changes that could be controlled by a global flag

They are:

db_query look for set name utf8 to reformat it to what the connector needs (Temporary while they fix their bug)

session.inc move SECURE_ONLY to a define in config.default.php also allow setting with Env Var

install/index.php allow setting DB settings from Env Vars

config.default.php - Flux specific - test db connection and if can not connect return 503 error to browser

That last one I can just append some lines to the file is the change is too specific to merge into master.

I am not going to submit anything until I have it all working, but it is looking good.

Tom

In the valuation report HA18 is listed at a unit cost of $23.08 and I have 11 On hand

I removed 11 @ $23.08 and added them back at $13.73 (which auto populated) and it looks ok.

I will try that with more items later today when I have time.

Tom

In my Valuation report (attached)

Acculap Pitch are always 13.73 but values range from 10.66 to 23.08

10.66 may have been a very old price for them...

I am not overly concerned how this happened, I just want to correct it moving forward.

Maybe it was wrong in the 10+ yr spam of usage database that I used to create my 2024 one...

I am looking at other issues, but it is likely if I can fix it for one item, that will allow me to fix them all

I assume that manufactured items get the value when they are manufactured, but I do not have a surplus, so those should correct over time.

Tom

20

(2 replies, posted in Reporting)

When I run the Costed Inventory Movements report I get some strange negative numbers for some items

The report is attached

How can I tell if these assumed values have totally corrupted my COGS?

I also attached my Valuation Report and it has a lot of wrong numbers.

The unit purchase pricing and reported unit cost are different, some time off by a lot.
How can I correct this?

I assume Unit Cost is used for COGS or Costed BOM for manufactured items.

Tom

21

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

apmuthu wrote:

Zip and attach herein and send to @joe.
Fork and send pull request to the unofficial Extensions repo as well.
Also it should state the version of WP it was tested on and whether PHP8 constructs undermine legacy PHP versions of FA in usage.

My PHP code is really simple I'm not sure what constructs came out in PHP8... I'm a PHP4/5 guy...

Can you recommend mysql/php versions I should test with?

Tom

22

(12 replies, posted in Installation)

The issue was in the db backend

I'd explain but nobody would understand LOL

Tom

23

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

Your link does not work.

Were the 'expectations' met?

I have a plug in that is working quite well for my needs. I need to test more PHP versions before I release on the FA site

Want to try it?

Tom

I am also seeing low or negative numbers.

Specifically on the Inventory Valuation Report I am seeing incorrect or negative numbers for a couple of items.

Is there a way to fix these numbers?
Do we have the wrong mb_iflag?

Maybe a report that displays the standard cost as well as the unit cost and costed BOM cost if manufacturered.

I'd write one but I have no clue how any of those are computed smile

Tom

I likely made a mistake when I started this new company...

I was looking at 2024 Trial Balance and get the message

The Opening Balance is not in balance, probably due to a non closed Previous Fiscalyear.

This is the First year... BUT I made it by deleting previous years from my store, it just change ownership structure

The non-zero values in the BROUGHT FORWARD are Checking Accounts, Receivables, Inventory, Sales Tax Liabilities (from previous year)
and loans from shareholders... oops the last one I may need to void out

So since I am explain all these, then it is ok and I should not have to worry about it in the future?

I also noticed that I have some open balances that should have been $0
There were no transactions against that, so I was wondering if I could edit the Opening balance to 0

Tom