Read post 7 above:-

you need to uncomment:-


File:includes\references.inc
63: //    'C' => 'customer',
64: //    'B' => 'branch',
65: //    'S' => 'supplier',
66: //    'L' => 'location'


So that it reads as this:-

File:includes\references.inc
63:     'C' => 'customer',
64:     'B' => 'branch',
65:     'S' => 'supplier',
66:     'L' => 'location'


This is not currently implemented

???? Along side the {UU} add a {L} you can separate them with a '-' or a '/' if you want.

So some examples:-

{YY}/{MM}-{001} exactly as it is written with curly brackets and YY & MM. example gives 19/02-001

{YY}{MM}-{001} exactly as it is written with curly brackets gives 1902-001

{YYYY}/{MM}-{UU}/{L}-{001} exactly as it is written with curly brackets gives 2019/02-07/4-001 where 07 = user number and 4 = location number

{YY}/{MM}/{UU}/{L}/{A001} exactly as it is written with curly brackets gives 19/02/07/4/A001 where 07 = user number and 4 = location number

{YYYY}/{MM}-{UU}-{001} exactly as it is written with curly brackets gives 2019/02-07-001 where 07 = user number

{YY}/{MM}/{UU}/{A001} exactly as it is written with curly brackets gives 19/02/07/A001 where 07 = user number

You can add or remove placeholders as you want... as per this this wiki page see the code block following 'Supported special fields for each transaction type: '

Experiment on your trial company

When you sell an item you have an option to sell from a location which you can select, this is the location that will used in the ref #

You can read about locations here.

You may be able to useeither:-
1. {L} - Location, you will have to define each country as a location and sell from that location
Or
2.
{P} - pos - Point Of Sale, each pos needs to be defined in setup against a location, which does come back to option 1.

In both casesyou will probably get just a number (of the location or pos), but you and your users will know what number each country is.

Please try on your training company first and report back for completeness.

Edit: I've had a quick look, it appears that pos can only be assigned to each user, which leaves just option 1.

At the beginning of Reference Pattern: you will see another box, you can add a preffix in there.
If you have already used the transaction ref, you may not be able to edit the prefix, so in this case make a new transaction reference

Hi, please read post 4 above, which means you need to use {UU} in your transaction reference. So each ref will be unique.

The wiki entry is mentioned in post 7 above too, which also states to use this method.

So the problem is in the db then...

Not Columbia... Colombia

You missed my point in post 2 above:-
With reference to your 1st post
The secondary company is working as expected... error "Process journal entry only if debits equal to credits" is correct, FA is double entry accounts software; for every credit there must be an equal debit and vice-versa. It means you have not entered a corresponding debit/credit in the journal entry

So as I understand, you swapped the db's around and the problem moved with the db?

So the problem is definitely within the db.

Have a closer look at the 3 account tables...chart_class, chart_master and chart_types

Can you use your backups and see when the problem appears?

Maybe when you upgraded you didn't upgrade the db at each stage? Or something went wrong?

The 'debits = credits' is because FA is double entry accounts software, so the problem may be with the main company?


Were the two companies created with the same COA?

May be worth comparing the two db with WinMerge. The data of course will be different, but you will see any differences in the db structure. (Make a backup of each company, select both in explorer, right click for context menu - WinMerge)

185

(6 replies, posted in Fixed Assets)

@apmuthu from my understanding of the code this is the intended functionality:-

Access(security) to certain fixed asset pages depends on a)access role for relevant fixed asset AND b)access role for relevant 'parent' page(Items & Inventory/Sales/Purchases).

I'm sure I've seen something like this in the wiki/forum, but cannot find it?

186

(6 replies, posted in Fixed Assets)

@mugao-em can you confirm the access role also has:-
-
Inventory configuration:    
Stock items add/edit
-
access as well?

If access for Inventory configuration: Stock items add/edit is unchecked - check it, then see if role can access add fixed assets please.

A lot of the fixed asset pages use existing items/sales/purchase pages, example you will not have access to fixed asset location if you do not have access to items & inventory locations

187

(2 replies, posted in Report Bugs here)

Working fine for me on 2.4.6

I revisited my ‘minimo’ theme introduced here and toned down the changes; also adding css only off-canvas menus, ie no additional js.

minimoV2, minimoV3 & minimoV4 all have the same general theme, but with different menu options:-
V2 – Hover left for menu with hover over menu tabs for complete applications menu.
V3 – Hover left for what I can only describe as ‘The Meg' full screen with all applications listed in a vertical format
V4 - Hover left for a horizontal version of V3
V5 - Not done, but applications only for the current tab is also an option.

With V2, V3 & V4 it’s possible to go from your current page to any other page in FA with just one click; although I am not 100% convinced in any improvements to productivity, but that will probably come with use. It’s also a little ‘weird/different’ having no menu, but that should also disappear with use.
It’s also possible to have 2 different menus for the left and the right in the same theme ie left menu V5, right menu V3.
Smaller screens may be an issue.

None of the themes are 100% complete, but if you like the concept and wish to include them in the core I will finish them.
To do list includes:- Log in/out screen. Remove redundant css.  Improve div start/end logic for V3, re-write menus as a function, change renderer tables to divs, etc

Demo here
username: demo
Password: password

@boxygen ref post 2. Is this similar to what you meant?

189

(3 replies, posted in Accounts Receivable)

???, you need to select a different payment type; at the top, right of center in direct sales

190

