[GNC] Car Repair Shop GNU questions

[Adrien Monteleone]

#1 - I don’t think so, at least not without a custom invoice report.

#2 - You can type anything you want there, but without re-coding the UI, you can’t add anything to the drop down list. That would be a good case for an RFE. And on that note, I’m not sure why the column is even there if you can’t use it to generate sub-total lines per your Question 1.

#3 - I’m not familiar with this, but others can help. There are limitations. You can grab transactions from the bank, but I don’t think you can create them from within GnuCash. From reading list threads I think more people opt to download from the bank separately in CSV format and then import rather than link directly, but certainly some do.

#4 - Again, not without re-coding the UI. But you can put them in the description field.

GnuCash isn’t set up for inventory based businesses at least insofar as providing any inventory tracking facility. That can be handled outside of GnuCash and then the resulting transactions imported. If you put the part # in the description, and don’t “consolidate splits” when you post invoices, the AR (and income) register will show the individual line items and from there you can run transaction reports filtering off of part #’s or other terms in the description. Unfortunately, the Action Items column is not exposed in AR, but you can post to separate income sub accounts. You could set one up for Labor, Parts, Shop Supplies, etc. This would also make the P&L/Income Statement more informative as to where the revenue is coming from.

Likewise, invoices can be imported to GnuCash. So if your friend wanted to still handle AR with GnuCash, you can create the invoices as needed in a spreadsheet or other app and then import them. Check the Help & Guide about importing business data.

Regards,
Adrien

> On Jan 19, 2020 w4d19, at 4:16 PM, Martijn Heuts <usadutchies at bellsouth.net> wrote:
> 
> Hello,
> I just helped a friend with GNUcash (I am a current user as well) however his situation is completely different then mine soI have some questions, maybe you guys can help me?
> Question 1:Can I make a summery at the bottom of an invoice with "Total Parts" and "Total Labor"?He itemizes every single 'part' on his invoice and might have 2 or 3 line items of 'labor'.
> Question 2:I also noticed the column "Action Items" I can select 'Hours'  or 'materials' or 'Project'.Can I add more items to the "Action Items" column and how can I utilize this in a report?
> 
> Question 3:How can I link his bank account to GNUcash?
> .Question 4:
> Is there any way I can add an extra column when I select "new invoice" for part numbers?
> Thanks so much for your help and have a blessed week!
> Martijn