MICHELE ANNONI

Yes, your point 2 is what I need (JSON as a text in a Global Field). Thank you for your help. I will check the demo file. Michele Annoni

I need to export Sales Orders into a JSON file but I am struggling to write the code (I am new to JSON). I attached a simple FMP file with 3 Sales Orders Head, Sales Order Lines and 3 Customers. The JSON output I need (based on the FMP file attached) is the following. Can anybody help me to write the script to do that? Thank you. Michele Annoni { "ORDER": [ { "Order_Nr": "0001", "Date": "01/10/2023", "Total": "100.23", "CUSTOMER": { "CustomerID": "1", "Name": "CUSTOMER_1" }, "ITEMS": [ { "Product_ID": "AA000K", "Product_Desc": "GEAR" }, { "Product_ID": "BB333D", "Product_Desc": "ENGINE" }, { "Product_ID": "CC444H", "Product_desc": "PISTON" } ] }, { "Order_Nr": "0002", "Date": "01/11/2023", "Total": "25.12", "CUSTOMER": { "CustomerID": "2", "Name": "CUSTOMER_2" }, "ITEMS": [ { "Product_ID": "FFTG66", "Product_Desc": "WHEEL" }, { " Product_ID ": "DD35TSH", " Product_Desc ": "REAR WINDOW" } ] } ] } JSON File.fmp12

Dear Geoffrey, you were right. There was a flag that was not working correctly and so the program was passing the field "Amount" to the item "Subtotal". Once the flag was properly tested the field "Amount" was skipped and the "Subtotal" correctly flow into QBs. Many thanks Michele Annoni

I am trying to transfer a Subtotal line of an Invoice from FM to QuickBooks using the FM Book Connector. What I pass is just the Line Item and the Description using the "InvoiceLineAdd" as I am expecting QuickBooks to automatically calculate the value of the Subtotal. But I get an error Code 3040 as per file attached. Any clue on how to deal with Subtotals? Thanks Michele Annoni

Windows 10, QuickBooks Desktop Pro 2019, QB connector 12.0.0.2 I have been working with the Connector for the past 2 years and it always worked fine. Few days ago the script "Begin Session" that checks if the connection with QuickBooks is on started getting stuck indefinitely at the "PCQB_BeginSession" instruction. I then tried the original PCQB Demo file from Productive Computing but with same result. I tried to install again the Connector but nothing changes. My same application on another PC with the Connector installed is working perfectly so the problem is with my PC. Does anyone has a clue what could be the cause of this? Thx, Mikki

Dear All, sorry, I was in Bangkok for few days. I made it!!! I needed to add some fields as skipping them was returning errors. Attached is the correct script. Thank you for your support. Mikki

The ListID field refers to to VendorListID that I previously pulled in (the FM field says List_ID_Customer but the value in it is the Vendor List ID). I even tried with this script attached referring to the Account instead of the Item but the result is the same. The same logic to Push Invoices works perfectly. I do not understand what is wrong here. Thanks a lot for your help!! Mikki

Dear Quincy I get a -1000 error (no response save)

Dear All, this is the ERROR that I get: CODE: -1000 SEVERITY: failure MESSAGE: No Response saved The ListID field refers to to VendorListID that I previously pulled in (the FM field says List_ID_Customer but the value in it is the Vendor List ID). I even tried with this script attached referring to the Account instead of the Item but the result is the same. The same logic to Push Invoices works perfectly. I do not understand what is wrong here. Thanks a lot for your help!! Mikki

Hi, I was able to push Invoices to QBs but when trying with Bills .... no way. Here attached is the script I use. Am I missing something? Mikki