How to enter stock serial wise and track sales wise ?
Hi, Im buying the year subscription and Im from India. We are a small trade agency, who buys items in quantity and then sells to customers. For example, I bought 100 routers today. I need to enter the 100 stock to Zoho Books serial number wise. So, whats while creating the sale, I can simply enter the serial number and it automatically deducts that exact serial item from the stock. Is it possible with Zoho Books ?
thank you note error
there seems to be some problem with the thank you note email the invoice number placeholder is not working
Lookup Custom Field
Hello Guys Is it possible to create custom field in Zoho Books with data type as lookup? I have not seen the option in the dropdown. If not is there a way around to include some item in my Invoice as my part of my custom field? To elaborate- I wish to create a custom field with type as Auto Generate Number where prefix shall be customer name and auto generating number shall start from 1. So I would come to know number of invoices generated for each customer. My another query is related to newly introduced
Invoice entry layout
Nice to see the white space being used more efficiently :-) Am I missing it or has the "Exclusive or Inclusive" of tax been omitted ?? I have 11 Custom fields of which 5 are mandatory - it would be nice to have these grouped at the top of the seperated custom fields so that there is less tabbing required (Choosing the sequence would be ideal) :-) !
Go Cardless integration
Does anyone know if anyone has ever created an integration from Zoho Books with the UK direct debit handler Go Cardless? www.gocardless.com
Bank statement
How to withdraw a statement of account statement for the cash and bank accounts? An extract report identical to the customer statement.
item Creation help
Hey Zoho experts, Can you please tell me what's wrong with the following code, it executes successfully but the indicated code in red does not produce the required results ? .... Item_Details = Map(); Item_Details.put("product_type","goods"); Item_Details.put("item_type","inventory"); Item_Details.put("purchase_rate",pr); Item_Details.put("tax_id",""); Item_Details.put("unit",Unit); Item_Details.put("rate",rate); Item_Details.put("account_name","Sales"); Item_Details.put("name",newRange); Item_Details.put("tax_percentage",0);
Bills from Docs
Docs features are continuing to evolve nicely but some small enhancements would be appreciated.... Docs | Add to New bill.... Then select Purchase order outstanding & all works fine except that we then need to select the tax rate unnecessarily as it's already selected in the item details & on the purchase order itself & with 10+ items in the PO this becomes tedious ! It would be nice to be shown any difference in value between the PO & Bill so that we can accept & save or query the bill ?
Aging Details By Bill Due Date: Group by Due Date
Please add the ability to sort / group the A/P aging report by due date. currently, we have to add this column to the report and it does not allow us to sort or group by the due date. We need to filter by month of payable not all of the outstanding bills. ~Ideally, this is how it would show on our Dashboard also instead of only grouped by overdue or current. Thanks! -Gina
Inventory adjustments - feature request
I would like to be able to adjust all items on a single screen when we do year-end inventory. Quickbooks does this by showing an alphabetical list of all items (or you can sort by description) with a column showing the stock on hand amount and an empty column where you enter how many you actually have per the count. When you have several hundred items or more, this saves us from having to adjust each one individually
Footer in Statement
Is it possible to add a footer to customer statements?
Custom views for Items
Whoooeeee, just as promised - arrived on time in (nearly) good working order :-) ...... I know we forced a rush on this guys but can we get a bit more into the filter criteria, such as inventory, non-inventory items, service items, usage unit*** etc, this along with a column width for the item table would be fantastical additions :-) The column layout with minimal required fields looks dreadful due to the lack of column width control, the name is very bunched up with lots of wasted space :-((((((
When creating or matching an expense, provide option to account for sales tax
Hi Team, We're really loving Books and its integration with Inventory! One area, however, that we seem to struggle with is the ability to separate the cost of goods or services and the associated sales tax when manually creating or matching expenses. For our accounting and tax purposes it's important for us to be able to clearly identify the sales tax that we have paid on all receipts. The only workaround I can think of is to manually enter two separate expenses for a single receipt: one for the
Rate table item or the Item's default sales pricing is not applied when converting Bills to Invoices.
We have default pricing for line items and we have rate tables with specific pricing. Currently when creating an invoice the Item's default sales pricing or the rate table's sales pricing is automatically entered for the specific customer. That is what is expected and works great. But when creating an invoice from a Bill, the customer's sales pricing is not applied, instead the bill's, or vendor's, pricing on the bill is carried over, This is not an expected behavior!!! When using items and rate
Searching bills & expenses for monetary values
Value amount search, ie 320.00 ?? All that happens is .... Bills.... P.O.# contains 320.00 (or) Bill# contains 320.00 (or) Vendor Name contains 320.00 Expenses.... Reference# contains 320.00 (or) Notes contains 320.00 (or) Customer Name contains 320.00 (or) Vendor Name contains 320.00 (or) Expense Account contains 320.00 How come amounts are not being searched without using an advanced search, surely a numerical entry with decimals would indicate what your search is for
Problem in zoho
Hi I face a big problem in my Profit and loss Report When I checked the operation expenses I found some cost of good sold for some invoices recorded in Sample Exp ( sample expenses account ) I don't know why?!! and when I check the items of these invoices I Checked the Account sales in Purchase information I found it Cost Of Good Sold. Thanks.
Workflow rules
I have a workflow rule which notifies of any invoices that have our own status changed using a custom field of type dropdown which acts as our own invoice status. This should only fire if the invoice status is still "Draft" but does so in any state ? Have I set it up incorrectly or is it an error ?
REST API for Creator is not working in zoho books
Hi I wrote a custom function in books which adds a new record in zoho creator by REST API.It was working fine. But Today I faced an error called Error due to -'1'. I don't know to solve this. The error looks awkward as it is meaningless. I tried API Integration method it works but there is no integration method for delete a record in creator which makes me sad. My code is dataMap = Map(); dataMap.put("authtoken","******************"); dataMap.put("scope","creatorapi"); creator_api = postUrl("https://creator.zoho.com/api/owner_name/json/books-estimation/form/Items/record/add/",dataMap);
Retainer Invoice tracking and reporting
We need more retainer invoice tracking and reporting It would be nice to have a report that has Sent Retainer invoices and Sent Invoices all in 1 report. This shows the actual invoices that are in process - I need to see a total for these 2 together.
How to book the following transactions?
Hi I'm trying to figure the bookkeeping part myself. Firstly I know I should separate business and personal expense/income ideally now. But i wasn't before. so I'm trying to see how i can record this in the book but moving forward of course its much easier. Scenario 1: Credit Card (Personal Credit Card) / Personal Saving Account - imported Personal credit card feeds into zoho (this is used as personal and business expense Q1. How do I record personal expense on the book? if I don't want to show in
Deposits versus A/P
I paid a vendor $500,000 USD in deposits. Then every week we pay the vendor a certain amount for invoices received. Vendor said that they do not want to mix the deposits with the ongoing A/P payments, ... how can I book these entries separately for the
Listener Event When Sales Order State Passes to Open
Hey guys, I would like to, whenever a Sales Order state is passed from draft to open, I would like to execute some code I have on my personal app. Is this possible? Basically, whenever a Sales Order state goes to open, I need to generate a document from another website via their API with some information from the Sales Order. And the API code for the other website is on my app. Is this possible?
Need a separate Balance column in Bank Accounts
Would be great to have a separate Balance column in Bank Accounts which will ease the process of reconciliation when onboarding Zoho books from manual accounts.
New items tabs
Whilst reviewing Low stock items, I've noticed the following inconsistencies.... If editing & removing the reorder point value as it's no longer needing a reorder value, saving it successfully removes it from the Low stock items list but sets the filter back to "Active items" - not the desired result ! Trying to set the Reorder level from the Overview page only allows a zero value which does NOT remove it from the Low stock items list, a blank value cannot be Saved - not the desired result ! Also
Foreign Currency used on trip & After trip how can adjusted in books of account
Hallo Sir, I have purchased Currency of Other Country for foreign trip vide my bank account and on the purchase of currency, posted in my books of account as currency of other country under the head of other asset and adjusted my bank account. So the currency of other country shown under the other asset head in balance sheet on that purchase date to till date. After I return back from foreign trip after few days, how can i adjusted my expenses incurred vide foreign currency with my book with effect
The input file does not conform with CSV/TSV file format.
I am trying to import a bank statement which I have converted from Excel to a .csv file. I'm receiving the statement "The input file does not conform with CSV/TSV file format. Please check the content and try again." and I'm not being allowed complete the import. Please advise.
How do I apply a Square charge to existing customer invoice?
A customer has an estimate. They make an in person chip credit card payment through Square for the retaining invoice (20%) converted off the estimate. How do I now apply the square payment to the retaining invoice? There is a Square invoice already created and it won't let me remove the invoice without deleting the payments. We want to be able to meet with customers and allow them to pay on the spot or via the portal at their convenience. So I assumed we could just associate a square payment with
How to record cheque deposits?
Hi, I operate an import business. I import mainly beers which arrive via a 40 foot container by sea. When a container arrives in my country I have to pay for the service of the shipping agent. This same shipping agent also charges an additional €360 security deposit for the container before the container is released to me. This deposit is refunded back to me within a matter of 4 weeks after the container is returned back to them. How do I record these types of transactions in Zoho books? The answer
error message "fallen below Re-order point"
One of my stock items, which has no purchase or sales history yet, keeps getting recognized as needing to reorder. I get daily messages about this, but the inventory is zero and no reorder amount given. Is there a way to fix this without having to delete that item and reenter it?
sending 15 expenses receipt swith invoice to the customer
Hi, I managed to scan my expenses receipts and attached them to expenses linked to a customer and to to project while on the road. great Zoho Books then at the end of each week, i need to send to the customer one invoice with all the expenses of the week. great again Zoho Books with all the 15 or so expenses linked to one expense invoice. But then my customers ask for a copy (pdf) of each expenses receipt... I do have them in Zoho books but i can only link 5 of them to an invoice. How do i do that
Api request using postman
how to generate filter based(lets say created time) api request to fetch contacts in zoho books?
Manage VAT return in Spain
Hi, how i can manage the VAT return ? I cant see the otions related on this link: https://www.zoho.com/books/help/settings/vat.html Regards
New items tabs
Love the new tabs, massive improvement, it's really exciting where you Zoho guys are taking this software :-) - Overview, Purchases, Adjustments & History - love it :-) One question : Zoho seem to think that we all use sales orders, this is not the case, so why only have a sales order summary, can we please also have an invoice sales summary ? & 1 little niggle - when a filter is active & we click on an item the filter is cleared, not the desired action ??
Clearing custom field values with imports
Still unable to clear all the values in an item custom field by importing the exported data after clearing this columns data! I need to reclaim this custom field for a different use as I've reached maximum, can you let me know when a fix will be available please guys ?
inventory cadastre of fixed assets of the company (Fixed)
Please can someone tell me how can I register my fixed means? and how can I make the repayments? Knowing that a company has to make the control of the inventory of the company's assets and then have the time period that will be amortized, please I want to have this my record in my accounts
çan I set a discount % for individual customers in the contact page?
Hi, We give customers discount on every purchase they make. Some large dealers reveive 30% and some others only 5%. Can we fix this discount on customer level? So we dont have to look up their discount percentag everytime. If we select a customer in a estimate or invoice their discountlevel is already filled in. Thanks Robert
Custom views
Out of interest, do you have a time frame for the release of this fantastic feature, specifically to the items & contacts ? Can it be made possible to retain or lock the selected fields for a particular user in any given module as that users preferred view choice ?
Vendor invoice from sales order
Is it possible to create a vendor invoice from a sales order without having to create a purchase order?
reports
I need to get a report of input and output movements. Payments and more receipts I need to take with all availability accounts Bank and cashier.
Change rate per hour without retroactively changing reports
Hi, our organisation sometimes needs to change the rate of a employee in an ongoing project in books, if for instance they get promoted and their rate changes. Currently, I can't see a way of doing this without all reports being retroactively changed with this new rate. Is there a way of freezing a rate, or selecting a rate by date range?
Next Page