Hello Joe,

Please i will like to ask a somehow unintelligent question. Where do I control my inventory using FIFO and LIFO in frontaccounting. I am having a little challenge because goods prices are always fluctuating. I used a price in June this year and today the price of the product has reduced.
when i try to print the sales of June, it was taking the new prices. I believe I must have done something wrong. Kindly help.

popsicles12

102

(2 replies, posted in Accounts Receivable)

Hello Joe,

Thanks for your response. i really appreciate it. The version I am using is 2.2.8. I will also check the solution you gave me and see how it goes.

thanks.

Popsicles.

103

(2 replies, posted in Accounts Receivable)

Hello Joe

thanks for your continuous response to all my question.

There is this error that my entry clerk told me ocurred.
By user rights and privilege, she can only enter invoices and cant enter payment.
two days back, she entered and invoice and surprisingly, a payment was created for that same invoice. When you try to click the invoice number to open it, it displays the following errors:
DATABASE ERROR: no debtor trans found for given params sql that failed was: SELECT 1_debtor_trans.*, ov_amount + ov_gst + ov_freight +ov_freight_tax + ov_discount AS Total, 1_debtors_master.name AS DebtorName, 1_debtors_master.address, 1_debtors_master.email AS email2, 1_debtor master *********************. and so on.

Please what is the cause of this error.

thanks in advance joe

popsicles12

Hello Janusz,

thanks once again.

this is what I mean.

I wanted to void a Purchase Order, Purchase Order Delivery and Supplier's Invoice. On going to the voiding section, I could only void Supplier's invoice. I could not void Purchase order nor the Purchase Order Delivery. I posted it on this forum and I was told to do a Stock Adjustment to correct my inventory status which I did.

About 6 - 7 days later, I discovered that the system (FA) automatically did the stock adjustment. this now made it a double adjustment with the manual stock adjustment I already did. I had to now void the manual stock adjustment i did initially.
I also discovered that the date this automatic adjustment was done on the same date as the Delivery date on the Purchase Order.
My observation is that the software does automatic adjustment when a suppliers invoice is voided. My question is that you please confirm this and that why do it have to take so many days although I am enable negative stock entry.

thanks.

popsicles12

Hello Janusz,

Thanks for your response.Ireally appreaciate it.

There is this issue I have been battling with about Voiding a PO, Invoice, Purchase Order Delivery. When you want to void, you can only void Invoice. I posted on it on the forum and I want to told to do stock adjustment. To my greatest surprise, I discovered that after some days, there was an automatic adjustment by the system concerning the Purchase invoice I voided thereby making it a double negative adjustment since I manually adjusted the stock. have you come across this?

Secondly, I also discovered that it adjusted based on the date the stock arrived my store.

Any comments on this?

thanks

popsicles.

NOTE:Please which is FS 2.3?

Hello Janusz,

Thanks for your reply.
How do I change automatically the delivery date on the purchase order to reflect the date the purchase order was raised? cos our vendor make delivery of purchase order the same day purchase order is raised.

How about a situation when my Vendors gives me discount in goods and not in cash. How do I handle it.
This is the scenario: I bought 1000 unit of  goods at 200 naira per unit and my vendor gave a discount of 100 units of goods. this make us sell less than purchase price. How do I handle this discount.

thanks .
popsicles12

107

(12 replies, posted in Accounts Payable)

Hello Janusz,

Thanks for your reply.
How do I change automatically the delivery date on the purchase order to reflect the date the purchase order was raised? cos our vendor make delivery of purchase order the same day purchase order is raised.

thanks .
popsicles12

108

(12 replies, posted in Accounts Payable)

Hello Janusz,

Sorry about the version error. I am using version 2.2.8. Please check it out. I will really appreciate that. thanks.

popsicles12.

109

(12 replies, posted in Accounts Payable)

Hello Joe,

I discovered something very strange from what you told me regarding voiding Purchase Order.
I did as you told me using stock adjustment. To my greatest surprise, i discovered that the stock in the already voided invoice has reversed itself. making it a double deduction. i am somehow confused please check it out. I am using version 2.0.
Now if it is so why does it have to take so many days to reverse because we take stock weekly although we enabled negative stock.
I will get the sceenshots for you to see what I am talking about.
please kindly check this out.

