It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by joe
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
Please, hadi, look in the Wiki
on how to setup the tax system.
/Joe
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
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
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
Ah I understand your problem. It is not possible to restrict/allow users from single records .
/Joe
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
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
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
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
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
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
Please look once again. I was sure it had been updated .
Look under Banking and General Ledger, Account Groups.
/Joe
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.
It means Dimensions Included.
/Joe
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
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
Well, I am not the Judge. The option has been here all the time, without complains so far.
/Joe
Please look into the Wiki regarding this.
/Joe
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
Well, it is possible to have a supplier where you buy items to go into the stock and other cost things that are not going into the stock.
This is the reason why both these options are in the Supplier Invoice/Credit note.
Normally there should be no problems having these operations in the same form. It has been here for 3-4 years, without any complains.
/Joe
The GL Postings are done correctly. If the stock is negative the standard cost for the item is 0.
Default the 'Allow negative stock' is NOT marked. Some business doesn't need to keep check of their stock. For some reason. Therefore negative stock gives no values in the inventory account.
So as I see here, you should operate with the 'Allow negative stock' unmarked, and we avoid these questions.
In other words, you should know what you are doing, if you mark this flag.
/Joe
It is the item qtys from the Sales Order.
/Joe
If you deliver items before any are received how is that possible? I know it can be done, but FA assumes that if you start delivering items, these items must have an initial value per item. This can be set initially in Items and Inventory, Standard Costs.
This is the danger having the stock check disabled. It is only delivering during the period from GRN to supplier invoice the price will change and only if there really is a price change from GRN to supplier invoice.
No problems stildalf.
If there are deliveries during the period from GRN to supplier invoice, these price differences are updated when the supplier invoice is entered. But only if there were differences.
/Joe
FrontAccounting forum → Posts by joe
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.