URL: https://dev1.gofmhost.com/fmi/data/v1/databases/theboss/layouts/web__fathomLog/records token:2c70965dfed9603fb14ce5d9516c6c2ff2afea176254d67a484 Post Fields: {"fieldData":{"json_Received":"{\"action_items\":[{\"assignee\":{\"email\":\"etechnologies34@gmail.com\",\"name\":\"Sean Kruger\",\"team\":null},\"completed\":false,\"description\":\"Investigate 'Is sales tax exempt' calc error; fix or advise Bryan\",\"recording_playback_url\":\"https:\/\/fathom.video\/calls\/706683083?timestamp=1239.9999\",\"recording_timestamp\":\"00:20:39\",\"user_generated\":false},{\"assignee\":{\"email\":\"etechnologies34@gmail.com\",\"name\":\"Sean Kruger\",\"team\":null},\"completed\":false,\"description\":\"Implement conditional related-table push (Add button, manual vs related, rule builder, empty-row skip); demo to Bryan\",\"recording_playback_url\":\"https:\/\/fathom.video\/calls\/706683083?timestamp=1517.9999\",\"recording_timestamp\":\"00:25:17\",\"user_generated\":false}],\"calendar_invitees\":[{\"email\":\"etechnologies34@gmail.com\",\"email_domain\":\"gmail.com\",\"is_external\":false,\"matched_speaker_display_name\":\"Sean Kruger\",\"name\":\"Sean Kruger\"}],\"calendar_invitees_domains_type\":\"one_or_more_external\",\"created_at\":\"2026-06-10T17:36:42Z\",\"crm_matches\":null,\"default_summary\":{\"markdown_formatted\":\"## Meeting Purpose\\n\\n[Define logic for pushing conditional line items from FileMaker to Acumatica.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=227.0)\\n\\n## Key Takeaways\\n\\n - [**Conditional Logic:** Sean will implement logic to push items from FileMaker's \\\"Other Section\\\" table to Acumatica. The primary rule is the `post separately` checkbox: checked items become individual lines, while unchecked items are ignored.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=258.0)\\n - [**Subtotal Adjustment:** Pushing separate items requires subtracting their value from the FileMaker subtotal. This is because Acumatica re-sums all lines, and failing to adjust the subtotal would inflate the order total.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=875.0)\\n - [**UI Simplification:** The middleware UI will be redesigned to hide complex related-table configuration by default. Users will click an \\\"Add\\\" button to reveal options for manual pushes, relational pushes, or relational sums.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1546.0)\\n - [**Bug Investigation:** Sean will investigate two FileMaker calculation bugs: one preventing a calculated field from mapping to Acumatica, and another causing a \\\"no sample record\\\" error in the middleware.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1250.0)\\n\\n## Topics\\n\\n### The Problem: Conditional Line Items\\n\\n - [FileMaker's \\\"Other Section\\\" table contains various items (shipping, services, install) that must be handled differently when pushed to Acumatica.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=221.0)\\n - [**Goal:** Push items as individual lines in Acumatica based on a rule, while ignoring others.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=258.0)\\n\\n### The Solution: Conditional Push Logic\\n\\n - [**Primary Rule:** The `post separately` checkbox in FileMaker's \\\"Other Section\\\" will trigger the push to Acumatica.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=258.0)\\n - [**Checked:** Item pushed as an individual line.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=258.0)\\n - [**Unchecked:** Item ignored (remains part of the main order line).](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=258.0)\\n - [**Secondary Rule:** Items with a specific category (e.g., `DI001` for Delivery\/Install) could also be used as a trigger.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=754.0)\\n\\n### The Complication: Subtotal Adjustment\\n\\n - [**Issue:** Acumatica automatically re-sums all line items.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=875.0)\\n - [**Impact:** If a `post separately` item is pushed as its own line, its value must be removed from the main order's subtotal in FileMaker.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=875.0)\\n - [**Rationale:** This prevents the order total from being inflated by double-counting the item.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=875.0)\\n - [**Implementation:** Bryan will create a new, adjusted subtotal field in FileMaker to send to Acumatica.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=992.0)\\n\\n### The Edge Case: Locked Orders\\n\\n - [**Issue:** The interaction between \\\"locked orders\\\" and `post separately` items is undefined.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1085.0)\\n - [**Scenario:** A locked order has a fixed total (e.g., $50). If a `post separately` item is also present (e.g., $165), subtracting its value would result in a negative subtotal.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1085.0)\\n - [**Decision:** This is a FileMaker-side issue to be investigated later, as it exists independently of the Acumatica integration.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1085.0)\\n\\n### Middleware UI & Bug Fixes\\n\\n - [**UI Redesign:** The middleware interface will be simplified to improve usability.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1546.0)\\n - [Related-table configuration will be hidden by default.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1546.0)\\n - [An \\\"Add\\\" button will reveal options for manual pushes, relational pushes, or relational sums.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1560.0)\\n - [**Bug Investigation:** Sean will investigate two FileMaker calculation bugs:](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1250.0)\\n - [A calculated field (`Is sales tax exempt`) fails to map, causing a \\\"does not exist\\\" error.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=424.0)\\n - [A \\\"no sample record\\\" error appears in the middleware when trying to update a field.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1263.0)\\n\\n## Next Steps\\n\\n - [**Sean:**](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1225.0)\\n - [Implement conditional push logic for the \\\"Other Section\\\" table, using the `post separately` checkbox as the trigger.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=258.0)\\n - [Redesign the middleware UI to hide complex related-table configuration by default.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1546.0)\\n - [Investigate and fix the FileMaker calculation mapping bugs.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1250.0)\\n - [**Bryan:**](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=992.0)\\n - [Create a new, adjusted subtotal field in FileMaker for use with the conditional push logic.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=992.0)\\n\",\"template_name\":\"Enhanced\"},\"highlights\":null,\"meeting_title\":\"\ud83d\udc4b Hello, Lets talk about your FileMaker solution! (Bryan Kogan)\",\"meeting_type\":null,\"meeting_url\":\"https:\/\/us02web.zoom.us\/j\/88150034550?pwd=bmytWCtbC1f85JJXv5wPNUnPQA9hjy.1\",\"recorded_by\":{\"email\":\"etechnologies34@gmail.com\",\"email_domain\":\"gmail.com\",\"name\":\"Sean Kruger\",\"team\":null},\"recording_end_time\":\"2026-06-10T17:36:22Z\",\"recording_id\":154000281,\"recording_start_time\":\"2026-06-10T17:08:11Z\",\"scheduled_end_time\":\"2026-06-10T18:07:56Z\",\"scheduled_start_time\":\"2026-06-10T17:07:56Z\",\"share_url\":\"https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM\",\"title\":\"\ud83d\udc4b Hello, Lets talk about your FileMaker solution! (Bryan Kogan)\",\"transcript\":[{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It's all good.\",\"timestamp\":\"00:00:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I literally just sent you an email like, are we still doing today's meeting?\",\"timestamp\":\"00:00:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Or do we need to reschedule?\",\"timestamp\":\"00:00:03\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Oh, I'm sorry.\",\"timestamp\":\"00:00:07\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I just lost track of time.\",\"timestamp\":\"00:00:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"That does tend to happen.\",\"timestamp\":\"00:00:09\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Anyways, I guess we're just checking in, seeing where we're at.\",\"timestamp\":\"00:00:14\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I was just kind of waiting to hear back from you for anything to see what the next step should be.\",\"timestamp\":\"00:00:22\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"For which part?\",\"timestamp\":\"00:00:32\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Well, what are we, are, did we want, do you want me to implement?\",\"timestamp\":\"00:00:33\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I think I was just waiting to hear back on the external, the relationships and how we want to handle that.\",\"timestamp\":\"00:00:39\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Do you want me to push ahead with the ideas that I had?\",\"timestamp\":\"00:00:48\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I wasn't completely clear that that's what we were doing.\",\"timestamp\":\"00:00:51\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"The relationships.\",\"timestamp\":\"00:00:56\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So when we have.\",\"timestamp\":\"00:00:58\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So an external relationship, we want to constrain it just by a specific set of external data.\",\"timestamp\":\"00:00:59\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Like we want to say that it has to equal a certain field or something like that.\",\"timestamp\":\"00:01:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Is that what we're doing?\",\"timestamp\":\"00:01:11\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think so.\",\"timestamp\":\"00:01:13\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"mean, hold on a second.\",\"timestamp\":\"00:01:15\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"have to remember which, Do you remember like an example where like you were going to say, like, if, if it's shipping, then we have to like, say that it's, and to use the external shipping.\",\"timestamp\":\"00:01:16\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I thought you were going to think about that and talk to the team and get back to me.\",\"timestamp\":\"00:01:29\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"But so personally, I think it'll work.\",\"timestamp\":\"00:01:33\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So I think I can implement it, but I just wasn't sure that that's what we were doing.\",\"timestamp\":\"00:01:38\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you would have to say something like if this field is, you know, beyond just specifying a field or value, you need a function to tell it what the rule is, right?\",\"timestamp\":\"00:01:45\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So if, if you want, if we have to create\",\"timestamp\":\"00:01:56\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So a set of lines or an iteration of lines, it's based on a rule or multiple rules.\",\"timestamp\":\"00:01:59\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So it might be this or this.\",\"timestamp\":\"00:02:06\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you might want to say, like, if this is one and it's greater than $500, then push all the related records associated with this.\",\"timestamp\":\"00:02:10\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"And then you might have another rule.\",\"timestamp\":\"00:02:21\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you might, you would have to create another.\",\"timestamp\":\"00:02:22\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Are we trying to do that for the other section on a second?\",\"timestamp\":\"00:02:24\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"I think so.\",\"timestamp\":\"00:02:35\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah.\",\"timestamp\":\"00:02:36\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"For the shipping and delivery and install.\",\"timestamp\":\"00:02:36\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"And we were talking about splitting them out.\",\"timestamp\":\"00:02:39\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"That was, that was before we started putting shipping in the shipping fields on the sales order.\",\"timestamp\":\"00:02:44\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"But we were also having issues with getting that.\",\"timestamp\":\"00:02:52\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah, that was the other part of it.\",\"timestamp\":\"00:02:57\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"You said you were going to.\",\"timestamp\":\"00:02:59\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"See about setting the specific shipping fields.\",\"timestamp\":\"00:03:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I don't know if, if you want me to do that, I can.\",\"timestamp\":\"00:03:03\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I mean, I think that would work in general.\",\"timestamp\":\"00:03:06\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I wasn't a hundred percent sure that's the direction we were taking yet.\",\"timestamp\":\"00:03:10\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Well, we could, I'm trying to think.\",\"timestamp\":\"00:03:16\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So we could do like category totals from the other section because the shipping has a place, but you can only put one shipping charge for sales order where they have it.\",\"timestamp\":\"00:03:21\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"You can't add multiple lines, which I was told would be okay.\",\"timestamp\":\"00:03:34\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think I got Sean and Harrison's approval on that.\",\"timestamp\":\"00:03:39\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It's all the other stuff that's going on in that other section table.\",\"timestamp\":\"00:03:41\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Like the services, the delivery and install that need to be pulled out.\",\"timestamp\":\"00:03:47\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"How many times are my nerves in the scene?\",\"timestamp\":\"00:03:52\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I'm just\",\"timestamp\":\"00:03:59\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah, it's all the stuff that we post separately on the invoicing because it has to be split out.\",\"timestamp\":\"00:04:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Otherwise, it won't post separate on their invoice.\",\"timestamp\":\"00:04:13\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Need conditional logic based on post separately checkbox.\",\"timestamp\":\"00:04:18\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think that's what we were looking at doing.\",\"timestamp\":\"00:04:23\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So in the other section, there's a checkbox that says post separately when you add an item.\",\"timestamp\":\"00:04:30\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think that was our conditional logic test.\",\"timestamp\":\"00:04:37\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you're saying you do want me to do that?\",\"timestamp\":\"00:04:52\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Tell me your idea one more time.\",\"timestamp\":\"00:04:55\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Can you just tell me just so I make sure we're on the same page?\",\"timestamp\":\"00:04:57\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Well, you have to have a way to define what the conditional rule is.\",\"timestamp\":\"00:04:59\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you're defining what the conditional rule is.\",\"timestamp\":\"00:05:04\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"You're going to say that if this is one, then push these records or summarize the sum value or whatever you're going to do.\",\"timestamp\":\"00:05:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yes, we do need to do that.\",\"timestamp\":\"00:05:16\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:05:20\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"And what depth do I need to do?\",\"timestamp\":\"00:05:21\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Are there situations where there's multiple lines that in there, they need to be combined into one, and there's some situations where there's multiple lines.\",\"timestamp\":\"00:05:25\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"You need to push multiple lines.\",\"timestamp\":\"00:05:33\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"Is that the case?\",\"timestamp\":\"00:05:37\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"That's, I think so.\",\"timestamp\":\"00:05:38\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I'm not entirely sure.\",\"timestamp\":\"00:05:40\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I guess I kind of have to see it working.\",\"timestamp\":\"00:05:41\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"We have so many random scenarios, it's hard to say.\",\"timestamp\":\"00:05:45\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"We might have to do a combination of both of those.\",\"timestamp\":\"00:05:48\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"But I'm wondering if we want to combine it.\",\"timestamp\":\"00:05:53\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Oh, think, Rhiannon, did we talk about that, that that wasn't going to work if we made like a calculated field in the work order table that summarizes a certain category of items in the other section?\",\"timestamp\":\"00:06:00\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"Well, were we still having issues with the calculated field?\",\"timestamp\":\"00:06:12\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think that's a different thing.\",\"timestamp\":\"00:06:20\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"Well, it would, I mean, it would be a calculation based on a related table.\",\"timestamp\":\"00:06:22\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"So it falls under that category.\",\"timestamp\":\"00:06:28\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay, hold on a second.\",\"timestamp\":\"00:06:33\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Me?\",\"timestamp\":\"00:06:35\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"Because I have a calculation that would hold just the shipping items and get the value of the shipping that I wrote, but I think it still falls into that pit, simply by nature of being a calculated field that relies on a related table.\",\"timestamp\":\"00:06:35\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So I'm wondering if the middleware would be better to calculate it, if we have to calculate it.\",\"timestamp\":\"00:07:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I mean, I can show you the one example, what she's talking about, let me see if I share my screen.\",\"timestamp\":\"00:07:04\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So right here in this field, we were trying to, is sales tax exempt equal one, then exempt otherwise taxable?\",\"timestamp\":\"00:07:13\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"And that's when it doesn't seem to want to calculate this.\",\"timestamp\":\"00:07:24\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It doesn't want to build a little calculator.\",\"timestamp\":\"00:07:35\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I don't know.\",\"timestamp\":\"00:07:37\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think I sent you an email about that.\",\"timestamp\":\"00:07:40\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Where did my email go?\",\"timestamp\":\"00:07:48\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I know I had it.\",\"timestamp\":\"00:07:51\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Oh, it's over here.\",\"timestamp\":\"00:07:51\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So when you map, when we send that field through, we get a, this field name.\",\"timestamp\":\"00:07:55\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Is sales tax exempt is true.\",\"timestamp\":\"00:08:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Does not exist in a specified table.\",\"timestamp\":\"00:08:02\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So that's one issue, but back to, to the related fields thing.\",\"timestamp\":\"00:08:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Um, I might have you do both.\",\"timestamp\":\"00:08:11\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I don't know which one's going to pan out.\",\"timestamp\":\"00:08:19\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:08:25\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you need a way to do a full calculation based on a set of rules or push a whole set of records.\",\"timestamp\":\"00:08:25\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I believe so.\",\"timestamp\":\"00:08:33\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah.\",\"timestamp\":\"00:08:34\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:08:35\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Not sure which one we're going to need over the other, because in some circumstances, um, this other section, let me move the screen over here.\",\"timestamp\":\"00:08:37\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I see it.\",\"timestamp\":\"00:08:52\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Come on frame ready.\",\"timestamp\":\"00:08:58\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Do you remember which work order we were working on or should I just recreate it because there's going to be I need a conditional that allows us let's say we put shipping on here $100 worth of shipping see how that came up by default post\",\"timestamp\":\"00:09:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So that would be one test to pull this line out of this section and to be able to put it on the sales order individually.\",\"timestamp\":\"00:10:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Or in this case, with shipping, I guess that was a bad example.\",\"timestamp\":\"00:10:13\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Where is delivery and install?\",\"timestamp\":\"00:10:19\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Services.\",\"timestamp\":\"00:10:21\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"The delivery and install would be the one.\",\"timestamp\":\"00:10:24\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"See, that's also post separately.\",\"timestamp\":\"00:10:28\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So that would come out on its own, but the shipping would end up in...\",\"timestamp\":\"00:10:31\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Where did my browser go?\",\"timestamp\":\"00:10:38\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"There we go.\",\"timestamp\":\"00:10:39\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:10:47\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So I think we need both.\",\"timestamp\":\"00:10:49\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It just depends on when we start sending it through, how it reacts.\",\"timestamp\":\"00:10:53\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Without knowing...\",\"timestamp\":\"00:10:58\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"If being able to see it, it's hard to know for sure.\",\"timestamp\":\"00:11:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Let's see.\",\"timestamp\":\"00:11:05\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think we've sent one through.\",\"timestamp\":\"00:11:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Come on.\",\"timestamp\":\"00:11:09\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Matica's gotten slow on us.\",\"timestamp\":\"00:11:15\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"That's this one.\",\"timestamp\":\"00:11:27\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"We were able to see how the shipping came in through here, but if we go back to...\",\"timestamp\":\"00:11:29\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Did we get one to go through, Rhiannon?\",\"timestamp\":\"00:11:40\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"don't know if we did.\",\"timestamp\":\"00:11:42\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think I made a manual one, didn't I?\",\"timestamp\":\"00:11:47\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"No.\",\"timestamp\":\"00:11:50\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Oh, no, we didn't.\",\"timestamp\":\"00:11:52\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"We didn't.\",\"timestamp\":\"00:11:53\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"if you just wanted to set the shipping, you probably could do that right now by creating a...\",\"timestamp\":\"00:11:54\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Well, no, we got this shipping to work.\",\"timestamp\":\"00:12:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"The only thing is we would have to, if someone put two shipping charges on one work order, we would have to sum it into this area.\",\"timestamp\":\"00:12:02\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"But we can also, I mean, I put this on here manually.\",\"timestamp\":\"00:12:14\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Imagine this was the delivery and install line.\",\"timestamp\":\"00:12:18\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So we'd have a delivery and install line and a custom order line.\",\"timestamp\":\"00:12:20\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"And that's kind of what we need to do.\",\"timestamp\":\"00:12:23\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"And that's what's kind of troublesome of this section is that there's multiple things going on in here.\",\"timestamp\":\"00:12:25\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"that need a separate path.\",\"timestamp\":\"00:12:32\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"But you're going to need say, you're going to need to say then if item, if whatever that field that says shipping on there or DI001 is, could we do it by category?\",\"timestamp\":\"00:12:34\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Like, mean, I'd be worried.\",\"timestamp\":\"00:12:48\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Or post separately, I guess you could just do is post separately.\",\"timestamp\":\"00:12:49\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Right.\",\"timestamp\":\"00:12:54\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Right.\",\"timestamp\":\"00:12:54\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"There's that.\",\"timestamp\":\"00:12:54\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"And there's also the category that could also help.\",\"timestamp\":\"00:12:55\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Well, if it's supposed to be summed, you'll have to create the rule.\",\"timestamp\":\"00:13:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you're going to say, if this is post separately, then push these individually.\",\"timestamp\":\"00:13:03\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"And then if it's not post separately, then push them as a group and sum them.\",\"timestamp\":\"00:13:08\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"And in that case, you're going to need...\",\"timestamp\":\"00:13:17\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Hold on.\",\"timestamp\":\"00:13:20\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It gets trickier.\",\"timestamp\":\"00:13:21\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Hold on.\",\"timestamp\":\"00:13:22\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"You just said something.\",\"timestamp\":\"00:13:23\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"made me think about something.\",\"timestamp\":\"00:13:24\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"That's what I was asking.\",\"timestamp\":\"00:13:26\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"This is where this gets really tricky.\",\"timestamp\":\"00:13:27\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Hold on.\",\"timestamp\":\"00:13:30\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Let put something on there that is going to defy this situation.\",\"timestamp\":\"00:13:30\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So, this is a map board.\",\"timestamp\":\"00:13:38\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"This map board is going to sum into the total of the custom order line.\",\"timestamp\":\"00:13:40\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Well, then you're not going to create a rule.\",\"timestamp\":\"00:13:50\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Then it doesn't matter.\",\"timestamp\":\"00:13:52\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"It doesn't matter for that one.\",\"timestamp\":\"00:13:54\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:13:56\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Then don't put anything.\",\"timestamp\":\"00:13:57\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"There is no rules.\",\"timestamp\":\"00:13:58\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So the other two rules negate, as long as there's a rule that you only post whatever's in there, if it's post separately, then you don't need to worry about it because it's never going to find it because there's no rule to put to your, you know, if you have a rule.\",\"timestamp\":\"00:14:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:14:19\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Yeah.\",\"timestamp\":\"00:14:20\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah.\",\"timestamp\":\"00:14:20\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:14:25\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I mean, at this point, I don't, I'm not even hearing that we need the summary thing, but I can put it in there just so you have it.\",\"timestamp\":\"00:14:25\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"You mean like the total?\",\"timestamp\":\"00:14:33\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Well, the total summary, well, this is the other part.\",\"timestamp\":\"00:14:35\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"The totals, if, if we pull this delivery and install line out of here, this 165, it needs to come out of the subtotal because Acumatica re-sums it.\",\"timestamp\":\"00:14:37\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So maybe that's where the summary thing came into play.\",\"timestamp\":\"00:14:52\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah.\",\"timestamp\":\"00:15:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Now, there is the field called, like, component total, but component total only summarizes the main window.\",\"timestamp\":\"00:15:03\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"See how other items are all totaled in here?\",\"timestamp\":\"00:15:13\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So if we pull it out and send it to Acumatica on its own line, its dollar amount needs to come out of the subtotal so Acumatica can put it back in.\",\"timestamp\":\"00:15:16\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah.\",\"timestamp\":\"00:15:33\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:15:37\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Well, you'll have to do that in the function somehow for the total, I guess.\",\"timestamp\":\"00:15:40\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"You mean, like, in FileMaker, fix the field that's...\",\"timestamp\":\"00:15:51\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"No.\",\"timestamp\":\"00:15:56\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I mean, I can do it, but you'll need to be able\",\"timestamp\":\"00:15:57\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I just don't know if it's reasonable to ask you guys to do that.\",\"timestamp\":\"00:16:01\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"You're going to have to say, okay, it's grand total in the function that we already have.\",\"timestamp\":\"00:16:04\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"You're going to have to say, I'm going have to make it so somehow you can tell it if it's post-separally, it's going to be grand total minus the sum of the foreign table when it's post-separally.\",\"timestamp\":\"00:16:08\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"And you have to set the field that that's associated with.\",\"timestamp\":\"00:16:26\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So that's a different thing that we didn't talk about.\",\"timestamp\":\"00:16:29\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Should we be looking at doing that in FileMaker, like making a field, like instead of sending this subtotal field, make a new If you don't already have one, it might be easier just to do it that way.\",\"timestamp\":\"00:16:32\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I mean, I think we kind of have one, but this was in some other table.\",\"timestamp\":\"00:16:44\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I don't know if I can zoom in on this.\",\"timestamp\":\"00:16:58\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Oh, FileMaker Zoom.\",\"timestamp\":\"00:17:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Come on.\",\"timestamp\":\"00:17:04\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I think they fixed it.\",\"timestamp\":\"00:17:06\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"It's just going to be big.\",\"timestamp\":\"00:17:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"No, I think they, I think they, I haven't looked yet, but I'm pretty, I haven't looked at that new feature yet, but I think they fixed it.\",\"timestamp\":\"00:17:10\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"What, the zooming problem?\",\"timestamp\":\"00:17:16\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I thought I read something about them fixing it, but it doesn't have a new version and I don't see it.\",\"timestamp\":\"00:17:21\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Right.\",\"timestamp\":\"00:17:26\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So what are this reporters doing?\",\"timestamp\":\"00:17:27\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I you zoom by, I thought you could actually zoom and scale now.\",\"timestamp\":\"00:17:28\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Mm hmm.\",\"timestamp\":\"00:17:31\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So anyways, I mean, we kind of have it going on.\",\"timestamp\":\"00:17:34\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I just think it's not this, these calculations aren't in the work order table.\",\"timestamp\":\"00:17:37\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"They're in some other table.\",\"timestamp\":\"00:17:41\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So we'd have to go remake those calcs, which I'm okay with doing if it makes this easier.\",\"timestamp\":\"00:17:47\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I mean, it almost sounds like it, we probably should.\",\"timestamp\":\"00:17:53\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Just go make the proper field to come through here.\",\"timestamp\":\"00:18:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"The other condition that we have to look into, which we haven't played with yet, is when someone locks an order down and says, this order is now $200.\",\"timestamp\":\"00:18:05\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I got to go figure out where and how that's being stored and what kind of condition.\",\"timestamp\":\"00:18:13\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Does the middleware need to detect that or should we be somehow detecting that?\",\"timestamp\":\"00:18:19\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"total.\",\"timestamp\":\"00:18:24\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"It's still your grand total.\",\"timestamp\":\"00:18:24\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"It's the same field.\",\"timestamp\":\"00:18:28\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Right.\",\"timestamp\":\"00:18:29\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"But the moment you have something that, but once you have something that posts separately on a locked order, I, things are going to get weird.\",\"timestamp\":\"00:18:30\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Like, you know, you're saying this is $165, but I just locked the order down to 50.\",\"timestamp\":\"00:18:41\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So if you take the 50 and you minus 165, we're going to be in the negative.\",\"timestamp\":\"00:18:50\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So I don't know how to handle that.\",\"timestamp\":\"00:18:55\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It's almost like if something posts separately.\",\"timestamp\":\"00:18:58\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It shouldn't be lockable, but I wonder how our current invoicing scenario handles that.\",\"timestamp\":\"00:19:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I don't know.\",\"timestamp\":\"00:19:08\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Yeah.\",\"timestamp\":\"00:19:15\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I've never, I've never really, I mean, I know that it runs at night, but I don't know what it does.\",\"timestamp\":\"00:19:16\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Is that saying tax is negative $19?\",\"timestamp\":\"00:19:32\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I mean, is there ever a scenario where that would happen?\",\"timestamp\":\"00:19:35\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Um, I don't know.\",\"timestamp\":\"00:19:49\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It lets me do it.\",\"timestamp\":\"00:19:54\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I don't think a user shouldn't be doing that.\",\"timestamp\":\"00:19:56\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"But I'll have to go figure that out next.\",\"timestamp\":\"00:20:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I don't know.\",\"timestamp\":\"00:20:07\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I've never considered that.\",\"timestamp\":\"00:20:08\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Because, yeah.\",\"timestamp\":\"00:20:12\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So that's kind of like...\",\"timestamp\":\"00:20:13\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"that's probably a problem regardless, whether outside of Acumatica, I think that's probably a problem.\",\"timestamp\":\"00:20:14\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Right.\",\"timestamp\":\"00:20:20\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Beyond Acumatica's concerns.\",\"timestamp\":\"00:20:21\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Why don't we just take a stab at this first part, and then once you see it, maybe that'll help define the next steps.\",\"timestamp\":\"00:20:25\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah, I think that probably will.\",\"timestamp\":\"00:20:36\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think that's kind of why I need to see it, to kind of understand it.\",\"timestamp\":\"00:20:38\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So, all right.\",\"timestamp\":\"00:20:44\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So you can take a stab at that.\",\"timestamp\":\"00:20:46\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Where was this?\",\"timestamp\":\"00:20:48\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Can you look into also why it doesn't like this field?\",\"timestamp\":\"00:20:50\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Yeah, I will.\",\"timestamp\":\"00:21:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:21:02\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Can you click update again?\",\"timestamp\":\"00:21:03\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"It wasn't giving you an error, right?\",\"timestamp\":\"00:21:04\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Where was that?\",\"timestamp\":\"00:21:06\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Oh, it's right here.\",\"timestamp\":\"00:21:09\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"No, it just says no sample record.\",\"timestamp\":\"00:21:13\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Let me see the, that's where that it's not displaying the samples.\",\"timestamp\":\"00:21:17\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Has it not been displaying the samples at all?\",\"timestamp\":\"00:21:23\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"No, there's other calculations that are just fine.\",\"timestamp\":\"00:21:25\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It's something to do with this.\",\"timestamp\":\"00:21:28\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"This is sales tax exempt field.\",\"timestamp\":\"00:21:30\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"This is a calculated field within FileMaker.\",\"timestamp\":\"00:21:38\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Do you know how to use the inspector?\",\"timestamp\":\"00:21:41\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I don't really want you.\",\"timestamp\":\"00:21:43\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Have you ever done that before?\",\"timestamp\":\"00:21:45\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"The inspector and web.\",\"timestamp\":\"00:21:47\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Can you right click on your, right click on the go to inspect?\",\"timestamp\":\"00:21:49\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Click on the console console.\",\"timestamp\":\"00:22:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"There you go.\",\"timestamp\":\"00:22:03\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"That's just noise.\",\"timestamp\":\"00:22:06\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"But we want to click on that field again.\",\"timestamp\":\"00:22:08\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Clear the inspector first.\",\"timestamp\":\"00:22:12\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"then in the top left corner of that, there's a little Ghostbusters thing.\",\"timestamp\":\"00:22:14\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Ghostbusters.\",\"timestamp\":\"00:22:21\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"What do you mean?\",\"timestamp\":\"00:22:22\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Down?\",\"timestamp\":\"00:22:24\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"That.\",\"timestamp\":\"00:22:25\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah, that clear it.\",\"timestamp\":\"00:22:26\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yep.\",\"timestamp\":\"00:22:28\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:22:29\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"And then try that again.\",\"timestamp\":\"00:22:30\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"It may not be reporting any errors or I can't remember how much about that.\",\"timestamp\":\"00:22:34\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Actually, I don't think it is.\",\"timestamp\":\"00:22:41\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Yeah, I don't have the tool.\",\"timestamp\":\"00:22:47\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I have the error tooling turned off on that.\",\"timestamp\":\"00:22:49\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"get to click on.\",\"timestamp\":\"00:22:51\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:22:52\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"All that other nonsense turned on.\",\"timestamp\":\"00:22:57\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"All right, let me look at that.\",\"timestamp\":\"00:23:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I'm not sure what's going on there.\",\"timestamp\":\"00:23:02\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Got it.\",\"timestamp\":\"00:23:06\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:23:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think that was it.\",\"timestamp\":\"00:23:10\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Bryan, can you think of anything else?\",\"timestamp\":\"00:23:13\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"that?\",\"timestamp\":\"00:23:15\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"No, not.\",\"timestamp\":\"00:23:17\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So I think what we need to put in here also is a way to add multiple tables and then get like a sum field.\",\"timestamp\":\"00:23:21\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I think you're going to wind up needing that here.\",\"timestamp\":\"00:23:29\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Can we add multiple tables?\",\"timestamp\":\"00:23:34\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Like a related table?\",\"timestamp\":\"00:23:36\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Yeah, I've been thinking that.\",\"timestamp\":\"00:23:38\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"If we can do related tables, that makes this a little bit easier because the other section was going to have to be a second API call then.\",\"timestamp\":\"00:23:42\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Well, in this scenario, you would only use that if it's a flat thing.\",\"timestamp\":\"00:23:51\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Like a one-to-one, or if you're trying to summarize something, if you're going to say, summarize the resulting value, and again, kind of comes down to whether or not you're going to be able to say something in this case where, you know, shipping is one, it's also shipping and whatever.\",\"timestamp\":\"00:24:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I mean, I don't know if you can define all that.\",\"timestamp\":\"00:24:22\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I know I could do it, but I just don't know if you can do it.\",\"timestamp\":\"00:24:27\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Like, I don't know if it has value to you guys.\",\"timestamp\":\"00:24:30\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Like, if you can sort that out, that's fine.\",\"timestamp\":\"00:24:33\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I just don't want to make it complex to the point where nobody understands how it works, especially over a given amount of time.\",\"timestamp\":\"00:24:38\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"That's the thing.\",\"timestamp\":\"00:24:44\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Like, the more features we add in here, the more confusing it is, the less likely anyone is to use it in the future anyway.\",\"timestamp\":\"00:24:45\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So, sometimes.\",\"timestamp\":\"00:24:52\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah, you're not wrong about that.\",\"timestamp\":\"00:24:55\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So, what would you suggest?\",\"timestamp\":\"00:24:58\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Nobody down the line, I we had to do a bunch of work, and then down the line, nobody even remembers what the hell's going on.\",\"timestamp\":\"00:25:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"It's, you know.\",\"timestamp\":\"00:25:06\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Right.\",\"timestamp\":\"00:25:08\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I mean, at some point, we're going to get this set up, and it's going to sit because it's going to be set up, you know.\",\"timestamp\":\"00:25:08\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Right.\",\"timestamp\":\"00:25:14\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"And maybe, maybe we, you know, we add a new feel, or, you know, and we're not going to do complicated ads, I think, after a certain point, but.\",\"timestamp\":\"00:25:15\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay, well, I'm going to approach this as I'm not going to touch anything until you tell me you really need it.\",\"timestamp\":\"00:25:28\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So I know now at this point, I'm going to do the conditions for the related tables, navigating to the related tables, and then what do you do there at that point?\",\"timestamp\":\"00:25:31\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:25:44\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"We already have the way to set it up.\",\"timestamp\":\"00:25:44\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So under each one of, when you see the repeating values, each one of, I think I'm actually going to hide them.\",\"timestamp\":\"00:25:46\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I'm going to adjust the interface so it's less confusing.\",\"timestamp\":\"00:25:52\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Like, I'm not even going to display them unless you add it.\",\"timestamp\":\"00:25:55\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"You're going to, instead of the way it's just automatically adding each, like relations, if you don't want that, I'll give you a place to add it, but I'm not going to put the, I forget what you call the hierarchy, I'm not even going to put those in unless you click an add button, and then when you click that add button, I'm going to say, what do you, you know, I'm going to say, are you adding a manual count, are you adding a relational count, are you adding a relational push, and what is the function for that?\",\"timestamp\":\"00:26:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you, right, if there is a conditional function, or not.\",\"timestamp\":\"00:26:29\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:26:34\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you won't see all the noise for the related tables until you actually say, I want to add something, and then I want to add another thing, right?\",\"timestamp\":\"00:26:36\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"And then that thing is either, again, what we have, which is the manual count, which is the iteration, you're going to say five, or it's the related thing, you're going to select the table, and then select, and then for both of those, I guess you need a rule for them.\",\"timestamp\":\"00:26:44\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:26:59\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"The manual push, we won't need the relationship.\",\"timestamp\":\"00:27:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I don't think so.\",\"timestamp\":\"00:27:04\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I'm not going to put that in there for the iterator push, because that means it's flat to me.\",\"timestamp\":\"00:27:06\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"It's a flat push.\",\"timestamp\":\"00:27:12\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So it's only for the related push where we're going to say, when it's related, these are the records we want you to push.\",\"timestamp\":\"00:27:13\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"The flat manual push, I think we don't need that.\",\"timestamp\":\"00:27:21\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:27:27\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I can just say if the values are empty, then don't push.\",\"timestamp\":\"00:27:27\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"We'll just assume that if the values are empty, don't push them.\",\"timestamp\":\"00:27:30\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:27:34\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Right.\",\"timestamp\":\"00:27:35\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Because we talked about that.\",\"timestamp\":\"00:27:35\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Like if, if the quantity is empty, then I, you know, quantity one is empty, then probably that whole row is going to be empty or that whole related.\",\"timestamp\":\"00:27:36\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I'm just going to do it like that.\",\"timestamp\":\"00:27:47\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"And we'll go from there.\",\"timestamp\":\"00:27:48\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think so.\",\"timestamp\":\"00:27:49\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah.\",\"timestamp\":\"00:27:50\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Like I said, think once, once you see it, we'll go from there and we can't obviously that every situation.\",\"timestamp\":\"00:27:52\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So I'll put it in there.\",\"timestamp\":\"00:27:58\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Tell me what's up with it.\",\"timestamp\":\"00:28:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"And we'll go from there.\",\"timestamp\":\"00:28:01\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:28:03\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"All right.\",\"timestamp\":\"00:28:04\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"All right.\",\"timestamp\":\"00:28:05\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Sounds good.\",\"timestamp\":\"00:28:06\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Thanks, guys.\",\"timestamp\":\"00:28:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Appreciate you.\",\"timestamp\":\"00:28:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yep.\",\"timestamp\":\"00:28:08\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Thank you.\",\"timestamp\":\"00:28:08\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"You too.\",\"timestamp\":\"00:28:08\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Bye.\",\"timestamp\":\"00:28:09\"}],\"transcript_language\":\"en\",\"url\":\"https:\/\/fathom.video\/calls\/706683083\"}"},"script":"Fathom | Incoming Log"} Result: {"response":{"scriptError":"0","recordId":"85","modId":"0"},"messages":[{"code":"0","message":"OK"}]} ------------------------- URL: https://dev1.gofmhost.com/fmi/data/v1/databases/theboss/sessions/2c70965dfed9603fb14ce5d9516c6c2ff2afea176254d67a484 token:2c70965dfed9603fb14ce5d9516c6c2ff2afea176254d67a484 Post Fields: {"fieldData":{"json_Received":"{\"action_items\":[{\"assignee\":{\"email\":\"etechnologies34@gmail.com\",\"name\":\"Sean Kruger\",\"team\":null},\"completed\":false,\"description\":\"Investigate 'Is sales tax exempt' calc error; fix or advise Bryan\",\"recording_playback_url\":\"https:\/\/fathom.video\/calls\/706683083?timestamp=1239.9999\",\"recording_timestamp\":\"00:20:39\",\"user_generated\":false},{\"assignee\":{\"email\":\"etechnologies34@gmail.com\",\"name\":\"Sean Kruger\",\"team\":null},\"completed\":false,\"description\":\"Implement conditional related-table push (Add button, manual vs related, rule builder, empty-row skip); demo to Bryan\",\"recording_playback_url\":\"https:\/\/fathom.video\/calls\/706683083?timestamp=1517.9999\",\"recording_timestamp\":\"00:25:17\",\"user_generated\":false}],\"calendar_invitees\":[{\"email\":\"etechnologies34@gmail.com\",\"email_domain\":\"gmail.com\",\"is_external\":false,\"matched_speaker_display_name\":\"Sean Kruger\",\"name\":\"Sean Kruger\"}],\"calendar_invitees_domains_type\":\"one_or_more_external\",\"created_at\":\"2026-06-10T17:36:42Z\",\"crm_matches\":null,\"default_summary\":{\"markdown_formatted\":\"## Meeting Purpose\\n\\n[Define logic for pushing conditional line items from FileMaker to Acumatica.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=227.0)\\n\\n## Key Takeaways\\n\\n - [**Conditional Logic:** Sean will implement logic to push items from FileMaker's \\\"Other Section\\\" table to Acumatica. The primary rule is the `post separately` checkbox: checked items become individual lines, while unchecked items are ignored.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=258.0)\\n - [**Subtotal Adjustment:** Pushing separate items requires subtracting their value from the FileMaker subtotal. This is because Acumatica re-sums all lines, and failing to adjust the subtotal would inflate the order total.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=875.0)\\n - [**UI Simplification:** The middleware UI will be redesigned to hide complex related-table configuration by default. Users will click an \\\"Add\\\" button to reveal options for manual pushes, relational pushes, or relational sums.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1546.0)\\n - [**Bug Investigation:** Sean will investigate two FileMaker calculation bugs: one preventing a calculated field from mapping to Acumatica, and another causing a \\\"no sample record\\\" error in the middleware.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1250.0)\\n\\n## Topics\\n\\n### The Problem: Conditional Line Items\\n\\n - [FileMaker's \\\"Other Section\\\" table contains various items (shipping, services, install) that must be handled differently when pushed to Acumatica.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=221.0)\\n - [**Goal:** Push items as individual lines in Acumatica based on a rule, while ignoring others.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=258.0)\\n\\n### The Solution: Conditional Push Logic\\n\\n - [**Primary Rule:** The `post separately` checkbox in FileMaker's \\\"Other Section\\\" will trigger the push to Acumatica.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=258.0)\\n - [**Checked:** Item pushed as an individual line.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=258.0)\\n - [**Unchecked:** Item ignored (remains part of the main order line).](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=258.0)\\n - [**Secondary Rule:** Items with a specific category (e.g., `DI001` for Delivery\/Install) could also be used as a trigger.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=754.0)\\n\\n### The Complication: Subtotal Adjustment\\n\\n - [**Issue:** Acumatica automatically re-sums all line items.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=875.0)\\n - [**Impact:** If a `post separately` item is pushed as its own line, its value must be removed from the main order's subtotal in FileMaker.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=875.0)\\n - [**Rationale:** This prevents the order total from being inflated by double-counting the item.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=875.0)\\n - [**Implementation:** Bryan will create a new, adjusted subtotal field in FileMaker to send to Acumatica.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=992.0)\\n\\n### The Edge Case: Locked Orders\\n\\n - [**Issue:** The interaction between \\\"locked orders\\\" and `post separately` items is undefined.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1085.0)\\n - [**Scenario:** A locked order has a fixed total (e.g., $50). If a `post separately` item is also present (e.g., $165), subtracting its value would result in a negative subtotal.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1085.0)\\n - [**Decision:** This is a FileMaker-side issue to be investigated later, as it exists independently of the Acumatica integration.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1085.0)\\n\\n### Middleware UI & Bug Fixes\\n\\n - [**UI Redesign:** The middleware interface will be simplified to improve usability.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1546.0)\\n - [Related-table configuration will be hidden by default.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1546.0)\\n - [An \\\"Add\\\" button will reveal options for manual pushes, relational pushes, or relational sums.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1560.0)\\n - [**Bug Investigation:** Sean will investigate two FileMaker calculation bugs:](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1250.0)\\n - [A calculated field (`Is sales tax exempt`) fails to map, causing a \\\"does not exist\\\" error.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=424.0)\\n - [A \\\"no sample record\\\" error appears in the middleware when trying to update a field.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1263.0)\\n\\n## Next Steps\\n\\n - [**Sean:**](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1225.0)\\n - [Implement conditional push logic for the \\\"Other Section\\\" table, using the `post separately` checkbox as the trigger.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=258.0)\\n - [Redesign the middleware UI to hide complex related-table configuration by default.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1546.0)\\n - [Investigate and fix the FileMaker calculation mapping bugs.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=1250.0)\\n - [**Bryan:**](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=992.0)\\n - [Create a new, adjusted subtotal field in FileMaker for use with the conditional push logic.](https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM?tab=summary×tamp=992.0)\\n\",\"template_name\":\"Enhanced\"},\"highlights\":null,\"meeting_title\":\"\ud83d\udc4b Hello, Lets talk about your FileMaker solution! (Bryan Kogan)\",\"meeting_type\":null,\"meeting_url\":\"https:\/\/us02web.zoom.us\/j\/88150034550?pwd=bmytWCtbC1f85JJXv5wPNUnPQA9hjy.1\",\"recorded_by\":{\"email\":\"etechnologies34@gmail.com\",\"email_domain\":\"gmail.com\",\"name\":\"Sean Kruger\",\"team\":null},\"recording_end_time\":\"2026-06-10T17:36:22Z\",\"recording_id\":154000281,\"recording_start_time\":\"2026-06-10T17:08:11Z\",\"scheduled_end_time\":\"2026-06-10T18:07:56Z\",\"scheduled_start_time\":\"2026-06-10T17:07:56Z\",\"share_url\":\"https:\/\/fathom.video\/share\/wtSL5pzd9xwKXkSm_UXqf3FM9tsQbKxM\",\"title\":\"\ud83d\udc4b Hello, Lets talk about your FileMaker solution! (Bryan Kogan)\",\"transcript\":[{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It's all good.\",\"timestamp\":\"00:00:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I literally just sent you an email like, are we still doing today's meeting?\",\"timestamp\":\"00:00:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Or do we need to reschedule?\",\"timestamp\":\"00:00:03\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Oh, I'm sorry.\",\"timestamp\":\"00:00:07\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I just lost track of time.\",\"timestamp\":\"00:00:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"That does tend to happen.\",\"timestamp\":\"00:00:09\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Anyways, I guess we're just checking in, seeing where we're at.\",\"timestamp\":\"00:00:14\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I was just kind of waiting to hear back from you for anything to see what the next step should be.\",\"timestamp\":\"00:00:22\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"For which part?\",\"timestamp\":\"00:00:32\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Well, what are we, are, did we want, do you want me to implement?\",\"timestamp\":\"00:00:33\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I think I was just waiting to hear back on the external, the relationships and how we want to handle that.\",\"timestamp\":\"00:00:39\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Do you want me to push ahead with the ideas that I had?\",\"timestamp\":\"00:00:48\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I wasn't completely clear that that's what we were doing.\",\"timestamp\":\"00:00:51\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"The relationships.\",\"timestamp\":\"00:00:56\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So when we have.\",\"timestamp\":\"00:00:58\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So an external relationship, we want to constrain it just by a specific set of external data.\",\"timestamp\":\"00:00:59\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Like we want to say that it has to equal a certain field or something like that.\",\"timestamp\":\"00:01:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Is that what we're doing?\",\"timestamp\":\"00:01:11\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think so.\",\"timestamp\":\"00:01:13\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"mean, hold on a second.\",\"timestamp\":\"00:01:15\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"have to remember which, Do you remember like an example where like you were going to say, like, if, if it's shipping, then we have to like, say that it's, and to use the external shipping.\",\"timestamp\":\"00:01:16\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I thought you were going to think about that and talk to the team and get back to me.\",\"timestamp\":\"00:01:29\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"But so personally, I think it'll work.\",\"timestamp\":\"00:01:33\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So I think I can implement it, but I just wasn't sure that that's what we were doing.\",\"timestamp\":\"00:01:38\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you would have to say something like if this field is, you know, beyond just specifying a field or value, you need a function to tell it what the rule is, right?\",\"timestamp\":\"00:01:45\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So if, if you want, if we have to create\",\"timestamp\":\"00:01:56\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So a set of lines or an iteration of lines, it's based on a rule or multiple rules.\",\"timestamp\":\"00:01:59\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So it might be this or this.\",\"timestamp\":\"00:02:06\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you might want to say, like, if this is one and it's greater than $500, then push all the related records associated with this.\",\"timestamp\":\"00:02:10\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"And then you might have another rule.\",\"timestamp\":\"00:02:21\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you might, you would have to create another.\",\"timestamp\":\"00:02:22\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Are we trying to do that for the other section on a second?\",\"timestamp\":\"00:02:24\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"I think so.\",\"timestamp\":\"00:02:35\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah.\",\"timestamp\":\"00:02:36\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"For the shipping and delivery and install.\",\"timestamp\":\"00:02:36\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"And we were talking about splitting them out.\",\"timestamp\":\"00:02:39\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"That was, that was before we started putting shipping in the shipping fields on the sales order.\",\"timestamp\":\"00:02:44\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"But we were also having issues with getting that.\",\"timestamp\":\"00:02:52\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah, that was the other part of it.\",\"timestamp\":\"00:02:57\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"You said you were going to.\",\"timestamp\":\"00:02:59\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"See about setting the specific shipping fields.\",\"timestamp\":\"00:03:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I don't know if, if you want me to do that, I can.\",\"timestamp\":\"00:03:03\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I mean, I think that would work in general.\",\"timestamp\":\"00:03:06\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I wasn't a hundred percent sure that's the direction we were taking yet.\",\"timestamp\":\"00:03:10\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Well, we could, I'm trying to think.\",\"timestamp\":\"00:03:16\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So we could do like category totals from the other section because the shipping has a place, but you can only put one shipping charge for sales order where they have it.\",\"timestamp\":\"00:03:21\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"You can't add multiple lines, which I was told would be okay.\",\"timestamp\":\"00:03:34\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think I got Sean and Harrison's approval on that.\",\"timestamp\":\"00:03:39\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It's all the other stuff that's going on in that other section table.\",\"timestamp\":\"00:03:41\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Like the services, the delivery and install that need to be pulled out.\",\"timestamp\":\"00:03:47\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"How many times are my nerves in the scene?\",\"timestamp\":\"00:03:52\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I'm just\",\"timestamp\":\"00:03:59\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah, it's all the stuff that we post separately on the invoicing because it has to be split out.\",\"timestamp\":\"00:04:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Otherwise, it won't post separate on their invoice.\",\"timestamp\":\"00:04:13\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Need conditional logic based on post separately checkbox.\",\"timestamp\":\"00:04:18\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think that's what we were looking at doing.\",\"timestamp\":\"00:04:23\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So in the other section, there's a checkbox that says post separately when you add an item.\",\"timestamp\":\"00:04:30\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think that was our conditional logic test.\",\"timestamp\":\"00:04:37\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you're saying you do want me to do that?\",\"timestamp\":\"00:04:52\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Tell me your idea one more time.\",\"timestamp\":\"00:04:55\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Can you just tell me just so I make sure we're on the same page?\",\"timestamp\":\"00:04:57\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Well, you have to have a way to define what the conditional rule is.\",\"timestamp\":\"00:04:59\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you're defining what the conditional rule is.\",\"timestamp\":\"00:05:04\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"You're going to say that if this is one, then push these records or summarize the sum value or whatever you're going to do.\",\"timestamp\":\"00:05:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yes, we do need to do that.\",\"timestamp\":\"00:05:16\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:05:20\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"And what depth do I need to do?\",\"timestamp\":\"00:05:21\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Are there situations where there's multiple lines that in there, they need to be combined into one, and there's some situations where there's multiple lines.\",\"timestamp\":\"00:05:25\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"You need to push multiple lines.\",\"timestamp\":\"00:05:33\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"Is that the case?\",\"timestamp\":\"00:05:37\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"That's, I think so.\",\"timestamp\":\"00:05:38\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I'm not entirely sure.\",\"timestamp\":\"00:05:40\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I guess I kind of have to see it working.\",\"timestamp\":\"00:05:41\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"We have so many random scenarios, it's hard to say.\",\"timestamp\":\"00:05:45\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"We might have to do a combination of both of those.\",\"timestamp\":\"00:05:48\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"But I'm wondering if we want to combine it.\",\"timestamp\":\"00:05:53\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Oh, think, Rhiannon, did we talk about that, that that wasn't going to work if we made like a calculated field in the work order table that summarizes a certain category of items in the other section?\",\"timestamp\":\"00:06:00\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"Well, were we still having issues with the calculated field?\",\"timestamp\":\"00:06:12\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think that's a different thing.\",\"timestamp\":\"00:06:20\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"Well, it would, I mean, it would be a calculation based on a related table.\",\"timestamp\":\"00:06:22\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"So it falls under that category.\",\"timestamp\":\"00:06:28\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay, hold on a second.\",\"timestamp\":\"00:06:33\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Me?\",\"timestamp\":\"00:06:35\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"Because I have a calculation that would hold just the shipping items and get the value of the shipping that I wrote, but I think it still falls into that pit, simply by nature of being a calculated field that relies on a related table.\",\"timestamp\":\"00:06:35\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So I'm wondering if the middleware would be better to calculate it, if we have to calculate it.\",\"timestamp\":\"00:07:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I mean, I can show you the one example, what she's talking about, let me see if I share my screen.\",\"timestamp\":\"00:07:04\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So right here in this field, we were trying to, is sales tax exempt equal one, then exempt otherwise taxable?\",\"timestamp\":\"00:07:13\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"And that's when it doesn't seem to want to calculate this.\",\"timestamp\":\"00:07:24\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It doesn't want to build a little calculator.\",\"timestamp\":\"00:07:35\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I don't know.\",\"timestamp\":\"00:07:37\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think I sent you an email about that.\",\"timestamp\":\"00:07:40\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Where did my email go?\",\"timestamp\":\"00:07:48\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I know I had it.\",\"timestamp\":\"00:07:51\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Oh, it's over here.\",\"timestamp\":\"00:07:51\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So when you map, when we send that field through, we get a, this field name.\",\"timestamp\":\"00:07:55\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Is sales tax exempt is true.\",\"timestamp\":\"00:08:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Does not exist in a specified table.\",\"timestamp\":\"00:08:02\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So that's one issue, but back to, to the related fields thing.\",\"timestamp\":\"00:08:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Um, I might have you do both.\",\"timestamp\":\"00:08:11\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I don't know which one's going to pan out.\",\"timestamp\":\"00:08:19\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:08:25\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you need a way to do a full calculation based on a set of rules or push a whole set of records.\",\"timestamp\":\"00:08:25\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I believe so.\",\"timestamp\":\"00:08:33\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah.\",\"timestamp\":\"00:08:34\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:08:35\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Not sure which one we're going to need over the other, because in some circumstances, um, this other section, let me move the screen over here.\",\"timestamp\":\"00:08:37\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I see it.\",\"timestamp\":\"00:08:52\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Come on frame ready.\",\"timestamp\":\"00:08:58\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Do you remember which work order we were working on or should I just recreate it because there's going to be I need a conditional that allows us let's say we put shipping on here $100 worth of shipping see how that came up by default post\",\"timestamp\":\"00:09:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So that would be one test to pull this line out of this section and to be able to put it on the sales order individually.\",\"timestamp\":\"00:10:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Or in this case, with shipping, I guess that was a bad example.\",\"timestamp\":\"00:10:13\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Where is delivery and install?\",\"timestamp\":\"00:10:19\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Services.\",\"timestamp\":\"00:10:21\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"The delivery and install would be the one.\",\"timestamp\":\"00:10:24\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"See, that's also post separately.\",\"timestamp\":\"00:10:28\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So that would come out on its own, but the shipping would end up in...\",\"timestamp\":\"00:10:31\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Where did my browser go?\",\"timestamp\":\"00:10:38\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"There we go.\",\"timestamp\":\"00:10:39\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:10:47\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So I think we need both.\",\"timestamp\":\"00:10:49\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It just depends on when we start sending it through, how it reacts.\",\"timestamp\":\"00:10:53\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Without knowing...\",\"timestamp\":\"00:10:58\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"If being able to see it, it's hard to know for sure.\",\"timestamp\":\"00:11:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Let's see.\",\"timestamp\":\"00:11:05\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think we've sent one through.\",\"timestamp\":\"00:11:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Come on.\",\"timestamp\":\"00:11:09\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Matica's gotten slow on us.\",\"timestamp\":\"00:11:15\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"That's this one.\",\"timestamp\":\"00:11:27\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"We were able to see how the shipping came in through here, but if we go back to...\",\"timestamp\":\"00:11:29\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Did we get one to go through, Rhiannon?\",\"timestamp\":\"00:11:40\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"don't know if we did.\",\"timestamp\":\"00:11:42\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think I made a manual one, didn't I?\",\"timestamp\":\"00:11:47\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"No.\",\"timestamp\":\"00:11:50\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Oh, no, we didn't.\",\"timestamp\":\"00:11:52\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"We didn't.\",\"timestamp\":\"00:11:53\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"if you just wanted to set the shipping, you probably could do that right now by creating a...\",\"timestamp\":\"00:11:54\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Well, no, we got this shipping to work.\",\"timestamp\":\"00:12:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"The only thing is we would have to, if someone put two shipping charges on one work order, we would have to sum it into this area.\",\"timestamp\":\"00:12:02\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"But we can also, I mean, I put this on here manually.\",\"timestamp\":\"00:12:14\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Imagine this was the delivery and install line.\",\"timestamp\":\"00:12:18\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So we'd have a delivery and install line and a custom order line.\",\"timestamp\":\"00:12:20\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"And that's kind of what we need to do.\",\"timestamp\":\"00:12:23\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"And that's what's kind of troublesome of this section is that there's multiple things going on in here.\",\"timestamp\":\"00:12:25\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"that need a separate path.\",\"timestamp\":\"00:12:32\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"But you're going to need say, you're going to need to say then if item, if whatever that field that says shipping on there or DI001 is, could we do it by category?\",\"timestamp\":\"00:12:34\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Like, mean, I'd be worried.\",\"timestamp\":\"00:12:48\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Or post separately, I guess you could just do is post separately.\",\"timestamp\":\"00:12:49\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Right.\",\"timestamp\":\"00:12:54\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Right.\",\"timestamp\":\"00:12:54\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"There's that.\",\"timestamp\":\"00:12:54\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"And there's also the category that could also help.\",\"timestamp\":\"00:12:55\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Well, if it's supposed to be summed, you'll have to create the rule.\",\"timestamp\":\"00:13:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you're going to say, if this is post separately, then push these individually.\",\"timestamp\":\"00:13:03\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"And then if it's not post separately, then push them as a group and sum them.\",\"timestamp\":\"00:13:08\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"And in that case, you're going to need...\",\"timestamp\":\"00:13:17\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Hold on.\",\"timestamp\":\"00:13:20\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It gets trickier.\",\"timestamp\":\"00:13:21\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Hold on.\",\"timestamp\":\"00:13:22\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"You just said something.\",\"timestamp\":\"00:13:23\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"made me think about something.\",\"timestamp\":\"00:13:24\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"That's what I was asking.\",\"timestamp\":\"00:13:26\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"This is where this gets really tricky.\",\"timestamp\":\"00:13:27\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Hold on.\",\"timestamp\":\"00:13:30\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Let put something on there that is going to defy this situation.\",\"timestamp\":\"00:13:30\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So, this is a map board.\",\"timestamp\":\"00:13:38\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"This map board is going to sum into the total of the custom order line.\",\"timestamp\":\"00:13:40\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Well, then you're not going to create a rule.\",\"timestamp\":\"00:13:50\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Then it doesn't matter.\",\"timestamp\":\"00:13:52\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"It doesn't matter for that one.\",\"timestamp\":\"00:13:54\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:13:56\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Then don't put anything.\",\"timestamp\":\"00:13:57\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"There is no rules.\",\"timestamp\":\"00:13:58\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So the other two rules negate, as long as there's a rule that you only post whatever's in there, if it's post separately, then you don't need to worry about it because it's never going to find it because there's no rule to put to your, you know, if you have a rule.\",\"timestamp\":\"00:14:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:14:19\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Yeah.\",\"timestamp\":\"00:14:20\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah.\",\"timestamp\":\"00:14:20\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:14:25\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I mean, at this point, I don't, I'm not even hearing that we need the summary thing, but I can put it in there just so you have it.\",\"timestamp\":\"00:14:25\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"You mean like the total?\",\"timestamp\":\"00:14:33\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Well, the total summary, well, this is the other part.\",\"timestamp\":\"00:14:35\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"The totals, if, if we pull this delivery and install line out of here, this 165, it needs to come out of the subtotal because Acumatica re-sums it.\",\"timestamp\":\"00:14:37\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So maybe that's where the summary thing came into play.\",\"timestamp\":\"00:14:52\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah.\",\"timestamp\":\"00:15:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Now, there is the field called, like, component total, but component total only summarizes the main window.\",\"timestamp\":\"00:15:03\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"See how other items are all totaled in here?\",\"timestamp\":\"00:15:13\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So if we pull it out and send it to Acumatica on its own line, its dollar amount needs to come out of the subtotal so Acumatica can put it back in.\",\"timestamp\":\"00:15:16\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah.\",\"timestamp\":\"00:15:33\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:15:37\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Well, you'll have to do that in the function somehow for the total, I guess.\",\"timestamp\":\"00:15:40\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"You mean, like, in FileMaker, fix the field that's...\",\"timestamp\":\"00:15:51\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"No.\",\"timestamp\":\"00:15:56\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I mean, I can do it, but you'll need to be able\",\"timestamp\":\"00:15:57\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I just don't know if it's reasonable to ask you guys to do that.\",\"timestamp\":\"00:16:01\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"You're going to have to say, okay, it's grand total in the function that we already have.\",\"timestamp\":\"00:16:04\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"You're going to have to say, I'm going have to make it so somehow you can tell it if it's post-separally, it's going to be grand total minus the sum of the foreign table when it's post-separally.\",\"timestamp\":\"00:16:08\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"And you have to set the field that that's associated with.\",\"timestamp\":\"00:16:26\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So that's a different thing that we didn't talk about.\",\"timestamp\":\"00:16:29\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Should we be looking at doing that in FileMaker, like making a field, like instead of sending this subtotal field, make a new If you don't already have one, it might be easier just to do it that way.\",\"timestamp\":\"00:16:32\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I mean, I think we kind of have one, but this was in some other table.\",\"timestamp\":\"00:16:44\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I don't know if I can zoom in on this.\",\"timestamp\":\"00:16:58\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Oh, FileMaker Zoom.\",\"timestamp\":\"00:17:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Come on.\",\"timestamp\":\"00:17:04\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I think they fixed it.\",\"timestamp\":\"00:17:06\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"It's just going to be big.\",\"timestamp\":\"00:17:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"No, I think they, I think they, I haven't looked yet, but I'm pretty, I haven't looked at that new feature yet, but I think they fixed it.\",\"timestamp\":\"00:17:10\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"What, the zooming problem?\",\"timestamp\":\"00:17:16\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I thought I read something about them fixing it, but it doesn't have a new version and I don't see it.\",\"timestamp\":\"00:17:21\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Right.\",\"timestamp\":\"00:17:26\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So what are this reporters doing?\",\"timestamp\":\"00:17:27\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I you zoom by, I thought you could actually zoom and scale now.\",\"timestamp\":\"00:17:28\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Mm hmm.\",\"timestamp\":\"00:17:31\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So anyways, I mean, we kind of have it going on.\",\"timestamp\":\"00:17:34\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I just think it's not this, these calculations aren't in the work order table.\",\"timestamp\":\"00:17:37\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"They're in some other table.\",\"timestamp\":\"00:17:41\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So we'd have to go remake those calcs, which I'm okay with doing if it makes this easier.\",\"timestamp\":\"00:17:47\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I mean, it almost sounds like it, we probably should.\",\"timestamp\":\"00:17:53\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Just go make the proper field to come through here.\",\"timestamp\":\"00:18:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"The other condition that we have to look into, which we haven't played with yet, is when someone locks an order down and says, this order is now $200.\",\"timestamp\":\"00:18:05\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I got to go figure out where and how that's being stored and what kind of condition.\",\"timestamp\":\"00:18:13\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Does the middleware need to detect that or should we be somehow detecting that?\",\"timestamp\":\"00:18:19\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"total.\",\"timestamp\":\"00:18:24\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"It's still your grand total.\",\"timestamp\":\"00:18:24\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"It's the same field.\",\"timestamp\":\"00:18:28\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Right.\",\"timestamp\":\"00:18:29\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"But the moment you have something that, but once you have something that posts separately on a locked order, I, things are going to get weird.\",\"timestamp\":\"00:18:30\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Like, you know, you're saying this is $165, but I just locked the order down to 50.\",\"timestamp\":\"00:18:41\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So if you take the 50 and you minus 165, we're going to be in the negative.\",\"timestamp\":\"00:18:50\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So I don't know how to handle that.\",\"timestamp\":\"00:18:55\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It's almost like if something posts separately.\",\"timestamp\":\"00:18:58\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It shouldn't be lockable, but I wonder how our current invoicing scenario handles that.\",\"timestamp\":\"00:19:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I don't know.\",\"timestamp\":\"00:19:08\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Yeah.\",\"timestamp\":\"00:19:15\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I've never, I've never really, I mean, I know that it runs at night, but I don't know what it does.\",\"timestamp\":\"00:19:16\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Is that saying tax is negative $19?\",\"timestamp\":\"00:19:32\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I mean, is there ever a scenario where that would happen?\",\"timestamp\":\"00:19:35\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Um, I don't know.\",\"timestamp\":\"00:19:49\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It lets me do it.\",\"timestamp\":\"00:19:54\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I don't think a user shouldn't be doing that.\",\"timestamp\":\"00:19:56\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"But I'll have to go figure that out next.\",\"timestamp\":\"00:20:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I don't know.\",\"timestamp\":\"00:20:07\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I've never considered that.\",\"timestamp\":\"00:20:08\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Because, yeah.\",\"timestamp\":\"00:20:12\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So that's kind of like...\",\"timestamp\":\"00:20:13\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"that's probably a problem regardless, whether outside of Acumatica, I think that's probably a problem.\",\"timestamp\":\"00:20:14\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Right.\",\"timestamp\":\"00:20:20\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Beyond Acumatica's concerns.\",\"timestamp\":\"00:20:21\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Why don't we just take a stab at this first part, and then once you see it, maybe that'll help define the next steps.\",\"timestamp\":\"00:20:25\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah, I think that probably will.\",\"timestamp\":\"00:20:36\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think that's kind of why I need to see it, to kind of understand it.\",\"timestamp\":\"00:20:38\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So, all right.\",\"timestamp\":\"00:20:44\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So you can take a stab at that.\",\"timestamp\":\"00:20:46\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Where was this?\",\"timestamp\":\"00:20:48\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Can you look into also why it doesn't like this field?\",\"timestamp\":\"00:20:50\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Yeah, I will.\",\"timestamp\":\"00:21:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:21:02\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Can you click update again?\",\"timestamp\":\"00:21:03\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"It wasn't giving you an error, right?\",\"timestamp\":\"00:21:04\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Where was that?\",\"timestamp\":\"00:21:06\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Oh, it's right here.\",\"timestamp\":\"00:21:09\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"No, it just says no sample record.\",\"timestamp\":\"00:21:13\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Let me see the, that's where that it's not displaying the samples.\",\"timestamp\":\"00:21:17\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Has it not been displaying the samples at all?\",\"timestamp\":\"00:21:23\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"No, there's other calculations that are just fine.\",\"timestamp\":\"00:21:25\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"It's something to do with this.\",\"timestamp\":\"00:21:28\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"This is sales tax exempt field.\",\"timestamp\":\"00:21:30\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"This is a calculated field within FileMaker.\",\"timestamp\":\"00:21:38\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Do you know how to use the inspector?\",\"timestamp\":\"00:21:41\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I don't really want you.\",\"timestamp\":\"00:21:43\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Have you ever done that before?\",\"timestamp\":\"00:21:45\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"The inspector and web.\",\"timestamp\":\"00:21:47\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Can you right click on your, right click on the go to inspect?\",\"timestamp\":\"00:21:49\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Click on the console console.\",\"timestamp\":\"00:22:00\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"There you go.\",\"timestamp\":\"00:22:03\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"That's just noise.\",\"timestamp\":\"00:22:06\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"But we want to click on that field again.\",\"timestamp\":\"00:22:08\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Clear the inspector first.\",\"timestamp\":\"00:22:12\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"then in the top left corner of that, there's a little Ghostbusters thing.\",\"timestamp\":\"00:22:14\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Ghostbusters.\",\"timestamp\":\"00:22:21\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"What do you mean?\",\"timestamp\":\"00:22:22\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Down?\",\"timestamp\":\"00:22:24\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"That.\",\"timestamp\":\"00:22:25\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah, that clear it.\",\"timestamp\":\"00:22:26\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yep.\",\"timestamp\":\"00:22:28\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:22:29\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"And then try that again.\",\"timestamp\":\"00:22:30\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"It may not be reporting any errors or I can't remember how much about that.\",\"timestamp\":\"00:22:34\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Actually, I don't think it is.\",\"timestamp\":\"00:22:41\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Yeah, I don't have the tool.\",\"timestamp\":\"00:22:47\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I have the error tooling turned off on that.\",\"timestamp\":\"00:22:49\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"get to click on.\",\"timestamp\":\"00:22:51\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:22:52\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"All that other nonsense turned on.\",\"timestamp\":\"00:22:57\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"All right, let me look at that.\",\"timestamp\":\"00:23:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I'm not sure what's going on there.\",\"timestamp\":\"00:23:02\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Got it.\",\"timestamp\":\"00:23:06\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:23:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think that was it.\",\"timestamp\":\"00:23:10\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Bryan, can you think of anything else?\",\"timestamp\":\"00:23:13\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"that?\",\"timestamp\":\"00:23:15\"},{\"speaker\":{\"display_name\":\"Rhiannon Nabours\",\"matched_calendar_invitee_email\":null},\"text\":\"No, not.\",\"timestamp\":\"00:23:17\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So I think what we need to put in here also is a way to add multiple tables and then get like a sum field.\",\"timestamp\":\"00:23:21\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I think you're going to wind up needing that here.\",\"timestamp\":\"00:23:29\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Can we add multiple tables?\",\"timestamp\":\"00:23:34\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Like a related table?\",\"timestamp\":\"00:23:36\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Yeah, I've been thinking that.\",\"timestamp\":\"00:23:38\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"If we can do related tables, that makes this a little bit easier because the other section was going to have to be a second API call then.\",\"timestamp\":\"00:23:42\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Well, in this scenario, you would only use that if it's a flat thing.\",\"timestamp\":\"00:23:51\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Like a one-to-one, or if you're trying to summarize something, if you're going to say, summarize the resulting value, and again, kind of comes down to whether or not you're going to be able to say something in this case where, you know, shipping is one, it's also shipping and whatever.\",\"timestamp\":\"00:24:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I mean, I don't know if you can define all that.\",\"timestamp\":\"00:24:22\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I know I could do it, but I just don't know if you can do it.\",\"timestamp\":\"00:24:27\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Like, I don't know if it has value to you guys.\",\"timestamp\":\"00:24:30\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Like, if you can sort that out, that's fine.\",\"timestamp\":\"00:24:33\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I just don't want to make it complex to the point where nobody understands how it works, especially over a given amount of time.\",\"timestamp\":\"00:24:38\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"That's the thing.\",\"timestamp\":\"00:24:44\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Like, the more features we add in here, the more confusing it is, the less likely anyone is to use it in the future anyway.\",\"timestamp\":\"00:24:45\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So, sometimes.\",\"timestamp\":\"00:24:52\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah, you're not wrong about that.\",\"timestamp\":\"00:24:55\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"So, what would you suggest?\",\"timestamp\":\"00:24:58\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Nobody down the line, I we had to do a bunch of work, and then down the line, nobody even remembers what the hell's going on.\",\"timestamp\":\"00:25:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"It's, you know.\",\"timestamp\":\"00:25:06\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Right.\",\"timestamp\":\"00:25:08\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I mean, at some point, we're going to get this set up, and it's going to sit because it's going to be set up, you know.\",\"timestamp\":\"00:25:08\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Right.\",\"timestamp\":\"00:25:14\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"And maybe, maybe we, you know, we add a new feel, or, you know, and we're not going to do complicated ads, I think, after a certain point, but.\",\"timestamp\":\"00:25:15\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay, well, I'm going to approach this as I'm not going to touch anything until you tell me you really need it.\",\"timestamp\":\"00:25:28\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So I know now at this point, I'm going to do the conditions for the related tables, navigating to the related tables, and then what do you do there at that point?\",\"timestamp\":\"00:25:31\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:25:44\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"We already have the way to set it up.\",\"timestamp\":\"00:25:44\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So under each one of, when you see the repeating values, each one of, I think I'm actually going to hide them.\",\"timestamp\":\"00:25:46\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I'm going to adjust the interface so it's less confusing.\",\"timestamp\":\"00:25:52\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Like, I'm not even going to display them unless you add it.\",\"timestamp\":\"00:25:55\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"You're going to, instead of the way it's just automatically adding each, like relations, if you don't want that, I'll give you a place to add it, but I'm not going to put the, I forget what you call the hierarchy, I'm not even going to put those in unless you click an add button, and then when you click that add button, I'm going to say, what do you, you know, I'm going to say, are you adding a manual count, are you adding a relational count, are you adding a relational push, and what is the function for that?\",\"timestamp\":\"00:26:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you, right, if there is a conditional function, or not.\",\"timestamp\":\"00:26:29\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:26:34\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So you won't see all the noise for the related tables until you actually say, I want to add something, and then I want to add another thing, right?\",\"timestamp\":\"00:26:36\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"And then that thing is either, again, what we have, which is the manual count, which is the iteration, you're going to say five, or it's the related thing, you're going to select the table, and then select, and then for both of those, I guess you need a rule for them.\",\"timestamp\":\"00:26:44\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Okay.\",\"timestamp\":\"00:26:59\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"The manual push, we won't need the relationship.\",\"timestamp\":\"00:27:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I don't think so.\",\"timestamp\":\"00:27:04\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I'm not going to put that in there for the iterator push, because that means it's flat to me.\",\"timestamp\":\"00:27:06\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"It's a flat push.\",\"timestamp\":\"00:27:12\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So it's only for the related push where we're going to say, when it's related, these are the records we want you to push.\",\"timestamp\":\"00:27:13\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"The flat manual push, I think we don't need that.\",\"timestamp\":\"00:27:21\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:27:27\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I can just say if the values are empty, then don't push.\",\"timestamp\":\"00:27:27\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"We'll just assume that if the values are empty, don't push them.\",\"timestamp\":\"00:27:30\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:27:34\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Right.\",\"timestamp\":\"00:27:35\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Because we talked about that.\",\"timestamp\":\"00:27:35\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Like if, if the quantity is empty, then I, you know, quantity one is empty, then probably that whole row is going to be empty or that whole related.\",\"timestamp\":\"00:27:36\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"I'm just going to do it like that.\",\"timestamp\":\"00:27:47\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"And we'll go from there.\",\"timestamp\":\"00:27:48\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"I think so.\",\"timestamp\":\"00:27:49\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yeah.\",\"timestamp\":\"00:27:50\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Like I said, think once, once you see it, we'll go from there and we can't obviously that every situation.\",\"timestamp\":\"00:27:52\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"So I'll put it in there.\",\"timestamp\":\"00:27:58\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Tell me what's up with it.\",\"timestamp\":\"00:28:00\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"And we'll go from there.\",\"timestamp\":\"00:28:01\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Okay.\",\"timestamp\":\"00:28:03\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"All right.\",\"timestamp\":\"00:28:04\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"All right.\",\"timestamp\":\"00:28:05\"},{\"speaker\":{\"display_name\":\"Sean Kruger\",\"matched_calendar_invitee_email\":\"etechnologies34@gmail.com\"},\"text\":\"Sounds good.\",\"timestamp\":\"00:28:06\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Thanks, guys.\",\"timestamp\":\"00:28:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Appreciate you.\",\"timestamp\":\"00:28:07\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Yep.\",\"timestamp\":\"00:28:08\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Thank you.\",\"timestamp\":\"00:28:08\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"You too.\",\"timestamp\":\"00:28:08\"},{\"speaker\":{\"display_name\":\"Bryan Kogan\",\"matched_calendar_invitee_email\":null},\"text\":\"Bye.\",\"timestamp\":\"00:28:09\"}],\"transcript_language\":\"en\",\"url\":\"https:\/\/fathom.video\/calls\/706683083\"}"},"script":"Fathom | Incoming Log"} Result: {"response":{},"messages":[{"code":"0","message":"OK"}]} -------------------------