thanks for your continued support.

Popsicles12

110

(12 replies, posted in Accounts Payable)

Hello Joe,

Please kindly let me know how i can void a Purchase Order and Purchase Order delivery. I tried to do this by going to setup - void transaction. When I try to call up the PO with it transaction no, it returns an error "cant be found or it has been voided".

how do I do this because I have already voided the invoice to this transaction.

Thanks

Popsicles12

111

(1 replies, posted in Accounts Receivable)

hello Joe,

Sorry to bother you on this issue. you said in your earlier post to me that I can enter an invoice without unit price and amount. Please I want to know how to do this.

Please!

thanks.

popsicles12

112

(2 replies, posted in Accounts Receivable)

Hello Joe,

I dont understand how you can create an invoice with prices when there the selling prices are entered in the system. Moreso, when you enter a product into the invoice it will show you the price for i unit then when you increase the unit, it automatically update the amount of such product.
Please kindly enlighten me on how to sell a product for free in front accounting and what to do to stop it.

thanks.

popsicles12.

113

(2 replies, posted in Accounts Receivable)

Hello Joe,

There are some discoveries I need explaination to.

1. A clerk of mine wrongly entered an invoice. I voided the invoice and asked her to enter the invoice correctly which she did. i later discover after three days that invoice has stock on it but no unit price and amount. Stock was deducted from my store but amount was not credited to the customers' account. What could have happened? Is there a way one can enter an invoice without the prices and an amount.

2. I voided a suppliers' invoice in the morning and in the evening, the stock on the invoice had not be returned to the store. although i checked the negative inventory entry. Why does it do this?

3. A customer gave me a cheque which was deducted from his debtor's account. on presenting the cheque, it was rejected so i do i add the amount back to his account?

please kindly assist.

thanks.

popsicles12.

114

(7 replies, posted in Setup)

Hello Joe,

My FA has been working fine until the system crashed. On reinstalling a new hard drive and installing FA, I restored the backups i had done. In it there are 4 companies running. the main office which is company 1, cannot not post any transaction. When I try to post, it brings the error "The entered information is a duplicate. Please go back and enter different value". So suprising that the other companies created from the main company are posting transaction very well. I have checked the database and I could not find anything wrong with it. Please help.
thanks

Popsicles12

Hello Joe,

thanks so much for all response concerning FA.

I just discovered that I am not able to place the meaning of the stock check sheet reports' heading.

In the heading you have
Stock Check Sheets Training Co.
Print Out Date: 05/21/2010 06:26 am frontaccounting.com
Fiscal Year: 01/01/2010 - 12/31/2010 (Active) Demo User
Category: Grapes used for wine
Location: Házi raktár
Only Shortage: No Page 1

Stock ID              Description              Quantity                         Demand           Available       On Order

I am familiar with what StockID and Description means. But I do not really understand what Quantity, Demand, Available and On Order means because the names are not really correspond with the the figures generated in the report.

Please help.

Thanks

popsicles12.

Hello Janusz,

How do I make a customer balances to be displayed based on Location or Salesman so that I can view the performance of each sales man in every location. the customer balances report is very fine but it moddle up all the customers from the different distribution together. I want a situation where when I want to display customer balances, I  will be able to select the sales folk so that it will generate my report based on sales folks.

secondly how do i make my stock check sheet display inventory based on specified period.

thanks

popsicles12.

117

(1 replies, posted in Items and Inventory)

Hello Joe,

I would like my inventory report to have a start and end date so that I can see the items sold per period.

thanks Joe

Popsicles12

118

(2 replies, posted in Accounts Receivable)

Hello Joe,

I have critically examined the Sales Reporting and I have found out that if only I can add to the customer balances report the Sales folks filter, my problem is solved. that is by sales folk report, I will be able to see my customer transaction per sales folk.
Please your help will be highly appreciated.

thanks.

Popsicles12

119

(2 replies, posted in Accounts Receivable)

Hello Joe,

Please I have a challenge with FA.

Like I told you earlier on. I run a business that we have sales reps that the head office gives goods to. FA was able to handle some of my problems. But the main problem here is as follows:

