1 Reply by synctwok

(6 replies, posted in Banking and General Ledger)

Hi Joe,

Thanks for your reply.

After days of searching, we finally found a solution to this. It was simple, we reinstalled the system and configured the services-based category to credit COGS instead of Inventory. And everything worked fine after that.

I would suggest you take a look at the SQL script (en_US-new.sql) for creating the database for the Items category. The services category is currently set to credit Inventory by default at line 1337 in the script.

Thanks.

Go to forum: Banking and General Ledger

2 Reply by synctwok

(6 replies, posted in Banking and General Ledger)

Hi Joe,

Just for your further information, I simulated the issue under "Testing Co" and there was no problem. It debits and credits COGS accordingly but when I create a new company with new service-based items, it debits COGS and credits Inventory.

Question: Is there a way to configure service-based items to debit and credit COGS?

Go to forum: Banking and General Ledger

3 Reply by synctwok

(6 replies, posted in Banking and General Ledger)

Hi Joe,

Thank you for your reply.

Yes, I can confirm that I have configured the service item under the "Services" category and also set the item type as "Service".

I simulated the issue under a newly installed system and this is what I did to re-produce the same issue:

1. Add a service-based item called "Test" with item code "01" and categorize it in the "Services" category and set the the item type as "Service"
2. Purchase the service-based item "01 - Test" from a supplier under the Purchases module
3. Sell the service-based item "01 - Test" to a customer under the Sales Module
4. Check the GL and the result is, there is a double COGS entry

I am using FA 2.2.11 under Windows, PHP 5.2.6 and MySQL

Thanks.

Go to forum: Banking and General Ledger

4 Topic by synctwok

(6 replies, posted in Banking and General Ledger)

Hi all,

I hope I am posting this in the correct thread.

Basically, I am having an issue where my COGS is double than the original amount.

If you refer to the picture at http://img441.imageshack.us/img441/8537/47951673.jpg, you will notice that I had made a purchase for a service-based item from Supplier BEA for the sum of 1113.42 which subsequently debits the COGS and credits the AP. These transactions are referred to under Supplier Invoice #2.

Now here comes the issue, when I actually sell back the same service-based item to Customer FLE for the same sum, 1113.42, the system subsequently debits the COGS account again which therefore doubles the overall COGS amount. These transactions are referred to under Delivery Note #1.

This has resulted in incorrect figures being recorded in the P&L statement where the expected COGS should only be 1113.42 instead of 2226.84. I hope you understand what I mean with this and would appreciate any sort of advise given to help to resolve this issue.

Thanking you in advance for any help rendered.

Go to forum: Banking and General Ledger