Topic: new report

i need report contain filteration credit customer by sales man ?
how this

Re: new report

State which report (Navigation sequence / repXXX.php number) that you want customised.

Re: new report

rep101 need add combobox filteration by saleman
how ?

Re: new report

A salesman is allotted to each customer branch. All sales to that customer branch will be under the specified salesman's log for commission / reporting purposes. If a sales order / invoice is made out to a customer's branch, the salesman can be looked up.

Report 101 does not have any salesman's column at all. The sql that generates the transaction list for the report is from lines 74 to 88 in the rep101.php - you can choose to link the cust_branch table in to filter the salesman you want.

Re: new report

you can try this small extension

Customer Balances

www.boxygen.pk

Re: new report

The updated extension is attached with whitespace synch with rep101.php and all CRLF converted to LF line endings.

Added to the FA24extensions repo.

Post's attachments

rep_customer_ledger.zip 5.9 kb, 10 downloads since 2017-12-21 

You don't have the permssions to download the attachments of this post.

Re: new report

please how to install in version 2.4
explain plz

thanks

Re: new report

Unzip into modules folder and a subfolder called rep_customer_ledger will get created. Now in your default company (generally company #0) go to Setup => Install/Update Extensions and "Install" the extension rep_customer_ledger. Then in the top dropdown box, choose Activate for target company and tick checkbox there. Logout and now login to your target company. Read the wiki.

Re: new report

Package 'rep_customer_ledger' is incompatible with current application version and cannot be activated. Check Install/Activate page for newer package version.


this is erorr msg

Re: new report

This error comes since you are not using the FA 2.4.3+ master. This error has since been fixed in the repo. Last week's commit and the update 3 days ago fixed it.

The zip of changed files from the release are available in this post.

Re: new report

i need in Sales Area choose all places in combobox
how this ?

Thanks

Re: new report

Do not choose to select any Sales Area - then all Sales Areas will be selected - that is for no filter on Sales Areas.

Re: new report

Not available to choose all places. Must choose one place only.

Re: new report

Which report are you referring to?

Re: new report

Customer Ledger

Re: new report

This requires changes to the core FA attached.
The modified report extension is available from here.

@joe: please commit the attachment for making the Areas Filter on reports have an "No Areas Filter" option in the dropdown box.

Post's attachments

AreasFilter.zip 39.6 kb, 2 downloads since 2017-12-23 

You don't have the permssions to download the attachments of this post.

Re: new report

where add this files ?

Re: new report

The extension file must overwrite the one in the modules/rep_customer_ledger folder.
The files in the core will have to be replaced from the "altered" folder in the file attached in my previous post.

Re: new report

file original and file .diff  where add ?

Re: new report

The "original" if for the devs to compare. The ".diff" is for the devs to patch the repo. Only the "altered" is for your install.

Re: new report

Thank you very much
i open new post need config POS web system  how
Thanks

Re: new report

@apmuthu, ref. post 16.

Files committed.

/Joe