Thank you, Apmuthu. Allow Negative Inventory is checked. This has allowed me to sell before receiving. That part is not the problem. As I have mentioned, the problem is that in this kind of negative inventory sale, the sales delivery gl posting does not get entered. This is the part I'm stuck on. Why doesn't this gl entry get posted?
1 11/28/2015 08:19:22 pm
Re: Sales delivery GL posting (8 replies, posted in Banking and General Ledger)
2 11/24/2015 07:50:08 pm
Re: Sales delivery GL posting (8 replies, posted in Banking and General Ledger)
Another use case (related to your question about selling inventory before receiving it) that happens frequently is physically getting the inventory in the store and selling it before it gets checked-in and invoiced. The customer pays for and walks out the door with the product, but the system doesn't record it properly in the gl.
Anyone?
Thank you,
Joshua
3 11/23/2015 06:02:20 pm
Re: Sales delivery GL posting (8 replies, posted in Banking and General Ledger)
Apmuthu, thank you for your response. The only flag I see related to negative anything in the config.php is $allow_negative_prices, which looks like it only relates to service items. It is set to 1.
Would you please explain what you mean by inventory position? Where is this and what kind of adjustments do you mean?
I process customer sales through a direct sales order, like the direct invoice on the supplier side, which generates the delivery and accepts payment all in one step. This works perfectly for all sales except those mentioned above.
I have looked through cart_class.inc and sales_delivery_db.php, but I don't see where these transactions are getting held up. Thoughts?
-Joshua
4 11/19/2015 10:08:02 pm
Re: Sales delivery GL posting (8 replies, posted in Banking and General Ledger)
Is anyone else having this issue? I have not been able to track down where in the code this kind of gl entry is being blocked. Any insight would be greatly appreciated.
-Joshua
5 11/16/2015 07:39:06 pm
Re: Sales delivery GL posting (8 replies, posted in Banking and General Ledger)
I don't understand. What invoice? Customer or Supplier?
On sales where I already have the inventory in stock, the customer delivery GL is posted as it should be. But on sales where I receive the inventory after the sale, the customer sales invoice GL entry is posted, as is the supplier delivery when I receive the inventory, but the customer sales delivery is not posted as a GL entry, so my inventory GL account (Finished Goods) is hugely bloated compared to the Inventory Valuation Report (which looks much closer to what we actually have on hand).
Thank you,
Joshua
6 11/14/2015 10:07:51 pm
Topic: Sales delivery GL posting (8 replies, posted in Banking and General Ledger)
Good day,
We frequently sell items before we receive them, and I've just noticed that there is no GL entry posted for the delivery on these sales, so this is causing the Balance Sheet Inventory Assets to drift very far from the Inventory Valuation Report.
In the company setup, the check box for Allow Negative Inventory has the Warning: This may cause a delay in GL postings. As far as I can tell, there is not just a delay--it never happens. When is it supposed to post the GL entries? Or where in the code do deliveries of back-ordered items get posted?
Thank you,
Joshua
7 01/30/2013 08:36:55 pm
Re: Error when changing from Direct GRN to Direct Invoice (12 replies, posted in Report Bugs here)
Cayrol,
It seems to be something in the way the Windows version of the server handles sessions that conflicts with FA. I've moved my setup to a Linux server and haven't had the problem show up any more.
-Joshua
8 01/09/2013 04:47:31 pm
Re: No longer able to enter negative amounts after upgrade 2.2 -> 2.3 (3 replies, posted in Banking and General Ledger)
Joe,
I know this thread is a little old, but why was this restriction put in place? After some testing with quick entries, negative numbers on the bank payments don't seem to cause any trouble. Do negative lines on a bank payment cause problems that I'm overlooking?
Thank you,
-Joshua
9 11/07/2012 05:35:58 pm
Re: Payroll Module Development (34 replies, posted in Modules Add-on's)
bjp99,
The project is on hold at the moment - that is, no one is actively working on it as far as I know. The module scope got enormous (trying to make it work for any country's tax requirements) and I got lost. It is currently in a very unusable state and needs direction and more motivation.
You should join the developers list and discuss this with Janusz. He already has a proposed DB structure in place. You could talk with him about moving forward.
10 10/03/2012 05:14:56 pm
Re: Error when changing from Direct GRN to Direct Invoice (12 replies, posted in Report Bugs here)
I see this was never really resolved here. I'm having the same issue, though I don't see any relation to the GRN. Often on a sales invoice, I get this same error without opening any other tabs. I'm running xampp on windows XP with Apache 2.2.21 and PHP 5.3.8
We run a retail store, so we use the sales invoice frequently and this is becoming quite a nuisance.
Thank you for any help,
-Joshua
11 08/03/2012 06:42:24 pm
Re: Payroll Module Development (34 replies, posted in Modules Add-on's)
Yes, several guys here have gotten onboard to help, including Janusz. The module now has multi-national aspirations that reach far beyond the simple little thing I originally had in mind. If it is realized, it will be a very helpful add-on.
12 07/11/2012 12:45:39 pm
Re: Payroll Module Development (34 replies, posted in Modules Add-on's)
Farhaj,
You should join the developers list and discuss this with Janusz. He already has a proposed DB structure in place. You could talk with him about moving forward.
13 06/28/2012 12:02:25 pm
Re: Edit Bank Transfer (5 replies, posted in Banking and General Ledger)
Joe,
Thank you very much for the date fix. This is very helpful.
As for the editing - based on what I've seen of your work, 'tricky' doesn't seem like it'd be a problem for a guy like you
-Joshua
14 06/27/2012 09:37:43 pm
Topic: Edit Bank Transfer (5 replies, posted in Banking and General Ledger)
I see an edit button for modifying existing Bank Payments, but not for Bank Transfers. Is this a difficult thing to implement? I'm sure it's not the last time I'll make a mistake on a transfer. I know I could void the transaction and re-enter it, but what a pain in the butt for just mis-inputting the date.
Speaking of the date, I have my system preferences set to Remember last document date, but the Bank Transfer page keeps going back to today.
15 04/30/2012 09:10:55 pm
Re: Customer Payment Account (5 replies, posted in Accounts Receivable)
Ah. I don't think the problem is with the bank accounts. I had used that as an example, but none of the item or customer sales accounts are currently linked to a bank account. I am using the GAAP US COA.
I've found it. My POS was linked to a non-existing bank account for default cash account.
So, a cash sale is the only kind that automatically generates a customer payment at the time of invoice, right? Is there an easy way to set up credit card and check sales to automatically generate a customer payment, but have these diverted to another holding bank account (ie Undeposited Funds)?
Thank you,
-Joshua
16 04/28/2012 09:52:52 pm
Re: Customer Payment Account (5 replies, posted in Accounts Receivable)
Thank you for your quick reply. And on a Saturday!
My bank accounts all have GL accounts listed on the Bank Accounts page. Where else should I look?
Okay on the report. I haven't looked at the reports much. I'll share it if I make one.
How about the rest? What is the end-of-the-day procedure in FA, regarding deposits and such?
Thanks again,
-Joshua
17 04/28/2012 07:00:02 pm
Topic: Customer Payment Account (5 replies, posted in Accounts Receivable)
I've done a Direct Sales Invoice and I see that a customer payment has been applied against it automatically. Very good. However, when I look at the General Ledger Inquiry for that Customer Payment, it shows a blank line for the debit - no account number or name, just the amount debited. The credit line shows the Accounts Receivables account info. This doesn't seem correct.
On a somewhat related note, is there a way to "batch out" at the end of the day? So, for example, we make several cash sales in a day and these are put in a Cash on Hand account (what I expect should be in the blank line above?). At the end of the day we make one bank deposit, so this one amount is moved from Cash on Hand to Bank Account to line up with the deposit on the bank statement. Credit card sales are also all grouped together and deposited at once. Check sales are deposited with the cash. So, credit card and check sales would be held in some sort of Undeposited Funds account until the sums are moved at the end of the day. Is this setup possible?
Also, is there a report for a daily sales summary - i.e. total sales, credits, tax collected, credit card and check listings, and amount available for deposit?
Thank you,
-Joshua
18 04/27/2012 08:12:32 pm
Re: Create direct invoice programmatically (2 replies, posted in FA Modifications)
I, for one, would find a transaction import module very helpful. Have you made progress on this?
19 04/25/2012 04:03:17 pm
Re: Related Item Pages (2 replies, posted in Items and Inventory)
Yes, that would be very useful. Thank you.
20 04/19/2012 04:47:27 pm
Re: End of year inventory count (2 replies, posted in Items and Inventory)
Thank you.
21 04/19/2012 12:29:03 pm
Topic: End of year inventory count (2 replies, posted in Items and Inventory)
I see the report for generating the inventory count sheets, but where do we make all the adjustments after the inventory has been physically counted?
22 04/19/2012 02:44:18 am
Re: Payroll Module Development (34 replies, posted in Modules Add-on's)
Progress is being made and the code is available here http://code.google.com/p/fa-payroll-module/ to look at. Serbanc is a more accomplished coder than I am so I have high hopes for this project. It is currently not anywhere close to functional, but you are free to browse the code and the wiki to see where it's going.
23 04/17/2012 12:49:03 am
Topic: Related Item Pages (2 replies, posted in Items and Inventory)
Good day,
Is there a particular reason the pages related to a specific item (foreign item codes, sales pricing, and purchase pricing) aren't together on the items page under different tabs?
Also, how much would need to be changed to keep duplicates of items with foreign item codes from showing up in item lists in the ui? That is, search all the different fields, but just show one version of the item.
24 04/16/2012 10:16:45 pm
Re: Payroll Module Development (34 replies, posted in Modules Add-on's)
serbanc,
I looked at several other open source payroll solutions, but I had not seen Anahaw. I am far enough into this that I'd rather not start over with something else if possible. I also noticed it has a 29% user approval rating...
I've progressed to the point of having a paycheck processed and ready to insert as a journal entry. I'm very open to pushing the code up for public perusal. If anyone wants to help, this would be a fantastic point to jump in.
25 04/15/2012 01:31:52 am
Re: Payroll Module Development (34 replies, posted in Modules Add-on's)
It sounds like most of the stuff in your edit could be handled by generating reports. I haven't done any reports yet, but from what I've read, it should be easier than creating a module. Fa already has the ability to create users with different limited permissions, so you could generate payslip and bank reports based on who is logged in.
I haven't really done any projects quite like this before, so I don't know how to break this up for distributed development, except for the kind of things you're talking about with the reports and whatnot.