3,926

(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,927

(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

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

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.

3,931

(2 replies, posted in Banking and General Ledger)

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

3,937

(24 replies, posted in Accounts Payable)

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

3,942

(1 replies, posted in Wish List)

This algorithm is setup now to increase the first numeric field and not the last. You should swap the info to:
MYCOMP/000000/2010, then it will increase correctly.

/Joe

3,943

(7 replies, posted in Items and Inventory)

If the Location has an email address and if the variable $loc_notification = 1; in config..php and the stock goes below the re-order level, the Location will receive an email regarding this.

Otherwise this field is only for your information to purchase or manufacture new items.

/Joe

Test3 and Test4: I guess you mean GRN (not GRV). How did you succeed to invoice non received GRNs?

This mechanism GRN, Invoice, creditnotes, voiding the items etc. has been rigoriously tested two years ago. And it should work.

/Joe

Thanks Towhid,
Yes, this was a bug. But Sales Quotation shouldn't be calculated at all. Only Sales Orders.
CVS Main trunk updated. You can get the new file here:



/Joe

Another tips regarding the tax paying.
If you have a tax reporting period for January and print this tax report out in the beginning of February. You want to pay this in February.
Then you should consider using an extra liability account for accumulated tax.
Then you can empty the tax accounts per Jan 31 and counter book them on this accumulated tax account. Now you are not destroying the statistics for February when you are paying the tax. This entry will debit the accumulated tax and credit the bank account.

I will put these instructions on the Wiki.

/Joe

Thanks.
A)
1, 2 and 3 are info that are put on the various dimensions, workorders and deliveries. After these days the records are marked as overdue in the inquiries.
4. When using multiple deliveries for one invoice, the shipping cost could either be accumulated or only use a single freight cost.
5 and 6 are related to the underlying sales order. You can only deliver a certain percent more items than origin.

B)
1. These tags are going to be used as extra selectors in reports. This is not implemented yet. Only prepared. Will come during the 2.2.X releases or in release 2.3.

/Joe

3,948

(24 replies, posted in Accounts Payable)

For gl items, you should create Quick Entries for your various non items related entries. This is the best way of doing this.

/Joe

Hello Again Tom,
You are right tom. It didn't void the amount, because the type was set to Bank Payment. A safety-guard that Janusz did some while ago.
But this is not a big deal here.
IMPORTANT.
You must run the Tax Report before you make any payments from the tax accounts inside the tax period.
The trans_tax_details holds the tax information on the documents. But it is also used for the quick entries to make cash sales or payments for utility bills.
So when you pay tax and debit a tax account, the statistic in not available anymore, because the trans tax details are updated.
The next time you run the tax report is maybe one month (period) later and now the payment from last period is no longer picked up on the new tax report. After the tax report is run, and you have a hardcopy you can pay/receive your tax for that period.

I would prefer if you do the payment in the Bank Payment. Then if this payment is voided, the trans tax details are also voided.

/Joe

3,950

(24 replies, posted in Accounts Payable)

If you have setup your supplier and items with correct tax groups/item tax types and correct purchase account, there shouldn't be any problems getting the correct tax calculated automatically for you.

/Joe