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.
Topic Participants
ViSFe
Selina Peter
Recent Topics
Change of Blog Author
Hi, I am creating the blog post on behalf of my colleague. When I publish the post, it is showing my name as author of the post which is not intended and needs to be changed to my colleague's name. How can I change the name of the author in the blogs?? Thanks, RamananShow Attachments in the customer portal
Hi, is it possible to show the Attachments list in the portal for the particular module? Bests.Please make it easier to Pause syncing
right now it takes 3 clicks to get there. sounds silly, but can you make it just 2 clicks to get it done instead? thats how dropbox does it, 2 clicks to pause instead of 3.Organization Emails in Email History
How can I make received Org Emails to show up here?Converting Sales Order to Invoice via API; Problem with decimal places tax
We are having problems converting a Sales Order to an Invoice via API Call. The cause of the issue is, that the Tax value in a Sales Order is sometimes calculated with up to 16 decimal places (e.g. 0.8730000000000001). The max decimal places allowed inhow to differentiate if whatsapp comes from certain landing page?
I create a Zobot in SalesIQ to create a Whatsapp bot to capture the lead. I have 2 landing pages, one is SEO optimized and the other want is optimized for leads comes from Google Ads. I want to know from which landing page this lead came through WhatsAppUpload API
I'm trying to use the Upload API to upload some images and attach them to comments (https://desk.zoho.com/DeskAPIDocument#Uploads#Uploads_Uploadfile) - however I can only ever get a 401 or bad request back. I'm using an OAuth token with the Desk.tickets.ALLHow to sync from Zoho Projects into an existing Sprint in Zoho Sprints?
Hi I have managed to integrate Zoho Projects with Zoho Sprints and I can see that the integration works as a project was created in Zoho Sprints. But, what I would like to do is to sync into an existing Zoho Sprints project. Is there a way to make thatHow to record company set up fees?
Hi all, We are starting out our company in Australia and would appreciate any help with setting up Books accounts. We paid an accountant to do company registration, TFN, company constitution, etc. I heard these all can be recorded as Incorporation Costs, which is an intangible asset account, and amortised over 5 years. Is this the correct way to do it under the current Australian tax regulations? How and when exactly should I record the initial entry and each year's amortasation in Books? GenerallyHow to create a drop down menu in Zoho Sheets
I am trying to find out, how do I create a drop down option in Zoho sheet. I tried Data--> Data Validation --> Criteria --> Text --> Contains. But that is not working, is there any other way to do it. Thanks in Advance.Show Payment terms in Estimates
Hi, we are trying to set up that estimates automatically relates payment terms for the payment terms we introduced on Edit contact (Field Payment terms). How can it be done? Our aim is to avoid problems on payment terms introduced and do not need to introduce it manually on each client (for the moment we are introducing this information on Terms and Conditions. Kind Regards,Rich-text fields in Zoho CRM
Hello everyone, We're thrilled to announce an important enhancement that will significantly enhance the readability and formatting capabilities of your information: rich text options for multi-line fields. With this update, you can now enjoy a more versatileHow can I calculate the physical stock available for sale?
Hey Zoho Team, I've tried to calculate the physical stock on hand in various ways - but always receive a mismatch between what's displayed in Zoho Inventory & analytics. Can you please let me know how the physical stock available for sale is calculated?When dispatched to crew, assigning lead missing
Hello, For the past two or three weeks, whenever an officer assigns Service Appointment to a team, the lead person is missing from the assigned service list. Therefore, we have to reschedule the SA and then the lead person becomes visible in the assignedCreate Lead Button in Zoho CRM Dashboard
Right now to create Leads in the CRM our team is going into the Lead module, selecting the "Create Lead" button, then building out the lead. Is there anyway to add the "Create Lead" button or some sort of short cut to the Zoho CRM Dashboard to cut outopen word file in zoho writer desktop version
"How can I open a Microsoft Word (.doc or .docx) file in Zoho Writer if I only have the file saved on my computer and Zoho Writer doesn't appear as an option when I try 'Open with'? Is there a way to directly open the .doc file in Zoho Writer?"Generate leads from instagram
hello i have question. If connect instagram using zoho social, it is possible to get lead from instagram? example if someone send me direct message or comment on my post and then they generate to leadI want to transfer the project created in this account to another account
Dear Sir I want to transfer the project created in one account to another accountInactive User Auto Response
We use Zoho One, and we have a couple employees that are no longer with us, but people are still attempting to email them. I'd like an autoresponder to let them no the person is no longer here, and how they can reach us going forward. I saw a similarWeekly Tips : Customize your Compose for a smoother workflow
You are someone who sends a lot of emails, but half the sections in the composer just get in your way — like fields you never use or sections that clutter the space. You find yourself always hunting for the same few formatting tools, and the layout justProblem Management Module
I am looking for a Problem Management module within Zoho Desk. I saw in some training videos that this is available, and some even provided an annual price for it. I want an official confirmation on whether this is indeed available. This is not a particularlyZoho Slowness - Workarounds
Hi all, We've been having intermittent slowness and Zoho just asks for same stuff each time but never fix it. It usually just goes away on it's own after a couple weeks. Given that speed is a very important thing for companies to be able to keep up withCustom Bulk Select Button
Zoho CRM offers the ability to select multiple records and invoke a Custom Button This functionality is missing from Recruit Currently we can only add buttons in the detail page and list But we cannot select Multiple Records and invoke a function withHow to create a Zoho CRM report with 2 child modules
Hi all, Is it possible to create a Zoho CRM report or chart with 2 child modules? After I add the first child module, the + button only adds another parent module. It won't let me add multiple child modules at once. We don't have Zoho Analytics and wouldZoho CRM still doesn't let you manage timezones (yearly reminder)
This is something I have asked repeatedly. I'll ask once again. Suppose that you work in France. Next month you have a trip to Guatemala. You call a contact there, close a meeting, record that meeting in CRM. On the phone, your contact said: "meet mePower of Automation :: Smart Ticket Management Between Zoho Desk and Projects
Hello Everyone, A custom function is a software code that can be used to automate a process and this allows you to automate a notification, call a webhook, or perform logic immediately after a workflow rule is triggered. This feature helps to automateFirst day of trying FSM in the field.
What we found. 1. with out a network connection we were unable to start a service call? 2. if you go to an appointment and then want to add an asset it does not seem possible. 3. disappointed not to be able to actually take a payment from within the appBUG - Google Business Buttons - Add a button to GBP Post
I am experiencing an issue with the "Add a button" feature when creating posts for my Google Business Profile (GBP) through Zoho Social. When I schedule or publish a GBP post and include a call-to-action button with a specific URL, the post itself publishesRich text Merge field - Not using font specified in HTML
I have a rich text merge field in a writer template which is creating a table. I have chosen to use this method instead of a repeat region because I need to specify specific cell background colours which change every time the document is created. TheSupport for Custom Fonts in Zoho Recruit Career Site and Candidate Portal
Dear Zoho Recruit Team, I hope you're doing well. We would like to request the ability to use custom fonts in the Zoho Recruit Career Site and Candidate Portal. Currently only the default fonts (Roboto, Lato, and Montserrat) are available. While theseCC and/or BCC users in email templates
I would like the ability to automatically assign a CC and BCC "User (company employee)" into email templates. Specifically, I would like to be able to add the "User who owns the client" as a CC automatically on any interview scheduled or candidate submittedTrying to export a report to Excel via a deluge script
I have this code from other posts but it gives me an error of improper statement, due to missing ; at end of line or incomplete expression. Tried lots of variations to no avail. openUrl(https://creatorapp.zoho.com/<username>/<app name>/XLSX/#Report:<reportname>,"sameZoho Reports Duplicating Entries
I have a custom costing tab with a table where we entre invoices. These are under a Heading (PO Subject) and notes added in the form with different line items. In the reports, I have organised the report to group per PO Subject, with the total of theNeed help to create a attach file api
https://www.zoho.com/crm/developer/docs/api/v8/upload-attachment.html Please help me to create it... It's not working for while. Do you have some example?Export view via deluge.
Hi, Is it possible to export a view (as a spreadsheet) via deluge? I would like to be able to export a view as a spreadsheet when a user clicks a button. Thankshow to add subform over sigma in the CRM
my new module don't have any subform available any way to add this from sigma or from the crmOutdated state in mexico
Hello Zoho team, the drop down to add the state for customers, when they introduce their state in mexico has a city named “Distrito Federal” that name changed many years ago to “ciudad de mexico”. could you please update this so my clients can find theSupport new line in CRM Multiline text field display in Zoho Deluge
Hi brainstrust, We have a Zoho CRM field which is a Muti Line (Small) field. It has data in it that has a carriage return after each line: When I pull that data in via Deluge, it displays as: I'm hoping a way I can change it from: Freehand : ENABLED ChenillePossible to generate/download Quote PDF using REST API?
See title. Is there any way after a quote has been created to export to a PDF using a specified template and then download it? Seems like something that should be doable. Is this not supported in the API v2.0?Creating an invoice to be paid in two installments?
Hi there, I own a small Photographic Services business and have not been able to find a way to fit my billing system into Zoho, or any other Accounting software. The way my payments work is: 1. Customer pays 50% of total price of service to secure theirNext Page