The main record is still $25000 where the allocated part is $15000. Left to allocate is $10000. This is the way it works.
/Joe
3,901 01/30/2010 08:26:56 am
Re: Customer Payment (show wrong) (4 replies, posted in Accounts Receivable)
3,902 01/28/2010 10:16:44 pm
Re: stocks work in process (4 replies, posted in Manufactoring)
Hello again, obahey,
I have now had a closer look into this complexity. I understand why we never implemented it by using the GL work in progress.
There are so many operations in the advanced assembly. Releasing, extra issues, overhead and labour cost adds, changing the workorder during the operations. To all the time keep track of the correct GL updates would be a huge task.
It is, however, updated correctly when producing. Maybe we in the future can dive into this and get it work as you mention, but not now. It will with guarantee give side-effects doing it now.
/Joe
3,903 01/28/2010 09:43:05 pm
Re: error The Retained Earnings Account or the Profit and Loss Year .. (3 replies, posted in Setup)
You get this warning is you have not set the profit and loss year account or the retained earnings account. Check this in System and GL setup.
Try to retrieve the exchange rate manually in Exchange Rate.
/Joe
3,904 01/28/2010 02:26:48 pm
Re: stocks work in process (4 replies, posted in Manufactoring)
Yes, of course you are right. It was only very complex when disassembling and extra issues and overhead costs and labour costs.
But I will have another look into it and see if we can correct it.
/Joe
3,905 01/28/2010 10:13:16 am
Re: stocks work in process (4 replies, posted in Manufactoring)
There are no GL transactions before the productions (unless there are overhead or labout costs). The stocks are automatically issued (according to the BOM) when creating the work order. We have had discussions forth and back regarding this, and came up with the approach we have now.
The items are reserved in the same way as if you create a sales order.
/Joe
3,906 01/25/2010 11:03:24 am
Re: currency problem (16 replies, posted in Report Bugs here)
Hello Alvin,
I have been looking at the algorithms for fetching the sales prices and I detected an error in the sequence in picking up the correct price.
You may have run into this problem
You say you are running 2.2.2. The release we are running is 2.2.4. I think, however, that you can download this file from the CVS Main trunk
/Joe
3,907 01/25/2010 09:42:48 am
Re: Inventory Item Status (7 replies, posted in Items and Inventory)
Please, hadi, look in the Wiki
on how to setup the tax system.
/Joe
3,908 01/24/2010 08:48:59 am
Re: Miscellaneous Enquiries on reports. (7 replies, posted in Reporting)
Sure.
1) Calculated Return is the same as Net Profit. It is called calculated because this is not a final statement.
2) a. Accumulated is from fiscal year begin upto and included the period. The period is only for the selected period.
b. Period Y - 1 is the amounts from the same period year - 1 (last year).
c. Budget is the budget entries from the selected period to compare with.
3) The Achiedved% is calculated first column 1 / column 2 * 100. If column 2 is 0 it is set to 999.0.
/Joe
3,909 01/22/2010 03:58:30 pm
Re: Forgot Password (4 replies, posted in Setup)
Are you sure your default company has a table prefix of 0_?
I only ask, because I have done the same mistake a couple of times 
You should see the correct table prefix in the table in Install/Update Companies (Setup tab) for your default company.
/Joe
3,910 01/22/2010 03:53:50 pm
Re: Miscellaneous enquiries on Sales (1 replies, posted in Accounts Receivable)
Hello. You may have Sales Persons that do get provision (bonus) of their sales in percent of what they sell. Maybe 5% upto $2000 (this will be the breakpoint then) and then maybe a lower/higher/same percent of the rest the sales person sells.
If you don't need them, just set the values to 0;
/Joe
3,911 01/22/2010 11:07:12 am
Re: User Privilege issues (3 replies, posted in Setup)
Ah I understand your problem. It is not possible to restrict/allow users from single records .
/Joe
3,912 01/22/2010 10:21:35 am
Re: Purchasing Pricing - How it works and how to use it! (25 replies, posted in Items and Inventory)
If you change the Standard Costing in Items and Inventory, a journal Entry is made to adjust Inventory and purchase price variance.
And the average standard cost is updated on the stock.
/Joe
3,913 01/22/2010 10:14:41 am
Re: Adding new exchange rates. (1 replies, posted in Banking and General Ledger)
You are right.
CVS Main trunk is updated. Affected file /gl/manage/exchange_rates.php. You can download it from here and replace at your server.
/Joe
3,914 01/22/2010 09:41:55 am
Re: User Privilege issues (3 replies, posted in Setup)
By following the access role items and setup relevant restrictions it should be possible to disable a user from dimension or part of.
After making this new role you should put them on the relevant users. You can copy an existing role and eliminate the dimension part you don want.
/Joe
3,915 01/22/2010 09:36:14 am
Re: Absolute URL (1 replies, posted in Setup)
As far as I know, there should be no absolute URLs in FA, so you should be able to just move all the files to another folder, but I have not tested it yet.
You could make a try and report back the results.
/Joe
3,916 01/21/2010 04:32:33 pm
Re: Generation of Receipt (6 replies, posted in Accounts Receivable)
If we use our document layout as a base, can you just briefly describe what information is good to have here and where on the document.
I guess we could use the same info as on the Remittance, though the other way round. Listing of the allocated invoices if any, right?
And a line for Stamp and/or sign, right?
/Joe
3,917 01/21/2010 09:12:15 am
Re: Can We have an Ex. for New Multi Level Types (6 replies, posted in Setup)
The good news is that you don't have to do anything at all if you are satisfied with the Chart of Accounts and Balance Sheets or Profit/Loss Statements as they are.
The old way (and the way FA works without any change):
Parent Level
1 Assets Class
1 Short term -1 Type/Group 1
5 Current Assets 1 Type/Group 2
1065 Bank 5 Account
2 Long term -1 Type/Group 1
1500 Inventory 2 Account
a.s.o
First there are classes. Then there are Types/Groups in 1-2 levels. And finally the Account itself.
In this example the 5 Current Assets is a sub-group of Type/Group 1 Short term.
The new way (With Group/Types of the same length)
Parent Level
1 Assets Class
1000 Short term -1 Type/Group 1
1001 Current Assets 1000 Type/Group 2
1002 Bank/Cash 1001 Type/Group 3
1003 Bank 1002 Type/Group 4
1065 Cheque Account 1003 Account
1100 Long term -1 Type/Group 1
a.s.o
Here you can have 4-5 levels of types/groups. But the Types/Groups must be in sorted order inside the class.
This example is somewhat exaggerated. In my opinion, I am satisfied with the old way of grouping.
But some countries/organizations may require more than the 2 levels we can handle in the old way.
Therefore this new was implemented.
The Wiki has been updated with this example.
/Joe
3,918 01/20/2010 05:31:36 pm
Re: Can We have an Ex. for New Multi Level Types (6 replies, posted in Setup)
Please look once again. I was sure it had been updated .
Look under Banking and General Ledger, Account Groups.
/Joe
3,919 01/20/2010 05:28:29 pm
Re: Tax inquiry report does not show all tax (13 replies, posted in Banking and General Ledger)
JE = Journal Entry, sorry.
While the Journal entry (that includes transactions on a tax account) is saved everything in GL are updated correctly, but when updating the trans_tax_details for this Journal Entry the type was changed to a Bank Payment because we couldn't figure out if this was Outgoing or incoming tax statistics.
When I see this in the code, I remember you did some changes here when we updated the Tax Report after implementation of the Quick Entries.
But again, these transactions should not be done before the Tax Report has been taken. See the Wiki regarding tips on how to do this correctly.
If this tax_trans_detail is still there after voiding the Journal Entry and if the Transaction is from before a Tax Report, this do not have any effect on the future tax reporting.
/Joe.
3,920 01/20/2010 05:04:27 pm
Re: Abbreviations (2 replies, posted in Banking and General Ledger)
It means Dimensions Included.
/Joe
3,921 01/20/2010 10:12:12 am
Re: Tax inquiry report does not show all tax (13 replies, posted in Banking and General Ledger)
Some time ago, about 9-12 months, you changed something here Janusz, when we implemented the quick entries. To pick up the correct debit/credit tax you changed a JE entered voucher with tax accounts from type 0 (JE) into type 1 (bank payment). I guess when this JE is voiced, it can't find the correct trans_tax_detail to void.
Please also read the info on how to use the Tax System and Reporting in practice on the Wiki
/Joe
3,922 01/20/2010 09:58:18 am
Re: Cost Difference on Supplier Invoice (10 replies, posted in Items and Inventory)
Stildalf,
You should immediately unmark the checkbox 'Allow Negative Inventory' in 'System and General GL Setup' (Setup tab).
Then goto Items and Inventory and check how much stock is negative for every item (Inventory and Item Status) . Write it down and then go to 'Inventory Adjustments'. Enter the number and the price (from your supplier) on every negative stock item so you get a positive stock.
Remember, you can always go to Inventory Adjustments to correct the stock qty and price.
If you need further correction of the price you can fine adjust it in Standard Cost lower right in Items and Inventory tab. This is usual if you know exactly how much the average standard cost is (or should be) now.
After these operations you should run without problems.
Maybe I should put this on the Wiki.
/Joe
3,923 01/19/2010 10:08:30 pm
Re: Cost Difference on Supplier Invoice (10 replies, posted in Items and Inventory)
Well, I am not the Judge. The option has been here all the time, without complains so far.
/Joe
3,924 01/19/2010 07:25:49 pm
Re: Can We have an Ex. for New Multi Level Types (6 replies, posted in Setup)
Please look into the Wiki regarding this.
/Joe
3,925 01/19/2010 07:23:15 pm
Re: Miscellaneous enquiries on System and general GL setups (6 replies, posted in Setup)
Ah, Towhid. You fooled me a bit when talking about over_receive and over_charge on deliveries and invoice.
My answer was wrong.
The over_receive is an allowed percent of over received qty when receiving items for a purchase order.
The over_charge is an allowed over charge of line items in a supplier invoice from received items.
Hope this is clear now.
/Joe