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
Can I add Conditional merge tags on my Templates?
Hi I was wondering if I can use Conditional Mail Merge tags inside my Email templates/Quotes etc within the CRM? In spanish and in our business we use gender and academic degree salutations , ie: Dr., Dra., Sr., Srta., so the beginning of an email / letterZoho mail account ownership transfer
We recently took over another company and have assumed responsibility for its Zoho account, including Zoho Mail and all related services. We would like to formally transfer ownership of this account to our organization. Could you please outline the completeEmail Authentication is Failing
I'm trying to setup gitlab with email authentication. I used the following configs picked up from: https://docs.gitlab.com/omnibus/settings/smtp/ gitlab_rails['smtp_enable'] = true gitlab_rails['smtp_address'] = "smtp.zoho.com" gitlab_rails['smtp_port']DMARC reports for mail I didn't send: how to deal with?
I know the enthusiastic amateur's bare minimum about e-mail; am able to set up a Thunderbird account and know the basic acronyms. I have a Zoho Mail account connected to my domain, and have set up SPF, DMARC and DKIM successfully according to Zoho's instructionms
Email set up for communicationFix the speed
It takes ages to load on every step even though my dataset is quite small.Capture Bank Charges for Invoice Payments
We've added the Bank Charges field in the "Add Payments" page both in Zoho Invoice & Zoho Books. So all you need to do is to enter the bank charges when you record a payment for the invoices. This bank charge will be included to the amount paid for that invoice. Steps to add the bank charges while you record the payment: 1. Click the "Invoices" sub-tab under the "Money-In" tab. 2. Click the 'add payment' link for the invoice that you wish to record the payment for. 3. On the addConditional Layouts On Multi Select Field
How we can use Conditional Layouts On Multi Select Field field? Please help.Image field in custom module
Hi guy, Is there any hope of adding a custom image field in the custom module? We created a custom module to keep track of assets, and it would be helpful if we could attach an image to the record. Thanks RudyDeluge Function to Update Custom Field
I'm trying to get a Deluge function (which will run as part of a Schedule in Desk) that retrieves all tickets with the status "Recurring" and updates the custom field checkbox "cf_recurring" to "true". Here's what I have, which doesn't work: searchValue"View ticket" link is broken
The "View ticket" link in our Zoho ticketing system confirmation emails is broken (please see attached). Impacts ability to update/review details, and, refresh recollection at a later date. Any help would be much appreciated.import data from Apollo.ai into zoho crm via zoho flow
I might be asking this question in the wrong forum. We use Apollo.ai to find potential new leads for our business, there are around 10000 leads that we have initially found. We have an Apollo.ai account but just to do searches, we dont use it as a crm.Woocommerce Line Item Information
I'd like to add each line item from a Woocommerce order to a zoho creator form record. The line items are found within the line items array, but I'm not sure how to get each item out of the array? Any help would be much appreciated.Synching changes to Stripe when changes are made in Zoho Billing
We have a situation where we have merged customers in Zoho BIlling and then found out later that the payment in Stripe was not updated and still associated with the old customer record. The card gets updated and billed, but that payment is still associatedHow do I fix this? Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked.
How do I fix this? Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked.Disable Smart Filters By Default
The smart filters "feature" is causing confusion for Zoho Mail users. New emails should be delivered to the inbox unless they have specifically opted to redirect them somewhere else. People don't understand that new emails might be waiting in a randomME SALE ESTE ERROR: No fue posible enviar el mensaje;Motivo:554 5.1.8 Email Outgoing Blocked
Ayuda!! Me sale este error al intentar enviar mensajes desde mi correo electronico de Zoho! Tampoco recibo correos pues cuando me envia rebotan. Ayuda, Me urge enviar unos correo importantes!! Quedo atenta MAGDA HERNANDEZ +5731120888408Client Script | Update - Client Script Support For Custom Buttons
Hello everyone! We are excited to announce one of the most requested features - Client Script support for Custom Buttons. This enhancement lets you run custom logic on button actions, giving you greater flexibility and control over your user interactions.Zoho Mail not working
Zoho Mail not workingQueries on Project-Based Inventory Consumption and Proforma Invoice in Zoho ERP
We would appreciate your clarification on how Zoho ERP plans to handle the following: Project-based inventory consumption without itemized sales orders Accurate project cost tracking along with inventory reduction Proforma Invoice usage We look forwardI can't add a new customer in Zoho invoice? Anyone had this issue before?
Ive been using Zoho invoice for over 6 years. Today I wanted to add a new customer to send an invoice to but it doesn't save when I try to access it from the pulldown menu when you go to send a new invoice.Spreadsheet View click & focus issue in Arabic (RTL) localization
Hello Zoho Support Team, I am facing an issue in Zoho Creator Spreadsheet View when using Arabic localization (RTL). Scenario: My app supports English (LTR) and Arabic (RTL). I created a Spreadsheet View for a form. In English, everything works correctly.Customer address in Zoho Bookings
Hello, Is it possible to add customer address information to the Zoho bookings appointment screen? Or have it pull that information automatically from the CRM? We are wanting to use this as a field management software but it is difficult to pull the address from multiple sources when it would be ideal to have a clickable address on the appointment screen that opens up the user's maps. It would also be advantageous for the "list view" to show appointment times instead of just duration and bookingGhost email notification on a form
Hello, We have recently encountered an error where I can not see a email notification set up for a form which I am currently the owner, although neither the form nor the notification were created by me. However, neither can the Super Admin access thebulk edit records and run internal logic
hi there is few logics in manner "it this than that" logics work well when i edit entry openning it one by one (via workflow "on add/edit - on success" , for custom field "on update/on user input") but when i try bulk edit records - logic does not work. how can i turn on logic to work as programmed - for mass editing records via bulk edit?Bulk bank rule creatioin
Hi team, I am exploring Option to create a multiple bank rule. Could please suggest the option to implement this?Limitations on editing a message in Cliq
Hi I've checked the documentations and there's no mention of how many times a message can be edited. When trying with code, I get various numbers such as ~1000 edits or so. Please mention if there's a limit on how many times one can change a message viaemail address autocomplete
Is there a way to eliminate certain addresses from showing up in auto complete when entering an address? Many old and unused addresses currently show up, many of which I would like to get rid of. ThanksHow to use MAIL without Dashboard?
Whenever I open Mail, it opens Dashboard. This makes Mail area very small and also I cannot manage Folders (like delete/rename) etc. I want to know if there is any way to open only Mail apps and not the Dashboard.Introducing Radio Buttons and Numeric Range Sliders in Zoho CRM
Release update: Currently out for CN, JP, AU and CA DCs (Free and standard editions). For other DCs, this will be released by mid-March. Hello everyone, We are pleased to share with you that Zoho CRM's Layout Editor now includes two new field formats—How can i download and secure all my mails from the archive folders?
Hi, i would like to download all my mails from my archive folders and secure it on my external HDD. Is this possible? Thx. amirHow to open filtered report in popup using Zoho Creator Deluge?
First report: There is so many records in Report, If I click one record, pop up is occur. Second report (Pop up): there is also so many record data, and this pop up is also Report, not Form. First report: It has got "Sales Order" field. when I click anyCan you default reports/charts to report the current week?
Our data table maintains two years of data. Management wants certain report to automatically filter the report to the latest calendar week. I know I can do this manually with filters but I want the report to automatically default to the latest calendarRendering PDF to view on page
My company upload lots of PDF files onto Zoho. But every time we open it, it downloads the file instead of viewing it on the web page. Does Zoho allow uploaded PDF files to be rendered to view on web page yet? I've been trying to use <embed> or <object> but it cannot be loaded. (similar thread: https://help.zoho.com/portal/community/topic/how-to-open-a-pdf-file-of-a-view-in-preview-mode)Overlapping Reports in Dashboards
It's rare, but occasionally it would be a good feature if I were able to overlap reports, either fully or partially in the Dashboards. Also, then having the ability to move objects to the front or rear, or make them transparent/translucent would be goodFeature request - pin or flag note
Hi, It would be great if you could either pin or flag one or more notes so that they remain visible when there are a bunch of notes and some get hidden in the list. Sometimes you are looking for a particular name that gets lost in a bunch of less importantAdmin guide: Handling Mailbox Settings for better user management
Managing day-to-day email scenarios, such as supporting users with multiple email addresses, ensuring uninterrupted email access during employee absences, enabling secure mailbox sharing, and enforcing organizational security and compliance, can be challengingCisco Webex Calling Intergration
Hi Guys, Our organisation is looking at a move from Salesforce to Zoho. We have found there is no support for Cisco Webex Calling however? Is there a way to enable this or are there any apps which can provide this? Thanks!Designing a practical Zoho setup for a small business: lessons from a real implementation
I recently finished setting up a Zoho-based operating system for a small but growing consumer beauty business (GlowAtHomeBeauty), and I wanted to share a practical takeaway for other founders and implementers. The business wasn’t failing because of lackDKIM (Marketing emails) UNVERIFIED (Zoho One)
I'm having a problem with Zoho One verifying my Marketing Email DKIM Record for MYFINISHERPHOTOS.COM. I have removed and re-entered the ownership, DKIM (Transactional emails), SPF and Marketing DKIM and all of them come back verified except the DKIM (MarketingNext Page