Normally our sales invoice handles the  shipping expense, along with its tax , right. ?

Receivables     50
Sales                               40
Shipping                          10

Here it connects the shipping expense inputted here 10.

Am i wrong ?.

152

(5 replies, posted in Banking and General Ledger)

Bank payment and deposit automatically makes journal entry. You can simply input the respective GL account with amount.

Suppose if i have only one location for my business. how do i add fixed assets location. ?

I need to create separate location for fixed assets. but actually its not original, As i need to use the same location that i have.

And also the category.

you are right. but we can do this partially and run the remaining stocks depreciation after sales.

is it not ok. ?

From fixed assets inquiry page, we have a purchased column with link, thats giving wrong trans_no.

get_fixed_asset_purchase  function get invoice now, how do we link the invoice trans no in place of  GRN  trans no.

function purchase_link($row)
{

      if ($row['purchase_date'] === NULL)
        return "";

      return get_supplier_trans_view_str(ST_SUPPRECEIVE, $row["purchase_no"], sql2date($row["purchase_date"]));
}

Here the $row['purchase_no'] has not exist. 

function purchase_link($row)
{

      if ($row['purchase_date'] === NULL)
        return "";
      //my suggestion would be something like this to get GRN now.
       $sql ="SELECT trans_no FROM ".TB_PREF."stock_moves WHERE 1=1 AND type =".ST_SUPPRECEIVE." AND stock_id =".db_escape($row['stock_id'])." AND qty > '0' ";
      $res = db_query($sql, "Can't get grn no");
       $row2=db_fetch($res);

     return get_supplier_trans_view_str(ST_SUPPRECEIVE, $rows["trans_no"], sql2date($row["purchase_date"]));
}

@Joe, check it.  otherwise we need to connect the invoice, instead of the GRN in purchase link.

and also i see, we can try the depreciation start with the date given from fixed assets input date. i dont know the reason why we are using every month start date.

this is perfect example dude. looks good to have it for drop down purpose.

157

(2 replies, posted in Accounts Receivable)

During Customer payment, as you can see a textbox stated charges, just input the 10 usd there. the system will put that 10 usd in the Interest and bank charges account.

So your journal entry will be like this.
AR                                350
interest and bank charges  10
Bank                                               360

Hope this helps you.

i feel, we can allow quantity as well as perform the depreciation based on per unit. so we can calculate the depreciation for one item and multiply with quantity.

and also for your existing fixed assets. we need to make the purchase invoice in its appropriate date. after that you can input the depreciation start date in that date. and than you can process depreciation from the date of purchase to till. in a journal entry. Hope that will help you to perform the material cost updated and cost variance also updated. later you can process the future value,

for future value also we need cron based automatic depreciation. so that we can avoid missing of making depreciation in time.

you are right.  but the parent has no use here i guess. it was simply kept there. but never used anywhere in the system.,

Suppose if i buy 20 laptops or computers in a same brand and same config. How do i add it in fixed assets?

each time should i need to create separate fixed asset and do the purchase and make the depreciation?

How about buying of 50 computers. or 100 Computers. ?

As i am trying out with Fixed assets, and came to know what is the use of parent class id in the fixed assets class.

I feel it was not used anywhere from the depreciation to the entire system.

162

(7 replies, posted in Fixed Assets)

kvvaradha wrote:

Looks like the input_num function issue.

@joe Update this on fixed_asset_classes.php

$input_error = 0;
if(input_num('depreciation_rate') > 100){
    display_error(_("The depreciation rate can't be greater than 100%"));
    $input_error = 1;
}

and also in the update_fixed_asset_class,add_fixed_asset_class last parameter change it to input_num from $_POST.

The issue is something connected with php level. 

Php normally using the floating values with huge decimals. Which causes unexpected values in sometime. 

During the average cost calculation it happens.  Afrer that the price goes either on positive or negative.  But it goes abnormally.

164

(7 replies, posted in Fixed Assets)

Looks like the input_num function issue.

165

(2 replies, posted in Setup)

If you are asking about the paid module.  Ask the respective seller. As of now. FA doesn't have elaborate POS in it. You can see point of sale connectivity with salesman and inventory location

166

(5 replies, posted in Items and Inventory)

You have made payment for it. So goto the customer allocations with respective payment transaction no. And unallocate the invoice  and do it again. It will work for you.

167

(5 replies, posted in Items and Inventory)

First of all you need to know the procedure.  As you are crediting an invoice, you need to start from that invoice and credit the respective item it's stock ( from customer transaction inquiry  filter the type to show sales invoice.  From there you  can the credit this invoice icon. With help of it. You can credit that invoice..

While crediting the invoice you can choose thw item returned to stock if the items are ok.
And regarding payment. If you credit from invoice that will automatically change the customer payment and allocate the credit note with that.

Or you can reallocate it manually  from customer allocations page.

Hope this explains to your problem

jwbosch wrote:
advocaat.pollet wrote:

I had the same problem en changed the '%d' by '%s'.

F.

Thanks, that does the trick

@joe  update it on core

This is reference number queried in debtor_trans table. 

Type =10 and trans_no = invoice no .

It might be connected with get_customer_trans function.  Which will help you to get the reference and pass it to invoice. 

Try enable pdf debug from config.php

And use display error function to check whether the reference passed properly

170

(1 replies, posted in Reporting)

Hope you customized the invoice. Speak with the new developer and make it aligned.

171

(4 replies, posted in Wish List)

cowlas wrote:

How to set the header on the Sales Invoice because its alingnment is out from the top of the page. Please guide possible with the images or steps so i can adjust it accordingly.

How are you cowlas?

This is actually not clear. Are you looking view_invoice.php

Or rep107.php header2.inc and doctext.inc

Hope you have the dual header options that we  done last time.

172

(4 replies, posted in Wish List)

fcarll wrote:

It would be helpful to be able to allow FA to auto increment the item code when adding new items. 

I am switching from an accounting system that auto populated the item code. 

Researching the forum showed that the issue was raised in 2017 but I cannot find any further reference.

Regards, Frank Carll

Hope the core doesn't have this feature. You need to create constant in types.in and use it inside the sysnames.inc and update it on transactions_db.inc. after that you can see the item in transaction references.

Create one there with your desired format and customize the items.php and get next reference will help you to make it auto increment on item codes.

Looks like during your FA installation there might be permissions issue to create installed_languages.inc file. Which leads to this problem.  Create it manually.

<?php

/* How to make new entries here for non-packaged languages:

-- 'code' should match the name of the directory for the language under \lang
.-- 'name' is the name that will be displayed in the language selection list (in Users and Display Setup)
-- 'rtl' only needs to be set for right-to-left languages like Arabic and Hebrew
-- 'encoding' used in translation file
-- 'version' always set to '' for manually installed languages.
-- 'path' installation path related to FA root (e.g. 'lang/en_US').
*/


$installed_languages = array (
  0 => 
  array (
    'code' => 'C',
    'name' => 'English',
    'encoding' => 'iso-8859-1',
  ),
);
$dflt_lang = 'C';

Which is not available as of now.  FA  has very basic functionality with salesman. If you are looking full cover module  you need to make it as separate module and connect it.

Sales executive needs to be created as separate module to manage their payouts and balances and also enhanced version of handling the provision points. 

Even there is a flaw in salesman concept. Which is not fixed in the module. As of now the salesman works like  customer level. But we need to work on per transaction.