3,151 Reply by joe

(5 replies, posted in Wish List)

Getting serious Dimension reports can not be done with use of dynamic dimensions. To get correctly P&L stqatements you must have the transactions sequential on the line (or in a table of its own with secondary keys).
Account - Dimension 1 - Dimension 2. Transactions belonging to Level 1, Dimension 1, and Level 2, Dimension 2 must be on the same transaction line and the account must be here too.

It would require enormous recursions with multi level of parents. And it would be impossible to handle these operations in the various forms.

/Joe

Go to forum: Wish List

3,152 Reply by joe

(1 replies, posted in Reporting)

Balance Accounts always shows Opening Balances from previous year, where Income/Expense accounts always shows Opening Balances from the fiscal year begin.

We had a bug in the Trial Balance Report a while ago regarding the totals, but this is fixed now.

/Joe

Go to forum: Reporting

3,153 Reply by joe

(5 replies, posted in Wish List)

For SME sized companies 2 dimensions are more than adequate. You can get a lot of GL reports where you can get the result on 2 levels.
If you have level 1 as departments and 2 as cost centres, you can get result for department X, cost centre Y. Or department X only.

Consider using Tags if you need more filtering.

/Joe

Go to forum: Wish List

3,154 Reply by joe

(2 replies, posted in Accounts Receivable)

You can look in /reporting/rep210.php about line 168 how to use price_in_words.

The function is located in /includes/ui/ui_view.inc.

You can also hook your own function by using the hook class.

/Joe

Go to forum: Accounts Receivable

3,155 Reply by joe

(6 replies, posted in Accounts Receivable)

This has now been fixed to follow the algorithms in Aged Customer/Supplier List. As default the allocated records are not shown and calculated.

HG repository has been updated. The changes will come in release 2.3.5

/Joe

Go to forum: Accounts Receivable

3,156 Reply by joe

(7 replies, posted in Manufactoring)

No, it is not. It will probably be necessary to use more decimals to do your operations.

/Joe

Go to forum: Manufactoring

3,157 Reply by joe

(3 replies, posted in Accounts Payable)

If you do not want to distribute the S&H in the line items when entering them you can do that when entering the Supplier Invoice under GL Items.

/Joe

Go to forum: Accounts Payable

3,158 Reply by joe

(6 replies, posted in Accounts Receivable)

Hello,

This has just been fixed so there is a selection on how use this for Aged customer/supplier listings. Default is now to not include allocations.

Maybe we should also include this for statements, right?

/Joe

Go to forum: Accounts Receivable

3,159 Reply by joe

(8 replies, posted in Accounts Receivable)

Yes you can handle these transactions in one Journal extry.

/Joe

Go to forum: Accounts Receivable

3,160 Reply by joe

(5 replies, posted in Dimensions)

It is important that the entrance of the dimension transactions are entered correctly.

Please try to explain exactly how you enter those dimension transactions. Either on Invoices or GL entries.

/Joe

Go to forum: Dimensions

3,161 Reply by joe

(8 replies, posted in Accounts Receivable)

Ah, I was referring to Journal Entry in Bank and General Ledger tab.

/Joe

Go to forum: Accounts Receivable

3,162 Reply by joe

(2 replies, posted in Setup)

Thanks tclim,

I will upload it to the central repository.

/Joe

Go to forum: Setup

3,163 Reply by joe

(7 replies, posted in Manufactoring)

You can use the conversion factor in Purchase Pricing, Items and Inventory tab. Also look in the wiki, https://frontaccounting.com/fawiki .

/Joe

Go to forum: Manufactoring

3,164 Reply by joe

(8 replies, posted in Accounts Receivable)

This was only related to the Tax on the Invoice. You will have to credit the appropriate taxes included in the discount amount. This is often very minor and not normally taken care of. But if you will you can do this. Please use the memo field to indecate the Invoice no.

/Joe

Go to forum: Accounts Receivable

3,165 Reply by joe

(5 replies, posted in Dimensions)

The balances are filled automatically from the GL entries (with the appropriate dimension(s)).

/Joe.

Go to forum: Dimensions

3,166 Reply by joe

(1 replies, posted in Items and Inventory)

I am not sure if I understand you correctly, but I will explain what happens during your run.

Initial:
marker ring 100 (have to be a positive value more than 5)
marker ringx5 0

After workorder of 1 item:

marker ring 95
marker ringx5 1

Sales order of 1 marker ringx5

Nothing changes on stock moves (only on demand in status)

Delivery of 1 marker ringx5

marker ring 95
marker ringx5 0

The invoicing doesn't change anything in stock.

/Joe

Go to forum: Items and Inventory

3,167 Reply by joe

(2 replies, posted in Accounts Payable)

Hey there, I think you missed the Quick Entries. Please read about them in the Wiki, https://frontaccounting.com/fawiki .

/Joe

Go to forum: Accounts Payable

3,168 Reply by joe

(2 replies, posted in Setup)

Which Chart of Account script have you been used when setting up your company?

I cannot reproduce this on en_US-new.sql script.

/Joe

Go to forum: Setup

3,169 Reply by joe

(8 replies, posted in Accounts Receivable)

If this is of importance to you, you can do a manuel journal entry for this. This is mostly of minor values and your invoice still have the values as indicating on the invoice.

/Joe

Go to forum: Accounts Receivable

3,170 Reply by joe

(12 replies, posted in Accounts Receivable)

Hello Jujuk,

The problem was NOT solved in release 2.3.4. But is solved in the HG repository. I have sent you the file /sales/includes/cart_class.inc directly by mail.

/Joe

Go to forum: Accounts Receivable

3,171 Reply by joe

(1 replies, posted in Accounts Payable)

You can use the memo/comments field on the PO for the information to the supplier.

And use the memo field when doing the supplier payment (without any allocations yet).

And then use this payment for allocation (down payment) on the supp invoice.

/Joe

Go to forum: Accounts Payable

3,172 Reply by joe

(12 replies, posted in Accounts Receivable)

I have asked Janusz to fix the demo.

/Joe

Go to forum: Accounts Receivable

3,173 Reply by joe

(12 replies, posted in Accounts Receivable)

This didn't got fixed before the 2.3.4. release but the fix is at the HG repository at sourceforge. It will go into 2.3.4 release.

/Joe

Go to forum: Accounts Receivable

3,174 Reply by joe

(5 replies, posted in Report Bugs here)

Hello again,

Please uncheck the Search Lists in company setup. These marks should only be set if you have many customers/suppliers/items.
Now you will see your records.

If you wonder how the search lists works, you can look in our central wiki, https://frontaccounting.com/fawiki.

/Joe

Go to forum: Report Bugs here

3,175 Reply by joe

(11 replies, posted in Manufactoring)

1. Yes you can. But the effect will first take place after change. There are no backward regulations. Former productions are as they were.

2. Again the change of BOM items will change the avg. cost for future productions.

3. If you are having trouble with something, there is always a last call to manuel Journal Entry.

/Joe

Go to forum: Manufactoring