Search options

I'm into it for a week to find out how to process a proper purchase from a foreign supplier along with local expenses, and I have found a solution that looks well to me, but I want to share it with you people to know how it is.

While making a purchase, we go through the process (Purchase Order > Good Receiving Note > Purchase Invoice > Payment Allocation), and after the purchase process the General Ledger looks like this:

General Ledger Transaction
Account Name      |   Debit   |   Credit   
Supplier Payable                       5000
Insurance Exp           500
Tax Exp                      300
Freight                       200
GR Clearing Acc         4000

Total                           5000        5000

The expenses are paid by us and in Home Currency, but in the above transaction, the total is credited into Supplier's Payable account.

The Solution
What if we make a payable account of all expenses above and credit the same amount in them, and Debit the total of Supplier Payable and others in Good Received Cleaning Account.

General Ledger Transaction
Account Name      |   Debit   |   Credit   
Supplier Payable                       4000
Insurance Payable                    500
Tax Payable                               300
Freight Payable                         200
GR Clearing Acc         5000

Total                           5000        5000

This way we will also get so-called Landed Cost debited into Good Received Clearing Account and we will have our local payable expenses separated from supplier payable. BUT While testing the above method, and creating all expenses payable account, the transaction is still being debited and I believe all GL Items "no matter what account I choose" will be debited, so we need to change the functionality.

My Do
I've disabled the GL Items in Purchase Invoice and Supplier Credit Note and making another function in Purchase section where I will get invoices and load local payable expenses, and add total value into Good Received Clearing Account of that invoice, which will solve our problem.

Currently, I've having hurdles as I'm a newbie in PHP and there is no documentation for Purchase section, so any help will be appreciable.

Hello everyone,
It's a beginner in the PHP world, and I'm trying to discover how FrontAccounting is working. I didn't find any Starting Guide for Developer which is making it a bit hard for me to make changes in FrontAccounting Core System.

I've been given the task to create an extension for Sales Projection where our Sales Officer will show his projection on sales in his area. The extension will have his own separate tables to save the projection but it can get sales from current tables to match the projection and show the difference.

I also would like to make the changes in the core system of FronAccounting Purchase tab, to prevent it from adding GL Items into Supplier Total, instead, we want it to save the transaction in its respective General Ledger in Home Currency because those GL Items (in other words, Further Expenses) are from purchasing company.

I've succeeded in preventing it adding GL Items total into Supplier Invoice Total, but AJAX event on the current invoice page is still adding the GL total in Invoice total...

I don't find any forum for this topic so posting it here.

Regards