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?

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

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

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

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

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

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

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

(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.

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

(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

(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

(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 smile

-Joshua

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

(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

(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

(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

I, for one, would find a transaction import module very helpful. Have you made progress on this?

19

(2 replies, posted in Items and Inventory)

Yes, that would be very useful. Thank you.

20

(2 replies, posted in Items and Inventory)

Thank you.

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

(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

(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

(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. smile

25

(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.