Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options
Hi barbarian, did you ever figure out the purpose of these journal entries? I can't figure them out. I think if I make a product with $1 parts, $1 labour, $ 1 overhead then I should have a GL entry:
Finished goods Dr $3
Inventory Cr $1
production labour Cr $1
overhead a/c Cr $1
I can't see why the journal entries are needed. I notice that they only appear when there is no stock of the finished goods and for the amount that isn't part of the BOM. I'm using advanced manufacture.
Thanks Joe, I will look at the git repository.
If you make a new product or a product with no current stock holding you get these odd journal entries,
1530 Finished Goods Cr 561.14 WO Issue settlement JV for zero/negative respository of newproduct
5410 Inventory Adjustment Dr 561.14 WO Issue settlement JV for zero/negative respository of newproduct
if you make some more of the product, everything seems to work normally until you've sold all the product and the stock holding becomes zero, in which case the journal entries appear again.
Why does this happen when there is no stock of the output product? I would have thought that a journal entry would only be required if you had insufficient stock of the input items and were allowing negative inventory?
I have tried this on the demo as well with the same result.
The value of these entries are the items added that weren't part of the BOM
Thanks Joe, I,ve just been taking one cent off the price of one of the items, add one cent of the tax free item and it seems to balance ok.
Thanks
Some suppliers round GST down to the nearest cent even if it's bigger than 0.5cents, Making the GST amount out by 1 cent. I saw in an older post where you could create a tax free service item and add to the invoice to fix the rounding problem. However if I add -1cent, FA says that negative amounts aren't allowed and changes the amount back to 0.00. Has something changed with later versions of FA? (I'm using 2.3.12) or am I likely doing something else wrong?
Thanks Pete,
I edited the mistakes I made with phpmyadmin. It wasn't too bad changing an amount but changing a date was a headache,won't do that again:)
I have all the historical transactions entered now, and everything working ok. Your script sounds cool. Could I use it to create a clean chart of accounts? would be useful to set up a friend with FA and use my own COA as a starting point.
I think my first problem with the quick entry was that I had the drawings account tied to a bank account, bank accounts aren't shown in the drop down.
I also had a problem with creating a new customer where the auto created branch wasn't visible, I couldn't create an invoice because there were no branches setup but I couldn't delete the customer because there was an existing branch. There was a fix for this on Mantis but didn't work in my scenario, what did work was deleting the branch from 0_cust_branch, I never had a problem with this before or since.
I have everything working well now including quick entries, starting to get easier now that I am getting to understand the accounting side of the things.
Look forward to trying your script
cheers
Thanks for the reply Joe,
I couldn't work out what was wrong. The account was set up the same as the others with Account status: active. I had a few transactions I had entered wrong anyway so I just did a fresh install with General US 4 digit COA which was the same as the first time. Everything seems to be ok. I am going to enter a few old transactions, what would be the best way to correct any mistakes If I type the date or amount wrong? I have myphpadmin installed if necesssary.
Thanks for your assistance,
I'm trying to set up a quick entry as follows:
for phone where 50% of the payment is drawings. Of the remaining 50%, 15% is GST, remainder is Telephone account(expense) something like this:
Description: Phone
Entry Type: Bank payment
% amount of base 50%: drawings
Taxes added, reduce base:GST
remainder: Telephone
However when I drop down the Account box, not all GL accounts are available, drawings doesn't appear on the list. I have a new installation with only a few transactions.
Posts found: 8
