Hi, try to understand the problem. In RF we have so called active/passive account, it mean that they have dr or cr saldo. They are organised by using sub account, and last one may be only dr or cr. the upper account just accumulate the sum of sub acc. It use when we pay an advance payment. Of course sub acc show in other part of BS. In example from training FA 2/3/8 i observe the situation when AR 2100 being in liabilities really has cr saldo. It means that there are prepayment and it is really an current assets. Probably the very qualify accountant easy find the trust, but ... i don't know! may be i am wrong and don't understand something in foreign statements? Help me please. In addition on forms BS and PLS no current (period) entries (like trial BS) and it make us to drill down till account entries. It not usability imho. In addition in trial BS form i've chose i marked (Only balances) option, but instead i seen a full chart of acc and all groups (ex. Group - 12 - General & Administrative expenses). Why? I really in mess. BR.
PS. Any i keen in FA.
1 02/08/2012 07:08:34 pm
Topic: AR but not liabilities, but what! (1 replies, posted in Accounts Payable)
2 02/07/2012 04:00:24 pm
Topic: off-balance-sheet liabilities (1 replies, posted in Accounts Payable)
In our practise very often there are situation, when we need take into account off BS liabilities. Example, we've sign the contract and have to prepaid it in middle-term future. Of course we wanna see it in our Calendar of Payments. To create the view from FA table with balance AP L is no problem. But is the any way how (where) to take into account off BS L?
3 01/19/2012 04:01:16 pm
Re: Credit Status Setup - how to money back (3 replies, posted in Accounts Receivable)
ok. i agree. thanks Joe.
4 01/19/2012 12:55:56 pm
Topic: Credit Status Setup - how to money back (3 replies, posted in Accounts Receivable)
Sirs, i occasionally stack into one problem. There is Credit Status Setup, it manage (from FA windows) possibility of invoicing (YES/NO INVOICING) but in really it blocked all entries with customer. I don't do a quote, SO .... moreover i cant do the customer payment. Where is good business logic. May be i agree with blocking of sales and invoice operation, but money! All of us wanna take money back and after do the decision how to work with bad customer!
5 01/18/2012 07:50:03 pm
Re: Decrease the item from stock spent in the service (9 replies, posted in Items and Inventory)
HI jose manuel, tell me please this topic would has a just accounting or managerial accounting or just commercial result. what goals you pursue?
6 01/18/2012 01:52:55 pm
Re: Decrease the item from stock spent in the service (9 replies, posted in Items and Inventory)
you have two issues. 1. it a how to change unit of measures 2. how to release the difference between economical calculation and fact. it is a accounting problem. (IMHO)
7 01/18/2012 01:46:50 pm
Re: Customer Invoice with problems with Chrome browser (2 replies, posted in Accounts Receivable)
seamonkey brouser. it a little clone from mozilla.
8 01/18/2012 01:45:34 pm
Re: Column tpe in debtor_trans? (2 replies, posted in Accounts Receivable)
thanks Joe.
9 01/18/2012 01:43:32 pm
Re: Draft and approve transaction (2 replies, posted in Wish List)
I don´t really know for what do the reverse transaction in Journal entry. Is the same? Very nice work
i haven't test this logic in fa, but in system we've used there is the same logic. you can create a big general journal consist of many entries. before you will post them, you can mark the button: save as template, reverse template, delete automatically. in case you've wrong in entries you open this template journal and post it again. both journals cannibalise each other.
10 01/17/2012 02:19:44 pm
Topic: Column tpe in debtor_trans? (2 replies, posted in Accounts Receivable)
Hi FA masters. There is 1_debtor_trans.tpe i.e. there are column tpe. What that? I never find a description. What's the data in that column?
11 01/13/2012 01:14:59 pm
Re: Didn't find a sence of two columns. (3 replies, posted in FA Modifications)
I see. Thank you itronics. But .... i have another one q.
in 1_debtor_trans there are column tpe. What that?
12 01/10/2012 08:59:51 pm
Re: serial number tracking (29 replies, posted in Wish List)
+1.
Ready to do a contribution for dev team.
13 01/10/2012 04:11:34 pm
Re: Didn't find a sence of two columns. (3 replies, posted in FA Modifications)
Sirs please respond me. I never find a solution. What are these mysterious columns. Some FA logic has changed data, but so way I can not imagine. -((((((
14 01/09/2012 02:59:48 pm
Re: Mixture of InnoDB and MyISAM type for FA MySQL tables (6 replies, posted in Setup)
Joe,
We have several times heard of FA 2.4 release. But everything is kept in the intrigue. Please give us (community) a couple of words about new features, changes, release time e.t.c. -)
15 01/08/2012 05:33:27 pm
Topic: Didn't find a sence of two columns. (3 replies, posted in FA Modifications)
Guru please help me. I need a couple of changes to the system and want to deal with all the values used by the system.
1. FA has table `0_sys_types` and second column named `type_no`. What is that? Is any restrictions on value in this column?
2. Table `0_sales_orders`what is column `type`. I've looked all rows and always type = 0
What is that also?
16 01/04/2012 05:51:53 pm
Re: Cash sale/POS functionality 2 (7 replies, posted in Accounts Receivable)
All ok J. I'm fully satisfied. Key phrase was "inventory is considered only as default". It's enough. And real life is more important.
17 01/04/2012 05:40:13 pm
Re: off-balance-sheet account (2 replies, posted in Banking and General Ledger)
-) Thanks Janusz
18 12/29/2011 11:21:07 am
Re: Cash sale/POS functionality 2 (7 replies, posted in Accounts Receivable)
Sirs once more. Very easy question. There is a link between pos and location. Does it have any influence for any FA business rules further? If yes, where? Or it just a link!!!!
19 12/28/2011 04:15:03 pm
Re: Cash sale/POS functionality 2 (7 replies, posted in Accounts Receivable)
Hi Janusz, thanks for answer. Very tricky case. I understood it that way. 1. There is location - it's mean stock and inventories 2. Around the location there are pos. It may be look likes sales desk and counter 3. All sales desk tied to their pos. 4. All pos's have the different right and rules to sale inventories. In pos set up i define the other conditions for sale. ok. I agree. But the same time i can change location and do the sale from other. What a sense to link pos and location? I had thought to consider pos as another type of dimension and accumulate revenue... But really i didn't understand a logic. Please give me another one clue to guess further. May be i observe a pos in a wrong way? What is that according to FA implementation?
20 12/28/2011 08:23:54 am
Topic: Cash sale/POS functionality 2 (7 replies, posted in Accounts Receivable)
Hi everybody, I'm confused testing pos/cash functionality. i set a control parameters in setup for pos.
POS Name Credit sale Cash sale Location Default account
Default23 Yes Yes Centre Cash machine 1
Default24 No Yes Kazan Cash machine 2
also there is user admin tied to User's POS: Default24.
I was thinking it means that Default24 can sale only for cash and after invoice, automatically creates payment and allocation. I prefer that configure default24 has no influence to default23 sale. But what was going on. When i (admin) create and performed B2B chain (location = centre) from quote .... invoice and on last one payment terms (10 days after invoice) surprisingly turn into cash (payment type = cash) automatically and fa doesn't allow to change it. Also invoice form had a strange behaviour. When i tried to change location to Kazan it performed with contemporaneously changing of form to invoice-cash window. I guess that it could be done from user setup, but i can not to do the same tuning on fa site testing instance, because it can be done just under admin account. is anybody who had the same problem? i prefer that rules for each pos attune separately. each pos have own rules for credit or not credit payment terms and it doesn't correspondent to other setup conditions. example: there is area with location stock and sales office. on sales office there is a counter for pos and cash machine. i wanna sale as from pos also b2b. in first it been sold for a cash, in second for bank transaction. i didn't see any restriction. may i am wrong. help me please.
21 12/27/2011 06:09:04 am
Re: how to use tag properly on dimension and account (8 replies, posted in Dimensions)
Hi Joe, thanks for answer, but i didn't find anything. Usually i use google search to find any notes before ask guru directly. May be you post a link to topic. BR.
22 12/26/2011 05:37:28 pm
Topic: how to use tag properly on dimension and account (8 replies, posted in Dimensions)
i wanna to extend functionality of tags and using them in current report. looked on table tag_association i found that may be problems follow from the same name in record_id field. if i will have the same name of dimension and account and link tags, that i never know what record in tag_association correspondent to account or dimension and will be having a mass of wrong info. that is right? should i add a new type of record (dim/acc) in table. it is very easy, but i prefer to ask. also i didn't understand what is a functionality with memo (Dimension Entry). some data put into table 0_comment but what is that. i can't make a sense of this operation. please help me. also i hardly agree with previous topic, that dimension have to be choosing previously on sale quota form. it allow to work more flexible. example: customer is serving by two dep's (sales and after sales service) i must to know on first step who is initiator of deal. who is responsible! all managers is on field. how the desk manager from maintain and support guess what dep's have to be on invoice. just way to do a few direct calls sales guy and ask theirs. it is an normal. all loss a time! BR. Happy MC.
23 12/16/2011 05:28:11 pm
Topic: off-balance-sheet account (2 replies, posted in Banking and General Ledger)
Hi everybody. In Russia we can use off BS account. For example, I lease a computer from company A, or take a goods for commission trade. In RF tax authorities require take the goods on off BS account. Of course we do not own this property. I didnt find a class of accounts for off BS entries. I guess that foreign accounting dont like use it. (Enron case) But how way could be? BR. Uma
24 04/26/2011 04:00:10 pm
Re: Aged Supplier / Aged Customers Analysis (2 replies, posted in Reporting)
This could be just me not understanding the logic, i'm not sure but an improvement in the ways it shows the current and 0-30, 31-60, 61+ could be better shown as follows:
I agree with t2webby, i also didn't understand the sense of result view
Example
Terms: Due 15th Of the Following Month
Currency RUB
invoice = 1800
paid = 2000 and has been done reconcile of 2000 to 1800, left 200
----> result view
Current 1-30 Days 31-60 Days Over 60 Days Total Balance
1 800,00 -2 000,00 0,00 0,00 -200,00
Why the reconcile doesn't work? The really this invoice was paid and no liabilities during this periods. The customer is creditor. Such report distorts the data. Is anyone who solved this problem?
Uma
25 04/25/2011 03:20:29 pm
Re: Item categories and Item types (6 replies, posted in Items and Inventory)
Hi everybody. i am newcomer from Russia. i am going to implement FA and learning a functional. there is an issue I didn't understand. The category is based on item type. when i create item, i define category and same time FA define item type. if i change category the item type change same matter. but if i change the item type on existing item, FA allow to do it. practical it can be a situation when item belong to product category and has GL account appointed to component and item type = manufacture. How it work. Please explain the logic. Really i going to mark item type as read only on form item. Hope it help me to avoid uncertainness. Sorry for my English, i had no practise for 2 years.