1 Topic by jeskremer

(0 replies, posted in Accounts Receivable)

Does anyone have a suggestion for showing quantities of zero cost items that are non-inventory on Sales Orders and Sales Invoices?

The interesting thing is that when I click "View Order" after submitting the Sales Order, the quantities appear, but when I go to "Print Order" the quantities don't visualize at all.

It is causing confusion for the people shipping our products because we are handwriting the quantity in on the Sales Order when it is passed on to the shipping dept. for items that are non-inventory.

Thanks for the help!  I'm sure it is a simple hack in a report file.

Go to forum: Accounts Receivable

2 Topic by jeskremer

(0 replies, posted in Report Bugs here)

Can someone please tell me how to properly refund just the Tax on an order.

When I refund it with a credit note and bank payment and run the GL report for the tax, it is accurate, however, the refund never posts to the Tax Report form 109 so the GL account and tax report do not match.

I've spent about 8 hours on this problem already

Thank you!

Go to forum: Report Bugs here

3 Reply by jeskremer

(18 replies, posted in Modules/Add-on's)

Scott Wheeler from CartSpan has a module for this.  We switched to FA this spring with the expectation that Scott was writing a module to allow CartSpan to dowload orders from Woo into FA and also post to ShipStation.

https://frontaccounting.com/punbb/search.php?search_id=299033542

Go to forum: Modules/Add-on's

4 Reply by jeskremer

(3 replies, posted in Items and Inventory)

I was able to figure out how to change them all in phpMyAdmin.

Go to forum: Items and Inventory

5 Reply by jeskremer

(1 replies, posted in Reporting)

As I am looking at this, what shows up on the Tax Report appears to be only Transactions that went through the Revenue column of the GL account.   Sales Tax Payable or Accumulated would be in the Liabilities.

In short, only 4 of my 22 credit notes show up on the Tax Report.  These four went through a Sales Return account under Revenue.  The others refunded a complete Sales Tax Payable account in Liabilities.

I can't find anything in the WIKI or forums to confirm this though.

Go to forum: Reporting

6 Topic by jeskremer

(1 replies, posted in Reporting)

I am paying year end Sales Tax, but have a confusing situation.

I had a few customers pay tax that should not have this year.  I would refund the Sales Tax with a Credit Note and Bank payment against the Sales Tax account.

When I run the Tax Report, however, it will only show tax refunded if a partial portion of an order or full order was refunded.  Just refunding the Sales Tax through a credit note is not reflected on here.

Is there a separate Journal Entry that I should be using to make Sale Tax report reflect a Bank Payment/Credit Note to Sales Tax Payable?

I hope this makes sense.  Thank you.

Go to forum: Reporting

7 Reply by jeskremer

(8 replies, posted in Items and Inventory)

I think I may have figured out how to enter it is SQL... manually change the mb_flag for the Item from D to B.

Do you think this will cause any issues?

Go to forum: Items and Inventory

8 Topic by jeskremer

(3 replies, posted in Items and Inventory)

OK, this probably is a stupid question, but when I setup FA to test it out, I did not start out with inventory.  I am now to the point of trying to get inventory to work, but realize that my Items, being set to Service and Non-Inventory, are unable to be changed to Inventory and Purchased.

Is there anyway to do this or am I completely stuck and have to re-enter all Items using new Item codes?

Thank you.

Go to forum: Items and Inventory

9 Topic by jeskremer

(0 replies, posted in Reporting)

OK, I've spent a few hours on this already and can't figure it out.  I've looked at the wiki mentioned previously on this issue and scoured the database and search terms in the forums.

Here is what I have so far.  What should be on the "Shipping Method" line to show the shipper_name?:

case ST_SALESORDER:
            $this->title = ($this->params['print_quote'] ? _("QUOTE") : ($this->formData['prepaid'] ? _("PREPAYMENT ORDER") : _("SALES ORDER ACKNOWLEDGEMENT")));
            $this->formData['document_name'] =_("Order Ackn. No.");
            $this->formData['document_date'] = $this->formData['ord_date'];
            $this->formData['document_number'] = $SysPrefs->print_invoice_no() == 0 && isset($this->formData['reference'])
                ? $this->formData['reference'] : $this->formData['order_no'];
            $this->formData['document_amount'] = $this->formData['order_no'];

            $aux_info = array(
                _("Customer's Reference") => $this->formData["customer_ref"],
                _("Sales Person") => get_salesman_name($this->formData['salesman']),
                _("Shipping Method") => $this->formData['shipper'],
                _("Internal Order No") => $this->formData['order_no'],
                _("Delivery Date") => sql2date($this->formData['delivery_date']),
            );
            break;

Go to forum: Reporting

10 Topic by jeskremer

(2 replies, posted in Accounts Receivable)

Is there any way to set the auto date range to a longer range in the search function?  I was digging through the config file, but couldn't locate anything.  I am having to broaden the search range constantly to reach back to where I need to start looking.

Additionally, if anyone has ideas on searching by order total payment amount due, that would be really helpful as well.  We sometimes have a check show up with just a dollar amount and a different name than the actual business name.  It takes quite a while to dig and find some of these.  Would be great to search by total.

Thank you all for a great Open Source accounting program!  Dumping QB was a great feeling this year.

Go to forum: Accounts Receivable

11 Topic by jeskremer

(1 replies, posted in Accounts Receivable)

Any thoughts on how to easily create monthly compounding interest invoices for late customers... or is the best way to just do it manually?

It takes a lot of man hours to do it manually with dozens of outstanding customers though.

Thanks!

Go to forum: Accounts Receivable

12 Topic by jeskremer

(1 replies, posted in Jobs wanted/offered, non-free offers)

I have been trying to figure out how to duplicate Sales Invoices so they don't have an "auto" number, but create a new number.  We have recurring customers from year to year who edit quantities slightly.  It would save tons of time and hassle if we could just duplicate a previous Sales Order from the past year.

I learned it is possible with a Direct Invoice, but not when starting from the Sales Order point in the ordering process.

I am willing to pay someone to help with this.

Thank you!
Jesse

Go to forum: Jobs wanted/offered, non-free offers

13 Topic by jeskremer

(0 replies, posted in Banking and General Ledger)

I have followed this topic: https://frontaccounting.com/punbb/viewtopic.php?id=5763 and read through the Quick Entry wiki several times, but can't quite figure this one out.

I have a Quick Entry for payroll.  It works fine for salaried employees, but hourly employees who have fluctuating negative tax amounts cannot be edited when I use Quick Entry.

It always has a warning about amounts less than zero or negative.

I can go in and edit the original Quick Entry and adjust the negative amounts, but when I go into a new Quick Entry post, it will not let me adjust the dollar amount that is negative.

Any suggestions?

Go to forum: Banking and General Ledger

14 Topic by jeskremer

(2 replies, posted in Accounts Receivable)

I often send a link for someone to make payment after creating a Sales Order, but for whatever reason, all of the customer info: phone, address, etc. is shown at the bottom of the Sales Order page, but Email is not.  Is there a way to add that so after I am done I do not have to go find the contact in the Customer tab so that I can locate the email address?

In short, how do we add the email address to be visible on the Sales Order page?

Thank you all.

Go to forum: Accounts Receivable

15 Reply by jeskremer

(20 replies, posted in Accounts Receivable)

Interesting.  I haven't received the date error message lately, but now I don't get it copying at all, but rather, showing a page with no data and a "Back" link.

I did try your suggestion of changing the Ref number.  That didn't seem to help.  I still get the "Back" link with no new sales order when I click the "Copy" button.

Go to forum: Accounts Receivable

16 Reply by jeskremer

(20 replies, posted in Accounts Receivable)

I did get all of this code inputted, however, when I copy a Sales Order, I get the following yellow caution bar at the top:

Missing refline context data: 'date'

In the Reference Number box, I also get this: YYYY-0001

Go to forum: Accounts Receivable

17 Reply by jeskremer

(4 replies, posted in Items and Inventory)

Perfect.  Thanks!

Go to forum: Items and Inventory

18 Reply by jeskremer

(20 replies, posted in Accounts Receivable)

Thank you!

Go to forum: Accounts Receivable

19 Topic by jeskremer

(0 replies, posted in Accounts Receivable)

Does anyone know how to make a finance charge on an overdue invoice so that I can print a statement and mail it? 

We have multiple customers that we need to do this for on a monthly basis.

Thank you.

Go to forum: Accounts Receivable

20 Reply by jeskremer

(4 replies, posted in Items and Inventory)

OK.  Figured the one out in a round-a-bout way.  In phpMyAdmin, I just downloaded the Item List to get all of the SKUs.

I still need to be able to see more than 10 or so customers or items when clicking the magnifying glass and the pop up opens.  There is no way to scroll or select next to see more.

Go to forum: Items and Inventory

21 Reply by jeskremer

(20 replies, posted in Accounts Receivable)

I was doing some looking at the code tonight and can't quite figure it out.  Obviously with this code posted previously by @trafficpest, we're copying an order from the "Customer Transactions" tab.

This is working great, however, we have one little hiccup.  I was trying to see if I could do the following from the Sales Order Inquiry screen or Customers tab:

Copy a Sales Order so that it gets an actual unique reference number instead of auto.

What you are doing now works great, except that, we are really close to getting a software called ShipSync to connect to ShipStation and post tracking back to Front Accounting.  The problem?  It does need a unique reference number or it won't work.

It is working great on unique and new orders, but if we start copying orders and only getting auto, it won't work.

We have dumped Quick Books for your software and are really excited to get this fully implemented in our business.  I think there is a HUGE market for Open Source programs like this.  I'd even be willing to pay someone a few bucks to help fine tune the end product for us.

Go to forum: Accounts Receivable

22 Topic by jeskremer

(4 replies, posted in Items and Inventory)

Maybe I'm missing something, but I have a two pronged question:

1. Is there a way to print an list of all of the items and their SKUs and even the Kits?

2. Is there a way to view more than 10 items, kits, customers, etc. when clicking the magnifying glass?  It is sometimes difficult to search when only 10 pop up.

Thanks!

Go to forum: Items and Inventory

23 Reply by jeskremer

(20 replies, posted in Accounts Receivable)

I also noticed that it does not create an actual reference number.  It just calls it "auto".

Go to forum: Accounts Receivable

24 Reply by jeskremer

(20 replies, posted in Accounts Receivable)

Yes, that is correct.  We get an order, schedule delivery, and then invoice.  Thus, the need to replicate the Sales Order end of things first.

I have been using this for a little bit now, but still can't find a duplicate button for Sales Orders when I query them.  There is one when searching customer transactions for the Sales Invoice and Delivery Note, but nothing next to Sales Order.

Go to forum: Accounts Receivable

25 Reply by jeskremer

(20 replies, posted in Accounts Receivable)

I did try this and it works great for Direct Invoice.  What would you recommend adjusting to replicate a Sales Order?

Go to forum: Accounts Receivable