1,451 Reply by joe

(45 replies, posted in Report Bugs here)

I Think I have found a solution to the manuel change of standard cost.
If a change is made to the item, then when saving the cost update, the stock_moves get the standard_cost updated for the difference and where the stock moves are <= the date.
This should eliminate the difference from the IVR and the GL when taken Before todays date.

I will upload three files here when fixing this and please download the files and help me testing this. The files will be /inventory/includes/db/items_trans_db.inc, /reporting rep301.php and &/reporting rep308.php.

Especially Apmuthu and MarkAndrew.

Thanks in advance.

/Joe

Go to forum: Report Bugs here

1,452 Reply by joe

(1 replies, posted in FA Modifications)

The transactions are in the table X_gl_trans, where X is your Company number.

/Joe

Go to forum: FA Modifications

1,453 Reply by joe

(45 replies, posted in Report Bugs here)

Well, the problem here is that you are allowed to change the standard costs at any time, which changes the GL as well, but does not change anything in the stock moves.
This will give an incorrect value in the IVR compared to the GL if taken before todays date and the standard cost has been changed manuelly.

The CIVR should give the correct costed value over all periods. If not, please download the final file here. However if you have changed the standard cost manuelly, it will show an incorrect value.

/joe

Go to forum: Report Bugs here

1,454 Reply by joe

(45 replies, posted in Report Bugs here)

Maybe we should take away the date selector from Inventory valuation Report, and force users to use the Costed Inventory valuation Report for selecting periods. What do you say guys?

Joe

Go to forum: Report Bugs here

1,455 Reply by joe

(4 replies, posted in Accounts Receivable)

When you use the delivery from sales order, you can deliver parts of the sales order.

Joe

Go to forum: Accounts Receivable

1,456 Reply by joe

(45 replies, posted in Report Bugs here)

But you can use the costed invnetory valuation report, right?

Are you saying, that this report should work just like the costed inventory report?

I am not sure if this is right. Somebody in the audience has earlier asked for the change as it is now.

Joe

Go to forum: Report Bugs here

1,457 Reply by joe

(7 replies, posted in Manufactoring)

One item on each Work Order.

No, you will have to initiate the work order yourself.

Joe

Go to forum: Manufactoring

1,458 Reply by joe

(13 replies, posted in Modules Add-on's)

Please Contact the author of the extension. You will find hes email, if you click on the extension name in 'Install / Activate Extensions'.

/Joe

Go to forum: Modules Add-on's

1,459 Reply by joe

(5 replies, posted in Installation)

There is a video link here:

I will have a chat with Janusz about this.

/Joe

Go to forum: Installation

1,460 Reply by joe

(13 replies, posted in Modules Add-on's)

Look into Access Setup and see if it is cheched for you user role.

/joe

Go to forum: Modules Add-on's

1,461 Reply by joe

(1 replies, posted in Items and Inventory)

I would use simple assembly in the Manufacturing tab, for the box with 12 units. This will make it easy to keep everything updated automatically.

Please use a Training Co. To test on. This way you will get a feeling of how to use it practically.

Joe

Go to forum: Items and Inventory

1,462 Reply by joe

(4 replies, posted in Accounts Receivable)

When you allocate the customer deposit on the left $300 you should select the bank payment to be allocated for this record. Then everything will be ok.

Joe

Go to forum: Accounts Receivable

1,463 Reply by joe

(2 replies, posted in Report Bugs here)

It seems that your MySql has been upgrading to a version that do not support the mysql_ routines.
Please try to downgrade the mysql version.

The actual version is first supported in FA release 2.4.

Joe

Go to forum: Report Bugs here

1,464 Reply by joe

(6 replies, posted in Installation)

Glad that it helped wink

Joe

Go to forum: Installation

1,465 Reply by joe

(6 replies, posted in Installation)

Check that the sales type you use doesn't have the tax included marked.

Joe

Go to forum: Installation

1,466 Reply by joe

(6 replies, posted in Installation)

If the tax is included in your prices, then the tax amount is not shown in the 'right' column, because it is already added.

/Joe

Go to forum: Installation

1,467 Reply by joe

(2 replies, posted in Accounts Receivable)

This is not possible, but you can just ignore it, if you don't need it.

Joe

Go to forum: Accounts Receivable

1,468 Reply by joe

(10 replies, posted in Report Bugs here)

You. Should not elaborate between allow and disallow negative stock. It will cause troubles.

Joe

Go to forum: Report Bugs here

1,469 Reply by joe

(2 replies, posted in Items and Inventory)

You can change in report rep308.php. Instead of the decimals in AmountCol (the last parameter) you can hardcode it to 2.

Joe

Go to forum: Items and Inventory

1,470 Reply by joe

(4 replies, posted in Announcements)

I don't think so. Maybe Janusz knows more.

Joe

Go to forum: Announcements

1,471 Reply by joe

(6 replies, posted in Setup)

Consider using dimension/account tags for the dimensions that exceed two.

Joe

Go to forum: Setup

1,472 Reply by joe

(5 replies, posted in Report Bugs here)

Hello again MarkAndrew,

Yes, it looks like we can improve this costed inventory valuation report.

Will you download the file rep308.php1 and rename it to rep308.php and replace it in /reporting folder. Please test with various scenarious and tell me if this is better. Thanks in advance.

/Joe

Go to forum: Report Bugs here

1,473 Reply by joe

(10 replies, posted in Report Bugs here)

This has now been fixed. The HG repository has been updated and the fix will go to next minor release.

You can download a fixed file here .

/Joe

Go to forum: Report Bugs here

1,474 Reply by joe

(10 replies, posted in Report Bugs here)

Seems to be some problems during voiding. Will have a look at this.

/Joe

Go to forum: Report Bugs here

1,475 Reply by joe

(5 replies, posted in Report Bugs here)

FA is using the average material cost when calculating the cost prices.

The item cost price can be manuelly adjusted in the Items and Inventory tab. These Changes will not affect the stock movements and therefore will show the wrong results when using the stock movement cost prices.

This is the fact for report:

Inventory Valuation report,

The reports, Inventory Sales Report, GRN Valuation report, Inventory Purchasing report, Costed Inventory Movements, Inventory Sales report shows the correct cost price values for the stock movements.

/Joe

Go to forum: Report Bugs here