Send a new invoice data from Books to local certified solution via API json due local compliance
Greetings,
I hope you are doing well and staying safe.
Due to local compliance regulations, I am required to issue invoices exclusively using locally certified software, which Zoho Books is not. However, we would like to continue using Zoho Books, so we need to send invoice data to an external certified solution each time a new invoice is issued. This external system should automatically generate a corresponding invoice, essentially mirroring the one created in Zoho Books.
I have access to the API documentation for the external certified solution and have attempted to create a custom function to extract invoice data, format it in JSON, and send it to the external system. However, due to my limited knowledge, I have been unable to save the custom function successfully, as the Deluge editor consistently flags syntax errors.
The API documentation for the external solution can be found here: https://api.factplus.co.ao/documentation/
Below are some of the approaches I have attempted:
===
void EnviarFctraParaFctpls( Map invoice, Map organization, Map user )
{
// A função já recebe os detalhes da fatura e organização como 'invoice' e 'organization'
// Não precisamos usar zoho.books.getRecordsByID para os dados básicos da fatura.
// Usaremos 'invoice' diretamente.
// 1. Extrair Detalhes da Fatura (diretamente do 'invoice' Map)
invoiceData = invoice; // 'invoice' já é o mapa com os dados da fatura
organizationId = organization.get("organization_id"); // ID da sua organização no Zoho Books
invoiceNumber = invoiceData.get("invoice_number");
invoiceDate = invoiceData.get("date"); // Formato 'YYYY-MM-DD'
dueDate = invoiceData.get("due_date"); // Formato 'YYYY-MM-DD'
reference = invoiceData.get("reference_number"); // Pode usar o número de referência do Zoho Books
currency = invoiceData.get("currency_code");
// observation = invoiceData.get("notes"); // Supondo que 'notes' seja para observações
// ATENÇÃO: Verifique na documentação do Factplus como lidar com 'retention'.
// Se o Zoho Books não tiver um campo direto para 'retention', você pode precisar de lógica extra
// ou definir como "0" se não for aplicável no seu caso.
retention_value = "0";
// Dados do Cliente
customerData = invoiceData.get("customer_details");
clientName = customerData.get("customer_name");
clientNIF = customerData.get("vat_reg_no"); // Assumindo que NIF seja o VAT Registration Number
clientEmail = customerData.get("email");
clientCity = customerData.get("city");
clientAddress = customerData.get("billing_address").get("address"); // Endereço de fatura
clientPostalCode = customerData.get("billing_address").get("zip"); // CEP de fatura
clientCountry = customerData.get("billing_address").get("country"); // País de fatura
// Itens da Fatura
lineItems = invoiceData.get("line_items");
factplusItems = collection(); // Coleção para armazenar os itens formatados para o Factplus
for each item in lineItems
{
// Para itemcode, é ideal usar um ID que seja único e identificável no Factplus.
// item.get("item_id") é o ID interno do Zoho Books, o que pode não ser ideal se o Factplus
// espera um código de item de produto/serviço. Considere usar item.get("name") ou um campo personalizado.
itemCode = item.get("item_id");
description = item.get("description");
price = item.get("rate");
quantity = item.get("quantity");
taxRate = item.get("tax_percentage"); // Taxa de imposto
discount = item.get("discount"); // Desconto por linha de item
// ATENÇÃO: exemption_code e retention por item precisam ser verificados na API do Factplus.
exemptionCode = ""; // Valor padrão, ajuste se tiver campo correspondente
itemRetention = "0"; // Valor padrão, ajuste se tiver campo correspondente
factplusItem = Map();
factplusItem.put("itemcode", itemCode);
factplusItem.put("description", description);
factplusItem.put("price", price);
factplusItem.put("quantity", quantity);
factplusItem.put("tax", taxRate);
factplusItem.put("discount", discount);
factplusItem.put("exemption_code", exemptionCode);
factplusItem.put("retention", itemRetention);
factplusItems.add(factplusItem);
}
// 2. Construir o Objeto JSON para a API do Factplus
// ATENÇÃO: SUBSTITUA 'SUA_CHAVE_API_AQUI' PELA SUA CHAVE DE 32 DÍGITOS DO FACTPLUS
factplusPayload = Map();
factplusPayload.put("apicall", "CREATE");
factplusPayload.put("apikey", "SUA_CHAVE_API_AQUI"); // <-- SUA CHAVE API DO FACTPLUS AQUI!
documentMap = Map();
documentMap.put("type", "factura"); // Tipo de documento, confirme se "factura" é o correto
documentMap.put("date", invoiceDate);
documentMap.put("duedate", dueDate);
documentMap.put("vref", invoiceNumber); // Usando o número da fatura como referência. Verifique se o Factplus aceita este formato.
// A "serie" é crucial. O exemplo do Factplus mostra "2020". Você precisa definir uma série apropriada.
// Se o Zoho Books não tiver um campo para série, pode ser um valor fixo ou derivado.
documentMap.put("serie", "2024"); // <-- ATENÇÃO: Defina a série correta para o Factplus (ex: "2024", "FS_A")
documentMap.put("currency", currency);
documentMap.put("exchange_rate", "0"); // Ajuste se houver taxa de câmbio
// documentMap.put("observation", invoiceData.get("notes")); // Se usar campo de notas
documentMap.put("retention", retention_value);
clientMap = Map();
clientMap.put("name", clientName);
clientMap.put("nif", clientNIF);
clientMap.put("email", clientEmail);
clientMap.put("city", clientCity);
clientMap.put("address", clientAddress);
clientMap.put("postalcode", clientPostalCode);
clientMap.put("country", clientCountry);
factplusPayload.put("document", documentMap);
factplusPayload.put("client", clientMap);
factplusPayload.put("items", factplusItems);
// Converter o mapa Deluge para string JSON
jsonString = factplusPayload.toString();
// 3. Fazer a Chamada HTTP POST para a API do Factplus
// ATENÇÃO: Você PRECISA substituir "https://api.factplus.co.ao" pelo ENDPOINT COMPLETO
// da API do Factplus para a criação de faturas.
// Ex: "https://api.factplus.co.ao/v1/invoices" ou similar.
factplusAPI_URL = "https://api.factplus.co.ao"; // <-- SUBSTITUIR PELO ENDPOINT ESPECÍFICO DE CRIAÇÃO DE FATURA
// Cabeçalhos (Content-Type é essencial para JSON)
headers = Map();
headers.put("Content-Type", "application/json");
// Executar a chamada API
apiResponse = invokeurl
[
url : factplusAPI_URL
type : POST
headers: headers
content : jsonString
];
// 4. Tratar a Resposta da API
info "Request sent to Factplus: " + jsonString; // Para depuração, mostre o que foi enviado
info "Factplus API Response: " + apiResponse;
// Adicione lógica para verificar a resposta aqui.
// Ex: if (apiResponse.get("status") == "success") { ... }
// ou if (apiResponse.get("code") == 200) { ... }
// Logar erros se a resposta indicar falha e talvez enviar um email de alerta.
if (apiResponse.get("status") == "success") // Supondo que a API retorne um campo 'status'
{
info "Fatura enviada com sucesso para o Factplus!";
// Opcional: Atualizar a fatura no Zoho Books com um campo de status "Enviado para Factplus"
// Ou armazenar o ID de retorno do Factplus.
}
else
{
error "Erro ao enviar fatura para o Factplus: " + apiResponse.get("message"); // Supondo campo 'message'
// Opcional: Enviar email de erro para o cliente ou para o administrador
}
}
===
And
===
// Função para enviar fatura do Zoho Books para o Factplus
// Parâmetro: invoice_id (ID da fatura criada)
invoice_id = input.invoice_id;
// Obter detalhes da fatura do Zoho Books
invoice = zoho.books.getRecordsByID("Invoices", organization_id, invoice_id);
invoice_data = invoice.get("invoice");
// Mapear dados do cliente
customer_id = invoice_data.get("customer_id");
customer = zoho.books.getRecordsByID("Contacts", organization_id, customer_id);
customer_data = customer.get("contact");
client_map = Map();
client_map.put("name", customer_data.get("contact_name"));
client_map.put("nif", customer_data.get("tax_reg_no", ""));
client_map.put("email", customer_data.get("email", ""));
client_map.put("city", customer_data.get("billing_address").get("city", ""));
client_map.put("address", customer_data.get("billing_address").get("address", ""));
client_map.put("postalcode", customer_data.get("billing_address").get("zip", ""));
client_map.put("country", customer_data.get("billing_address").get("country", "Angola"));
// Mapear itens da fatura
items_list = List();
for each item in invoice_data.get("line_items")
{
item_map = Map();
item_map.put("itemcode", item.get("item_id", "ITEM" + item.get("line_item_id")));
item_map.put("description", item.get("name"));
item_map.put("price", item.get("rate").toString());
item_map.put("quantity", item.get("quantity").toString());
item_map.put("tax", "14"); // Ajuste conforme a tributação aplicável
item_map.put("discount", item.get("discount", "0").toString());
item_map.put("exemption_code", "");
item_map.put("retention", "");
item_map.put("unit", "Unidade");
items_list.add(item_map);
}
// Construir o corpo da requisição para o Factplus
payload = Map();
payload.put("apicall", "CREATE");
payload.put("apikey", "SUA_CHAVE_API_FACTPLUS"); // Substitua pela sua chave de API
document_map = Map();
document_map.put("type", "factura");
document_map.put("date", invoice_data.get("date"));
document_map.put("duedate", invoice_data.get("due_date"));
document_map.put("vref", invoice_data.get("invoice_number"));
document_map.put("serie", invoice_data.get("date").left(4)); // Ano da fatura
document_map.put("currency", "AOA");
document_map.put("exchange_rate", "0");
document_map.put("observation", "");
document_map.put("retention", "0");
payload.put("document", document_map);
payload.put("client", client_map);
payload.put("items", items_list);
// Enviar requisição para o Factplus
headers = Map();
headers.put("Content-Type", "application/json");
response = invokeurl
[
type: POST,
parameters: payload.toString(),
headers: headers,
connection: "FactplusAPI"
];
// Logar a resposta para depuração
info response;
===
Any help?
Thanks in advance.
Access your files securely from anywhere
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
ViSFe
Selina Peter
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Set Default Status of Assembly to "Assembled" When Entered in UI
I've just discovered the new "confirmed" status of Assemblies within Inventory. While I understand the intent of this (allowing for manufacturing planning and raw material stock allocation), it was initially confusing to me when manually entering someHow to apply customized Zoho Crm Home Page to all users?
I have tried to study manuals and play with Zoho CRM but haven't found a way how to apply customized Zoho CRM Home Page as a (default) home page for other CRM users.. How that can be done, if possible? - kipi Moderation Update: Currently, each user hasPlug Sample #14: Automate Invoice Queries with SalesIQ Chatbot
Hi everyone! We're back with a powerful plug to make your Zobot smarter and your support faster. This time, we're solving a common friction point for finance teams by giving customers quick access to their invoices. We are going to be automating invoiceEnrich your contact and company details automatically using the Data Enrichment topping
Greetings, I hope you're all doing well. We're happy to announce the latest topping we've added to Bigin: The Data Enrichment topping, powered by WebAmigo. This topping helps you automatically enhance your contact and company records in Bigin. By leveragingZoho Billing Partial Proration...
Hi, In Zoho billing, we offer upgrades, downgrades, suspends, and resumes. We use online payment for most subscriptions, but have only a few that are offline, but we treat them the same either way.. We prorate only parts of these changes.. Right now zohoAny update on adding New Customer Payment Providers who support in store terminal devices?
Currently there is only one Customer payment provider listed for terminal devices in USA- Everyware. They charge a monthly fee of almost $149 minimum. Will you add other providers - like Zoho Payments or Stripe or Worldpay that would allow integratedGetting Subform Fields to Display Top to Bottom
I have a form where the fields are all in one column. I want to insert a subform where the fields are stacked in one column as well. I have built both the form and subform but the subform displays the fields from left to right instead of a stacked column. This will cause a problem displaying the subform correctly on mobile apps. How can I do this please?' Here is my form with subform now. As you can see the subform "Follow Up Activity" is displaying the fields left to right. I need them to go top[Feature Deprecated] Gamescope in Zoho Projects
This feature is no longer available. All work and no play makes Jack a dull boy. Well, yes. That's true! Tiring work, buzzing coffee makers, busy turnstiles , occupied meeting rooms, back-to-back status updates and what not. Your everyday routine need not have to be this hectic. It can be more rewarding. It can be more fun. Zoho Projects believes in this fact and hence has launched Gamescope - A module that turns every project into an exciting game and boosts the spirit of your team by leaps andCreating a task, i can not work out how to get ID for What_Id
hi From Module A function I map Module B record reference membershipid (ours). I need Module B Zoho ID to create the related to on task. All examples i've seen start with the Zoho ID. void automation.LTM_Assign_Dispute_Task(String membershipid) { tryHow to Convert NSF to PST Format Effortlessly? - SYSessential
It is highly recommended to obtain the error-free solution of the SYSessential NSF to PST converter to convert NSF files from Lotus Notes. Using this professional software, it becomes easier to convert all NSF database items, including emails, journals,Can't connect to POP and SMTP over VPN
I use Thunderbird to access Zoho Mail via POP and SMTP. I have configured an app-specific password for Thunderbird to use. Everything is properly configured and works correctly — until I enable my VPN. I'm using a paid commercial VPN service (Mullvad).my zoho mail is hacked
my email is sending my username and password to people i dont knowSuministrar accesos
Asunto: Enable UPLOAD_RULE for API Attachments Mensaje: Hola, Necesito habilitar la capacidad de subir attachments vía API en Zoho Mail. Actualmente recibo el error: "UPLOAD_RULE_NOT_CONFIGURED" al usar el endpoint: POST /api/accounts/{accountId}/messages/attachmentsIntroducing real-time document commenting and collaboration in Zoho Sign
Hi, there! We are delighted to introduce Document commenting, a feature that helps you communicate with your recipients more efficiently for a streamlined document signing process. Some key benefits include: Collaborate with your recipients easily withoutTicket Loop from Auto Responce
We’re seeing an issue where a client’s help desk triggers a ticket loop. When they email us, our system creates a ticket and sends the acknowledgement. Their system then creates a ticket from that acknowledgement and sends one back to us, which createsSaving issue
First problem I opened a MS word file in writer. after the work is done, it does not save instantly, I waited for like 10min and it still did not save. second problem When I save a file, then file gets saved as another copy. I just did save, not saveHow to make rule to filter out some emails from receiving the notification "Receiving a new ticket"?
Good Morning, We are currently using the "Receiving a new ticket" notification rule to provide that auto reply template to a customer that emails us for support. However, there are some emails we don't want to receive this auto-reply. Where can I setZoho Signatures Missing
In the past after collecting signatures from two different PDFs I would merge them by calling an api and the signatures would appear in the combined PDF. Recently the signatures have disappeared whenever I combine the PDFs together. Why did this randomlyStop the Workarounds: We Need Native Multi-Step Forms
After over 17 years of community requests, I'm hoping the Zoho team can finally address the lack of native multi-page form support in Zoho Creator. This has been one of the longest-standing feature requests in the community, with threads spanning nearlyFilter button in the Zoho Sheet Android App doesn't toggle on
I am a new Zoho Sheets user and experiencing a specific issue with the filter functionality in the Android mobile application. Detailed Issue Description: The filter icon appears correctly in the toolbar. Upon tapping the filter icon/button, the toggleAutomate pushing Zoho CRM backups into Zoho WorkDrive
Through our Zoho One subscription we have both Zoho CRM and Zoho WorkDrive. We have regular backups setup in Zoho CRM. Once the backup is created, we are notified. Since we want to keep these backups for more than 7 days, we manually download them. TheyExciting Updates to the Kiosk Studio Feature in Zoho CRM!
Hello Everyone, We are here again with a series of new enhancements to Kiosk Studio, designed to elevate your experience and bring even greater efficiency to your business processes. These updates build upon our ongoing commitment to making Kiosk a powerfulReply to Email for SO/PO
Hello, We are new to Zoho Books and running into an issue. Our support@ email is our integration user. When our team is sending out PO/SO's we are updating the sender email, but for some reason many of our responses are coming back to our support@ emailNew activity options for workflows
Greetings, We are excited to announce the addition of two new dynamic actions to our workflow functionality: Create Event and Schedule Call. These actions have been thoughtfully designed to enhance your workflow processes and bring more efficiency toRemove the “One Migration Per User” Limitation in Zoho WorkDrive
Hi Zoho WorkDrive Team, Hope you are doing well. We would like to raise a critical feature request regarding the Google Drive → Zoho WorkDrive migration process. Current Limitation: Zoho WorkDrive currently enforces a hard limitation: A Zoho WorkDriveKaizen #228 - Process Large-Scale Migrated Data Using Catalyst Solutions
Howdy, tech wizards! This week’s Kaizen explores how Catalyst Solutions in the Zoho CRM Developer Hub help import large volumes of data into Zoho CRM while improving data quality and simplifying the migration process. Why Catalyst Solutions? CatalystZoho Expense Import Reports Won't Work Because Default Accounts Already Exist
Im trying to import reports from another Zoho expense account to mine and im getting errors that won't allow the import to happen The account name that you've entered 'Ground Transportation' already exists. Enter another name for the account and try again.zInactive License for free account.
I recently upgraded my Cliq subscription not my team (on the free version), are unable to login to their accounts. The error message received is Inactive License Looks like you have not been covered under the current free plan of users. Please contactMake panel configuration interface wider
Hi there, The same way you changed the custom function editor's interface wider, it would be nice to be able to edit panels in pages using the full width of the screen rather than the currently max-width: 1368px. Is there a reason for having the configuration panel not taking the full width? Its impossible at this width to edit panels that have a lot of elements. Please change it to 100% so we can better edit the layouts. Thanks! B.2026 Product Roadmap and Upcoming Features
This is your guide to what is coming in Zoho Vertical Studio throughout 2026. We’ll update this post throughout the year as items move from development to release, and as and when new initiatives are added. Once a feature is released, it will be reflectedSyncing zoho books into zoho crm
I was wondering how I can use zoho books in crm as I have been using them separately and would like to sync the two. Is this possible and if so, how? ThanksAnnouncing new features in Trident for Mac (1.34.0)
Hello everyone! We’re excited to introduce the latest updates to Trident, which are designed to take workplace communication to the next level. Let’s take a quick look at what’s new. Connect with customers using Zoho Voice integration. You can now easilyMassive Zoho Books failure
We have not received any communication or notification from Zoho, but we have detected that Zoho Books is not working for all our users. We cannot access or use Zoho Books. This is critical. We are trying to contact Zoho on the Spain telephone number,The Social Wall: January 2026
Hello everyone, We’re back with the first edition of The Social Wall of 2026. There’s a lot planned for the year ahead, and we’re starting with a few useful features and improvements released in January to help you get started. Create a GBP in SocialHow to block whole domain?
I am getting at least 50-75sometimes over 100 spams emails a day. I see a lot of the spam is coming from .eu domains. I would like to block /reject all email coming for the .eu domain. I do not have any need for email from .EU domains. Why won't the BlackListHow Zoho Contracts Makes Negotiations Clear, Secure, and Transparent
Negotiation is one of the most critical—and often most chaotic—stages of the contract lifecycle. Multiple stakeholders review the same document, propose changes, debate terms, and exchange feedback. Without the right tools, this collaborative processError: Invalid Element tax_override_preference
In both Books and Inventory, we're getting the following error whenever we try to enter any Bill: I think this is a bug. Even cloning an old bill (that obviously was entered just fine), this error occurs.Assign Income to Project Without Invoice
Hello, Fairly new user here so apologies if there is a really obvious solution here that I am just missing... I have hundreds of small deposits into a bank account that I want to assign to a project but do not want to have to create an invoice every timeHow to Print the Data Model Zoho CRM
I have created the data model in Zoho CRM and I want the ability to Print this. How do we do this please? I want the diagram exported to a PDF. There doesnt appear to be an option to do this. Thanks Andrewour customers have difficult to understand the Statements
our costumers have big problems to understand Zohos Statements. we need a text box after the payment number to explain what the payments are for. Is it possible to develop a version of the Statement with that kind of box and if so whu can do itNext Page