after restoring a backup we find that the we get double recodes in table call comments
i fix it by removing it from the database
hope you can fix it in the next ver
thank you
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by Amjad
after restoring a backup we find that the we get double recodes in table call comments
i fix it by removing it from the database
hope you can fix it in the next ver
thank you
the item is not taken back or return its the same item only the date is modified and in the total report i have the moment is more then the stock that has been orders
if i have 10 battery's i should have a report of 10 not 20 or 40
if i make and order then delivery note and didnt make a invoice waiting to confirm the delivery date (i only order one item)
they goods where delivered after 3 days so i modified the date
i see that the Inventory Item Movement
is doubling every time i change or check the note
also did it in the online demo
this is what i got
this is the
item NB5C Nokia Battry 5c 800Mah
From Location
Ching Mai
Delivery Note 168 xs4-2 06/04/2012 aung kyaw minn (aung kyaw minn) 1 0
Delivery Note 168 xs4-2 06/04/2012 aung kyaw minn (aung kyaw minn) 1 1
Delivery Note 168 xs4-2 06/04/2012 aung kyaw minn (aung kyaw minn) 1 0
Delivery Note 168 xs4-2 06/04/2012 aung kyaw minn (aung kyaw minn) 1 1
Delivery Note 168 xs4-2 06/04/2012 aung kyaw minn (aung kyaw minn) 1 0
this out put is from the online demo you can see it by choosing the item and location as on top in the Demo 2.3
even same happens with the 2.3.11
thanks for the replay
if i make
Sales Order ---> Delivery Note --> Invoice with the Dimension selected
and go to the statement i get C.O.G.S for the Dimension i choosed ,the total of the C.O.G.S is always there and correct when no Dimension selected in both cases
when i do the same with (Direct Invoicing or Direct Delivery --> Invoice) with the same Dimension and same item , same date
the C.O.G.S is not there ( total C.O.G.S is there when no Dimension is selected)
i checked in the Customer Transaction Inquiry ,go to the invoice ,i see that the Dimension is not selected , i selected with the same Dimensions that i made the invoice , update the invoice still it doesn't show in the C.O.G.S with the Dimension is selected
also there is cost for the goods soled when we perched them from the suppler
i hope this helps
i start making Dimension for all my Customers so i can see costs and profit for these customers
if i make Sales Order ---> Delivery Note --> Invoice
then i go to Profit and Loss Drilldown --> Choose the Dimension --> Press Show
i get the full report with the Cost of Good Sold in the statement
the problem become when..
when i make Direct Invoicing or Direct Delivery --> Invoice
i doesn't get the C.O.G.S (doesn't appear in the P&L statement)
i also tried it on the online Ver with the same problem
Please confirm
Great
i will start on it after the week end
Dear joe
i would like to make this report
please inform me how you want us to make it and if you are not all ready doing it
thank you
it would be so nice to have a customer filter in all the reports
like in "Print Invoice"
i can choose from - to the invoice that i want to start & stop but i can't choose the invoice from a particular customer ,so i get all the invoice for all the customers.
thank you
yes please
i would love to see it
card_man_@hotmail.com
and thank you in advance
great work
can you please upload the file
thank you itronics for the replay but i have the asset module up and running
i have created a routine alter routine an excite even and trigger enabled
i add the assets but when i go to the GL report there is no entry and i can't find any trace only in the asset report that comes with the module
did any one try or has it working ?
thank you
i have tried the online front accounting demo server also when i choose Show closed it also Doubles
is this normal ?
Hi,
I don't know if I understand it correctly but when I enable 'Show closed' in Journal Inquiry it shows some of the entries total Amount double or even triple. Just opening a Journal Transaction from this list and pressing the button 'Process Journal Entry' will add the Total a other time to the same entry.
When I view the Journal Entry details it shows the correct values.
It looks like it is on the db_pager that this happens.
Is this a error or am I just reading it wrong..?
Thanks for your help,
Kind Regards,
Amjad Hassan
but i still think that haveing a list with all email for the company and branch's is much better so i can chose who i want to send and don't want to send from the list
thanks joe
im sending invoice and quotes from the email but i can only send to the first email in the contact if i have more then one contact with email i can not chose witch email that you want send to or if i want to send to 2 or 3 email at once
thank you
yap im all the way with elax
and i think you should have a void report to see what you void ,there is a memo message bar but there is no where that you can see the memo !
thanks
i have been trying to import csv after reading the readme.txt with no success ( i try exporting the data and importing it back it dosent accept the fields )
can any one give me a sample line of the item import and sales order
thanks alot
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
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
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
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
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
it will be so nice to have authorization request for customer credit that all these transactions have to be approved by the manger before printing the orders
for example a customer needs credit 500 USD this will send a request to the manger and he approves it for one time
thanks
i all so get 2 invoice even if i edited the sales order before the the invoice
i get 2 invoices with the same invoice number ,one with the old order and the second one with the extra add items
it would be nice if its all in one invoice
thank you
if i enabled (Search Item List) the item disappear from the scroll bar that is beside the Select an item
i can only get the items when i search for it first
i think that the scroll bar should have the full list of the item and category's before search and after search should contained the searched items
thanks
FrontAccounting forum → Posts by Amjad
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.