FrontAccounting forum — journal inquiry error

Re: journal inquiry error

null@example.com (Amjad) — Wed, 21 Dec 2011 09:55:43 +0000

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

Re: journal inquiry error

null@example.com (joe) — Mon, 19 Dec 2011 23:00:43 +0000

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

Re: journal inquiry error

null@example.com (Amjad) — Mon, 19 Dec 2011 15:05:10 +0000

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

Re: journal inquiry error

null@example.com (joe) — Mon, 19 Dec 2011 14:17:53 +0000

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

/Joe

Re: journal inquiry error

null@example.com (Amjad) — Mon, 19 Dec 2011 10:16:13 +0000

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

Re: journal inquiry error

null@example.com (joe) — Thu, 15 Dec 2011 13:07:16 +0000

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

Re: journal inquiry error

null@example.com (Amjad) — Thu, 15 Dec 2011 10:08:40 +0000

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

Re: journal inquiry error

null@example.com (joe) — Wed, 14 Dec 2011 13:54:49 +0000

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

journal inquiry error

null@example.com (Amjad) — Wed, 14 Dec 2011 13:14:25 +0000

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