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.

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?

ok. i agree. thanks Joe.

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!

HI jose manuel, tell me please this topic would has a just accounting or managerial accounting or just commercial result. what goals you pursue?

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)

seamonkey brouser. it a little clone from mozilla.

thanks Joe.

jose manuel wrote:

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.

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?

I see. Thank you itronics. But .... i have another one q. hmm
in 1_debtor_trans there are column tpe. What that?

12

(29 replies, posted in Wish List)

+1.
Ready to do a contribution for dev team.

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. -((((((

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. -)

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?

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.

-) Thanks Janusz

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!!!!

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?

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.

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.

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.

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

t2webby wrote:

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

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.