• From: Bahrain, Manama
  • Registered: 09/19/2011
  • Posts: 29

Topic: journal inquiry error

in the journal inquiry all my Delivery Note are base on the purchase prices not on the the customer selling price ,when i go to Trans and see the right the right amount from the order is there



also i see that some times the journal inquiry amounts are doubles i restore the backup and it becomes ok and some time just refreshing the page work



is any one having the same problem

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: journal inquiry error

For deliveries in journal entries, the JE transactions are based on the purchase price. The purchase is credited the Inventory Account and debited the COGS Account. Just as it should. The Invoice JE transactions take care of the Sales amounts etc.

Make sure you have the last release regarding the double entries. There has been a bug here that is fixed.

/Joe

3 Reply by Amjad (edited by Amjad 12/15/2011 11:31:37 am)

  • From: Bahrain, Manama
  • Registered: 09/19/2011
  • Posts: 29

Re: journal inquiry error

i hope this helps you to understand the problem

the amount in the journal is not the same as in the Trans


JE .. 1  (doubles) still happening im using the last update 

http://im13.gulfup.com/2011-12-15/1323940583921.png

for the doubles the problem goes and comes for some reason i some times restore a previous backup then the problem is not there
---


eg. 1  Delivery Note (this is the over view of journal inquiry for the Customer Delivery Note)
http://im13.gulfup.com/2011-12-15/1323940583572.png

eg. 2
http://im13.gulfup.com/2011-12-15/1323940583653.png



thanks joe for the amazing support

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: journal inquiry error

The JE do not have anything to do with the amounts of the delivery. These amounts are first handled when invoicing. As told before the only GL transactions for the delivery are the the crediting of inventory and debiting of COGS. Please try to discuss this with an accountant.

I cannot reproduce the 1 and 2 errors. Nobody have reported problems in the latter releases.

/Joe

5 Reply by Amjad (edited by Amjad 12/19/2011 10:17:42 am)

  • From: Bahrain, Manama
  • Registered: 09/19/2011
  • Posts: 29

Re: journal inquiry error

thanks so much i found the COGS and you are 100 % right


but still have problems with the doubles entries im using FrontAccounting 2.3.9 ,MySql 5.0.8 , PHP 5.3.8  apache 2.2.21


is this upon your stander


if you like i can give you access to the server and see for you self im ruing multiple company's and have the problem in all of them


please tell if you like talk on MSN or any way you like

thank you

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: journal inquiry error

This is not necessary. Just explain to me how you can produce doublicate entries. Please explain in detail what you are doing.

/Joe

  • From: Bahrain, Manama
  • Registered: 09/19/2011
  • Posts: 29

Re: journal inquiry error

these are my steps

1- purchase order
2- purchase delivery
3- supplier invoice

in same date I do the

1- sales order and Delivery note and invoice become after


Normal purchase and sales transaction

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: journal inquiry error

The amounts shown in the Journal Entries is always based on the GL Entries. This is not always the same as the amount from the original document. The Journal entry shows the total of the debit column.
The original amounts are shown when you press the document number.

But I see a double amount of the first JE, 1,000,000.00. It should be 500,000.00. However the transaction rows are shown correctly.
I cannot reproduce this.

/Joe

9 Reply by Amjad (edited by Amjad 12/21/2011 07:51:34 pm)

  • From: Bahrain, Manama
  • Registered: 09/19/2011
  • Posts: 29

Re: journal inquiry error

after talking with you we looked at the last backup that was with out any doubles it was last month we restored it and did the hole month again

now all the entries are ok



i try to find what trigger this


so much thanks for your support