Search options (Page 32 of 200)

An addendum to my former post!

1. Advanced Manufacturing.
If you make several productions or adding extra costs to a Work Order, the work in progress will be visible in the balance sheet.

When the closing productions has been done the work in progress is transferred from works in progress to finished goods.

From the Release status to Production you will see the demand of BoM items in the Item Status together with other demands as sales orders.

Joe

@alaa

I cannot reproduce any errors in rep201. Could you be more specific and detailed.

Specific trans types? Or?

Joe

@boxygen
I am terrible sorry that I did not accept your change in the SQL sentences in rep110. It turns out that you were right in changing it.
The 3.rd SQL sentence regarding the open balance allocation, it should also be changed accordingly.
The 4.th SQL sentence seems to be ok as is.

I am attaching the corrected file, rep101.php1. Please download and rename it to rep101.php and update your reporting folder.

Please test it and tell me if this is ok. I will then commit it and change rep201.php in the same way.

Joe

@apmuthu.
As I wrote, if a credit note is made after a payment has been used for allocation the credit note is taken over the allocation, leaving the original Customer Payment open for other allocations.

@boxygen
A Bank Payment will show up in the Customer Balance. No problems with that. If the Bank Payment is not allocated with an existing Customer Payment, you can see that in the rep101.

Joe

Hello Guys.

No we are not combining Customers and Suppliers even if they are the same legal entity.

However I understand @boxygens post. It will arise if the following condition has happened:

1. Sales Invoice is sent for products.
2. Sales Invoice is paid by Customer.
3. Customer is returning Items to us for some reason and the items are ok.
4. Credit Note is sent to Customer.
5. Bank Payment is sent to Customer as Compensation for returned Items.

This no. 5 has to be taken care of in the system.

So we must fix this.
I guess we have a similar condition on the Supplier side.

Joe

You can close a date for further entries.
You are free to define your own periods so to speak. There are no periods in FA but many reports are on a monthly selected base. You can change if desired.

Joe

Hello,

Oh yes, they are saved. Just press the Get button after you have selected the Fiscal Year and Account / Dimension.

/Joe

Will have a look later. Maybe we should address this to Janusz.

Joe

Sure, you can edit the PO and set the number to be the same as the received items. And it will NOT show up in the Outstanding Orders to Receive any more.

/Joe

Ah, now I see the problem. Of course it gives weird results using the move.stock_id value instead of move.qty

Will be fixed asap and committed to 2.4. repo. Thanks for observing this.

/Joe

Committed

This has been committed to 2.4 official repo.

/Joe

Ok, Guys. This has been committed with zero decimals in the amounts. I think it is better not to have too much digits when you shall overview the report.

/Joe