Under the Salesman, in Sales tab, you can set the salesman to 0%. Breakpoint 1000 and then 1%. Further operations are not possible.

If you want more sophisticated sales reports you can select the Excel as destination and use columns for further calculations.

/Joe

The script file en_US-new.sql is empty for transactions. Only the Chart of Accounts and a couple of managed records, that are easily changed.

I don't know why your script-file is filled with transactions. Are you sure you didn't use the en_US-demo.sql, whitch is meant as a training script?

/Joe

3,153

(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

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

3,155

(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

3,156

(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

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

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

/Joe

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

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

3,161

(8 replies, posted in Accounts Receivable)

Yes you can handle these transactions in one Journal extry.

/Joe

3,162

(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

3,163

(8 replies, posted in Accounts Receivable)

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

/Joe

Thanks tclim,

I will upload it to the central repository.

/Joe

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

/Joe

3,166

(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

3,167

(5 replies, posted in Dimensions)

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

/Joe.

3,168

(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

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

/Joe

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

3,171

(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

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

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

I have asked Janusz to fix the demo.

/Joe

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