(3 replies, posted in Accounts Receivable)

Check your bank accounts

Banking and General Ledger ->Bank accounts

Which bank accounts under the column heading type are 'Cash Account' If you are using standard bank accounts then there is only one...Petty Cash

I believe that FA views a direct sale as a cash sale, therefore there is only one account of type 'Cash Account' the petty cash account.

So create another bank account say 'Cash' type Cash Account.

I'm sure I've read something in the wiki, but cannot find it at the moment, will have another look tomorrow.

Would the system version of the supplier invoice be enough?

If so type the following url into your browser; changing the last number (Its the system number of the invoice) for the invoice number you need to print

http://www......your FA path.....   /purchasing/view/view_supp_invoice.php?trans_no=2

Not very user friendly but this will show the system version of the invoice with a print option

192

(114 replies, posted in Reporting)

I think i would copy both to a spread sheet and try to align from there.

Another thought, when did you start using the Dutch COA? Might be useful to download the latest Dutch COA and compare that? Seems they were updated approx 9 months ago.

Go back to basics and check everything; i.e. Do you have a GL account assigned to each tax? I s that GL account used elsewhere, etc.

193

(114 replies, posted in Reporting)

Hi,

So if the ''Standard USA COA + demo data' it works fine' so the problem could be with your COA? Check your COA with the std, make sure all accounts are assigned and -> Setup -> System and General GL Setup accounts is matching as per @apmuthu's post 11 above

I'm getting the same, so wiki

wiki wrote:

Advanced Manufacturing.

    If you make several productions or adding extra costs to a Work Order, the work in progress will be visible in the balance sheet.
    When the closing productions has been done the work in progress is transferred from works in progress to finished goods.
    From the Release status to Production you will see the demand of BoM items in the Item Status together with other demands as sales orders.

To me the 2nd line reads that only when the w/o is closed will the wip be transferred to stock.

So it seems separate w/o's are necessary: Is there a reason you cannot issue a w/o for 200 and 2 more for 100 each?

195

(5 replies, posted in Setup)

FA version number as well please.

xampp?
wamp?

196

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

@apmuthu ah ok, initial thoughts are I can do that with customers & suppliers as they are the same, but not so sure with items as whilst similar are not the same, will have a look next week. Thank you.

197

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

@apmuthu not quite sure what you mean or how this is possible, can you please clarify? Example/s would also help me?

198

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

kvvaradha wrote:

@poncho -  If you are really interested to bring the custom fields. We have to make changes in the core to allow it to add additional fields.  Instead of making it as extension.  Try to make it within core. and get the difference of file with help of git difference. So it would be added to the core in next release of FA2.5.

Hope it sounds good. Also @joe waiting to hear your thoughts before he start working inside core.

we are ready to make this one.

@kvvaradha @joe My apoligies for my late reply; I mis-read kvvaradha's post (or it was changed?) and was mulling over a response

Can you please clarify if: You want me to modify core files to incorporate custom fields as it was into the core for release FA2.5 (I think this is what you mean)

So a few thoughts:-

1. Use existing FA db tables where possible or db structure as is in additional fields ext.(which makes upgrading easier?)
2. Address options

  1. Keep the existing address field as FA core and have additional address fields as extra info?

  2. Use the existing FA core address field as the first 1/2/3/4 lines of the address then add extra fields for city, department, etc? This is quite a large change; customers, customer branches, suppliers, locations, company setup etc and all relevant reports

  3. Separate fields for all lines of address? ie Address Line 1, Address Line 2 - 4 and then city, department, etc

  4. Or another way not listed here?

3. Use dropdown lists for city, etc or empty box? Or a combo box that allow select from list or manual entry) Also I think its possible to use a flat file for a list of cities etc and then only store the value in the db. Users can then add their own 'locale'

4. Option in company setup to turn on/off custom fields?
5. Create a detail query for each CSI (I'm fairly sure I need help with this)

199

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

Due to the number of conflicts created with the integrated version I have revised the ext so that it is non-integrated.
It was not as user friendly - now CSI additional info entry is now a two-step operation (eg Enter new customer data in FA core as std, then go to customer additional info (You can see FA core CSI details, but you cannot edit them... see screenshots below)) but the ext now has no conflicts with FA core. No changes to database.

Demo is here
Username: demouser
Password: 12345678

Code is here

New screenshots here:-

https://imgur.com/a/OV0R4nQ
https://imgur.com/a/PATDJRz
https://imgur.com/a/3DsSyev
https://imgur.com/a/UOtXCkI


If you have already installed additional fields then you are advised to change to this latest version as FA will not fully work with the old version. To do this:-

Method one:-
1. Make a backup of your database (Just in case)
2. Delete all files in /modules/additional_fields/
3. Down load the new version and unpack the contents to /modules/additional_fields/
4. Check access permissions change if necessary then log out and log in

Or

Method two:-
1. Make a backup of your database
2. Deactivate and delete the additional_fields ext
3. Down load the new version and unpack the contents to /modules/additional_fields/
4. Install and activate the additional_fields ext.
5. Restore the backup you created in step one
6. Check access permissions change if necessary then log out and log in

Please note: There are a number of file deletions, therefore a differences pack will not work

Can you confirm that you have changed Preferences -> Query page size: to 60?

This should give you all the customers transactions for the month (you stated around 50) on one page of customer payments. It also means you will not need to use the customer balances report.

If you are only seeing 'auto' in the references column, you may not be using the direct sales with credit correctly