I cannot view the report of customers balances attached to each reps so that I can see the customer balances as per sales rep.
secondly, i cannot view the payment of the customers as per sales reps so that at a glance we can view what they have paid and what they are owing based on the various sales reps.

I want to see the transactions per sales reps. I can only see salesman's listing.
also when I tried to get the customer balances there is no provision for specific dates.

so what do I do to get these reports.

please help me cos I am in the middle of a fix because i cant get my customers per reps.

thanks in advance


popsicles12

120

(4 replies, posted in Reporting)

Hello Joe,

I just ran into this problem. when I want to print customer balance report, salesman report and some other reports in inventory using pdf it shows that warning triangle. I went into the config.php file to enable error report and this is what it shows me when i want to print in PDF.

%PDF - 1.3
3.0 obj
<<Type/ Page
1 Parent /OR
1 mediaBox [00595.28 841.89]
1 Resource 20R
1Contents 4 ) R >>
endobj
4 0 obj   <</Filter/StateDecode/
Length 2096>>
stream
''
then funny symbols will apprear

how do i correct this.
funny enough if i click a category in the a Customer in customer Balances to print it will print it in PDF but when I want it to print all, it will bring the above error.

secondly, my login page showed this error after i enable debug.
"Undefined variable: power_url infile: c:\zampp\htdocs\frontaccounting\access\login.php at line 73"
"Undefined variable: power_url infile: c:\zampp\htdocs\frontaccounting\access\login.php at line 136"
"Undefined variable: power_url infile: c:\zampp\htdocs\frontaccounting\access\login.php at line 139"

please help

popsicles12

121

(5 replies, posted in Items and Inventory)

Hello Joe,

Thanks for your responses. i do appreciate you and all that works on the FA project.

I have this challenge and will very much appreciate if you can help me out. I have been able to do my conversion in inventory to units because we sell both in cartons and units. so my FA sees all as units.
my challenge now is this: when I am taking stock of goods in the store, i will like for FA to converts the unit stock into cartons so that i can see the quantity in cartons. E.g. We have a product that have 60units in a carton. by purchase price conversion, i have i carton in my store as 60units. when I want to take stock at the end of a period, i will love to see that 60units as 1 carton.

Is this possible, please help

thanks

popsicles12.

122

(2 replies, posted in Items and Inventory)

Thanks for your response Joe.

Still on my supplier's discount, i have about 6 suppliers and the discount they give to me varies. sometimes they give 2% discount whichis equivalent to an amount say 250 naira. having posted the invoice with the amount before the discount. how do I deduct the discount received?
thanks

popsicles12.

123

(2 replies, posted in Items and Inventory)

Hello Joe,

I have a little problem with my FA. sometime when i post a transaction, i post it with a wrong date. i discovered that I cannot correct the date within FA even as admin. how do I correct this situation.
Also when i try to generate a PDF report in FA, it initializes but later shows a triangle symbol at the top and no PDF is generated. how do i correct this also.

thirdly, how do i place Supplies discount in my transaction in FA.

Thanks

popsicles12

124

(0 replies, posted in Reporting)

hello Joe,

I just discovered that my customers balance in reporting does not display. when I click the display customer balances, it tries to but after a while it brings the red triangle icon at the top. same happens for aged customer balance. what may be the reason?
is it because the customers at many say 250 customers or what. Funny enough if i try to generate the report via excel, it opens.
moreso, if I want to get the customers balances per location, how do I go about it.

Please help

thanks.

popsicles12

Hello Joe,

Please there is a situation with my FA. I have assigned all my debtors to their respective location that is manned by the salesreps. The issue I now how is:
1. when I want to issue an invoice to a customer (debtors) one I click the customer all the parameters to that customer is supposed to appear like payment = delayed, Deliver from location= location the customer is tied to. But this is not the case. I do i do this cos it will enhance speedy entry.

2. I also need to add additional fields (2 fields) for customers. how do I go about this.

3. I also want only customers assigned to a branch be made available to the salesrep when he logs in to FA. i.e he should be restricted to his customers alone.

4. How do I tie a salesrep to a location.


thanks.

popsicles12