Givebutter applies the discount to each item times quantity. I have create a spreadsheet style formatter to add the line items into a total discount amount but when there is no discount, it’s not recognizing the 0 amount in discount. What’s the best way to accomplish this? The goal is to get a total discount amount of all line items to apply to one field in Create a Sales Receipt field of QuickBooks.
Hi
Welcome to the Community.
In order to calculate total discounts accurately in Zapier when using Givebutter and QuickBooks, ensure each line item includes a discount field, even if it's zero. Use Zapier's Formatter tool with the "Numbers" action to sum all discounts, accounting for zero or missing values by replacing them with zero if needed. Once calculated, map the total discount to the appropriate field in QuickBooks to ensure accurate sales receipts.
If you have any further questions or need more detailed guidance, feel free to ask. We're here to help.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.