201 Reply by boxygen

(28 replies, posted in Items and Inventory)

Hello @popsicles12

It is very important to know for all of us that why and when the standard cost of an item changes. FA tries to keep the weighted average of the material cost so that the Inventory Valuation reflecting in Trial Balance shall be same as that of in the Inventory Valuation Report.

FA does this by calling update_average_material_cost function from 5 different places in FA.

1. When a Stock Movement is Voided. Even if Location Transfer is Voided. (As per my understanding on Location Transfer Void this function shall not be called because Location Transfer doesn't affect the overall cost of the Item in FA)

2. When Stock Adjustment is Done either positive or negative if the Cost of Adjustment is manually changed to differ from the existing standard cost.

3. When the GRN of Item is recorded.

4. When a Purchased Item is Returned to Supplier

5. When the Direct Supplier Invoice is Recorded.

You can search the said function in FA to find out its location.

You can create a New instance of FA and do random operations to find out the change in Standard Cost and Log it to find out the behaviour of FA.

Q#3: You can do manual feeding of Standard Cost if you totally disable the call of this function in FA.

please go through this post https://frontaccounting.com/punbb/viewtopic.php?id=8157

You can also go through this post https://frontaccounting.com/punbb/viewtopic.php?id=8184

You can go through this post https://frontaccounting.com/punbb/viewtopic.php?id=8238

These problems were discussed in detail earlier.

We are hoping that in FA 2.5 these problems will be handled properly.

Go to forum: Items and Inventory

202 Reply by boxygen

(4 replies, posted in Accounts Receivable)

Change the Price List to Wholesale on this document and then add Line items

Go to forum: Accounts Receivable

203 Reply by boxygen

(15 replies, posted in Reporting)

@joe, @barbarian has already done some work available in github for upgrading reporting folder with latest TCPDF. You can check that

https://frontaccounting.com/punbb/viewtopic.php?id=8216

Go to forum: Reporting

204 Reply by boxygen

(12 replies, posted in Accounts Receivable)

The problem is that when same window is opened at two different computers then the next available reference is picked by the system which is same for both users.

Whoever lucky to process earlier will be through but later will see this message due to same reference usage.

In order to overcome this you need to do some changes is core references.inc

The function is_new_reference() shall be customized to return the newest reference irrespective of reference number on the form being picked by system

Go to forum: Accounts Receivable

205 Reply by boxygen

(8 replies, posted in Report Bugs here)

Try using this module FA SMTP Mailer

Go to forum: Report Bugs here

206 Reply by boxygen

(5 replies, posted in FA Modifications)

@naeem you may need to edit purchasing/includes/ui/po_ui.inc and grn_ui.inc and some other core files to get it working.

Go to forum: FA Modifications

207 Reply by boxygen

(9 replies, posted in Banking and General Ledger)

@joe, which module. I couldn't locate

Go to forum: Banking and General Ledger

208 Reply by boxygen

(1 replies, posted in Reporting)

Actually dimension is not mandatory in all transactions that hit customer balances. specially Customer Payments has no option of Dimensions selection.

So I think your desired report needs alot of changes in the core.

Go to forum: Reporting

209 Reply by boxygen

(2 replies, posted in Reporting)

Thanks, got it

Go to forum: Reporting

210 Topic by boxygen

(2 replies, posted in Reporting)

Hello,

Can anyone help me to know the option to control the retention of PDF reports in company/x/pdf_files folder. I can see that such report files are removed after sometimes. Which option is controlling this?

Go to forum: Reporting

211 Reply by boxygen

(21 replies, posted in Wish List)

Thanks my pleasure. Looking forward to your findings

Go to forum: Wish List

212 Reply by boxygen

(21 replies, posted in Wish List)

Ok now if Invoice is digested for the time being lets discuss Purchases.

Practically and Logically if a Manufacturer (ABC) sells a Candy to a Non Registered Retailer (Xehroz) @ Rs. 70 then then invoice shall reflect as below

Inventory                  70
       GRN Account                      70


GRN Account            70
17% Tax                  11.9
3%   AT                    2.1
2%   ET                    1.4
            Payable                          85.40

But What I am understanding that even the ABC Supplier is Invoicing at 70, but he is applying All Taxes on MRP i.e. 100. Is that Right? as below

Inventory                  70
       GRN Account                      70


GRN Account            70
17% Tax                  17
3%   AT                    3
2%   ET                    2
            Payable                          92


IN that case wouldn't your Input Tax will always be Equal to Output Tax? If true, then is it necessary to do all this accounting of Taxes as Retailer? Simply you can record all your purchases @ 92 and record all your sales @ 122 and your Rs. 30 Profit will be there and you have no Tax Liabilities. Any way I raised this point just to understand your need to Record all taxes.


Now lets come to your problem. If any way you need to record all Purchase Taxes on MRP then we will have to modify FA Purchases to link it to the MRP. MRP can be defined as a Sales Type Retail in FA and can be used for calculating Tax Purchases.

It will have no Adverse impact on Input and Output Tax working. It will show something like THIS

Go to forum: Wish List

213 Reply by boxygen

(21 replies, posted in Wish List)

My previous solution is self explanatory depending on your statement that you want to setup this for Retailer.

Retailer shall always sell the product on MRP. 100 was taken for simplicity. It can be any number but it shall be MRP.

And your all taxes apply on MRP.

As a retailer the case will be very similar to Registered Buyer invoice for candy and non candy.

And this solution is without any hack.

Go to forum: Wish List

214 Reply by boxygen

(21 replies, posted in Wish List)

Yes, this is achievable if the Price Before Tax is set to 100 PKR and Resulting Net Price to the Buyer is calculated as a discount say 15% of MRP = 85 PKR.

A little modification in the Invoice Write() function to link the Tax Calculations to MRP instead of Resulting Net Price can achieve this.

Go to forum: Wish List

215 Reply by boxygen

(21 replies, posted in Wish List)

Case 1: Non Registered Buyer with Candy

Case 2: Non Registered Non Candy

Case 3: Registered Buyer with Candy

Case 4: Registered Buyer with Non Candy


Is this exactly what you want?

Go to forum: Wish List

216 Reply by boxygen

(21 replies, posted in Wish List)

xehroz wrote:

First situation
The Manufacturer sell this to it's registered customer (In this step to a Retailer) at following rate
90+17+2=109
90 Goes into COGS account for that product
17 goes to Sales Tax Account for that product (this can be passed on / Claimable)
2 goes to "Extra Tax" account for that product (this can also be passed on further to next customer  / Claimable)

Question # 1: Are we trying to setup this Tax System for the Manufacturer or Distributor or Retailer? I am assuming we are doing this for Manufacturer.

Understanding # 1: MRP = 100 and all Taxes are being applied on MRP on each intermediary selling steps (irrespective of the selling price at each step ** ) till it reach End Consumer. Right?

** for e.g. This Candy's Manufactured Cost could be 70. It was the sold to the Retailer at 90 but the taxes are applied keeping MRP as a base.

Objection # 1: If Manufacturer is selling at 90+17+2 then 90 Can be the Purchase Price of Retailer but it can't be the COGS for Manufacturer. The COGS can be 70 as mentioned above.


xehroz wrote:

Second situation
The Manufacturer sell this to it's Un-registered customer (In this step to a Retailer) at following rate
90+17+3+2=112
90 Goes into COGS account for that product
17 goes to Sales Tax Account for that product (this can be passed on  / Claimable)
3 goes to "Additional Sales Tax" for that product (THIS CAN-NOT BE PASSED ON FURTHER / non-claimable)
2 goes to "Extra Tax" account for that product (this can also be passed on further to next customer / Claimable)

This situation is similar accept the Retailer is Unregistered so he is penalized extra 3%. This 3% is an Output Tax for Manufacturer but Not an Input Tax for the Retailer.

Extra Tax 2% is related directly to the Item Type not the Buyer Type.

Let us first digest the Sales Side then we will discuss the procurement side.

Comment: Normally in Distribution Setup Where MRP is always the Base, the Selling Price to Retailer is also defined as a discounted MRP price. But you didn't mentioned that. If this is possible then it will be much easier to implement this within the current Tax System of FA with small modification.

You didn't mentioned the Fixed Value Rate handling mentioned in This Doc

I have create an online sheet. Please check Click Here

Go to forum: Wish List

217 Reply by boxygen

(21 replies, posted in Wish List)

@xehroz, I didn't went through your documents before my first post. Now I have read in detail. The case you are referring here is mostly FMCG products distribution setup. Unfortunately I didn't come across such situation because majority of my clients are service based.

But this is quite interesting and I would like to understand it first. Based on your two documents can you please state some examples with Basic values for each type of Item category and tax category. I want to see the complex formulae that are being applied in any single case.

for e.g. Item A Cost = 90, MRP is 100, Tax is 17%, Additional is 3%, Extra is 2% then What GL Transactions shall be recorded when this Item is sold and What OutPut Tax accounts are Credited.

Also the impact of Item A for each type of Registered, Unregistered and End Consumer.

If Item A is defined to be confectionary item then it will always be added 2%?

Go to forum: Wish List

218 Reply by boxygen

(21 replies, posted in Wish List)

Hello @xehroz, I have implemented FA in more than 50 companies in Pakistan. You can send me email or call me to discuss your issue. Once settled we will post here so that others can be benefitted.

Go to forum: Wish List

219 Reply by boxygen

(6 replies, posted in Accounts Receivable)

Yes, exactly. I am using this feature.

Go to forum: Accounts Receivable

220 Reply by boxygen

(13 replies, posted in Report Bugs here)

@Braath, you are right. I think this shall be addressed in the next major release.

Go to forum: Report Bugs here

221 Reply by boxygen

(13 replies, posted in Report Bugs here)

In my case the hosting server is Linux but client accessing from windows.

Do I still need to set the above mentioned Syspref variable to 1?

Go to forum: Report Bugs here

222 Reply by boxygen

(13 replies, posted in Report Bugs here)

I am also being reported by one of my client and conditions are same as above.

This edit session has been abandoned by opening sales document in another browser tab. You cannot edit more than one sales document at once."

But the problem is that this doesn't always occur so I am still unable to find the reason

Go to forum: Report Bugs here

223 Reply by boxygen

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

I want to modify this api module to execute Recurring Invoices automatically through a cron call. Is it workable idea? If yes then can you guide me over this?

Go to forum: Modules Add-on's

224 Topic by boxygen

(1 replies, posted in Development)

As a developer it is very important to follow the Coding Standards. Atom provides a very easy built in system after installing this Package.

Once installed in windows with XAMPP in the settings set values as below.

PHP executable path: c:\xampp\php\php.exe

PHP-CS-fixer executable path: [path_to_atom]\.atom\packages\php-cs-fixer\php-cs-fixer-v2.phar

You need to download php-cs-fixer-v2.phar file from here in the above path.

Enjoy...

Go to forum: Development

225 Reply by boxygen

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

@apmuthu I tested this api.

ON https://frontaccounting.com/fawiki/index.php?n=Devel.SimpleAPIModule?action=browse

fabridge.php shall have following commit

$headers[] = "X_company: "  . COMPANY_NO;
$headers[] = "X_user: "     . REST_USER;
$headers[] = "X_password: " . REST_PWD;

shall be changed to

$headers[] = "X-COMPANY: "  . COMPANY_NO;
$headers[] = "X-USER: "     . REST_USER;
$headers[] = "X-PASSWORD: " . REST_PWD;

to comply it with util.php

Go to forum: Modules Add-on's